Reconcile statements and invoices with Claude Cowork
They used Claude Cowork to line up bank transactions with invoices and export the results into Excel.
- What they did
- They gathered a monthly bank statement and several invoices in one local folder, then gave Claude Cowork a single instruction for the whole job. The agent cleaned up merchant names, sorted spending into categories, found invoice matches for transactions, marked anything without a bill, created a formatted Excel spreadsheet, and proposed uniform names for the invoice files.
- How it went
- It identified the records correctly, renamed the invoices neatly, and marked every transaction that lacked an invoice. The author said it saves them about an afternoon each month. They only tested a few invoices.
- Tips
- Try it first on a small, low-risk set of files, since Cowork can access local documents directly. Review the proposed matches and filename changes before using it on a full month.
Try it yourself with Claude Cowork
Please look through [folder path], which contains a bank statement file and invoice documents. Normalize the vendor names, organize each expense into a category, and match the invoices to the corresponding transactions. Create an Excel workbook that includes the matched items, transactions without invoices, and invoices that do not link to any transaction. Before changing any file names, list the new names you want to use and wait for my approval. If anything is ambiguous, ask me before continuing.
Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.
Get 3 agent uses like this every morning
With the day's top AI news. Free, and one click to unsubscribe.
Related agent uses
Build a morning chief-of-staff routine
A surgeon uses scheduled agent tasks to sort messages, prepare meetings, and surface stale deals before the day starts.
Stage your docs and let Cowork run the scripts
A commenter uses Claude Cowork on a headless setup to run work scripts on cloned documents kept in its cloud session.
Teach your agent a folder of personal scripts
Claude Cowork learned a set of homegrown automations from a scripts folder and kept using them in its own app.
Use Claude to check Booking.com reservations each day
A small-hotel owner used scheduled Claude tasks in Chrome to review Booking.com bookings and confirm which guests had checked in.
Use Claude Cowork to grade papers and plan lessons
A teacher used Claude Cowork to speed up lesson planning, marking, slide creation, and grade analysis across several classes.
Sort PDF batches into folders by their text
They used Claude Cowork to read hundreds of PDFs in one folder and move them into subfolders based on text matches.