← Back to library

Hand tax-season sorting and spreadsheets to a coding agent

Chris Blattman, a professor who once worked briefly as an auditor, used Claude Code for most of his tax prep: pulling charitable gifts from a sprawling sheet, gathering deductible expenses and parsing broker exports before handing numbers to his preparer.

  • OutcomeArrive at your tax software with charitable gifts, itemized deductions and a self-employment schedule already compiled into spreadsheets.
  • SetupAn afternoon+
  • LevelIntermediate
  • CreditChris Blattman
View original
Works with
Claude CodeClaude Cowork

Published Oct 23, 2026Updated Oct 23, 2026AI dry run on sample input: passed Oct 23, 2026Source verified Oct 24, 2026

When should you use it?

  • You file yourself and dread the gathering
  • Receipts are spread across email and statements
  • You have side income to report

Not for: Tax advice or filing positions; Anyone who should hire a preparer anyway

What do you need, and what do you get?

You need

  • Card statements and exports
  • Donation records
  • Receipts in email
  • Consulting income records

You get

  • Spreadsheet of charitable contributions
  • Itemized deduction totals
  • Draft self-employment schedule figures

How does it work, step by step?

  1. Collect exportsDownload statements and transaction CSVs into one folder.
  2. Compile giftsHave it total charitable contributions from your records.
  3. Gather deductionsSearch receipts and statements for deductible items by category.
  4. Build the business scheduleSort consulting income and expenses into the form's lines.
  5. Do the judgment calls yourselfMark items like medical or childcare by hand, then enter totals in your software.

The prompt

Our own prompt, inspired by Chris Blattman and written to work in Claude Code and Claude Cowork. Values in lime are placeholders.

Prompt0 variables
In this folder are my card statements, bank exports and a donations sheet for [year]. Build three spreadsheets: charitable contributions with date, recipient and amount; possible itemized deductions grouped by category with the source file for each; and consulting income and expenses mapped to self-employment schedule lines. Mark anything uncertain for my review. Do not guess whether a charge is medical or childcare; list those for me.

Inspired by Chris Blattman: Using Claude Code for Tax Season - Claude Blattman · AI for Professionals Who Don't Code. The prompt above is written by playbooks.bot in our own words; nothing from the original is quoted.

What can go wrong?

  • Categories need your knowledge; the author still eyeballed some charges.
  • Totals are inputs for your software, not a filing; check them.

Our take

Coming from someone with real accounting background, the split is credible: the agent is very good at sorting, filtering and parsing exports, and you or a preparer still own elections and filing. Chris used the agent for what it does well: totaling charitable gifts from a messy sheet, searching statements for deductible items and parsing broker exports. The judgment calls, such as medical and childcare items, stayed with him, and the totals went to a preparer rather than straight into a filing. Copy that split. Download source exports into one folder, ask for spreadsheets you can trace back to individual lines, and check every total against the original forms. Expect to eyeball some categories yourself, since the agent does not know your situation. Never let it file anything or invent a deduction it cannot point to. Keep the tax folder encrypted and backed up. If your situation is complicated enough that you need a preparer, this prepares a cleaner packet for them; it does not replace them.

Where the time goes back: Sorting, filtering and parsing exports, the slowest part of DIY taxes, is done for you.

FAQ

Is this tax advice?
No. The author says so too and walks through skills using fictional profiles.
What stayed manual?
Flagging which card charges were medical versus childcare.

Source and credit

Inspired by Chris Blattman. We describe the idea in our own words, link to the original, and wrote the prompt ourselves; nothing is quoted.

Inspired by
Using Claude Code for Tax Season - Claude Blattman · AI for Professionals Who Don't Code
Creator
Chris Blattman
Published on
claudeblattman.com
Original date
Jan 1, 2025
License
Not openly licensed (the poster keeps all rights), so we quote nothing and link to the original
Originally for
Claude Code
AI dry run
Oct 23, 2026: passed. Dry-run tested by our AI test agent on sample input. PASS: Gates held on desk check; no live sends or purchases.
AI dry run on sample data; not run with live connected accounts. The playbooks.bot test agent filled the prompt with synthetic inputs, produced the output and checked it against the page's stated outputs and guardrails.
Verified
Oct 24, 2026: source link resolves to the original, the credited creator published it, our excerpt or prompt matches it, and the license allows our use.

Are you the creator? Claim or correct this page.

More in Money & Admin

All 82 Money & Admin playbooks →

Related playbooks

Money & AdminWorkflow✓ AI dry run

Plan your week from your inbox and a spoken to-do list

Let a coding agent read your recent email and current calendar, combine them with a to-do list you dictate, and propose a week's schedule for your approval.

Credit: u/Still_Reindeer_435 on r/AIPersonalAssistant

Under an hour
Money & AdminWorkflow✓ AI dry run

Build a household spending dashboard from exports

See where household money goes, including what the Amazon line items really were, in a dashboard you checked yourself.

Credit: Michael Crist

Under an hour
Money & AdminRoutine✓ AI dry run

Sweep rental sites twice a day with outreach drafts

Have an agent search several rental sites twice daily, filter out what you do not want, draft a tailored message per good listing, and email you a digest.

Credit: u/mikebmx1 on r/ClaudeAI

Under an hour