Skip to content
TriedPrompts

More in Bookkeeping, receipts & invoices.

Reconcile 12 trip receipts into an expense sheet with Claude Cowork

WorkedEvidence: Described by posterPosted Last checked

Rameez Khan used Claude Cowork to match 12 scanned trip receipts to a bank statement and build the expense Excel.

How to use this

  1. Tap Copy prompt.
  2. Open the tool the case used (or a similar one) and paste the prompt; results may differ from the original.
  3. Paste it into the message box.
  4. Send it, then read the answer before acting on it.
New to this? What's a prompt?

A prompt is the message you send to the AI tool. Copy the one on this page, put your own details where it asks, and read the answer before you act on it.

Prompt

Recreated prompt

The source didn't share its exact prompt, so we wrote one from what it describes. The result shown is the source's, not ours.

What the prompt labels mean

The person didn't share their exact words, so we wrote this from what they described. We haven't tested it, and they didn't use this exact version.

I have a folder with 12 scanned PDF receipts and my bank statement from a business trip. Extract date, description, and amount from each receipt, rename files to YYYYMMDD_placename.pdf, move originals to an archive folder, match each receipt to the bank statement, build an Excel spreadsheet in my company's expense form format, include transport charges, and run a completeness check before I submit. Do not invent matches.

Try this in:

ChatGPT Gemini Grok Claude

Sends the Recreated prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini and Claude open empty, so we copy the prompt for you to paste. Every button also copies it.

The source used Claude Cowork, which can take actions in a browser or app. These are general chat tools, so results may differ, and a normal chat may only give you a plan.

Opens in a new tab. We don't see what you send.

These links are only a shortcut. We're not affiliated with OpenAI, Google, Anthropic or xAI, and your results may not match the source.

Optional stronger version

Our rewrite with extra checks. The poster didn't test it.

Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish.

Goal: Reconcile trip receipts to the bank statement and produce the company expense spreadsheet.

Questions to ask me first:
- Folder path and expense template?
- Local currency and transport rules?
- Who must approve before submit?

Inputs (fill in or confirm):
- Folder: [PATH]
- Template: [FILE]
- Currency: [LOCAL]
- Transport: [RULES]

Rules:
- Match only when the bank line supports it.
- Rename with YYYYMMDD_placename.pdf.
- Archive originals; keep working copies tidy.
- I submit the claim myself.

Checkpoint: After matching half the receipts, show open items.

If you get stuck: If a receipt has no bank match, list it separately.

Verify before you finish: Every included row has a receipt and a bank line or an explicit exception.

Output: Excel sheet plus renamed PDFs ready to attach.

Done when: I can paste into the company system and submit.

AI tool

Claude Cowork

Outcome

Rameez Khan returned from a business trip with 12 scanned PDF receipts and a bank statement. Claude Cowork extracted dates, descriptions, and amounts, renamed files to YYYYMMDD_placename.pdf, archived originals, matched receipts to bank lines (including judgement calls like Café Milano), built an Excel sheet in the company expense format, added transport charges, and ran a completeness check. The sheet and renamed PDFs were copied into the expense system and submitted.

Evidence: Described by posterThe person describes what happened in words, without screenshots or video.

Source

Posted
by Rameez Khan
Last checked
Method:
How we verify

https://rameezkhan.me/posts/2026/2026-02-11--using-claude-cowork-to-process-scanned-pdf-receipts-for-expense-claims/

More in Bookkeeping, receipts & invoices

Similar cases