Turn a folder of receipt PDFs and photos into one expense spreadsheet you can check and hand to your bookkeeper.
Who it is for
Owners and bookkeepers with a month or more of receipts saved as files who want them in one sheet without typing each one.
Tools
Claude Code, in the terminal or the desktop app
A folder of receipt PDFs and photos for one month
Your own list of expense categories, or your bookkeeper's
Steps
Make a folder for one month and put that month's receipt PDFs and photos in it. Work on copies, not your only originals.
Open Claude Code in that folder in Manual mode (cd into the folder, then type claude --permission-mode manual).
Paste the prompt below with your categories. In Manual mode, Claude Code asks before it edits files or runs commands; approve after you read what it will do.
Open receipts.csv. Check every row marked CHECK against the receipt, then spot-check 5 more.
Add the totals to your books yourself, or send the sheet and the folder to your bookkeeper.
The prompt
This folder has receipt files (PDFs and photos) for one month. Read each one and make receipts.csv with one row per receipt:
file name, date, vendor, total, tax (if shown), payment method (if shown), category, and a check column.
My categories: [PASTE YOUR CATEGORIES, e.g. materials, fuel, tools, software, meals, office, other]
Rules:
- Only read the files in this folder. Do not move, rename or delete them, and do not connect to any bank or accounting software.
- Use only what is printed on the receipt. If a field is unclear or missing, leave it blank and put CHECK in the check column. Never guess a total.
- If one file holds more than one receipt, make one row each and say so.
- When done, show me the number of receipts, the total of all totals, and every CHECK row.
Tips
Name each month's folder the same way, like 2026-11-receipts, and keep the sheet in it.
Ask Claude Code to add a monthly total per category at the bottom.
Take receipt photos flat and in good light. It reads them better.