Skip to content
UsecaseBoard
← All use cases
blogMoney

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.

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 →