Finance dashboard

A finance dashboard puts the monthly pack on one page: revenue against budget, margin, cash and how long cash lasts. The finance lead builds it after month-end close, and the board trusts it when every figure ties to the ledger with its formula beside it.

Last reviewed

Monthly finance pack, example

Revenue finished November 4.2% under budget

Example data

Revenue, November

£412K

4.2% under a £430K budget

Cash runway

14.2months

Bank balances ÷ average monthly net burn, last 3 months

Gross margin

61.8%

Up 0.6 pts on October

Operating cash flow

−£38K

£6K better than October

Line chart, example data. Monthly revenue rose from £322K in December to £412K in November. Budget rose from £320K to £430K. Revenue ran above budget until March and below it every month since April and was 4.2% under in November.£300K£350K£400K£450KDecJunNovBudget, Dec: £320KBudget, Jan: £330KBudget, Feb: £340KBudget, Mar: £350KBudget, Apr: £360KBudget, May: £370KBudget, Jun: £380KBudget, Jul: £390KBudget, Aug: £400KBudget, Sep: £410KBudget, Oct: £420KBudget, Nov: £430KRevenue, Dec: £322KRevenue, Jan: £333KRevenue, Feb: £344KRevenue, Mar: £353KRevenue, Apr: £349KRevenue, May: £358KRevenue, Jun: £367KRevenue, Jul: £371KRevenue, Aug: £380KRevenue, Sep: £389KRevenue, Oct: £398KRevenue, Nov: £412KLine chart, example data. Monthly revenue rose from £322K in December to £412K in November. Budget rose from £320K to £430K. Revenue ran above budget until March and below it every month since April and was 4.2% under in November.£300K£350K£400K£450KDecJanFebMarAprMayJunJulAugSepOctNovBudget, Dec: £320KBudget, Jan: £330KBudget, Feb: £340KBudget, Mar: £350KBudget, Apr: £360KBudget, May: £370KBudget, Jun: £380KBudget, Jul: £390KBudget, Aug: £400KBudget, Sep: £410KBudget, Oct: £420KBudget, Nov: £430KRevenue, Dec: £322KRevenue, Jan: £333KRevenue, Feb: £344KRevenue, Mar: £353KRevenue, Apr: £349KRevenue, May: £358KRevenue, Jun: £367KRevenue, Jul: £371KRevenue, Aug: £380KRevenue, Sep: £389KRevenue, Oct: £398KRevenue, Nov: £412K£18K shortBudget £430KRevenue £412KLine chart, example data. Monthly revenue rose from £322K in December to £412K in November. Budget rose from £320K to £430K. Revenue ran above budget until March and below it every month since April and was 4.2% under in November.£300K£350K£400K£450KDecJanFebMarAprMayJunJulAugSepOctNovBudget, Dec: £320KBudget, Jan: £330KBudget, Feb: £340KBudget, Mar: £350KBudget, Apr: £360KBudget, May: £370KBudget, Jun: £380KBudget, Jul: £390KBudget, Aug: £400KBudget, Sep: £410KBudget, Oct: £420KBudget, Nov: £430KRevenue, Dec: £322KRevenue, Jan: £333KRevenue, Feb: £344KRevenue, Mar: £353KRevenue, Apr: £349KRevenue, May: £358KRevenue, Jun: £367KRevenue, Jul: £371KRevenue, Aug: £380KRevenue, Sep: £389KRevenue, Oct: £398KRevenue, Nov: £412K£18K shortBudget £430KRevenue £412KLine chart, example data. Monthly revenue rose from £322K in December to £412K in November. Budget rose from £320K to £430K. Revenue ran above budget until March and below it every month since April and was 4.2% under in November.£300K£350K£400K£450KDecJanFebMarAprMayJunJulAugSepOctNovBudget, Dec: £320KBudget, Jan: £330KBudget, Feb: £340KBudget, Mar: £350KBudget, Apr: £360KBudget, May: £370KBudget, Jun: £380KBudget, Jul: £390KBudget, Aug: £400KBudget, Sep: £410KBudget, Oct: £420KBudget, Nov: £430KRevenue, Dec: £322KRevenue, Jan: £333KRevenue, Feb: £344KRevenue, Mar: £353KRevenue, Apr: £349KRevenue, May: £358KRevenue, Jun: £367KRevenue, Jul: £371KRevenue, Aug: £380KRevenue, Sep: £389KRevenue, Oct: £398KRevenue, Nov: £412K£18K shortBudget £430KRevenue £412K
Example data: a monthly finance pack for an invented company. November revenue was £412K against a £430K budget, £18K short, and cash runway is 14.2 months on three-month average net burn.
Show the numbers
Revenue against budget, last 12 months, example data
MonthRevenueBudget
Dec£322K£320K
Jan£333K£330K
Feb£344K£340K
Mar£353K£350K
Apr£349K£360K
May£358K£370K
Jun£367K£380K
Jul£371K£390K
Aug£380K£400K
Sep£389K£410K
Oct£398K£420K
Nov£412K£430K

Finance KPIs and how to calculate them

The formula behind each line of the pack, in words.

Fourteen of these fifteen come from the trial balance and the budget and reforecast files. Cash runway also needs the bank accounts, because net burn counts the cash moving through them.

KPIFormulaA good readingThe common mistake
Budget and forecast
Revenue against budget(Revenue − budgeted revenue) ÷ budgeted revenue × 100Inside the tolerance the board agreed, with a reason given when it isn'tComparing to the reforecast and calling it budget. Show budget and reforecast as two separately labelled lines.
Budget varianceActual − budget, per line, in pounds and as a percentage of budgetEvery variance over an agreed threshold has a one-line reasonLetting a positive number mean good on revenue lines and bad on cost lines. Label each variance favourable or adverse.
Full-year forecast against budget(Actual revenue to date + reforecast revenue for the remaining months − full-year budgeted revenue) ÷ full-year budgeted revenue × 100. Run the same sum for profit.Updated after every close, with an agreed plan for any gap outside the toleranceFilling the remaining months with the original budget. The forecast then shows the budget, and the gap only appears a month at a time.
Profit
Revenue growth(Revenue this month − revenue in the comparison month) ÷ revenue in the comparison month × 100, against last month and against the same month last yearYear on year, at or above the growth the budget assumesReading month on month as the trend. Seasonality and the number of working days move it, so judge the trend on year on year.
Gross margin(Revenue − cost of sales) ÷ revenue × 100Steady month to month. A move of a point or more comes with a reason.Accounts drifting between cost of sales and overheads, so margin moves when nothing in the business did
EBITDA and EBITDA marginEBITDA is operating profit + depreciation and amortisation. EBITDA margin is EBITDA ÷ revenue × 100. This row uses the unadjusted figure, with nothing added back.Moving with operating margin, above it by the depreciation and amortisation chargeTreating EBITDA as cash. It leaves out the money tied up in debtors, stock and creditors, which operating cash flow counts.
Operating marginOperating profit ÷ revenue × 100, where operating profit is gross profit minus operating expenses, before interest and taxRising as revenue grows, because overheads grow more slowlyLeaving one-off costs in some months and taking them out in others
Net profit marginProfit after interest and tax ÷ revenue × 100. Some packs use profit before tax. This row uses profit after tax.Following operating margin, with the gap explained by interest and the tax chargePosting corporation tax only at year end. Eleven months then show profit before tax as net profit, and the twelfth takes the whole charge.
Payroll as a share of revenue(Gross pay + employer's National Insurance + employer pension contributions) ÷ revenue × 100Flat or falling as revenue grows, with any rise matched to hires the budget plannedCounting gross pay alone. Employer's National Insurance and pension are part of what each person costs.
Cash
Operating cash flowOperating profit + depreciation and amortisation − increase in debtors and stock + increase in creditors. This row is before tax and interest paid.Positive, and close to operating profit across a quarterReading the change in bank balance as operating cash flow. That change also carries loans, equity and capital spend.
Cash runwayCash at bank ÷ average monthly net burn over the last three monthsLonger than the time to break-even or the next funding round, with a margin the board has namedDividing by one month's burn. A single month swings with payroll dates and annual bills.
Working capital
Debtor daysTrade debtors ÷ credit sales in the period × days in the periodClose to the payment terms on your invoicesDividing by all sales. Cash and card sales were never owed, so the figure looks better than it is.
Creditor daysTrade creditors ÷ credit purchases in the period × days in the periodClose to the terms your suppliers setDividing by total costs, which include payroll and other costs nobody buys on credit
Working capitalCurrent assets − current liabilities, at month end. Current means due, or expected to turn into cash, within twelve months.Positive, and growing no faster than revenueLeaving a loan repayment due this year in long-term liabilities. Working capital then looks bigger than it is.
Current ratioCurrent assets ÷ current liabilities, at month endAbove 1, so the debts due within a year are covered by assets that turn into cash within a yearCounting every debtor at full value. Invoices months overdue may never be paid, so read the ratio next to the aged debtors list.

Net burn, for the runway, is all cash paid out of the operating bank accounts in a month minus all cash received. Payroll, PAYE, VAT and loan repayments count. New equity and loan drawdowns are funding, so they stay out. If net burn is negative, the business is adding cash and runway doesn't apply.

If the dashboard's revenue doesn't tie to the trial balance to the pound, the board will spend the meeting on the gap.

How to build a finance dashboard

Sources, grain, refresh, and two decisions to settle first.

Data sourcesThe ledger (Xero, Sage, NetSuite or similar) for the trial balance, the budget and reforecast files from whoever owns them, and bank balances for cash.
GrainA monthly trial balance by account is enough for the pack. Load journal lines only if people need to drill from a figure to the transactions behind it.
Refresh cadenceOnce a month after close for the pack, and weekly or daily for bank balances when runway is short.
Sign conventionIn double-entry, income is a credit and costs are debits. If your ledger export shows credits as negative numbers, revenue arrives negative. Fix it once in the account mapping, so revenue and costs both read as positive and a credit note reduces revenue. If each chart flips signs its own way, a credit note will one day show up as extra sales.
Financial-year date tableBuild a date table with your financial year, period number and quarter on every date. Year to date then starts in your first month, say April, and comparisons with last year line up period by period.

Questions a finance dashboard should answer

Six board questions, each matched to the KPI that answers it.

“Are we going to hit the year?”Year-to-date revenue against budget, and against the latest reforecast as its own line.
“How long does the cash last?”Cash runway on three-month average net burn.
“Why is margin down this month?”Gross margin, with cost of sales broken out by account.
“Who owes us money, and how late is it?”Debtor days, next to the aged debtors list.
“Are we paying suppliers faster than we need to?”Creditor days, compared with the terms suppliers set.
“Which overspend should I worry about?”Budget variance by line, sorted by pounds, with anything over the threshold flagged.

Typing a question like these in plain English and following the answer back to its source is what the AI-led analytics demo shows, on example data.

Finance dashboard examples by tool

What each tool is good and bad at for a finance pack.

Power BI

In Power BI the account mapping and the financial-year date table sit in one model, and the year-to-date functions take your year-end date, so a March year end totals correctly. Sharing a Power BI finance dashboard needs a paid licence for each person who opens it, or capacity the organisation pays for, and scheduled refresh runs a limited number of times a day. Our Power BI consultancy builds the model and hands it over.

Data Studio (formerly Looker Studio)

Data Studio is free and quick to share. Before you commit the pack to it, build the income statement page first. Rows with their own signs and subtotals are the hardest layout in the pack.

Excel

Power Query can pull a ledger export into Excel and refresh it in one click, which replaces pasting the export in by hand each month. A sheet holds just over a million rows, plenty for a trial balance but tight for several years of journal lines. Its weak spot is version control, once copies of the pack start going round by email.

Google Sheets

A Google Sheets file holds up to 20 million cells, so years of monthly trial balance fit in one file. If your pack carries a marketing spend line, Fresh Sheets, our Google Sheets add-on, writes Google Ads data into the sheet on a schedule. It doesn't load ledger data.

If you'd rather not build it yourself, our dashboards and BI service builds this pack on your own ledger, with the definitions agreed before the first chart. Lenders and insurers carry further figures on top of these fifteen, covered on financial services analytics.

Questions people ask

Can you build a finance dashboard in Power BI?

Yes, and most of the work happens in the model before any visual. Map the chart of accounts with one sign convention, add a date table that follows your financial year, and load the trial balance by account and month. Power BI's year-to-date functions take a year-end date, so a year that ends in March totals correctly.

What's the difference between finance KPIs and finance metrics?

A finance metric is any figure you can calculate from the ledger, such as cash at bank or total overheads. A metric becomes a KPI once someone has agreed a target for it and the board reviews it every month.

How often should a finance dashboard refresh?

The pack refreshes once a month, after close, so it shows reconciled numbers. Cash is the exception: if runway is short, refresh bank balances weekly or daily. Refreshing the rest mid-close shows figures that will still move, so label any open month as provisional.

Do we need a data warehouse first?

Usually not. A monthly trial balance by account is a small table, and an Excel sheet holds just over a million rows. A warehouse earns its place when you join the ledger to billing, CRM or payroll data, or when people need to drill into journal lines across several years.

Should budget and reforecast be on the same chart?

They can share a chart, as two separate lines with their own labels. Never merge them into one line that switches from budget to reforecast partway through the year, because nobody can then tell which target a variance is measured against.

Want this pack built on your own ledger?

We'll map your chart of accounts, settle the signs and the financial year, then build the pack in the tool your board already reads.

Book a call