Open Data·Open Metrics
Open Data Waterloo Region · Note

Financial Dashboard: What to Put on One and How to Lay It Out

July 24, 2026 · Uncategorized

A financial dashboard is a dashboard built for one purpose: showing whether the money is coming in faster than it is going out. Same idea as a sales dashboard or a marketing one, different subject. Here the subject is cash, and cash is unforgiving. A vanity chart on a marketing board costs you a raised eyebrow. A buried runway number on a finance board costs you payroll.

So the bar is higher. The page has to answer the only question the CFO actually asked walking in: are we fine, and if not, when do we stop being fine. Everything else is supporting cast.

What a financial dashboard tracks

Strip it back to the numbers a finance team checks before coffee. Cash on hand. Monthly burn. Runway, which is just cash divided by burn and the single most sobering figure on the page. Then revenue, gross margin, and the two that quietly wreck small companies: accounts receivable (money owed to you, sitting in someone else’s bank) and accounts payable (money you owe, pretending it is not due yet).

A financial dashboard reports position, not activity. That distinction matters. “We sent 400 invoices” is activity. “We are owed $180,000 and $60,000 of it is over 60 days late” is position. The board should be almost entirely position.

The layout finance teams actually read

Reading order beats decoration. Eyes land top-left first, so put cash and runway there. Nowhere else. I have watched a founder scroll past three quarters of revenue charts to hunt for the bank balance, and every one of those seconds was a design failure.

Group the rest the way an accountant thinks. Liquidity together (cash, runway, AR, AP). Performance together (revenue, margin, expenses vs. budget). Give each group a heading and a little breathing room. If you want the mechanics of arranging blocks so the important ones win, the dashboard layout guide covers the grid work in detail.

Chart types that fit financial data

Money data is mostly trends and single numbers, which narrows the choices fast. A line chart shows cash and revenue moving through time, and the shape of that line is the story. A bar chart compares this month to last, or actual to budget. A KPI card holds one figure that needs to be read in a glance, like current cash, and reads better big and alone than crammed into a grid.

Skip the pie chart. Nobody has ever made a better decision because their expense breakdown was round instead of a ranked bar. If you are unsure which mark fits which number, the chart type guide maps it out.

Mistakes that bury the number that matters

The classic one: showing revenue in giant type and cash in a footnote. Revenue feels good. Cash keeps the lights on. Size the numbers by how much they can hurt you, not by how much they flatter you.

Second, undated numbers. “$240,000” means nothing without a timeframe and a comparison. Is that the month, the quarter, up, down. Every figure needs a period attached and something to sit beside. Third, mixing accrual and cash figures on the same row without saying which is which, a small crime that starts real arguments in board meetings.

Get those right and a financial dashboard does the one thing it exists for: it lets a person glance, exhale or panic, and move. That is the whole job. For the wider system these boards fit into, start with the pillar on dashboard design, then borrow the single-number discipline from the KPI dashboard guide.

← All community notes