Should the dashboard be weekly or monthly?

Monthly. Weekly introduces too much noise for KPIs that naturally move slowly (NRR, Gross Margin, LTV:CAC). Operational dashboards (pipeline, product) can be weekly; financial KPI dashboards should be monthly.

Can I use a BI tool like Looker or Tableau instead of Excel?

Yes, and many later-stage companies do. But even companies using BI tools typically export their KPI dashboard to a spreadsheet for board packets. The format of the dashboard should be the same regardless of the tool that produces it.

How do I handle one-time events that distort the metrics?

Annotate them. A major enterprise deal, a one-time price increase, a merger — these should appear as footnotes on the dashboard with their impact quantified. Running the dashboard both with and without the event gives the board the context to interpret.

What if my current metrics are all red?

Then the dashboard is doing its job. A dashboard that's all green is probably not measuring the right things. Red metrics surface where the team should focus.

How often should the benchmarks be updated?

Annually, or when a major new data source publishes (Benchmarkit quarterly, SaaS Capital annually, Bessemer annually). Don't update benchmarks more often than the underlying data — it adds noise.

How do I present this to a board that doesn't know SaaS?

Add a glossary as an appendix to the board packet. Every metric should have a one-sentence definition. Non-SaaS board members typically need education on NRR, Burn Multiple, and Magic Number specifically.

Should the dashboard include forecasts?

Not in the KPI section. Keep forecasts separate. The KPI dashboard should show what the business did; a separate forecast section should show what's expected. Mixing them makes the dashboard unclear.

CFO Dashboard Template: 12 SaaS KPIs for 2026

A SaaS CFO dashboard in 2026 should show exactly 12 KPIs on a single tab: ARR, Net New ARR, NRR, GRR, Gross Margin, CAC Payback, LTV:CAC, Rule of 40, Burn Multiple, Magic Number, Runway, and Headcount Productivity. Every KPI should be color-scored against current 2025 benchmarks, with the source of each benchmark documented. A dashboard with fewer than these misses critical angles; a dashboard with more than these becomes noise that boards and investors ignore. The goal of the dashboard is not to show everything measurable — it's to surface the twelve numbers that drive SaaS decision-making.

TL;DR

A board-ready SaaS CFO dashboard shows exactly 12 KPIs, not 20, not 50.
The 12 metrics: ARR, Net New ARR, NRR, GRR, Gross Margin, CAC Payback, LTV:CAC, Rule of 40, Burn Multiple, Magic Number, Runway, Headcount Productivity.
Every KPI is color-scored (green/amber/red) against 2025 benchmarks directly in the dashboard.
The dashboard should fit on one tab, update from a single data entry sheet, and print to one page.
Bad CFO dashboards show too many metrics. Great ones show the twelve that matter and delete the rest.

Why exactly 12 KPIs

The number 12 is not arbitrary. It's the count that fits on a single tab in Excel or Google Sheets, prints to a single page in landscape letter format, covers every major angle of SaaS performance without duplication, and fits the attention span of a quarterly board meeting. Fewer than 12 misses things (a dashboard without NRR is missing an essential retention metric). More than 12 becomes noise that diffuses the board's attention.

The 12 KPIs below are organized into four categories with three metrics each: Growth (ARR, Net New ARR, NRR), Quality (GRR, Gross Margin, CAC Payback), Efficiency (LTV:CAC, Rule of 40, Burn Multiple), and Operating Health (Magic Number, Runway, Headcount Productivity).

Every category answers a specific question:

Growth: How much bigger is the business getting?
Quality: How sustainable is that growth?
Efficiency: How much capital is it costing?
Operating Health: Can we keep doing this?

A dashboard that covers all four categories gives a complete picture. Dashboards that overweight one category (usually Growth) hide problems in the others.

The 12 KPIs, explained

1. ARR (Annual Recurring Revenue)

The headline number. Annualized value of all active subscriptions at the end of the reporting period. Formula: MRR × 12 or SUM(Annualized contract values for active customers). Always shown in absolute dollars, with YoY and QoQ growth rates displayed alongside.

2025 benchmark for growth rate: Sub-$10M ARR median 35% YoY; $10-20M median 28%; $20-50M median 22% (Bessemer State of the Cloud 2025).

2. Net New ARR

The sum of all ARR changes in the period: new + expansion − contraction − churn. Shows the actual directional momentum of the business, which headline ARR hides. A company can grow ARR while Net New ARR is shrinking if expansion from existing accounts masks deteriorating new business.

Best practice: show Net New ARR as a stacked bar each month for the last 12-18 months. The composition of New / Expansion / Contraction / Churned tells a richer story than the total.

3. NRR (Net Revenue Retention)

The percentage of revenue from a cohort that remains (including expansion) after 12 months. Formula: (Starting ARR + Expansion − Contraction − Churn) / Starting ARR. The single most important SaaS quality metric.

2025 benchmark (Benchmarkit Q4 2025): median 106%, top quartile 120%+, below 95% is a warning.

4. GRR (Gross Revenue Retention)

NRR without expansion. Formula: (Starting ARR − Contraction − Churn) / Starting ARR. Measures pure stickiness — how much of the revenue base stays, absent any expansion motion. If GRR is 80% and NRR is 115%, the company is adequate at retention but excellent at expansion. If GRR is 90% and NRR is 95%, the company is sticky but has a weak expansion motion.

2025 benchmark: median 90%, top quartile 95%+.

5. Gross Margin

SaaS gross margin should be over 75% for a healthy business. Formula: (Revenue − COGS) / Revenue. Gross margin below 65% indicates either a services-heavy business (not true SaaS) or an infrastructure-heavy business with high hosting costs. Trend over time matters — gross margin should hold stable or improve as the business scales.

2025 benchmark: median 76%, top quartile 82%+ (SaaS Capital 2025).

6. CAC Payback

Months to recover customer acquisition cost. Formula: CAC / (ARPA × Gross Margin). Shorter is better. A 12-month payback is excellent; 18 months is median; 28+ months is suspect.

2025 benchmark (Benchmarkit Q4 2025): median 18 months, top quartile 12 months, bottom quartile 28 months.

7. LTV:CAC

Lifetime value to CAC ratio. Formula: LTV / CAC, with LTV calculated from cohort-fitted retention and capped at 60 months. A 3:1 ratio is the industry standard for healthy SaaS. Below 1.5:1 is unsustainable. Above 5:1 often indicates underinvestment in acquisition.

2025 benchmark: median ~3:1, top quartile 5:1+.

8. Rule of 40

YoY ARR growth % plus profit margin % (EBITDA or FCF). A single score combining growth and profitability. 40+ is the threshold for healthy SaaS.

2025 benchmark (Bessemer State of the Cloud 2025): median 28%, top quartile 48%+.

9. Burn Multiple

Net burn divided by net new ARR. Measures capital efficiency of growth. Below 1.0 is excellent; 1.0-1.5 is great; above 2.0 is suspect.

2025 benchmark: median 1.4x, top quartile 0.8x, bottom quartile 2.5x.

10. Magic Number

Quarterly ARR growth annualized, divided by prior quarter S&M spend. Formula: (ARR_Q − ARR_Q-1) × 4 / S&M_Q-1. Measures sales and marketing productivity specifically.

2025 benchmark: above 1.0 indicates S&M is paying back efficiently enough to scale up; below 0.5 indicates S&M is inefficient and should be contracted.

11. Runway

Months of cash remaining at current burn rate. Formula: Current Cash / Average Monthly Net Burn (trailing 3 months). Essential for survival-stage discussions.

Benchmark: 18+ months is healthy; 12-18 months is acceptable but starts fundraising pressure; below 12 is alarm territory for non-profitable businesses.

12. Headcount Productivity

ARR per employee. Formula: Current ARR / Current full-time employees. A proxy for operational efficiency. Benchmarks vary significantly by category and stage, but $200k+ ARR per employee is a reasonable target for Series B+ SaaS.

2025 benchmark: median ~$150k ARR/FTE for Series B, $250k+ for Series D+, $400k+ for public SaaS.

The visual structure of a great CFO dashboard

The 12 metrics should fit on a single page (landscape letter, or equivalent in Excel or Google Sheets). The layout should follow a specific visual hierarchy:

Row 1 — Growth. ARR prominently at top-left (largest number on the page). Net New ARR as a small trend chart. NRR as a single number with benchmark context.

Row 2 — Quality. GRR, Gross Margin, CAC Payback. All as single-number callouts with trend arrows (last quarter vs this quarter).

Row 3 — Efficiency. LTV:CAC, Rule of 40, Burn Multiple. Same callout format.

Row 4 — Operating Health. Magic Number, Runway, Headcount Productivity. Same format.

Each KPI cell contains: the current value, the period change (vs previous quarter), the 2025 benchmark level (with source), and a color indicator (green/amber/red). Background color should be slightly tinted to show status at a glance.

Conditional formatting logic:

= IF(metric >= top_quartile, "green", IF(metric >= median, "amber", "red"))

The board should be able to spot a red cell from across a conference room. Green means above median, amber means at/approaching median, red means below median. Benchmark sources should be footnoted on every metric.

What NOT to put on the dashboard

Three categories of metrics that feel important but belong somewhere else, not on the CFO dashboard:

Vanity metrics. Total registered users, total downloads, page views, NPS scores taken in isolation. These make the deck feel fuller but don't drive financial decisions. They belong in marketing reports, not CFO dashboards.

Low-signal ratios. Revenue per marketing dollar, sales velocity, win rate by stage — all useful for operating leaders but noise for a CFO dashboard. These belong in sales operations dashboards.

Non-standardized custom metrics. "Engagement score," "health score," "activation rate." These are product metrics. They matter internally but don't benchmark externally — investors can't compare them to other companies. Keep them in product dashboards.

Gross metrics without net. New ARR without churn is misleading. New customers without logo churn is misleading. If a metric is gross, it shouldn't be on the dashboard without its net counterpart.

The discipline of limiting to 12 is what makes the dashboard useful. The instinct to add "one more metric" is how dashboards become unreadable.

How often to update and who should see it

Monthly updates are standard. Quarterly is too infrequent for operational decisions; weekly is too frequent to show meaningful trends and adds noise.

Audience:

Internal exec team: monthly review, with actions assigned to red items.
Board: quarterly in full, with a narrative accompanying each red item.
Investors (between rounds): quarterly with the monthly update email.
Fundraising prospects: the current snapshot plus the last four quarters of trend data.

The dashboard should be designed to print cleanly to PDF. Most board meetings in 2026 still reference printed artifacts, and a dashboard that only works digitally is incomplete.

The three variants: SaaS, Marketplace, SMB

The core 12 KPIs above work for most pure-SaaS businesses. Two adjacent categories need variants.

Marketplace dashboard (two-sided businesses like Uber, Airbnb, Etsy):

Replace ARR with GMV (Gross Merchandise Value)
Replace NRR/GRR with Take Rate and Buyer/Seller retention separately
Keep CAC Payback, Rule of 40, Burn Multiple, Runway
Add: Buyer Lifetime Value, Seller Lifetime Value, Liquidity ratio

SMB dashboard (traditional small business subscription):

Keep ARR, Net New ARR, GRR, Gross Margin, Runway
Drop LTV:CAC (customers are too small for the calc to be meaningful)
Drop NRR (expansion rarely material)
Add: Logo count, Average Revenue Per Account, Collections rate, Days Sales Outstanding
Modify Rule of 40 to focus on growth + operating margin (not FCF)

Choose the variant that matches the business model. Forcing a marketplace into a SaaS dashboard, or vice versa, makes the metrics misleading.

Common mistakes in CFO dashboards

Too many metrics. 30+ KPIs on a dashboard is a sign of indecision. The CFO's job is to decide which 12 matter most and commit.

No benchmarks. A dashboard showing "NRR 105%" tells you nothing on its own. Showing "NRR 105% (median 106%, top quartile 120%+)" turns a number into a signal.

Gross metrics without context. A $5M Net New ARR looks great until you realize it's against $40M in starting ARR (12% quarterly growth annualized ≈ 50%, healthy) or against $200M (2.5% quarterly ≈ 10%, anemic). Show percentages, not just absolutes.

Missing trend context. A single point-in-time snapshot hides whether the metric is improving or deteriorating. Show at least 4 quarters of trend for every metric.

Inconsistent definitions. CAC calculated three different ways in three different places. Document the formulas once and reference them across the dashboard.

Key takeaways

A CFO dashboard is valuable because of what it leaves out as much as what it includes. The 12 KPIs above — ARR, Net New ARR, NRR, GRR, Gross Margin, CAC Payback, LTV:CAC, Rule of 40, Burn Multiple, Magic Number, Runway, and Headcount Productivity — cover every angle of SaaS performance that drives board decisions. Each one should be color-scored against 2025 benchmarks with the source documented. The dashboard should fit on one tab, update from a single data entry sheet, and print to one page.

For the pre-built template implementing this exactly, see the Meritra CFO Dashboard. For the deeper methodology on the individual metrics, see our guides on Rule of 40, Burn Multiple, LTV:CAC, and Cohort Analysis in Excel.

CFO Dashboard Template: The 12 SaaS KPIs That Actually Matter in 2026