Skip to content
UsecaseBoard
← All use cases
blogPersonal finance

Log daily spending in Claude and let it update the budget workbook

At a glance

Mahnoor had Claude build a multi-sheet budget workbook, then logged purchases in natural language from a Claude Project so the spreadsheet updated without opening Excel. This workflow is listed under Personal finance, Budgeting.

Agents / tools
Claude, Claude Projects, Excel

SourceBuilding a tool for these workflows? See weekly rates.

What they did

1) Ask Claude in plain language for a budgeting workbook with a Transactions sheet plus derived Dashboard, Monthly Budget, Monthly Summary, Savings Goals, Recurring Bills, and Net Worth sheets driven by formulas from Transactions. 2) Create a Claude Project, upload the workbook as reference, and write persistent instructions that categorize spends, ask clarifying questions when needed, and return an updated file. 3) When you spend or earn money, open the Project chat on phone or desktop and type the date plus what happened in natural language (for example matcha amount and commute cost). 4) Answer category questions if Claude is unsure (cafe vs groceries), then download the returned spreadsheet after it appends rows with a library such as openpyxl. 5) Repeat for later purchases in the same Project so context continues; verify a few totals against your bank or card before trusting the dashboard.

How it went

She reported logging from phone or laptop in the moment and ditching budgeting apps for this Claude-plus-spreadsheet loop; the published demo recreates the same process without her private months of data.

Worth knowing

There is no bank sync in this workflow; you are narrating spends to a cloud model. Strip account numbers and avoid pasting full statements if privacy is a concern. Keep the latest downloaded workbook as the source of truth and re-upload it when starting a new chat; do not assume an older Project reference has updated itself.

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 →