Receipts to a sheet with Claude Code
Turn a folder of receipt PDFs and photos into one expense spreadsheet you can check and hand to your bookkeeper.
For owners and bookkeepers with a month or more of receipts saved as files · Claude Code · Intermediate
Researched, not run yetWhat that means
Copy the prompt
Fill in the [brackets] after you paste it.
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.Copied. Paste it into Claude Code next.
Free PDF
Get this setup as a PDF
Enter your email and a print-ready copy of this setup opens here, to save as a PDF. The free starter pack opens too. Tap confirm in the email that follows to get occasional new setups. Unsubscribe anytime.
Already a subscriber? Unlock it on this device
Free PDF
A confirmation email is on its way too: tap confirm in it to get new setups by email.
Three ways to run this setup
Free
Copy and paste it yourself
Copy the prompt above into ChatGPT, Claude or Grok. It drafts. You approve.
Go to the prompt$9 once
Complete Pack
One payment, no membership. Opens the pack pages: Bot Safety Checklist, Second Brain Starter Vault, Voice File Starter, Tested Grok Bot prompt pack, Write it as code prompts.
See the Complete PackFree to start, VIP $19 a month
Save it as a bot in the guided setup app
The app turns this setup into a bot with the draft-only rules. 3 setups build free; the rest are part of VIP. A human reviews a prompt or setup for you within 24 hours, up to 2 a month.
Build it in the app
Want this one tested next? Vote for it.
What you get back
Example written for this page with made-up names. Not from a test run.
- Read 37 files. Wrote 38 rows (one PDF had two receipts). Sum of totals: $2,914.06. 4 rows marked CHECK.
- IMG_0412.jpg | 2026-11-03 | Valley Lumber | $184.20 | $10.43 | card | materials |
- scan_07.pdf | (blank) | Shell | $61.88 | (blank) | (blank) | fuel | CHECK: date not readable
3 steps
- Copy the prompt.
- Paste it into Claude Code.
- Fill in the [brackets], then read the answer before you send or use it.
Quick answer
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 per receipt: date, vendor, total, tax, category and the file name. Anything it cannot read clearly gets marked for you to check. It works only on the files in that folder and is never connected to your bank or accounting software.
How do you set it up?
Skip this if
- Your receipts already flow into accounting software that reads them.
- You have only a few receipts a month. Typing them is faster.
Done after day one
One spreadsheet of a month of receipts, with the unsure rows checked by you.
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.
Where to paste this prompt
Claude Code → terminal, IDE extension, or web session in your project directory
More ways to run it
Which chat tools work with this prompt?
Paste the prompt into any of these assistants (free or paid tiers).
- Claude Code
How sure is this?
Last updated: · Last reviewed:
Before you use this
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.
What it is allowed to do: Read-only. Only reads, researches, or summarizes. It never drafts outbound content or changes anything.
At a glance: time, cost and difficulty
At a glance
All outcome figures are estimates from cited sources, not independent verification by us.
- What it is allowed to do
- Read-only
Only reads, researches, or summarizes. It never drafts outbound content or changes anything.
- Time saved (estimate)
- Not measured yet
- Difficulty
- Intermediate
- Tools needed
- Claude Code, Google Sheets
- Typical 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.
Reviewed Nov 9, 2026
Basis (estimate): Not measured yet. We haven't timed this.
What usually goes wrong?
Where agents tend to stall on this job. More patterns in Where AI gets stuck.
- 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.
What tips make it smoother?
- 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.
Where do the claims come from?
Summaries use public sources linked below, not independent verification. How setups are picked.
- Read Anthropic’s write-up (code.claude.com)
Anthropic: 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).
- Read Anthropic’s write-up (code.claude.com)
Anthropic: 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.
Common questions
- What does this setup do?
- 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 per receipt: date, vendor, total, tax, category and the file name. Anything it cannot read clearly gets marked for you to check. It works only on the files in that folder and is never connected to your bank or accounting software.
- Who is it for?
- Owners and bookkeepers with a month or more of receipts saved as files who want them in one sheet without typing each one.
- What does it cost to run?
- Claude Code needs a paid Claude plan (Pro, Max, Ultra, Team or Enterprise) or a Claude Console account. Plan prices: see claude.com/pricing.
- What usually goes wrong?
- 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.
- How much time might it save?
- Not stated in sources. Not measured yet. We haven't timed this.
Free kit by email
Get the free kit by email
The starter pack and the Portable AI Office, sent to your inbox. New setups by email after that. Unsubscribe any time.
What to do next
- Log receipts by photo instead of typing
Photograph receipts and have AI pull out vendor, date, and total into a running expense sheet.
- Catch up months of books before your bookkeeper
Sort months of bank and card exports into categories with AI, flag duplicates and missing receipts, and hand your bookkeeper a cleaner file to cut catch-up fees.
- Sort your expenses into tax-ready categories
Categorize a year of business expenses into IRS Schedule C buckets
Have a setup that works? Submit it. We credit sources and write it up in plain language.