Reconcile 200 business transactions with a review list

1 · The problem

Reconciling a month of bank rows against receipts was slow and error-prone.

2 · Agent setup

The author had Claude Code build a repeatable pipeline that matches bank rows to receipts, suggests a category with a reason, and flags uncertain rows instead of guessing.

3 · Result

Of 200 transactions, 11 were miscategorised (94.5% right). Seven of those errors were already in the 18 rows it flagged.

4 · Copy-paste prompt

Match each row in bank.csv to a receipt in /receipts by amount and date. Suggest a category with a one-line reason. Never guess silently: put every uncertain row in a separate 'review' sheet.

Related