Build and check a personal spending dashboard from a CSV
At a glance
A tutorial turns fictional purchase data into a filterable Claude dashboard and checks the arithmetic. This workflow is listed under Money, Life admin.
- Agents / tools
- Claude
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Export a month of purchases as CSV; remove account numbers and identifying details, separate transfers and income from spending, and check dates and currency. The example file has date, description, category, and amount columns. 2) In a new Claude chat upload the file and ask for a spending dashboard with month and category filters, matching rows and totals, and a field for monthly take-home pay. 3) Follow up to make the category filter apply to the total, chart, count, and table, while keeping the pay comparison based on the entire month and leaving source amounts unchanged. Open the artifact, enter pay, and check individual rows and sums against the CSV.
How it went
With fictional data, the authors checked an October total of $2,090 across 19 purchases and three subscriptions totaling $45; the checked totals matched the file.
Worth knowing
The dashboard only reflects the uploaded data. In the test the pay field did not persist after refresh, and a new month required another upload.