What the agent did
Built a re-runnable pipeline that pulls the month's transactions over MCP, matches bank rows to receipts by amount and date, proposes a category with a one-line reason for each row and flags rows it isn't sure about.
Result, as claimed
200 transactions reconciled and 11 miscategorised, a 94.5% hit rate. Review shrank to 18 flagged rows plus a sample. 7 of the 11 errors were in the flagged pile and 4 were caught on the sample.
This is the result as claimed in the public source linked below. It has not been checked and is not a typical outcome.
Proof
Try it yourself
Have the AI sort a month of transactions and tell you which rows it's unsure about, so you check 20 rows instead of 200.
Prompt
Here is last month's business bank export with account numbers removed: [paste CSV]. Here is my category list: [list]. Here are my receipts and invoices with date, vendor and amount: [paste list]. For each row, match a receipt if amount and date agree, suggest one category and give a one-line reason. Add a confidence column: SURE or CHECK. Mark CHECK for anything personal-or-business, any meal or entertainment, any payment covering two things and any row with no receipt. Don't guess tax rules. End with a count of SURE and CHECK rows. Return a draft only. Never send, spend, change settings or write to a live system.
Prompt: starter by Solopreneur Code
Steps
- Export one month of bank transactions and remove account numbers.
- Paste it with your category list and receipt list.
- Check every CHECK row yourself.
- Spot-check 10 SURE rows. If any are wrong, add a rule and run again.
- Give the reviewed sheet to your accountant. Don't file from it directly.
Watch out: The AI can't know if a purchase was personal or business, or your local tax rules, so a confident wrong category can slip into a tax filing.
Starter version by Solopreneur Code
Skill: Money and bookkeeping
Add this skill
Bookkeeping draft with doubt flags
Sorts a month of transactions, matches receipts and marks every row SURE or CHECK so you review the doubtful ones first.
- Works with
- Claude, ChatGPT, Gemini, Any AI chat Any AI chat can work on a pasted CSV. Pulling transactions directly needs a coding agent with an MCP or API connection to your accounting software, as in the story. Not tested.
- Tools in the story
- Claude Code
- Country
- Japan
How to use this: Copy the skill, paste it into Claude, ChatGPT or Gemini, and ask it to save it as a skill. If it cannot, it will still follow the steps.
Show skill
If the Copy button does not work, select this text and copy it.