Startup financial dashboard: the 12 KPIs that every CFO must follow
12 financial KPIs for startups: formulas, limitations and decisions to prepare. Build alerts suited to your model and data.
Cofondateur, DAF externalisé et CFO
Contents
- Category 1 — Growth (3 KPIs)
- KPI 1 — MRR (Monthly Recurring Revenue)
- KPI 2 — Net New MRR
- KPI 3 — Monthly MRR growth rate
- Category 2 — Acquisition and retention (3 KPIs)
- KPI 4 — CAC (Customer Acquisition Cost)
- KPI 5 — LTV/CAC
- KPI 6 — NRR (Net Revenue Retention)
- Category 3 — Cash (3 KPIs)
- KPI 7 — Net burn rate
- KPI 8 — Runway
- KPI 9 — WCR / CA
- Category 4 — Profitability and efficiency (3 KPIs)
- KPI 10 — Gross margin
- KPI 11 — CAC Payback Period
- KPI 12 — Rule of 40
- Summary table
- Section — How to build your first dashboard
- Recommended tools
- Recommended service frequency
An effective financial dashboard is not measured by the number of indicators it contains, but by their relevance. An excess of metrics drowns out information; a deficit masks the warning signs.
These 12 indicators are a working starting point for subscription models. Choose those that inform your decisions; alerts depend on your history, margins, sales cycle and financing. No unsourced fundraising threshold or sector benchmark is presented here.
Category 1 — Growth (3 KPIs)
KPI 1 — MRR (Monthly Recurring Revenue)
The MRR is the monthly recurring revenue. It constitutes the fundamental metric of any subscription model business.
Formula: MRR = Σ (price of each active subscription / period in months)
Example: a customer paying €12,000 per year contributes €1,000 to the MRR. A customer paying €500 per month contributes €500.
Analyse MRR by cohort and reconcile it with active contracts. No MRR threshold guarantees funding.
Tracking frequency: weekly (monthly minimum).
KPI 2 — Net New MRR
Net New MRR measures real growth in recurring revenue by incorporating losses.
Formula: Net New MRR = New MRR + Expansion MRR − Contraction MRR − Churned MRR
Vigilance thresholds:
- Analyse the Net New MRR trend and its components
- Negative Net New MRR: contraction after new business, expansion and losses
Tracking frequency: monthly.
KPI 3 — Monthly MRR growth rate
Formula: (MRR month N − MRR month N-1) / MRR month N-1 × 100
Interpret growth alongside the starting base, retention and acquisition cost.
Tracking frequency: monthly.
Category 2 — Acquisition and retention (3 KPIs)
KPI 4 — CAC (Customer Acquisition Cost)
The CAC measures the total cost of acquiring a new customer.
Formula: CAC = (marketing spend + SDR/AE sales spend) / number of new customers
Compare cohorts and channels using the same cost scope, including their margin and payback period.
Tracking frequency: monthly, by acquisition channel.
KPI 5 — LTV/CAC
The LTV/CAC ratio measures the return on investment of customer acquisition.
Formula: LTV/CAC = (ARPU × marge brute %) / (churn mensuel × CAC)
LTV depends on churn and margin assumptions; test their stability before setting an alert.
Tracking frequency: quarterly.
KPI 6 — NRR (Net Revenue Retention)
NRR measures the percentage of revenue retained from a cohort of customers, including expansion (upsell/cross-sell).
Formula: NRR = (MRR start of period + Expansion − Contraction − Churn) / MRR start of period × 100
NRR below 100% indicates cohort contraction; distinguish cancellations, reduced usage and expansion.
Tracking frequency: monthly.
Category 3 — Cash (3 KPIs)
KPI 7 — Net burn rate
The burn rate measures monthly net cash consumption.
Formula: Burn rate = total monthly expenses − monthly income received
Build cash alerts from payment deadlines and financing scenarios, with an agreed safety buffer.
Tracking frequency: weekly.
KPI 8 — Runway
Formula: Runway (months) = free cash flow / net burn rate
Prepare financing around commitment deadlines and cash scenarios. A runway ratio assumes stable burn and may hide one-off payments.
Tracking frequency: weekly.
KPI 9 — WCR / CA
The ratio BFR / CA measures the working capital requirement in relation to turnover.
Formula: WCR / CA = (Inventories + Customer receivables − Supplier debts) / Annual turnover × 100
Working capital requirements depend on the sales cycle, inventory and payment terms. Set an alert based on your activity’s cash needs.
Tracking frequency: monthly.
Category 4 — Profitability and efficiency (3 KPIs)
KPI 10 — Gross margin
Formula: Gross margin = (CA − Cost of sales) / CA × 100
Compare margins by product, channel and cohort using consistent cost classification rules.
Tracking frequency: monthly.
KPI 11 — CAC Payback Period
The CAC payback period measures the time to recover a customer's acquisition investment.
Formula: CAC Payback = CAC / (monthly ARPU × gross margin%)
Set an acceptable payback period based on margin, retention and available cash.
Tracking frequency: quarterly.
KPI 12 — Rule of 40
The Rule of 40 adds the growth rate and the margin EBITDA. It assesses the growth/profitability balance.
Formula: Rule of 40 = Annual turnover growth rate (%) + EBITDA margin (%)
The Rule of 40 is a SaaS analytical indicator; no score replaces analysis of cash, development stage and revenue quality.
Tracking frequency: quarterly.
Summary table
| KPIs | Formula | Frequency |
|---|---|---|
| MRR | Σ (subscription price / period in months) | Weekly. |
| Net New MRR | New + Expansion − Contraction − Churn | Mens. |
| MRR Growth | (N − N-1) / N-1 | Mens. |
| CAC | (Marketing + Sales) / New | Mens. |
| LTV/CAC | LTV / CAC | Trim. |
| NRR | (Start + Exp − Contraction − Churn) / Start | Mens. |
| Burn rate | Expenses − Income | Weekly. |
| Runway | Cash / Burn | Weekly. |
| BFR/CA | WCR / Annual turnover | Mens. |
| Gross margin | (CA − COGS) / CA | Mens. |
| CAC Payback | CAC / (ARPU × margin) | Trim. |
| Rule of 40 | Growth + EBITDA margin | Trim. |
Start with a small set of indicators tied to your team’s decisions. Add more once definitions, sources and review frequency are established.
Section — How to build your first dashboard
Recommended tools
| Tool | Function | Price |
|---|---|---|
| Google Sheets | Basic dashboard | Free |
| Finthesis | Advanced reporting (connects Pennylane, Stripe) | On quote |
| Google Data Studio | Visual dashboard | Free |
| Concept | Database + dashboard | Free |
To entrust the construction of the dashboard and the monthly review of deviations, our outsourced management control links the indicators to the manager's decisions.
Recommended service frequency
| Format | Participants | Frequency | Duration |
|---|---|---|---|
| Individual review | CFO / DAF | Weekly | 30 mins |
| Management Committee | CEO + CFO + VPs | Monthly | 2h |
| Board | CEO + CFO + Investors | Quarterly | 4h |
FAQ
Which KPIs should we start with?
MRR, burn rate, runway, CAC and churn. The choice depends on the business model and decisions to prepare.
How often should they be updated?
MRR, burn rate, and runway: weekly. CAC, churn, and gross margin: monthly. LTV/CAC, NRR, and Rule of 40: quarterly.
Which tool to create a dashboard?
Google Sheets is enough to get you started. Finthesis or Google Data Studio are suitable for more sophisticated dashboards.
Does the Rule of 40 apply to all startups?
No. It is mainly relevant for mature B2B SaaS (Series B+). In the seed phase, the focus should be on MRR and CAC. A Fractional CFO builds the reporting and sets up these 12 KPIs for your team. → Set up my dashboard with a CFO
