← All use cases

Use case #15 · CPA

Accountant has Claude build a nine-month balance sheet reconciliation of about 2,000 transactions

Sharrin Fuller (LinkedIn) ·

The short version

What they did

Replying to a post asking accountants for recent examples of using Claude: had it build a balance sheet reconciliation covering about 2,000 transactions over nine months, then corrected some of the totals.

Result (as claimed)

“It just built an entire BS rec of about 2000 transactions for a period of 9 months. Totally blown away. I did have to correct some of the ‘sums’ but the data was correct. Saved me about 6 hours.”

Prompt

I’m an accountant reconciling [balance sheet account] for [start date to end date]. I’ll attach [general ledger detail], [supporting statements] and [the last agreed reconciliation with its closing balance].

1. Confirm the files cover the same account and period. Ask me about gaps before proceeding.
2. Build a spreadsheet showing the opening balance, monthly activity, closing balance and supporting statement balance. Use formulas for totals.
3. List reconciling items with dates, amounts and references to the original transactions.

Add a short summary of the remaining difference and anything I need to investigate. Show the formulas so I can check the arithmetic. Don’t invent transactions or force the balances to agree. Mark possible explanations as suggestions until the documents support them.

Do it yourself

These steps are my suggested way in, not Sharrin Fuller’s setup.

What you need

  • A chat assistant that reads and builds spreadsheets, such as Claude or ChatGPT.
  • GL detail for one balance sheet account and the statements it should agree to.
  • Use a business plan of the AI tool, or sample data, for anything with client details in it.

Start simple

  1. Start with an account you already reconciled for a past period.
  2. Paste the Prompt with that GL detail and the statements.
  3. Ask for a spreadsheet with live formulas, not typed-in totals.
  4. Compare its ending balance and reconciling items with your finished rec.

Take it further

  • Move to a longer period or a busier account once the short one matches.
  • Ask it to group reconciling items by cause, such as timing or a missing entry, and propose the entries.
  • Save the prompt and layout as your firm’s template for that account.

Check your work

  • Re-add the totals yourself. Fuller had to fix some sums even though the data was right.
  • Check the opening balance against last period’s signed-off rec.
  • Trace a sample of reconciling items to the bank or vendor statement before you book anything.

Before you rely on it

  • This is general information about how accountants use AI, not professional guidance for your engagements.
  • You stay responsible for the work under your professional standards, including review and sign-off. An AI tool’s output is a draft, not evidence.
  • Before you send client data to an AI tool, read the tool’s data and training terms, and get any client consent you need. For tax return information, that includes IRC section 7216.

Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: Not stated. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.

More in Close/bookkeeping

New cases go out every Saturday in Inside AI.