Home/Blog/ChatGPT Prompts for Bookkeeping: 12 for Monthly Client Work
Blog

ChatGPT Prompts for Bookkeeping: 12 for Monthly Client Work

P
promptstudio

12 ChatGPT prompts for bookkeeping: document chasers, uncategorized transaction triage, bank rules, reconciliation checks, month-end lists and owner summaries.

ChatGPT Prompts for Bookkeeping: 12 for Monthly Client Work

ChatGPT prompts for bookkeeping take care of the writing and sorting around the books: chasing client documents, triaging uncategorized transactions, drafting bank rules, finding reconciliation differences and explaining the month to an owner in plain words. They work on the exports and notes you paste; your bookkeeping software and the bank statement stay the source of truth. The 12 prompts below follow the order a month usually runs, with a worked example after them.

The core of this list is the bookkeeper prompt that turns uncategorized lines into client questions. You paste the client profile, chart of accounts, uncategorized lines, existing rules, a materiality limit, the contact and the close date. It codes only what the rules support, pairs transfers, flags possible duplicates, checks the totals and writes one short email of questions for the owner.

Use the last four digits for account references and leave out full account numbers, tax IDs and card numbers. These prompts are not tax advice; tax treatment stays with you and the client's accountant.

Client documents

1. Monthly document chaser

Write a short email to [client] listing what I need to close [month] by [date]: [statements, receipts, invoices]. Number the items, say where to upload them [portal or email], and keep it friendly and under 120 words.

2. Missing receipts list

From these card transactions [date, payee, amount] and the receipts I have [list], list every transaction over [amount] with no receipt, grouped by payee, and write a one-line request for each.

3. New client onboarding questions

A new client runs a [business type] on [cash or accrual] basis with [accounts and cards]. Write the 15 questions I should ask in the first call about accounts, payroll, sales channels, owner draws and who approves what, grouped by topic.

Categorize

4. Flagship: uncategorized triage with client questions

ClientProfile [business, method, software], ChartOfAccounts [accounts], UncategorizedList [date, description, amount, account], KnownRules [rules], Materiality [limit], ClientContact [owner and preference], CloseDate [deadline]. Return the triage table, totals check, transfer matches, duplicate check, client questions, rule proposals and close note.

5. Bank rule spec

From how these payees were coded over the last [months] [payee, description text, account], propose bank rules with the exact text to match, the account, and any payee that should not get a rule because it was coded to more than one account.

6. Business or personal questions

These charges on the business card could be personal [list]. Write one neutral question per charge asking the owner whether it was for the business, and if so what it was for. Do not suggest an answer.

Reconcile

7. Reconciliation difference finder

The bank statement ending balance is [amount] and the book balance is [amount] for [account] at [date]. Here are uncleared items [list] and this month's transactions [list]. Find which items explain the difference, show the arithmetic, and list what is still unexplained.

8. Transfer and duplicate matcher

Across these accounts [account and transactions], pair transfers of equal and opposite amounts within [days] of each other, and list any two lines with the same payee, amount and reference as possible duplicates.

9. Credit card statement tie-out

The card statement for [period] shows previous balance [amount], payments [amount], charges [amount] and new balance [amount]. The books show [figures]. Check the statement adds up, then list the differences between the statement and the books line by line.

Close and report

10. Month-end checklist for one client

Build a month-end checklist for [client] from their setup [accounts, payroll, sales channels, loans]. One line per task with an owner and a due date before [close date], and mark tasks that depend on the client.

11. Plain-language month summary

From this profit and loss [paste] and last month's [paste], write a five-line summary for an owner with no accounting background: what changed, the largest two reasons from the figures, and one question for them. No forecasts.

12. Records retention checklist

List the record types I keep for [client] [list] and draft a retention checklist that I will confirm against IRS Publication 583 and any state rules. Put a blank in every retention period so I fill each one in from the source.

Worked example: a florist's October queue

In the flagship example, an invented one-owner florist has nine uncategorized October lines: two wholesale flower charges with the same order number, a transfer from checking to savings and its other side, fuel, a design subscription, a big-box store purchase, a mobile deposit and a bank service charge. The output codes four lines by existing rules for 487.96, pairs the 1,000.00 transfer so it stays out of income and expense, holds the second 412.80 wholesale charge as a possible duplicate, and checks that 487.96 + 1,000.00 + 86.40 + 412.80 adds back to the 1,987.16 that went out. The owner gets one email with three numbered questions: business or personal for the 86.40, sale or owner money for the 350.00 deposit, and one order or two for the repeated order number.

Variations

  • Accrual clients: add open invoices and bills so deposits and payments match to them before anything goes to the client.
  • Many clients: run prompt 1 for every client on the same day and keep one tracker of who has replied.
  • Year-end: run prompt 4 across the whole year's leftovers and add a column for which month each line affects.

Tips

  • The IRS says to keep records that support income, deductions or credits until the period of limitations for that return runs out, which is generally 3 years after filing, with longer periods in some cases. Employment tax records must be kept for at least 4 years (IRS Publication 583).
  • Paste bank descriptions exactly. Rules match on that text, and a cleaned-up description will not match next month.
  • Never let the model decide business or personal. Ask the owner, and record the answer in your notes.
  • Check every total the model shows against the export before you post anything.
  • Code in your bookkeeping software, not in the chat. PromptDig is not affiliated with OpenAI or any accounting software vendor.

Related on PromptDig

Turn approved rules into a setup spec with the Xero bank rules spec prompt, then close with the month-end close kit prompt. For owner conversations, try the small business monthly numbers review, and see ChatGPT prompts for accountants for the wider practice. More prompts are in the Finance hub; you can browse all prompts or share a bookkeeping prompt.

Share this article