Skip to content

Search setups and tools

Type a few words to search.

Browse all setups

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.

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 Pack
  • Free 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

  1. Copy the prompt.
  2. Paste it into Claude Code.
  3. 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

  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.

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?

ResearchedRead-only

Invoicing & money · Intermediate · Small business

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.

Reviewed Nov 9, 2026

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.

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