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.
Monthly finance pack, example
Revenue finished November 4.2% under budget
Revenue, November
£412K
4.2% under a £430K budget
Cash runway
14.2months
Bank balances ÷ average monthly net burn, last 3 monthsGross margin
61.8%
Up 0.6 pts on October
Operating cash flow
−£38K
£6K better than October
Show the numbers
| Month | Revenue | Budget |
|---|---|---|
| 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.
| KPI | Formula | A good reading | The common mistake |
|---|---|---|---|
| Budget and forecast | |||
| Revenue against budget | (Revenue − budgeted revenue) ÷ budgeted revenue × 100 | Inside the tolerance the board agreed, with a reason given when it isn't | Comparing to the reforecast and calling it budget. Show budget and reforecast as two separately labelled lines. |
| Budget variance | Actual − budget, per line, in pounds and as a percentage of budget | Every variance over an agreed threshold has a one-line reason | Letting 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 tolerance | Filling 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 year | Year on year, at or above the growth the budget assumes | Reading 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 × 100 | Steady 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 margin | EBITDA 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 charge | Treating EBITDA as cash. It leaves out the money tied up in debtors, stock and creditors, which operating cash flow counts. |
| Operating margin | Operating profit ÷ revenue × 100, where operating profit is gross profit minus operating expenses, before interest and tax | Rising as revenue grows, because overheads grow more slowly | Leaving one-off costs in some months and taking them out in others |
| Net profit margin | Profit 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 charge | Posting 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 × 100 | Flat or falling as revenue grows, with any rise matched to hires the budget planned | Counting gross pay alone. Employer's National Insurance and pension are part of what each person costs. |
| Cash | |||
| Operating cash flow | Operating 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 quarter | Reading the change in bank balance as operating cash flow. That change also carries loans, equity and capital spend. |
| Cash runway | Cash at bank ÷ average monthly net burn over the last three months | Longer than the time to break-even or the next funding round, with a margin the board has named | Dividing by one month's burn. A single month swings with payroll dates and annual bills. |
| Working capital | |||
| Debtor days | Trade debtors ÷ credit sales in the period × days in the period | Close to the payment terms on your invoices | Dividing by all sales. Cash and card sales were never owed, so the figure looks better than it is. |
| Creditor days | Trade creditors ÷ credit purchases in the period × days in the period | Close to the terms your suppliers set | Dividing by total costs, which include payroll and other costs nobody buys on credit |
| Working capital | Current assets − current liabilities, at month end. Current means due, or expected to turn into cash, within twelve months. | Positive, and growing no faster than revenue | Leaving a loan repayment due this year in long-term liabilities. Working capital then looks bigger than it is. |
| Current ratio | Current assets ÷ current liabilities, at month end | Above 1, so the debts due within a year are covered by assets that turn into cash within a year | Counting 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.
Questions a finance dashboard should answer
Six board questions, each matched to the KPI that answers it.
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.