Consolidate bank statements into a spending dashboard with Claude
Miles Deutscher reportedly uses Claude to merge monthly bank statements into a dashboard, visualize spending, compute metrics and analyze portfolio allocation.
Done with a custom-built or unnamed agent
- What they did
- Miles Deutscher drags monthly bank statements into Claude. The model consolidates the statements, builds a dashboard for spending visualization and calculations, and analyzes portfolio allocation. The user double-checks outputs because the model can hallucinate.
- How it went
- This let him handle his basic passive portfolio without full-time high-cost advisers, though he still seeks occasional consulting advice.
- Worth knowing
- Always verify AI outputs manually as hallucinations remain possible.
Try it yourself with Claude Cowork
I've put my monthly bank statements from [months] in [folder]. Merge them into one spreadsheet, categorize each transaction, and build a dashboard showing spending by category, monthly totals, and [metrics, e.g. savings rate]. If I add [portfolio holdings file], also show my allocation by asset type. Finish by telling me the three biggest things you notice, and do not change or delete my original files.
Source: X · Oct 3, 2026
Five of these in your inbox every morning
The best things people got an AI agent to do, each with the prompt to try it.
More like this
- Custom agent
Shop for umbrella insurance through your personal agent
Personal AI agents use Coverage Cat's Agent API/MCP to size umbrella coverage and compare carrier options with price ranges, backed by a licensed broker.
File a complex tax return with OpenClaw
OpenClaw built a Schedule C P&L from bank transactions, guided TurboTax entry for 4+ hours and caught an error in a prior accountant's work.
Fill forms and review tax filings with Codex computer use
Secondhand accounts of OpenAI staff using Codex computer use for forms and PDFs, including one tax filing review that caught an error worth thousands.
Prepare and file overdue German VAT statements
Cowork with Claude's Chrome extension prepared accounts from invoice PDFs, then logged into Elster and submitted the overdue Q3 2025 VAT forms.
- Custom agent
Draft a refund demand for an unauthorized renewal
The poster used ChatGPT to write a stronger message to Skillshare after an unauthorized $24 renewal, threatening a dispute and chargeback.
- Custom agent
Fight a mattress warranty claim by email
A user's agent emailed back and forth with the mattress company's agent, citing laws and pushing aggressively, to resolve a warranty claim.