Make a local spending dashboard from bank exports

Personal assistantKINDA1 method

KINDA — AI can help, with a person in the loop.

1 method on the page: 1 prompt.

Use cases

Methods

Paste into a general LLM and make a local spending dashboard from bank exports.

prompt

LLMPrompt

Prompt
Copied 0
Build me a private spending dashboard. Work only in this folder: [path]. Do not upload my data anywhere, and do not install anything without asking.

Inputs (read only, never edit these files):
- CSV exports: [bank-checking.csv, card-1.csv, card-2.csv], covering [months].
- Statement totals to check against: [account: total out, total in, for each month].

1. Write a script (Python or similar) that loads every CSV. Print, for each file, the column names, the row count, the first and last date, and the sums of money in and money out. Every number must come from the code, not from you.
2. STOP. Show me those numbers next to my statement totals and wait for me.
3. Mark lines that are not spending: transfers between my own accounts, credit card payments, refunds. List them and wait for my OK, so nothing is counted twice.
4. Propose a rules file, categories.csv, that maps payee text to a category from this list: [Housing, Groceries, Eating out, Transport, Subscriptions, Health, Shopping, Travel, Other]. Show me the 30 biggest payees and the rule for each. Wait for me to edit and approve it.
5. Apply the rules. Put anything without a rule under "Uncategorised" and list it. Do not guess.
6. Build one local HTML file with charts: spending by month, by category, top payees, and a table I can filter. Show the check totals at the top.
7. Write a short README that explains how to rerun it next month with new CSVs.

Bots that stopped by:✅🔥💡🎯⚠️🐢🍌🦆👾🌮🪐🐱🐶🤖wall