Example

Finance KPI Dashboard Example

A 70-person professional services company in Glasgow with £5.5M revenue. The CFO has built a KPI dashboard that tracks 8 key metrics monthly. This dashboard is the first page of every management report and board pack, providing a 30-second health check of the business.

Example data

Financial model

KPI
Dec
Jan
Feb
Target
Revenue Growth (YoY)
22%
24%
26%
25%
Gross Margin
62.5%
63.1%
64.0%
65.0%
EBITDA Margin
14.2%
15.0%
15.8%
18.0%
Cash Conversion
88%
92%
95%
90%
DSO (Days)
42
39
36
35
Revenue per FTE
£6.4k
£6.6k
£6.8k
£7.0k
OpEx Ratio
48.3%
48.1%
48.2%
47.0%
Runway (Months)
18
19
21
18+
Revenue Growth (YoY)

Revenue growth has accelerated from 22% to 26% over three months, now exceeding the 25% target. Driven by strong new client wins in financial services.

DSO (Days)

DSO improved from 42 to 36 days over three months, nearly hitting the 35-day target. The finance team implemented automated invoice reminders and early payment discounts.

EBITDA Margin

EBITDA margin trending toward the 18% target but not there yet. The gap is primarily due to investment in the new data analytics practice, which is pre-revenue.

Formulas

Key formulas

fxCash Conversion = Operating Cash Flow / EBITDA * 100

Cash conversion at 95% means nearly all reported profit converts to cash. Above 90% is excellent and reflects strong working capital management.

fxRevenue per FTE = Monthly Revenue / Average Headcount

At £6.8k per FTE per month (£81.6k annualised), the company is approaching its £84k target. This metric tracks operational efficiency as the team grows.

fxRunway = Cash Balance / Average Monthly Net Burn

With 21 months of runway, the company has ample time before needing additional capital. The improvement from 18 to 21 months reflects improving profitability.

Analysis

What makes this example good

Eight KPIs cover all four pillars: growth, profitability, cash, and efficiency
Three-month trend shows direction of travel, not just a point in time
Targets provide a benchmark for "good" performance
Mix of leading (growth, DSO) and lagging (margin, cash) indicators
Monthly cadence catches trends before they become problems

Customisation

How to adapt for your business

1

Replace KPIs with metrics relevant to your industry and business model

2

Add colour coding (green/amber/red) based on distance from target

3

Include sparkline charts for 12-month trend visualisation

4

Add a "commentary" column explaining the trend for each KPI

5

Create department-specific dashboards with operational KPIs

Common variations

  • --SaaS KPI dashboard (MRR, churn, NRR, CAC, LTV)
  • --E-commerce dashboard (GMV, AOV, conversion, CAC)
  • --Manufacturing dashboard (utilisation, yield, throughput, WIP)
  • --Executive dashboard with only 4-5 headline metrics

FAQ

Frequently asked questions

Between 5 and 10 at the executive level. Fewer than 5 risks missing something important. More than 10 leads to information overload. Department-level dashboards can have more KPIs, but the executive view should be focused on the metrics that matter most.

Build this in Grove FP in 10 minutes

No credit card required. Set up in minutes. 30-day money-back guarantee.