How to build a financial dashboard

What a financial dashboard is for

A financial dashboard answers the owner’s and the finance head’s standing question: are we making money, and do we have enough of it? It is not the statutory accounts and not the full management pack. It is the page that shows, at any point in the month, how revenue, margin, costs and cash are tracking — so surprises surface on the 12th, not after close.

Most finance teams rebuild these figures in a workbook every month. A dashboard reads them from the ledger directly or on a schedule, so the workbook and the copy-paste go away, and the same numbers feed the monthly pack.

The eight figures it needs

1. Revenue — month to date and year to date, against budget and last year.
2. Gross margin — amount and %, because revenue can rise while profit falls.
3. Operating costs — against budget, by the five or six biggest cost heads.
4. Net profit (or EBITDA) — the bottom line, same comparisons.
5. Cash — balance across all bank accounts, and days of costs it covers.
6. Receivables — total and the share over 60 or 90 days; see the AR ageing dashboard.
7. Payables — what is due in the next 30 days.
8. One forward-looking figure — order backlog, pipeline or the cash forecast, so the page is not only about the past.

A worked example: a distribution company’s page reads revenue 2.31M MTD (103% of budget), gross margin 24.8% (−1.4 pts), opex 96% of budget, net profit 182k, cash 1.05M (21 days of costs), receivables over 90 days 14% (up from 9%). The two numbers that need a conversation — margin and overdue receivables — are visible in five seconds.

How to lay it out

• Top row: the eight tiles, each with its comparison. Colour only what is off budget.
• Middle: a 13-month trend of revenue and gross margin %, and a cash balance trend beside it.
• Bottom: budget vs actual by cost head, sorted by the largest overspend; and receivables by customer, oldest first.
• Filters: entity, branch or cost centre, and period.

Keep the cash view on the same page as profit. The cash-flow dashboard guide covers the deeper cash page, but the headline belongs here.

Connecting the accounting system or ERP

Most financial dashboards sit on top of the system that already keeps the books — Tally, Zoho Books, QuickBooks, Xero, SAP Business One, Odoo, Business Central, NetSuite or Sage. Some of these can be read live; others come in on a schedule, nightly or hourly. Either works for a financial dashboard, as long as the page shows when it was last updated.

Bring the budget in from wherever it lives — usually a spreadsheet — and relate it to the actuals by account, cost centre and month. Then define the calculations once: what counts as revenue (excluding VAT or GST and inter-company sales), which accounts are cost of goods, how entities in different currencies are converted. The accounting system stays the system of record; the dashboard only reads from it. See ERP reporting.

Entities, branches and who sees what

Groups with several companies or branches need two things. First, a consolidated view: every entity’s figures in one currency, with inter-company sales removed. Second, permissions: the group CFO sees everything, each company’s finance manager sees their company, each branch head sees their branch, and salary lines are masked for everyone outside finance.

Set those rules once on the data, not on each report, so the dashboard, the downloads and the scheduled PDF all respect them.

The monthly routine

• Daily or weekly: finance and the owner glance at revenue, margin and cash — sent to their inbox or WhatsApp each morning.
• Mid-month: review budget vs actual by cost head while there is time to act.
• After close: the same dashboard, now final, becomes the core of the monthly pack — no rebuild.
• Each quarter: check the definitions still match how the business is run.