How to build a financial dashboard
with Claude.
Short answer: There are four ways to build a financial dashboard with Claude: ask Claude chat to turn an uploaded export into an interactive view; use Claude Dashboards (beta) when the data sits in a warehouse or connected app; build inside a workbook with Claude for Excel; or build a dashboard app with Claude Code that you rerun every month on new exports. Whichever you choose, agree the totals before you build and check every chart against them.
A financial dashboard is only useful if the numbers are right and someone can rebuild it next month. This guide covers the four ways to build one with Claude, which dashboard fits which role, the metrics worth showing, and how to grow from a simple cash view to a dashboard a finance team relies on.
Four ways to build a financial dashboard with Claude
| Way | Where the data comes from | Best for | Plans | Watch out for |
|---|---|---|---|---|
| Claude chat (an interactive artifact) | A CSV or Excel export you upload | A quick view to explore or share once | All plans, including Free | You rebuild it when the data changes |
| Claude Dashboards (beta) | A data warehouse (Snowflake, BigQuery, Databricks, Amazon Redshift, ClickHouse) or a connected app such as Salesforce | Quick questions on company data, with the SQL query behind each chart | Pro, Max, Team, Enterprise (on Enterprise an owner turns it on) | Anthropic says they are for quick, exploratory questions; check each chart's query |
| Claude for Excel | The open workbook | Dashboards that must stay in Excel, built on pivot tables and conditional formatting | Pro, Max, Team, Enterprise | No macros or VBA; review every change |
| Claude Code | Exports on your computer (CSV or Excel) | A dashboard app you rerun every month on new exports, with import checks | Paid plans that include Claude Code | Takes an afternoon to build, and you maintain it |
Our workshop teaches the fourth way because it keeps working after the first demo: the same app reads next month's export, refuses duplicate rows and shows totals you can check. The step-by-step cash flow dashboard guide shows the build, and the interactive demo shows the result.
Which dashboard for which role
| Role | Dashboard | Key views | Data |
|---|---|---|---|
| Bookkeeper or accounting firm | Client cash dashboard | Money in, money out and net cash by month; top expense categories; uncategorized transactions | Bank, QuickBooks or Xero transaction export |
| Fractional CFO | One layout reused for every client | Monthly cash, 13-week forecast, lowest week, runway | Each client's exports, one folder per client |
| CFO | Weekly cash and 13-week forecast | Opening and closing cash by week, lowest week, budget vs actual summary | Bank export plus expected receipts and payments |
| FP&A or controller | Budget vs actual | Variance by department and account in dollars and percent, top drivers | Budget file and a general ledger or P&L export |
| Small business owner | Owner's cash view | Cash this month vs last month, biggest expenses, who owes you | Bank export and accounts receivable aging |
| Nonprofit finance team | Spending by program | Spending by program and by funding source, cash on hand | General ledger export with program or fund tags |
Metrics worth putting on a financial dashboard
- Net cash flow: money in minus money out for the period.
- Closing cash: opening cash plus net cash flow. It must equal the next period's opening cash.
- Lowest week: in a 13-week view, the week with the smallest closing cash. That is where a buffer or credit line matters.
- Runway: cash on hand divided by average monthly net cash outflow. It only means something while the business is burning cash.
- Budget variance: actual minus budget, in dollars and percent. State which sign is favorable for each line, because it differs for revenue and costs.
- Accounts receivable aging: unpaid invoices grouped by days past due, for example 0–30, 31–60, 61–90 and over 90.
- Gross margin: revenue minus cost of sales, divided by revenue.
A prompt to start
Build a financial dashboard for [business or client] from the attached [export name]. Columns: date, description, category, amount. Positive amounts are money in; negative amounts are money out. Expected totals for this file: money in $____, money out $____, net $____. Show these totals first and stop if they don't match. Views: net cash by month; top 5 expense categories; [lowest cash week]; [budget vs actual by account, if a budget file is attached]. Flag rows you can't read instead of guessing. Explain your approach before you build anything.
From a simple dashboard to an advanced one
- One cash view from one export. Net cash by month, checked against known totals. This is the starting project in our workshop.
- Repeatable import. Next month's export is added without double counting; importing the same file twice changes nothing.
- Budget vs actual. A second file joined by account and month. Every variance traces back to source rows.
- Forecast. A 13-week roll-forward where each closing balance is the next opening balance. Start from our 13-week template and its free Claude Skill.
- Several entities or clients. The same layout for each entity, totals per entity and combined, and no mixing of clients' data.
- Refresh and sharing. Only after the checks pass every time: decide who can see which numbers before you share.
Each step adds a new way to be wrong, so add one at a time and keep the checks from the steps before. Anthropic says its own finance analysts build interactive forecasting and cohort dashboards from prompts, without SQL or engineering help; the discipline that makes those dashboards trustworthy is the same.
Checks before anyone relies on it
- Totals match the same report in the accounting system or bank.
- Importing the same file again changes nothing.
- Money in is positive, money out is negative, and refunds go the right way.
- The first and last day of each period are included exactly once.
- Every chart can be traced to the rows behind it.
- Someone who didn't build it reviews it once before it is shared.
More detail in eight checks for AI financial calculations. For client or company data, read can you upload confidential client data to Claude? first.
Sources: Anthropic, what are artifacts, get started with Claude Dashboards, Claude for Excel, plans and pricing, how Anthropic's finance team uses Claude. Checked October 29, 2026. The Experts AI is independent and not affiliated with Anthropic.
Frequently asked questions
Can Claude build a financial dashboard?
Yes. Claude chat can turn an uploaded export into an interactive dashboard, Claude Dashboards (beta) builds charts from a data warehouse or connected app, Claude for Excel works inside a workbook, and Claude Code can build a dashboard app you rerun on new exports.
Which Claude option is best for a CFO dashboard?
For a weekly cash and 13-week view you update every week from exports, a small app built with Claude Code. For quick questions on data that already sits in a warehouse, Claude Dashboards. If the model must stay in Excel, Claude for Excel.
Do I need to code to build a dashboard with Claude Code?
No. You describe the dashboard, give Claude the data and the expected totals, and check what it builds. Our Claude Code setup guide for non-developers covers the first session.
How do I know the dashboard numbers are right?
Agree control totals before you build, make Claude show them first, re-import the same file to test for duplicates, and trace every chart to its source rows.
Turn a CSV into a working cash flow dashboard.
A self-paced Claude Code workshop for bookkeepers, accountants and FP&A: six lessons, one project, sample data with expected totals. Taught by CFO Leo Godnik.
See the six lessons — $69 → Or start with the free lesson ↗