Reconcile a month of business transactions
Match a month of bank transactions to receipts and invoices, with uncertain items flagged for your review.
What the agent did
Source-reported example · as described by Ken Imoto
A small-business owner had Claude Code build a reusable bookkeeping pipeline. It pulled transactions from an accounting platform, matched bank rows to receipts and invoices, suggested categories, and flagged uncertain items.
What the author reported
The author reports processing 200 transactions with 11 category errors. Seven errors were among 18 flagged items; the remaining four were caught during a sample review. The owner retained responsibility for reviewing tax-relevant categories.
Limitations
Errors involved missing context about business versus personal purchases, local tax rules, and payments covering multiple items.
Try it in your business
What you'll need
The original setup used an accounting-platform connection, bank data, supporting documents, and an agent-written pipeline script. The accounting platform, connection, exact prompts, and script are not disclosed.
Author had Claude Code build a reusable reconciliation pipeline; connecting the accounting app was one part of that setup.
The original is a custom-built system. The prompt below is a simpler starting point and won’t reproduce it.
Starting prompt
The author didn't publish their prompt (author points to a paid book), so this is our adaptation.
How ours differs from the original setup: Original pulls transactions over an MCP connection to an accounting platform; ours starts from a CSV and folder, on copies.
Build a reusable reconciliation script for the bank transactions in [CSV] and receipts and invoices in [folder]. Propose matches using amount and date, explain the suggested category for each transaction, and flag uncertain matches, split payments, and missing documents. Export a spreadsheet for my review. Work on copies and leave my accounting records unchanged.
Replace the [bracketed] parts with your own files and tools.
Get examples like this every Tuesday and Friday
Practical ways to put AI agents to work in your business. We check the original sources, explain the setup and point out the limits. Free.
Unsubscribe any time. Privacy policy
Related use cases
Categorize bank transactions, number vouchers, match payments to invoices and draft year-end accounts
Have Claude Cowork do the bookkeeping from a bank statement and spreadsheet, match payments to invoices and draft year-end accounts, as the author describes in a LinkedIn post that he says Claude wrote.
Our suggested starting prompt — not the author's original · untested
You'll need: Claude Cowork with access to your bookkeeping spreadsheet (and a backup copy), your bank statement export and your sales invoices; last year's accounts prepared by your accountant, for the format; a rules file kept alongside the spreadsheet; your own answers to its questions; your accountant's review.
You are helping me with bookkeeping in Cowork. Files: bank statement [file], bookkeeping spreadsheet [file], sales invoices [folder], last year's accounts from my accountant [file]. Step 1: make a backup copy of the spreadsheet before changing anything and tell me where it is. Step 2: read the spreadsheet and describe my categories, how voucher numbers run and which kinds of transaction never get a number; wait for me to confirm. Step 3: fill in only blank rows where the category and voucher number are clear from the history; for anything new or ambiguous, list a question for me instead of guessing, and never overwrite a filled row. Step 4: check your work against the backup: row counts, and gaps or duplicates in the numbering; report what you find. Step 5: match each client payment to a sales invoice and list any invoices still outstanding and any matches you are unsure about. Step 6: save the rules we agreed, and my answers, to [rules file] and show me what was added. Then, only after I have reviewed all this, draft this year's accounts in the same layout as last year's, section by section, from the categorised data, and flag anything that needs my accountant's judgement (for example depreciation, tax and opening balances) instead of filling it in. Do not send anything to my accountant or anyone else.
Stage bookkeeping entries from receipts and bank rows for owner approval
Have Claude Code or Codex work through a bookkeeping backlog: read receipts and invoices, propose accounts and VAT, match bank rows, and stage draft entries that wait for your approval before anything is posted.
Our suggested starting prompt — not the author's original · untested
You'll need: Claude Code or Codex with your own Anthropic or OpenAI subscription; a bookkeeping platform the agent can reach through a CLI or MCP server with a stage-then-approve queue (he used Igdrasil); your receipts, invoices and bank feed in that platform; a practice company for testing; your rules for voucher series, recurring accounts and what should wait; your own approval of every posting and anything sent to the tax authority
You're helping me with the books for my company [name] in [bookkeeping tool], which you can reach through its CLI/MCP. Work in drafts only. First, list what is unmatched in the bank right now and group the rows. For each group, read the linked receipts or invoices and propose the account, VAT code and business purpose, and flag anything unclear, new suppliers, mixed VAT or unpaid supplier invoices for me instead of guessing. Use voucher series [series] and these rules: [account rules, what should wait]. Create draft entries and stage them for my approval, then check the draft set for duplicates and show me a list of what you staged. Do not post, approve, correct or delete anything, file or send anything to the tax authority, export to other systems, create test entries, or change any code. After I approve a batch and it's posted, read the ledger back and give me a reconciliation, not a summary.
Create and send monthly client invoices and check last month's payments, with your checks before invoices are created and before they're marked paid
Have Claude Code run a skill that drafts your monthly client invoices from your time reports and calendar, creates them in Xero, emails them from Gmail and checks last month's payments, pausing for your check before invoices are created and before they are marked paid.
Author's original prompt
You'll need: Claude Code; a Claude skill describing your monthly invoicing steps; access from Claude Code to your time tracker (Toggl), accounting software (Xero), calendar (Google Calendar), email (Gmail) and a notes app for the task list (Obsidian); your client rates and invoicing rules; your own review at the skill's checkpoints (after the time reports, before invoices are created in Xero, and before invoices are marked paid); the post states no check right before invoices are emailed, so our suggested prompt adds one
Hey Claude, I'm a freelancer and I have to send invoices every month and also verify that my past month's invoices were paid. Could you help me make a skill to do this?

