Reconcile scanned travel receipts into a complete expense claim
At a glance
Rameez Khan used Claude Cowork to reconcile trip receipts with bank transactions and prepare the company's expense sheet. This workflow is listed under Expenses, Office Automation, Travel.
- Agents / tools
- Claude Cowork, Excel
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Put scanned receipt PDFs and the matching bank statement in a directory Cowork can access. Specify which expenses are business-related and the company's required spreadsheet columns: reference, date, description/business reason and cost. 2) Ask Cowork to extract receipt dates, merchants and amounts, rename working files as YYYYMMDD_placename.pdf and retain the originals in an archive folder. 3) Match receipts to statement transactions, using the statement's local-currency amounts and flagging uncertain merchant matches. 4) Extract public-transport charges by day and check other trip-period transactions for missed expenses. Require receipt coverage and reconciled totals. 5) Review uncertain entries, copy the finished sheet into the expense system, attach the renamed PDFs and submit it yourself.
How it went
Twelve receipts became a 21-line claim in about six prompts. Completeness checks surfaced an eSIM purchase and an Uber expense.