Skip to content
UsecaseBoard
← All use cases
personal blogmoney

Turn monthly receipt photos into a household ledger

At a glance

A household uses Claude Code to turn receipt photos into a categorized spreadsheet and repeat the process each month. This workflow is listed under money, household, bookkeeping.

Agents / tools
Claude Code, Excel

SourceBuilding a tool for these workflows? See weekly rates.

What they did

1) Gather a month of receipts, photograph two or three at a time so the text is legible, and transfer the images to a desktop folder. Open Claude Code with access to that folder. 2) Ask it to read all images and create an Excel file in the same folder with each purchase date, store, tax-inclusive amount, category and main items, plus a date-ordered list and category totals. Instruct it to count a receipt and card slip for the same purchase only once, leave unreadable entries blank and ask about expenses without receipts. 3) Approve the requested file operations if prompted, check the resulting numbers against the receipts and adjust categories or layout in conversation. Enter salary and automatic withdrawals yourself. 4) Once the format works, ask Claude Code to create a skill from the process and an annual ledger. For the next month, put the new photos in a folder and ask it to follow the same procedure.

How it went

The author reports spending about 15 minutes on a month of bookkeeping, compared with about an hour when entering it by hand.

Worth knowing

The author used a paid Claude plan and treats the AI-generated numbers as a draft to check.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →