· Back to the setup

AI Setups That Work

Receipts to a sheet with Claude Code

Researched

What it does

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

Steps

  1. Make a folder for one month and put that month's receipt PDFs and photos in it. Work on copies, not your only originals.
  2. Open Claude Code in that folder in Manual mode (cd into the folder, then type claude --permission-mode manual).
  3. 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.
  4. Open receipts.csv. Check every row marked CHECK against the receipt, then spot-check 5 more.
  5. 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

Sources