Skip to main content
    Back to Resources
    Guides13 min read

    Last verified:

    Build Your AI Financial Dashboard

    Most people couldn't tell you where their money went last month. Build one dashboard inside ChatGPT or Claude that shows all of it, updated every month, with eleven copyable prompts for your personal money and your business.

    Get the full guide as a PDF

    Free

    Save it, print it, read it offline. It's yours.

    Most people couldn't tell you where their money went last month. This guide shows you how to build one dashboard inside ChatGPT or Claude that shows all of it, updated every month. It works for your personal money, your business or both.

    • Connect your bank or business apps, or just upload statements
    • Build the whole dashboard with one copyable prompt
    • Spot forgotten subscriptions and duplicate charges
    • A business version with profit and tax flags for your accountant
    • Eleven copyable prompts, including a gentle spending roast

    Start Here: How Your Dashboard Works

    The plan · 5 steps

    1. 1Pick ChatGPT or Claude.
    2. 2Connect your accounts or upload your statements.
    3. 3Paste the dashboard prompt and answer its three quick questions.
    4. 4Ask it questions before you spend.
    5. 5Set it to update every month.

    Before you start

    Tool

    ChatGPT or Claude. The free plan of either one is enough to build it. Automatic updates in Claude need a paid plan.

    Time

    About 15 minutes for the first build, then a few minutes a month.

    Privacy

    Connections are read-only. Never paste passwords or security codes into a chat, and cover account numbers before you upload a statement.

    If you came from the newsletter, this is the full setup. You'll end up with one place that shows where your money goes, helps you decide whether a purchase makes sense and keeps your numbers ready for tax time.

    I have one of these for my business. I bank with Mercury, and it's connected directly.

    What the dashboard shows

    The AI reads your transactions, either from accounts you connect or from statements you upload. It sorts them into categories and builds the dashboard for you. Here's what goes on it:

    On your dashboardWhy it helps
    Money in and out by monthSee if you're ahead or behind at a glance
    Spending by categoryFind out where the money actually goes
    Every subscription and recurring chargeCatch the ones you forgot about
    Biggest changes from last monthSpot a problem while it's still small
    Duplicate or unusual chargesCatch double billing and charges you don't recognize
    Profit by month and tax flags (business)Know if the business is making money and what to ask your accountant

    Maverick's tip

    This is a tool for seeing your own numbers. It isn't financial or tax advice. Anything it flags as tax-deductible is for your accountant to confirm, and any estimate it gives you should be treated as rough.

    Copy This First: The Dashboard Prompt

    This is the whole dashboard in one prompt. Paste it into ChatGPT or Claude once your accounts are connected or your statements are uploaded. Step 2 shows you how to do that.

    The Dashboard Prompt

    Prompt 1 · Copy & paste
    Build me an interactive financial dashboard from the accounts I've connected or the statements I've uploaded. First ask whether it's for my personal money, my business or both, plus my currency and which months to include. Show money in and out by month, spending by category, every subscription and recurring charge, my biggest changes from last month and any duplicate or unusual charges. For a business, add profit by month and flag expenses that might be tax-deductible for my accountant to confirm. Put the key numbers at the top and let me click into any category. Only use my actual numbers and list anything you couldn't categorize. Don't move money or change anything in my accounts.

    Why it's written this way

    Part of the promptWhat it does
    Personal, business or bothSets up the right views, and keeps the two apart if you have both
    Currency and monthsKeeps everything in your money and picks the time range
    Only use my actual numbersStops it from filling gaps with guesses
    List anything you couldn't categorizeShows you exactly what needs a quick fix
    Don't move money or change anythingKeeps the whole thing read-only

    Maverick's tip

    Keep everything in one chat and give it a clear name, like Financial Dashboard. Then every question and update has all the context it needs.

    1

    Choose ChatGPT or Claude

    Both can build this. The big difference is how your numbers get in and what the finished dashboard looks like.

    What mattersChatGPTClaude
    Your US bank or credit cardConnects through the Finances tab (US only)Not directly. Use statements instead.
    Business apps like Mercury, QuickBooks and StripeYesYes, plus a few more
    What you getInteractive charts right in the chatA dashboard page you can click around and reopen
    Automatic updatesMonthly, as a scheduled taskWeekly, as a scheduled task (paid plans)
    Pulling statements with the browserEasierMore cautious with banking sites

    My simple take

    In the US, for personal money: start with ChatGPT. The Finances tab links your bank and cards, so you don't have to download anything.

    For a business: either one works. Mercury, QuickBooks, Xero, Stripe, PayPal, Shopify, Gusto and Ramp connect to both.

    Outside the US: either one works with statements. Claude's dashboard page is nice because you can reopen it and click around any time.

    2

    Get Your Numbers In

    The easiest way is to connect your accounts directly. These connections were checked on October 11, 2026, in ChatGPT's official plugin listings and Claude's official connector directory.

    App or accountChatGPTClaude
    MercuryYesYes
    QuickBooksYesYes
    XeroYesYes
    StripeYesYes
    PayPalYesYes
    ShopifyYesYes
    GustoYesYes
    RampYesYes
    Your US bank or credit cardYes, through the Finances tabNo

    Claude also connects to FreshBooks, Zoho Books, Square, Brex, Qonto, Tiller, NetSuite and MYOB (beta, for Australia and New Zealand). Xero is read-only in both tools, and Mercury is read-only by default.

    Where to connect

    In ChatGPT: open Plugins in the left sidebar and connect your business apps there. Finances has its own tab for US banks and credit cards.

    In Claude: go to Customize, then Connectors. Connectors from Claude's directory work on every plan, including Free. Custom connectors need a paid plan.

    You can't add connectors in the mobile apps. Set them up on the web or desktop and they'll carry over to your phone.

    About ChatGPT's Finances tab

    Finances links to more than 12,000 US banks and credit cards through Plaid. It's available on the Free, Go, Plus and Pro plans, US only. It's read-only and can't move money. If you disconnect, your synced data is deleted within 30 days. On Plus and Pro it can also show your Experian credit score.

    No connector? Three easy options

    When I checked Claude's directory, Wise, Revolut, Monzo, Chase, Monarch and YNAB weren't in it. If your bank isn't listed, or you just don't want to connect anything, use one of these.

    Option 1: Just tell it. Give it your rough monthly income and main bills. It's less precise, but it's a great five-minute start.

    Prompt 2 · Copy & paste
    I don't want to connect any accounts or upload statements yet. Build me a simple starter money dashboard from rough numbers. Ask me for these all in one message: my currency, my monthly take-home income, my main bills and what each one costs, roughly what I spend on groceries, eating out, transport and fun, any subscriptions I remember, and any savings or debt payments. Then show where my money goes each month, what's left over and my three biggest costs. Label everything as an estimate based on what I told you, and tell me which statements would make it more accurate.

    Option 2: Upload statements (best). In your banking app or website, download the last three months as a CSV file. Use PDF if CSV isn't offered. Cover or remove your account numbers first, then attach the files before you paste Prompt 1.

    Option 3: Let the browser pull them. ChatGPT's browser can go into your bank's website and pull your recent transactions. You sign in yourself, and it pauses at sign-in pages. It also asks before doing anything that's hard to undo, like a payment. Only use it to read and download.

    Prompt 3 · Copy & paste
    Use your browser to open my bank's website: [bank website]. Stop at the sign-in page and wait for me to sign in myself. Never ask me to type a password or security code into this chat. Once I'm in, only read and download. Go to [account name] and get my transactions for the last three months, as a CSV file if there's an option. Don't click anything that moves money, pays a bill, changes a setting or sends a message. If you're not sure what a button does, stop and ask me. Then use those transactions for my financial dashboard.

    Claude's Chrome extension is more careful with banking sites. Anthropic lists financial and banking sites among the categories it blocks by default, and it suggests using a separate browser profile without banking access. So this route is easier in ChatGPT.

    3

    Build It

    Open a new chat. If you're using statements, attach them first. Then paste Prompt 1.

    It'll ask three things before it builds: personal, business or both, your currency and which months to include. Answer in one line, like "Personal, US dollars, July to September."

    What you'll see

    In Claude: an interactive dashboard page, called an artifact, that you can click around and reopen any time. This works on the Free plan, worldwide.

    In ChatGPT: interactive charts right in the chat. They come with GPT-6's new Intelligent UI, rolling out to all plans starting October 7. Use the Chat tab.

    Check it before you trust it

    Look at the list of charges it couldn't categorize, and tell it what they are. Then pick two or three numbers and check them against your banking app. These quick fixes help:

    "All charges from [merchant] are [category]."

    "Treat transfers between my own accounts as transfers, not spending or income."

    "Show me the transactions behind [number]."

    Maverick's tip

    Claude also has a feature called Dashboards (Pro and up, in beta). It's built for live business data like BigQuery, Snowflake and Salesforce. You don't need it for this.

    4

    Ask It Anything

    This is where the dashboard pays off. Before you buy something, ask it. You'll get an answer based on your real numbers instead of a gut feeling.

    What you want to knowTry asking
    Where it all wentWhere did my money go last month, in plain words?
    A big purchaseI want to buy a [item] for [price]. Can I afford it without touching my savings?
    Eating outHow much did I spend eating out over the last three months, and what's the monthly average?
    A goalHow much could I realistically set aside each month for [goal]?
    A business costIs [software or expense] worth it based on what the business made?

    Ask It Anything

    Prompt 4 · Copy & paste
    Using my financial dashboard and my actual numbers, answer this: [your question]. Keep the answer short and show me the numbers you used. If you're missing something you'd need to answer properly, tell me what it is instead of guessing. Label any estimate as rough. Don't move money or change anything in my accounts.

    Maverick's tip

    Not sure about a purchase? Ask it to give you the case for and the case against using your numbers. Seeing both sides makes the decision a lot easier.

    5

    The Business Version

    Everything above works for a business too. You just want a few extra things on the dashboard: profit, software costs, how long your cash lasts and anything to flag for your accountant.

    If you bank with Mercury or use QuickBooks, Xero, Stripe, PayPal, Shopify, Gusto or Ramp, connect those first. Otherwise, upload your business statements.

    Business Dashboard

    Prompt 5 · Copy & paste
    Set up my financial dashboard for my business, [business name]. Use only my connected business accounts or the business statements I've uploaded. Show revenue, expenses and profit by month, my biggest expense categories, every software tool and subscription, and how many months of expenses my current balance would cover. Flag any charges on business accounts that look personal, and any expenses that might be tax-deductible, for my accountant to confirm. If I also have personal accounts connected, keep them in a separate view. Only use my actual numbers, label any estimate as rough, and don't move money or change anything in my accounts.

    Maverick's tip

    Mixing personal and business spending is what makes tax time painful. If the dashboard flags personal charges on a business account, sort them out each month so they don't pile up.

    6

    Keep It Updated Every Month

    A dashboard is only useful if it's current. Set it up once and it updates on its own.

    In ChatGPT

    Just ask in the chat. It turns your request into a scheduled task, and you'll find it under Scheduled in the sidebar. Scheduled tasks can use your connected apps and Finances.

    Prompt 6 · Copy & paste
    On the 1st of every month, update my dashboard with last month's transactions and tell me what changed. Show money in and out for the month, my top five categories compared with the month before, any new subscriptions or price increases, and anything unusual or duplicated. Keep the summary under 150 words, then show the updated dashboard. Only use my actual numbers. Don't move money or change anything in my accounts.

    Free and Go plans allow up to 3 active tasks, Plus allows 5 and Pro allows 15. One catch: a task created inside a project can't access that project's uploaded files.

    In Claude

    Go to Scheduled in the sidebar and click New task, or describe it in a chat and confirm. You can choose hourly, daily, weekly, weekdays or manual. There's no monthly option yet, so pick weekly. Scheduled tasks need a paid plan.

    Prompt 7 · Copy & paste
    Check my connected accounts for new transactions since the last update and refresh my financial dashboard. Then tell me in a few lines: money in and out so far this month, how that compares with the same point last month, any new subscriptions or price changes, and anything unusual or duplicated. Only use my actual numbers. Don't move money or change anything in my accounts.

    When a scheduled task uses cloud connectors, it runs even when your computer is asleep.

    Maverick's tip

    Using statements instead of connections? Once a month, upload the new statement to the same chat and say "update my dashboard." That's it.

    Four More Prompts Worth Saving

    Once the dashboard is built, these four make it even more useful. Paste them into the same chat.

    Subscription Audit

    Prompt 8 · Copy & paste
    Go through my last three months of transactions and list every subscription and recurring charge: the name, the amount, how often it charges and the yearly total. Flag any that went up in price, any I seem to be paying for twice and any free trials that turned into paid plans. Sort them by yearly cost, highest first, and add up the total. Then ask me which ones I actually use and help me make a cancel list. Don't cancel anything or contact anyone for me.

    Roast My Spending (Gently)

    Prompt 9 · Copy & paste
    Roast my spending, gently. Look at last month's transactions and give me a funny, kind roast of my habits, like a friend who's good with money teasing me over dinner. Keep it light, with no shaming. Only use my actual transactions and amounts. Then switch to serious and give me the three changes that would save me the most each month, with a rough estimate for each, clearly labeled as rough.

    Tax-Time Pack

    Prompt 10 · Copy & paste
    Help me get ready for tax time. Using my transactions for my tax year, [start date] to [end date], make a summary my accountant can work from: total income by source, expenses by category, and a list of expenses that might be tax-deductible, each with the date, merchant, amount and why it might qualify. Mark every deductible item "for my accountant to confirm," since the rules depend on where I live. List anything you couldn't categorize and any personal charges mixed into business accounts. Put it all in a clean table I can copy into an email or spreadsheet. Don't give me final tax figures or file anything.

    Monthly Recap

    Prompt 11 · Copy & paste
    Give me my monthly money recap for [month]. In plain words and under 200 words, tell me money in, money out and what's left, my top three spending categories and how they changed from last month, one win, one thing to watch and any new subscription or charge. Then suggest one simple goal for next month based on my actual numbers. Only use my actual numbers. If something looks off, ask me instead of guessing.

    On a Claude Team or Enterprise plan, you can also use Claude Motion (beta) to turn last month's numbers into a 20-second animated recap.

    Common Mistakes and Easy Fixes

    If this happensTry this
    A number looks made upAsk "Show me the transactions behind that number." Remind it to only use your actual numbers.
    Lots of charges in OtherTell it once: "All charges from [merchant] are [category]."
    Transfers counted as spendingSay "Treat transfers between my own accounts as transfers, not spending or income."
    Your bank isn't in the listDownload your statements as CSV files and upload them (Step 2).
    You can't find connectors on your phoneSet them up on the web or desktop. They carry over to mobile.
    A PDF statement reads badlyDownload the CSV version instead.
    Amounts in more than one currencyTell it your main currency and ask it to label converted amounts as rough.
    Claude has no monthly schedulePick weekly. It keeps the dashboard current.
    A ChatGPT task can't see your statementsTasks made inside a project can't use that project's files. Use connected accounts, or upload the new month and say "update my dashboard."
    You lost the dashboardClaude: reopen the artifact. ChatGPT: keep it all in one named chat.
    You're worried about privacyConnections are read-only. Cover account numbers on statements, and disconnect any time.

    Quick Reference: Your AI Financial Dashboard

    TaskChatGPTClaude
    Connect accountsPlugins in the left sidebar. Finances tab for US banks and cards.Customize, then Connectors
    Build itPaste Prompt 1Paste Prompt 1
    Where it showsInteractive charts in the chatAn artifact page you can reopen
    Auto-updateAsk in the chat. Runs on the 1st of every month.Scheduled, then New task. Pick weekly.
    PlansFinances on Free, Go, Plus and Pro (US only)Directory connectors on all plans. Scheduled tasks need a paid plan.

    Setup in four lines

    Connect: Link your accounts, or download the last three months of statements as CSV files.

    Build: Paste Prompt 1 and answer its three questions.

    Ask: Check purchases and goals against your real numbers with Prompt 4.

    Update: Set a monthly task in ChatGPT or a weekly one in Claude.

    DO THIS TODAY: Pick one account, your main bank account or your business account. Connect it or download last month's statement, paste Prompt 1 and look at your subscription list. If there's one you forgot you were paying for, cancel it today.

    Save this guide for later

    Save it, print it, read it offline. It's yours.

    Download PDF (Free)
    Newsletter

    Get new resources in your inbox

    Every Wednesday and Sunday. Short, free, and you'll like it. Join 250,000+ readers.

    Join the newsletter

    Keep reading