by Audra Carpenter

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.

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

Report a correction

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.

Claude · Finance and bookkeeping · Custom development · Source: Michael Pierce, founder and principal architect of MDPSync (AI consulting firm), writing about his own single-member LLC side business · June 24, 2026

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.

Claude Cowork · Finance and bookkeeping · Connected apps · Source: Michel Abood (San Diego), works in a wine-import business (per his own reply on the post); the posts do not name the company; Rundown profile 'michel' links to linkedin.com/in/michelabood; company size not stated · October 13, 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