Turn six months of receipts into a categorized spreadsheet with Claude Cowork
- Posted
- by Afro Chuck (@ChuckYouSuck)
- Last checked
- Method:
- How we verify
Evidence: Shown on videoThe source includes a video or screen recording of the agent doing the task.
Outcome
Pointed at a folder, Claude Cowork organized 6 months of receipts into a categorized spreadsheet with monthly breakdowns.
Agent
Prompt Recreated prompt
The source didn't share its exact prompt, so we wrote this from what it describes.
Here's a task I'd like your help with. Read it all the way through before you start. Goal: Turn the receipts in this folder into a spreadsheet, sorted into categories with a monthly breakdown. Check with me first: Do I have categories I already use, or should you suggest some? What I'll give you: - The folder with my receipts - Any categories I want you to use Rules: - Read each receipt and record the date, merchant, amount and category. - If a receipt is unreadable or unclear, list it and ask me rather than guessing. - Don't move or change the original receipt files. Output: A spreadsheet with every receipt, a category for each, and totals per month. You'll know it worked when: each month's spending is broken down by category and every receipt appears once.
Try this in:
Sends the Recreated prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini opens empty, so we copy the prompt for you to paste. Every button also copies it.
The source used Claude Cowork, which can take actions in a browser or app. These are general chat tools, so results may differ, and a normal chat may only give you a plan.
Opens in a new tab. We don't see what you send.
These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.
Optional stronger version
Our rewrite with extra checks. The poster didn't test it.
Here's a task I'd like your help with. Read it all the way through before you start. Goal: Turn six months of receipts into a categorized spreadsheet with a monthly breakdown. Quick check first: tell me if anything below is missing or unclear. Inputs (fill in or confirm): - Receipts folder - Categories to use (or ask me to suggest) - Currency and whether to split VAT/tax - Date range - Business vs personal split, if any Rules: - Record date, merchant, amount, tax and category for each receipt; one row each. - Use my categories; suggest new ones only as a list for my OK. - Flag duplicates (same merchant, date, amount) rather than deleting. - Add a pivot or summary tab: totals per category per month. - Keep a column with the receipt file name for traceability. If you get stuck: If a receipt is unreadable, add it to a 'check' tab with the file name. If a login, CAPTCHA or two-step code appears, stop and ask me to handle it; never guess or store passwords. Verify before you finish: Check the grand total equals the sum of all receipt amounts. Output: Spreadsheet with data, monthly summary and check tabs. Done when: every receipt is in the sheet once and the monthly totals reconcile.
Source
https://x.com/ChuckYouSuck/status/2014502869336989810
Related cases
- Enter retail-arbitrage receipts into a spreadsheet with Claude CoworkRecreated promptEvidence: Described by poster
Claude Cowork weekly processes a folder of RA receipts into a spreadsheet with buy cost, store and item; the poster still double-checks but says admin time is way down.
Claude Cowork · Ops · Source date:
- Match a tax-prep checklist against a receipts folder with Claude CoworkRecreated promptEvidence: Described by poster
The poster says matching a spreadsheet of items for their accountant against a folder of receipts usually took 4–6 hours, and that with Claude Cowork it took about an hour.
Poster says:4–6 hour job done in about an hour
Claude Cowork · Ops · Source date:
- Categorize 419 ledger transactions into an Excel template with ChatGPT agentRecreated promptEvidence: Screenshots or logs
Given an Excel ledger template and 419 transactions, ChatGPT agent asked for help on ambiguous merchants, then keyed in all ~400 rows and took 4 minutes.
Poster says:Done in 4 minutes
ChatGPT agent · Ops · Source date: