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.
What the agent did
Source-reported example · as described by 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
The author, Andrew Blumson, posted on LinkedIn on 2026-10-24 that bookkeeping is the job he puts off each year: export the business bank statement, work through hundreds of transactions one by one, tag each with a category, give every business purchase its own voucher number, match client payments to sales invoices, then hand it all to his accountant.
He introduces the rest of the post as written by Claude ("Below from Claude as it writes better than I do"). The post says that this year he handed most of that to Claude in Cowork, and describes five things it did.
(1) It read his spreadsheet first and worked out his categories, how his voucher numbering runs, and which transactions never get a number (loans, salaries and money coming in).
(2) It filled in only what it was sure of: anything with a clear history was completed, and anything new or ambiguous came back to him as a question (Amazon purchases are always asked about).
(3) Every run takes a backup first and only fills blank rows, then audits itself against the backup, checking the row counts and the numbering for gaps and duplicates; the post says it spotted a small inconsistency from over a year ago that he had not noticed.
(4) It became a reusable skill whose rules live in a file that grows every time he answers a question, so it asks fewer questions each month; the post says the latest run filled over 100 rows and stopped for only a handful of genuine decisions.
(5) It reads his sales invoices, puts the right invoice number against each client payment, recognises when a client pays a few days early, and lists anything still outstanding.
For the year-end accounts, the post says he gave it an old set prepared by his accountant; it went through the layout section by section (cover page, director's report, profit and loss, balance sheet, notes and the detailed expense schedule) and built this year's draft in the same format from the categorised bank data.
Items that need professional judgement, such as depreciation, tax and opening balances, were flagged for the accountant to complete. The post says the accountant still checks everything. It does not say which business the books belong to, give a prompt or show any output.
He says the workflow "saves me so many hours" (no figure given), that the latest run filled over 100 rows and stopped for only a handful of genuine decisions, and that the skill asks him fewer questions each month. No time saved, accuracy or error rate is reported.
Limitations
A single LinkedIn post, and the author says the body was written by Claude, so it is Claude's description of what it did, posted by him; the post shows no screenshots, files, prompt or output, and nothing in it can be checked beyond his word.
The post does not say which business the books belong to, the size of the files, how long the year-end draft took, or how accurate the categories or the draft were. The time saved is not quantified.
Items needing professional judgement were left for his accountant, who still checks everything, so the draft accounts are not final. The post says the skill asks him fewer questions each month although it also describes a yearly routine; it does not explain the difference. The model is not stated.
Try it in your business
What 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.
The post describes Claude in Cowork working from his spreadsheet, a backup copy, his sales invoices, an old set of accounts and a rules file. No connected apps or custom code are described.
Starting prompt
The author didn't publish their prompt (read the full LinkedIn post text; no prompt or skill text is quoted), so this is our adaptation.
How ours differs from the original setup: Same execution agent (Claude Cowork). The author published no prompt, so this is our starting prompt built from his five numbered steps and his description of the year-end draft. File names are blanks for you to fill in.
It adds a confirm-before-filling step, a ban on overwriting filled rows, and an explicit no-send instruction. It treats the year-end draft as a separate step after review, because the post does not say whether that was done in the same session.
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.
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 business transactions to Schedule C lines and export the year's books for your accountant
Have Claude or Codex build a local bookkeeping app from a reviewed plan that sorts your bank and card transactions into Schedule C lines and exports the year's books for your accountant.
Author's original prompt
You'll need: Access to ChatGPT, Claude (including UltraPlan) and Codex for planning, review and build; a Mac; a paid MCP data feed connected to your bank and card institutions (he used OpenBudget and Truthifi); an Anthropic API key for merchant categorization; a scheduled sync job; adapting the sanitized plan to your own accounts and Schedule C categories; your own review of uncertain transactions; your accountant's review of the year-end export
I am not an accountant. I have a side business that is a single-person LLC, and I file a Schedule C. I use QuickBooks, but I need something I can understand. As a senior accounting consultant, write a plan I can use as a starting point to build a simple, understandable accounting application. It should take in data from an MCP connected to my accounts, categorize transactions, and give me dashboards and reporting. Assume it needs to be an effective replacement for QuickBooks.
Draft late invoice reminder emails every Monday for your approval
Have Claude Cowork set up a Monday-night agent that drafts late-invoice reminder emails for you to review and send, as the author describes.
Our suggested starting prompt — not the author's original · untested
You'll need: Claude Cowork; access to your list of overdue invoices (the post does not say how); a Google Sheet of customer names and contact names; your own reminder email template; access to your mailbox so drafts can be saved; your own review before anything is sent.
Every Monday evening, open [my receivables or invoice system] and list invoices that are past due. Match each customer against my Google Sheet [name] (customer name, contact name). For each match, draft a late-invoice reminder from my template [paste template], using the contact name and each overdue invoice's number, amount and due date. Save the drafts in my Drafts folder. Do not send any email. Then give me a short report: customers included, amount owed per customer and the total, plus any overdue customer who is not in my Sheet and anything you could not read. Do not change or mark anything in the invoice system; I review and send the drafts myself.
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.

