Key takeaways
- A finance dashboard should answer four questions: are we profitable, do we have cash, are we using capital well, and is the finance process under control?
- Twelve well-defined KPIs are more useful than fifty loosely defined ones.
- Every KPI needs a written definition, a data source, an owner, a target and a review frequency.
- Show trends, not just the latest month, and pair each chart with a short commentary on the driver and the action.
Most management teams do not lack data. They lack a short, trusted set of numbers that tells them, in a few minutes each month, whether the business is on track and where to look if it is not. Too many finance dashboards try to show everything: dozens of tiles, competing definitions of “margin”, charts that change format every month. Leaders stop reading them, and the monthly meeting returns to discussing spreadsheets.
This guide proposes twelve core KPIs for a management finance dashboard, grouped into four questions, with definitions, formulas and practical advice on design. It is based on what I have found works in multi-entity manufacturing and trading groups, but the framework applies to most mid-sized businesses.
1. Four questions, twelve KPIs
| Question | KPI | Formula / definition |
|---|---|---|
| Are we profitable? | Revenue growth | (Revenue this period − same period last year) ÷ same period last year |
| Gross margin % | (Revenue − Cost of sales) ÷ Revenue | |
| EBITDA margin % | EBITDA ÷ Revenue | |
| Operating expense ratio | Operating expenses ÷ Revenue | |
| Do we have cash? | Operating cash flow | Cash generated from operations (direct or indirect method) |
| Cash conversion | Operating cash flow ÷ EBITDA | |
| Liquidity headroom | Cash + undrawn committed facilities − minimum buffer | |
| Are we using capital well? | Cash conversion cycle | DSO + DIO − DPO |
| Return on capital employed | EBIT ÷ (Total assets − Current liabilities) | |
| Net debt to EBITDA | (Borrowings − Cash) ÷ last-12-month EBITDA | |
| Is finance under control? | Days to close | Working days from period end to approved management pack |
| Forecast accuracy | 1 − |Actual − Forecast| ÷ Actual, for revenue and EBITDA |
Each question has an obvious owner in the leadership team, and each KPI can be traced to the general ledger or a controlled subledger. That traceability is what makes the dashboard trusted.
2. Profitability: margins tell you where to look
Revenue growth on its own is a vanity metric. It must be read with margins. Gross margin shows whether pricing, product mix and direct costs are under control; EBITDA margin adds the effect of overheads. Plotting both on one chart over twelve months is one of the most informative visuals a CFO can show.
Swipe sideways to see the full chart →
Gross margin and EBITDA margin, last 12 months (illustrative)
View the data behind this chart
| Period | Gross margin % | EBITDA margin % |
|---|---|---|
| Oct | 22.5% | 9.8% |
| Nov | 23.1% | 10.2% |
| Dec | 21.8% | 8.9% |
| Jan | 22.9% | 10.0% |
| Feb | 24.0% | 11.1% |
| Mar | 23.6% | 10.7% |
| Apr | 22.2% | 9.1% |
| May | 21.5% | 8.4% |
| Jun | 22.8% | 9.7% |
| Jul | 23.9% | 10.9% |
| Aug | 24.4% | 11.5% |
| Sep | 24.1% | 11.2% |
If both lines fall together, the cause is usually at gross-margin level — a price concession, an adverse mix, or higher material and freight costs. If gross margin is stable but EBITDA margin falls, overheads are growing faster than revenue. This simple reading tells the leadership team which part of the business to question first. The detailed explanation then comes from the variance analysis.
3. Cash: profit is an opinion, cash is a fact
Cash conversion — operating cash flow as a percentage of EBITDA — is the single best test of earnings quality. A business that consistently converts less than 70–80% of EBITDA into operating cash is usually building up receivables or inventory, and the reason should be understood. Liquidity headroom answers the question every board asks in difficult times: how much room do we have before we need new funding? It should be calculated from the 13-week cash flow forecast, not just the month-end balance.
4. Capital efficiency
The cash conversion cycle combines receivables, inventory and payables into one number of days. It is best shown with its three components, because the actions are different for each: collections for DSO, planning and purchasing for DIO, supplier terms for DPO. Return on capital employed shows whether the business earns enough on the assets it uses, and net debt to EBITDA shows leverage in the form most lenders use in their covenants. For the working-capital components, see the guides on receivables ageing and DSO and inventory ageing.
5. Finance process KPIs
A dashboard that measures only the business misses half the picture. The finance function itself should be measured: how fast it closes, how accurate its forecasts are, how many post-close adjustments it makes. These numbers build — or erode — leadership’s confidence in everything else on the page.
Swipe sideways to see the full chart →
Working days to close the books (illustrative)
View the data behind this chart
| Category | Working days to close |
|---|---|
| Apr | 9 |
| May | 8 |
| Jun | 8 |
| Jul | 7 |
| Aug | 7 |
| Sep | 6 |
6. Design principles for a dashboard people use
- One page first. The headline page shows the twelve KPIs with current value, target, trend arrow and a 12-month sparkline. Detail pages sit behind it.
- Consistent definitions. Write a KPI dictionary and freeze it. Changing a definition requires approval and a restated history.
- Trends over snapshots. Show at least 12 months so seasonality and direction are visible.
- Targets and thresholds. Use a clear rule for red, amber and green and always pair colour with a label or icon.
- Commentary beside the numbers. Two or three sentences per KPI: driver, impact and action.
- One axis per chart. Avoid dual-axis charts; if two measures have different units, use two small charts.
- Drill-down by entity, segment and product, using the same definitions at every level.
7. Building it in Power BI
A practical Power BI model has fact tables for general ledger actuals, budget and forecast, plus subledger facts for receivables, payables and inventory. Shared dimensions — date, entity, account hierarchy, cost centre, customer, product — let every measure be sliced consistently. KPIs should be built as measures, not calculated columns, and documented in the model. Refresh after each close, with a validation page that reconciles key totals to the trial balance so users can see that the numbers tie. My Power BI MIS dashboard case study shows an anonymised example of this structure.
8. Governance: keeping the dashboard trusted
| Element | Practice |
|---|---|
| KPI dictionary | Definition, formula, source, owner, target and frequency for each KPI |
| Data validation | Reconciliation of dashboard totals to the trial balance every refresh |
| Change control | Approval for new KPIs or definition changes; history restated |
| Access | Role-based security by entity and sensitivity |
| Review rhythm | Monthly leadership review; quarterly review of the KPI set itself |
Frequently asked questions
How many KPIs should a finance dashboard have?
A headline page usually works best with around 8 to 15 KPIs. More detail can be provided on drill-down pages, but leadership should be able to understand the overall position from one page in a few minutes.
What is the difference between EBITDA margin and operating margin?
EBITDA margin excludes depreciation and amortisation, so it is closer to operating cash generation. Operating (EBIT) margin deducts depreciation and amortisation and so reflects the cost of using long-term assets.
Why measure cash conversion?
Cash conversion compares operating cash flow with EBITDA. It shows whether reported profits are turning into cash, and highlights growing receivables or inventory before they become a liquidity problem.
Conclusion
A good finance dashboard is short, consistent and honest. Organise it around four questions — profit, cash, capital and control — use about a dozen clearly defined KPIs, show trends with targets, and write brief commentary that links each number to an action. Built and governed well, it turns the monthly meeting from a review of the past into a conversation about what to do next.
Written by Liakat Hossain
Finance and accounts professional with experience in FP&A, SAP FICO, Power BI, internal control, reporting, audit, tax, VAT and export-oriented business operations.
This article is original educational content based on professional finance practice. Real-project examples are anonymized, and scenario figures are identified as model outputs rather than guaranteed results.