Match a month of invoices to your bank statement in minutes

🧰 Before you start

• A paid Claude plan (Pro, Max, Team or Enterprise)
• The Claude desktop app (Mac or Windows) for Cowork features
• Your bank statement for the month (download as CSV if possible) and the invoices as PDFs, in one folder

🪜 Steps (tick as you go)

1. ☐
   1. Make a folder

   On your computer create a folder like 'Reconcile 2026-10' and put the bank statement and all invoice PDFs inside.

2. ☐
   2. Open Cowork

   Open the Claude desktop app, choose Cowork and give it access to that folder only.

3. ☐
   3. Paste the prompt

   Copy the 'Reconcile' prompt below and run it.

4. ☐
   4. Check the 'unmatched' list

   Look at payments with no invoice and invoices with no payment. Find the missing ones or note why.

5. ☐
   5. Save for your accountant

   Keep the spreadsheet and renamed files in the folder and send it to your accountant.

6. ☐
   6. Optional: automateOptional extra

   If you want this to run automatically from Google Sheets, try the n8n template (install button). It uses OpenAI and needs some setup.

💬 Prompts to copy

In this folder are my bank statement for [month] and invoice PDFs.
1. Clean up supplier names (e.g. 'TNB*BILL 123' becomes 'TNB').
2. Categorise each payment: [rent, utilities, salaries, marketing, software, supplies, other].
3. Match each invoice to a payment by amount (MYR), date (within 7 days) and supplier.
4. Make a spreadsheet: date, supplier, category, amount, invoice number, matched (yes/no), file name.
5. List unmatched payments and unmatched invoices separately.
6. Rename invoice files 'YYYY-MM-DD supplier amount.pdf'.
Don't delete anything. Ask me if something is unclear.

🔗 Links

• Substack review (source): https://aiblewmymind.substack.com/p/claude-cowork-use-cases-guide
• n8n template: bank statement and invoice reconciliation: https://n8n.io/workflows/10581-automate-bank-statement-and-invoice-reconciliation-with-gpt-and-google-sheets/

From https://usecasy.com/use-case/claude-bank-reconcile/ · Guide checked 15 October 2026 · Prices are rough and shown in USD unless stated (MYR where relevant).