---
name: turn-a-folder-of-receipts-into-a-spreadsheet-with-claude-code
description: "Receipts to a sheet with Claude Code. Put a month of receipt PDFs and photos in one folder and open Claude Code there. Paste the prompt below. It reads each receipt and writes one spreadsheet row."
---

# Receipts to a sheet with Claude Code

## When to use

Owners and bookkeepers with a month or more of receipts saved as files who want them in one sheet without typing each one.

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

## Prompt

Fill the [BRACKETED] parts with the user, then follow this 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.
```

## Guardrails

- Draft first and show the user. Never send, post, pay, book, cancel or delete without the user's explicit approval of that exact action.
- Use only facts the user gives you or that you can cite. If something is missing, ask instead of guessing.

## Common snags

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

## Source

https://www.aisetupsthatwork.com/setups/turn-a-folder-of-receipts-into-a-spreadsheet-with-claude-code/ (AI Setups That Work)
