# Receipts to a sheet with Claude Code

> Researched. Small business · Intermediate · Invoicing & money. Updated 2026-11-09.

Canonical page: https://www.aisetupsthatwork.com/setups/turn-a-folder-of-receipts-into-a-spreadsheet-with-claude-code/

## 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's 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
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.

## Copy-paste prompt
Adapt bracketed fields to your situation.
```text
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.
```

## Guardrails
- What it touches: Chat input you provide (Claude Code, in the terminal or the desktop app; A folder of receipt PDFs and photos for one month).
- Needs your OK: Send, pay, publish, delete, and CRM updates stay with you unless you explicitly opt in.
- Safety level: Read-only
- You check the numbers: Reading blurry photos is where mistakes happen. The prompt marks every unsure row CHECK. Compare those with the receipt before the sheet goes to your books.
- Not tax advice: The category is a sorting aid. Your bookkeeper or tax preparer decides what is deductible.
- A faded receipt gives a wrong total. That row should say CHECK; fix it by hand.
- The same receipt saved twice. Ask Claude Code to flag rows with the same vendor, date and total.
- Claude Code asks to install a tool to read PDFs. Ask it what and why before you approve.

## 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.

## Estimates (labeled, not measured)
- Time saved: Not stated in sources.
- Money saved: Not stated in sources.
- Tool cost: Claude Code needs a paid Claude plan (Pro, Max, Ultra, Team or Enterprise) or a Claude Console account. Plan prices: see claude.com/pricing.

## Sources
Summaries use the public sources below, not independent verification.
- Anthropic: https://code.claude.com/docs/en/quickstart (Claude Code quickstart (read Nov 9, 2026): install commands for macOS, Linux, WSL and Windows, a desktop app option, plans that include it (Pro, Max, Ultra, Team or Enterprise, or a Claude Console account), start it with "cd" into a folder then "claude". Whether it asks before acting depends on the permission mode (see the permission modes page).)
- Anthropic: https://code.claude.com/docs/en/permission-modes (Claude Code permission modes (read Nov 9, 2026): in Manual mode Claude Code stops and asks before most actions that edit files, run shell commands or reach the network; auto mode is the built-in starting mode for interactive terminal and VS Code sessions on current versions; start in Manual with claude --permission-mode manual, or switch with Shift+Tab.)

## Get the free starter pack
Five beginner copy-paste AI setups, free by email: https://www.aisetupsthatwork.com/starter-pack/?utm_source=ai-agent&utm_medium=markdown&utm_campaign=setup-turn-a-folder-of-receipts-into-a-spreadsheet-with-claude-code

Related:
- [Log receipts by photo instead of typing](https://www.aisetupsthatwork.com/setups/receipt-expense-log-with-ai/index.md)
- [Catch up months of books before your bookkeeper](https://www.aisetupsthatwork.com/setups/catch-up-months-of-books-before-your-bookkeeper/index.md)
- [Sort your expenses into tax-ready categories](https://www.aisetupsthatwork.com/setups/expense-categories-for-tax-time/index.md)
