← All use cases

Use case P65 · Human

Have AI track your household spending, then check it against your statements: a monthly budget review in a Google Sheet, and a daily ledger kept with Claude Code

Michaela Jillings and Erik Craddock (@erik) ·

The short version

What they did

Two people had Claude do the sorting and categorizing of their household spending, and both still check the result against their statements because it makes mistakes.

A monthly budget review in a Google Sheet

Michaela Jillings built a monthly family-finance review in Claude using a linked Google Sheet and uploaded credit-card statements, without connecting bank accounts. It categorizes charges and compares spending with the budget, returning a summary she can question. The initial output was wrong because Claude could not read all the spreadsheet columns; she says archiving older columns fixed that issue. Her article, 2026-08-07.

A daily ledger kept with Claude Code

Erik Craddock added Claude Code to his daily personal-finance routine, using a text-based Ledger file and version history. Claude processes receipts, categorizes transactions and adds missing entries that he copies from bank websites. He still checks amounts and cleared balances against bank statements every day because mistakes remain. He also shares his own starter repository, so this case is conservatively marked as a vendor source. His article, 2025-08-17.

Result (as claimed)

The monthly review: “Categorizes all charges and compares totals to our monthly budget, flagging where spend is meaningfully over”

“Test the skill and output with Claude - initially, Claude returned inaccurate information due to the size of my spreadsheet. It had me archive all the columns prior to two years which fixed the issue”

The daily ledger: “Every morning, I spend 5-10 minutes processing my financial transactions from the previous day.”

“It handles the tedious work while maintaining accuracy, automatically categorizing transactions and verifying balances using the ledger CLI tool.”

“While I could automate this completely, I value staying engaged with my finances, and the few daily mistakes make those 5 minutes worthwhile to avoid larger debugging sessions later.”

Prompt

Their prompt:

run my monthly finance review.

This was her invocation for an already configured monthly-review skill. The article says to describe the existing review procedure to Claude and test it against the actual spreadsheet.

Their prompt:

Add this pending transaction to the Visa

This assumes his account mapping and Ledger workspace already exist; it does not authorize bank access or payments.

For the monthly review:

A fuller version to copy:

I’m reviewing my household spending for [month]. I’ll attach [bank and card statements] and [budget sheet with category amounts]. My category rules are [notes, or ask me to define them].

1. Confirm which files, rows and columns you can read before calculating. List any missing part.
2. Categorize each charge, total the categories and compare them with the budget. Show unclear transactions separately for me to decide.
3. Compare the included transactions with each statement total and explain any difference.

Return a category table and a short plain-English summary of spending above budget. Use only the records supplied. Do not silently skip unreadable data, invent transactions or count transfers twice. Mark assumptions and show the arithmetic behind differences. This is a review of downloaded records, not permission to access bank accounts or move money.

For the daily ledger:

A fuller version to copy:

I’m using Claude Code to keep my personal spending in a plain-text Ledger file at [file location]. The account mapping is [paste mapping or name its file]. Here is a pending card transaction copied from my bank: [date, description and amount].

1. Check whether the transaction is already recorded. If it may be a duplicate, ask me before adding it.
2. Use the existing account names to add a balanced entry, keeping its pending status clear. Ask about an uncertain category.
3. Run the ledger check and show the new entry and any reported errors.

Give me a short change summary in plain words. Do not invent missing dates or amounts, access my bank or make payments. I will check the entry and cleared balance against my statement; a passing file check alone does not prove the balance is right.

Do it yourself

These steps are my suggested way in, not any one person’s setup.

Level: Advanced for the daily ledger. The monthly review below is Intermediate.

What you need

  • A chat assistant that can read files, such as Claude or ChatGPT.
  • Your budget in a spreadsheet, such as Google Sheets or Excel, and statement downloads from your bank and cards.
  • For the daily version: Claude Code and a free plain-text accounting tool, such as ledger or hledger.

Start simple

  1. Download last month’s statements, as CSV files if your bank offers them. They read more reliably than PDFs.
  2. Put your budget categories and monthly amounts in a sheet. Keep only recent months, so the file stays small.
  3. Upload both and ask: “Categorize every charge, total each category and flag where we’re over budget.”
  4. Ask about anything surprising.
  5. Write down the steps that worked, so next month you can ask for the same review.

Take it further

  • Save the steps as a project or skill, so “run my monthly finance review” is all you type.
  • Keep a daily plain-text ledger with Claude Code and git, and have it add receipts and pending charges.
  • Ask it to compare category totals month over month.

Check your work

  • Check that the categorized charges add up to each statement’s total.
  • Reconcile the ending balance against your bank statement every time.
  • Don’t give the AI your bank login or any way to move money.

Before you rely on it

  • This is general information, not financial, tax or accounting advice for your situation.
  • AI tools make arithmetic mistakes and misread statements, and they sound just as sure when they do. Check every number against your own records before you act on it.
  • For decisions with tax, loan, insurance or retirement consequences, talk to a qualified professional who knows your situation.

Claimed. Quoted from the source but not yet checked against it. Their prompt is quoted from the source; any fuller version is written for this library. The source was published by a vendor of the tool. Business size: Individual. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.

More in Money and shopping

New cases go out every Saturday in Inside AI.