Skip to content
UsecaseBoard
← All use cases
blogExpenses

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.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →