by Audra Carpenter

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.

Our suggested starting prompt — not the author's original · untested
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

Report a correction

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.

Claude Cowork · Finance and bookkeeping · Prompts and files · Source: Andrew Blumson, founder of Adevious, a UK AI training and software business (per adevious.co.uk); the business whose bookkeeping the post describes is not named · October 24, 2026

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.

Claude Code and Codex · Finance and bookkeeping · Connected apps · Source: Philip Eriksson, co-founder of Igdrasil (Swedish bookkeeping platform), writing about his own companies · September 27, 2026

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.

Claude Code · Finance and bookkeeping · Connected apps · Source: Peter Hartree, freelancer and self-described AI Uplift Consultant; author of the AI Wow study journal and newsletter (wow.pjh.is); describing his own freelance invoicing · December 8, 2025