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.