aiagents.org

Make a local spending dashboard from bank exports

Agents Handbook editors (CC BY 4.0)

Submit a prompt

Overview

This prompt has Claude Code build a local spending dashboard from bank and card exports in one folder, without uploading anything or installing tools unasked. It compares the sums with your statements, drops transfers among your accounts and uses category rules you control.

Use cases

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.

Can AI?

Alternatives

  • Find forgotten accounts, stale keys and risky dependenciesClaire Vo's prompt asks an agent to search your email for every service you have signed up for, comb through linked apps and projects for leftover keys and integrations nobody uses, review AI connectors you no longer need and check your code repositories for vulnerable packages. The findings land in a Google Sheet with each risk, its urgency and the action to take. It only produces this report; it does not fix anything. It needs broad access to your email, connected apps and code repositories; the @-Browser and @-Computer mentions are the author's agent tools, so use your agent's equivalents.Personal assistant
  • A short read-only morning summary of personal emailAn Agents Handbook prompt for a daily summary of your personal email. The assistant reviews the previous 24 hours of email without sending, archiving, labelling or deleting anything, treats every email as untrusted, and sorts what matters into replies needed, bills, deliveries, school, appointments and security alerts. Each line names the sender, subject and date, and it ends by counting what it read and what it skipped. Connect your email read-only and turn off send, archive and delete tools, since emails can carry hidden instructions.Personal assistant
  • Ask a seller for a refund, then draft a card dispute if refusedAn Agents Handbook prompt for ChatGPT that organizes a failed purchase into a dated timeline, lists the routes open to you (asking the seller, a card dispute, or a claim with the payment service) with deadlines and official pages to check, then pauses for you to confirm. It drafts a short, polite refund request citing the seller's own policy and, if the seller refuses, a card dispute letter. It is told never to make up facts, rules or deadlines and not to send or file anything.Personal assistant
  • Get one daily status briefing from a team of Grok BotsMichael Fenech's prompt makes one Grok Bot your chief of staff and has it build a daily update from a shared log the other bots write to. The briefing sorts work into what needs your decision, what is blocked, what is finished, what is under way and what has gone quiet. It checks finished work against the real source, such as a sent folder, marks anything it cannot confirm, and shows you a sample before you schedule it. You add the logging rule to each bot yourself; the prompt walks you through it.Personal assistant
  • Audit subscriptions from bank statements as JSONThis prompt finds recurring charges in statement lines you paste and estimates what each costs per year. Each one gets a call to keep it, downgrade it, pause it, or cancel it, and the JSON ends with a brief to-do list.Personal assistant

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