← All use cases

Use case #30 · CPA

Have AI hunt for the difference in a reconciliation or tie-out, then check its work: a revenue reconciliation and a subledger test

Jacob Krogue, CPA, and Robert Persons, CPA ·

The short version

What they did

Two CPAs gave ChatGPT a reconciliation problem: find what doesn’t match, and show the rows. An accountant evaluates what it finds.

A 20,000-line revenue reconciliation

After a team member spent four hours searching a 20,000-line revenue reconciliation, Jacob Krogue asked ChatGPT in Excel to locate the discrepancy. He describes a revised process: human orientation, AI search, then accountant evaluation. His LinkedIn article, 2026-05-07.

A subledger tie-out test

Robert Persons supplied a trial balance and subledger to ChatGPT, clarified that he wanted one account tied out, then tried a non-reconciling example. He accidentally requested an inventory tie-out after providing a loan subledger. This was an exploratory test, not a reported client engagement. His LinkedIn article, 2023-04-13.

Result (as claimed)

The revenue reconciliation: “It found the issue in 5 minutes.” This is Krogue’s account of one variance search, not a timed comparison conducted by this library or a claim that the full reconciliation took five minutes.

The subledger test: “I was pleasantly surprised when ChatGPT asked me if I had given it the correct sub-ledger.” The first attempt had not matched his requested output. He reported no production time saving.

Prompt

Written for this library, one for each example.

Find the variance:

I’m an accountant investigating a revenue reconciliation difference for [period]. I’ll attach [the reconciliation workbook and supporting exports]. The sheets to compare are [sheet names], matched using [transaction reference or other key]. My initial hypothesis is [hypothesis, or none].

1. Confirm what each sheet contains and compare its totals.
2. Search for unmatched rows, duplicates and amount differences that might explain the remaining balance.
3. Show candidate discrepancies in a table with sheet names, row references, amounts and the arithmetic connecting them to the difference.

Add a short plain-English explanation of what to check next. Test my hypothesis rather than assuming it’s right. Ask about unclear matching rules and don’t force unrelated transactions to match. Leave corrections for my review and don’t change the workbook.

Tie out one account:

I’m an accountant testing a tie-out for [account name and number] at [date]. I’ll attach [trial balance] and [subledger detail], with [notes explaining the columns and debit or credit signs]. Compare only this account.

1. First confirm that the account, subledger and dates describe the same thing. If they don’t, stop and ask for the correct file or clarification.
2. If they match, calculate the subledger total, show the trial balance amount and calculate the difference.
3. List any rows that may explain a difference, with file, sheet and row references.

Return a short summary and a table I can check. Show your arithmetic, flag unreadable or missing data and don’t assume a mismatch is a bookkeeping error. Don’t change any figures or claim the account reconciles if a difference remains.

Do it yourself

These steps are my suggested way in, not any one person’s setup.

What you need

  • A chat assistant that reads spreadsheets, or an AI add-in for Excel, on a business plan.
  • A reconciliation you already solved, with the answer known.
  • The trial balance and subledger files for one account.

Start simple

  1. Pick a past reconciliation where you know what the difference was.
  2. Spend five minutes orienting yourself first. Write down your best guess at the cause.
  3. Paste the “Find the variance” prompt with your guess and attach the file.
  4. Check whether it found the real difference, with row references you can open.
  5. Try the “Tie out one account” prompt. Give it the wrong subledger once, and see if it notices.

Take it further

  • Use it on live reconciliations as the search step only. You orient, AI searches, you evaluate.
  • Save both prompts with your file layout described, so you don’t repeat the setup.
  • Ask it to summarize recurring causes of differences across months.

Check your work

  • Open every row it cites and confirm the amounts yourself.
  • Check that its totals match the file’s totals before trusting any difference.
  • It proposes, you decide. Make no correcting entry without your own review.

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.