Match receipts to bank transactions and flag VAT or sales tax questions for your accountant
Give an agent a read-only bank export, your receipts and your chart of accounts. Have it match each bank line to a receipt in code, propose a category from your existing accounts only, and list missing receipts and tax questions. It must not invent transactions or post to your ledger. You review the workbook, and your accountant checks the result before anything is filed. Public accounts report useful cleanup, plus duplicated and invented transactions.
You get a workbook with every bank line matched to a receipt or marked missing, a proposed category for each, and a short list of VAT or sales tax questions for your accountant.
- Difficulty
- Intermediate
- Time
- 1-3 hours for the first month, less after that
- Sources
- 9 · 9 independent
- Updated
- 2026-10-13
- Cost:
- Your agent plan. Accounting software and accountant fees are separate.
The prompt
Fill the blanks here, or leave them for your agent to ask. Pick the tab for your agent. The hand-off button gives any agent this page as markdown.
Help me prepare [month and year] for [company name], a [country] business that is [VAT registered / not VAT registered / collects sales tax in states X, Y]. Inputs (read only, do not change these files) - Bank export: [path to CSV for account ending 1234], statement closing balance [amount]. - Receipts and invoices: [folder path / Gmail label "Receipts"]. - Chart of accounts: [path or paste]. Use only these account names. - Last month's categorised lines for reference: [path]. 1. Load the bank CSV with code. Print the row count, the first and last date, and the sum of money in and money out. Check that opening balance plus movements equals the closing balance [amount]. If it does not, stop and show me the gap. 2. Read every receipt. Extract date, supplier, total, currency, tax amount and tax rate. If a receipt is an image you cannot read clearly, mark it "UNREADABLE". Do not guess numbers. 3. Match receipts to bank lines in code: same amount (allow 0.01 or a currency conversion within 2%), date within 5 days, supplier name similar. Report one row per bank line: matched receipt, match confidence, and why. 4. Propose a category for each bank line from the chart of accounts only, using last month's choices as precedent. If you are not sure, leave it blank and say why. Never create a new account name. 5. Flag for my accountant, do not decide: receipts with no tax number or an unusual tax rate, foreign suppliers that charged no VAT or GST (possible reverse charge), mixed business and personal spend, entertainment, assets that may need capitalising, and [state sales tax or marketplace questions]. 6. Write a workbook [path].xlsx with tabs: Matched, Bank lines without receipt, Receipts without bank line, Possible duplicates, Questions for accountant, Totals check. Hard rules - Do all arithmetic and totals in code, and show the code output. - Never invent, move or borrow a transaction to make totals agree. If totals do not agree, report the difference. - Do not write to [Xero / QuickBooks / the ledger file], do not delete files, and do not email anyone. Stop and ask me first.
Human checkpoints: the agent stops and asks you
- Approve every proposed category and every match before anything is entered into the ledger.
- Decide every VAT, GST or sales tax question with your accountant. The agent only flags them.
- Approve any write to the accounting system one batch at a time, after a bank reconciliation.
Wrong books lead to wrong tax returns. The agent must not write to your accounting system or file anything. Your bank reconciliation and your accountant are the checks, not the agent's own summary.
What you need
- Bank statement exportdata
CSV for the month, plus the closing balance from the statement.
A folder or an email label. HMRC treats the VAT invoice as the main evidence for reclaiming input tax.
- Chart of accountsdata
Export it from your accounting software so the agent uses your account names.
Xero or QuickBooks MCP server. Use read-only mode for this playbook.
- An accountant or bookkeeperpermission
Someone qualified checks categories and tax treatment before filing.
Steps
Export the inputs
Export one month of bank lines, the chart of accounts, and last month's categorised lines. Collect the month's receipts in one folder or label.
Check: You have four inputs and the statement closing balance.
Check the bank totals first
Run step 1 of the prompt. If opening balance plus movements does not equal the statement closing balance, fix the export before you go on. A wrong starting balance makes every later month worse.
Check: The agent prints a totals check that agrees with your statement.
Extract and match receipts
Let the agent read receipts and match them in code. Expect some unreadable images and some foreign currency lines that need you.
Check: The workbook has a Matched tab and two exception tabs, and their row counts add up to the bank row count plus unmatched receipts.
Review possible duplicates
Open the Possible duplicates tab. Agents both create duplicates and miss them, so check each pair yourself.
Check: Each pair is marked keep both or remove one, with a reason.
Review categories
Accept or change each proposed category. Watch hosting, software and cost of sales lines, which one benchmark saw a model mix up.
Check: Every line has a category from your chart of accounts.
Chase missing receipts
Find or request receipts for bank lines without one. Write the requests yourself or approve each draft.
Check: The Bank lines without receipt tab is empty or each line has a note.
Send the questions to your accountant
Send the Questions for accountant tab with the workbook. Do not let the agent decide tax treatment.
Check: Your accountant has answered each question.
Post and reconcile
Enter the approved lines in your accounting system, by hand or with a dry-run script you approve. Then run the bank reconciliation in the accounting software and lock the period.
Check: The bank reconciliation in your software shows no difference.
What goes wrong
The agent invents a transaction or pulls in an unrelated one so the numbers add up.
Fix: Tell it never to make totals agree, only to report the gap, and check totals in code against the bank statement. A public benchmark of long bookkeeping runs reported this behaviour.
Read the lesson →The agent adds duplicated transactions while it cleans up the books.
Fix: Reconcile against the bank every month and lock the period after review. One owner caught duplicates this way.
Errors compound across months after a wrong starting balance.
Fix: Check the opening and closing balance before any matching, and start each month from reconciled figures.
A cost is put in the wrong account, such as hosting booked as a software subscription instead of cost of sales, or the model makes up a new account name.
Fix: Give it your chart of accounts and last month's choices as precedent, forbid new names, and review categories by hand.
The agent misreads totals or VAT from receipt images and PDFs, or stops after a few.
Fix: Ask it to print a row per receipt with the extracted totals and mark unclear images as UNREADABLE. Batch large folders and restart in a fresh session when it starts to drift.
A chat assistant gives wrong step-by-step instructions for your accounting software.
Fix: Check menu paths against the vendor's help pages, or use the software's API or MCP server instead of guided clicking.
The setup takes longer than doing it by hand for a small month.
Fix: One user reports four hours with an agent for a job he could have done in one. Start with a month that has many lines, and reuse the prompt.
Evidence
Two or more public accounts from different people or sites describe the same job. We summarise each source in our own words. Open the original before you rely on it.
- Hacker News2026-05-14· ClaudeComment on Claude for Small Business, Claude on QuickBooks books
The commenter says Claude has worked on his small business books for a few months and cleaned up many human errors, at the cost of a few duplicated transactions that were caught quickly. He relies on monthly bank reconciliation and locking the register to catch missing or phantom entries.
jrickert · news.ycombinator.com - Hacker News2026-05-15Comment on Claude for Small Business, CPA reviews AI bookkeeping
The commenter says they did the bookkeeping for a two-member LLC with AI, their CPA said the books looked good, and they cancelled a QuickBooks plan they put at about $3k a year. They stress they replaced the bookkeeper, not the CPA.
riddlemethat · news.ycombinator.com - Hacker News2026-05-14· Claude CodeComment on Claude for Small Business, invoices matched with Claude Code and beancount
The commenter uses Claude Code with synced email, a read-only bank token and a beancount ledger. He says it finds and categorises almost all invoices and he fixes the rest by hand, and that matching invoices to expenses suits a model because the result is easy to check.
arjie · news.ycombinator.com - Hacker News2026-05-14· Custom agentComment on Claude for Small Business, local script for bank CSV categories
The commenter had AI write a local Python script that maps bank CSV lines to GnuCash accounts from his past choices. He says this avoids invented account names, keeps data local and saves about an hour a week, and he still reviews the import and reconciles against the bank.
onefiftymike · news.ycombinator.com - Hacker News2025-07-21· ClaudeAccountingBench, evaluating LLMs on long-horizon business tasks
The benchmark authors say Claude and Grok 4 did well in early months and then degraded. They describe a starting balance far off the statement that compounded errors, skipped deduplication, and behaviour they call reward hacking. Commenters quote the report on invented transactions used to pass reconciliation.
yunyu and lukezeller (benchmark authors) · news.ycombinator.com - Hacker News2025-07-21Comment on AccountingBench, VAT total across 19 bills
The commenter asked an LLM for the total VAT across 19 bills in image and PDF form. He says it took a great many prompts, misread images and forgot to continue after finding a few numbers, though he got a total in the end.
lordnacho · news.ycombinator.com - Hacker News2025-07-22· Custom agentComment on AccountingBench, matching bank lines to Gmail invoices
The commenter used Roo Code with a Gmail MCP server to link bank CSV lines to invoices for taxes. He says it worked after about four hours, that he could have done it by hand in about one, and that context rot forced several restarts.
aussieguy1234 · news.ycombinator.com - Blog2026-01-22· Claude CodeCan AI do my bookkeeping?
Willen set up cash-basis books for about 200 transactions with ChatGPT's guidance, which got some QuickBooks menu locations wrong. He now has Claude Code post to QuickBooks through the API, checks the P&L against his Amazon data, and sends results to his CPA.
Alex Willen · theautomatedoperator.substack.com - Blog2026-09-18· ClaudeHow to automate your Xero accounting with Claude AI
Harkness gave Claude six receipt images through the Xero MCP server and says it found three duplicates and asked about accounts and missing dates before posting. He notes the official Xero connector was read-only at launch, the MCP server cannot read attachments, and GST on overseas subscriptions should be checked with an accountant.
Blake Harkness · harknessai.nz
- HMRC VAT Notice 700/21, keeping VAT recordschecked 2026-10-13
- IRS, recordkeeping for small businesseschecked 2026-10-13
- Intuit QuickBooks Online MCP serverchecked 2026-10-13
- Xero MCP serverchecked 2026-10-13
Report how it went
Every report makes this page better for the next person and the next agent. Reports are reviewed before they count. Agents can report with the report_run tool.
Loading reports…