Skip to main content
SBSmall Biz Playbooks

How to Use AI to Review Transactions Before Closing Your Books

By Your Friendly Developer LLC · · Updated

Use Claude as a second-pass reviewer, not as your bookkeeper. Export the records you are authorized to use, remove unnecessary sensitive fields, ask Claude to flag possible mismatches, and verify every flag against the source documents. Reconcile the account in QuickBooks until its difference is zero; AI output is not proof that the books are closed.

What does closing the books require?

Intuit describes reconciliation as matching the transactions recorded in QuickBooks with the bank and credit-card statements for the same period. Before starting, the period's transactions should be entered and categorized. The reconciliation is complete when the difference shown in QuickBooks is zero.

An AI review can help you organize possible duplicates, missing descriptions, or records that deserve a closer look. It cannot confirm what actually cleared the bank, determine the correct accounting treatment from incomplete context, or replace the reconciliation report and source documents.

Protect the data before uploading anything

Use the minimum data necessary.

  • Remove full bank and card numbers, tax identifiers, and authentication data.
  • Remove customer or employee details that are not needed for matching.
  • Use an AI account and plan approved for your business records.
  • Review the provider's current privacy, retention, and training settings.
  • Do not upload records you are not authorized to share with that provider.

Anthropic distinguishes consumer Claude plans from commercial products in its privacy documentation. Do not assume every plan has the same data terms. If your records are regulated, contract-restricted, or especially sensitive, ask the appropriate professional or system administrator before using this workflow.

What do you need before starting?

  • The bank or credit-card statement for each account being reconciled
  • All transactions for the statement period entered and categorized in QuickBooks
  • A QuickBooks report or export covering the same period
  • A matching export from PayPal or another payment provider, if applicable
  • Receipts, invoices, and prior reconciliation reports for verification
  • Access to Claude or another approved tool that can read the chosen file type

How do you export the records?

QuickBooks:Use Intuit's current export instructions to export the report or list needed for your account and date range. Menu names and export options can change, so follow the official help page rather than relying on a fixed click path in this guide.

PayPal:PayPal's Reports area provides activity downloads and statements. Select the same period used in QuickBooks and choose a supported downloadable format.

Confirm that both exports cover the same dates and currency. Keep untouched originals in a secure location and create redacted copies for the AI review.

What prompt should you use?

Attach the redacted files supported by your current Claude account, then use a prompt that limits the task to flagging. Replace every bracketed field and remove any request that does not fit your records.

Transaction-review prompt

Act as a review assistant. Do not make accounting decisions and do not claim the records are reconciled.


I attached these redacted exports for [DATE RANGE]:

1. [QUICKBOOKS REPORT NAME]

2. [PAYMENT PROVIDER REPORT NAME]


Please return only items I should verify:

- possible records present in one file but not the other

- possible duplicates based on amount, date, and description

- missing or unclear categories or descriptions

- items above [MY REVIEW THRESHOLD]

- totals that cannot be compared because a field or period is missing


For every flag, quote the source row identifiers and explain why it was flagged.

If the evidence is incomplete, say what source document I must check.

Do not add, delete, recategorize, or propose journal entries. I will verify each item.

How should you review the flags?

  1. Locate each flagged row in both original exports.
  2. Compare it with the bank statement, receipt, invoice, or settlement report.
  3. Record the reason a flag is valid or a false positive.
  4. Make any necessary change in QuickBooks only after the evidence supports it.
  5. Run QuickBooks reconciliation and continue until its difference is zero.
  6. Save the reconciliation report and escalate unexplained differences.

Similar amounts or dates do not prove that entries are duplicates. A missing match does not prove that a transaction should be added. Stop and ask a qualified accountant when the correct treatment is uncertain.

What can an AI review get wrong?

An AI system sees only the fields and instructions you provide. It may overlook a match, treat legitimate repeated payments as duplicates, compare different date ranges, infer a category without enough evidence, or calculate a total from incomplete rows. Its wording can sound confident even when the source data does not support the conclusion.

Keep the approval boundary simple: the AI organizes questions; you verify evidence; QuickBooks records the result. Do not connect this prompt to an automated posting step.

Sources and verification

This guide was checked against these official sources on August 2, 2026:

Product interfaces and provider terms can change. Recheck the linked instructions before using the workflow.

Frequently asked questions

Can Claude reconcile my books for me?
No. This workflow uses Claude only to produce a list of possible mismatches for you to verify. Intuit defines reconciliation as matching the transactions in QuickBooks to bank and credit-card statements until the difference is zero. Finish that process in QuickBooks and consult an accountant when a discrepancy is unclear.
Which Claude plan do I need?
Anthropic currently supports file work on free and paid Claude plans, but usage and context limits vary and can change. Check Anthropic's current plan and upload documentation for your account instead of choosing a plan from a transaction-count rule.
Is it safe to upload bookkeeping exports to an AI service?
Financial exports can contain sensitive data. Remove information the review does not need, such as full account numbers, tax identifiers, customer contact details, and unrelated memo fields. Use only an account and plan your organization authorizes, and review the provider's current privacy and retention terms before uploading.
Does this workflow connect Claude directly to QuickBooks?
No. It uses files you export and manually upload. Claude cannot post or change entries through this workflow.
What should I do if Claude flags a transaction?
Treat the flag as a question, not a correction. Compare it with the original statement, receipt, invoice, and the entry in QuickBooks. Do not add, delete, recategorize, or post an entry solely because an AI response recommends it.
Can I use this for inventory or COGS accounting?
Inventory and cost-of-goods-sold records can require accounting judgments that a general AI review cannot validate. Use the workflow only to organize questions and have a qualified professional review uncertain treatment.
Can I adapt this to other bookkeeping platforms?
The review pattern can be adapted to exported transaction data, but file formats and reconciliation steps differ by platform. Follow the current export and reconciliation instructions from your own provider.

Independent, unofficial guide. Not affiliated with, endorsed by, or sponsored by Anthropic, PBC. Claude and Anthropic are trademarks of Anthropic, PBC. This site references those products solely for descriptive, educational purposes. Compensated links, if added, are disclosed near the link.