SaaS KPI Dashboard Excel Setup: 12 Metrics (2026)

A SaaS KPI dashboard Excel workbook is useful when you need one shared view of revenue, retention, acquisition, and product usage without buying another analytics tool. The spreadsheet is not the hard part. The hard part is defining every metric so finance, product, and customer success calculate the same number.

This guide gives you a four-tab workbook structure, 12 formulas, and the checks that keep the dashboard honest. It is designed for a monthly operating review. You can build it from billing, account, and product-usage exports, then move to a live database dashboard when copying CSV files becomes a liability.

What your SaaS KPI dashboard should answer

A useful dashboard answers four questions in under five minutes: Is recurring revenue growing? Are existing customers staying and expanding? Is acquisition efficient? Are users adopting the product? If a chart does not help answer one of those questions, remove it.

Keep the headline view to 12 metrics. Detailed plan, channel, and cohort breakdowns belong on supporting tabs. Mixing every segment into the first screen produces a colourful spreadsheet that nobody can scan during a decision meeting.

Use four Excel tabs

1. Raw_Data: paste one row per customer per month. Include month, account ID, plan, starting MRR, ending MRR, new MRR, expansion, contraction, churned MRR, signup date, cancellation date, acquisition cost, trial status, and qualifying product activity. Never type corrections directly into this tab; fix the source export or document an adjustment.

2. Definitions: record the exact rule, owner, source field, update frequency, and exclusions for each KPI. State whether MRR includes discounts, usage revenue, tax, refunds, internal accounts, and paused subscriptions. This tab prevents the same argument from returning every month.

3. Metrics: calculate one column per month and one row per KPI. Put helper calculations here rather than hiding them inside chart formulas. When a number looks wrong, you should be able to trace it from dashboard to metric to source row.

4. Dashboard: show the current value, previous-month value, target, and trend. Use scorecards for the current state and line charts for direction. Reserve red and green for performance against an agreed threshold, not for whether a number merely went up or down.

The 12 SaaS KPIs and formulas

1. Monthly recurring revenue (MRR)

MRR is the normalized monthly value of active recurring subscriptions at month-end. Formula: sum ending recurring revenue for all active paying accounts. Convert annual contracts to a monthly amount and exclude one-time setup fees, taxes, and services revenue.

2. Annual recurring revenue (ARR)

ARR is the annualized run rate of recurring revenue. Formula: ending MRR multiplied by 12. Do not mix this run-rate metric with annual contract value or recognized revenue; they answer different questions.

3. Net new MRR

Net new MRR shows the monthly change caused by customer movements. Formula: new MRR plus expansion MRR minus contraction MRR minus churned MRR. Keep all four components visible so growth from new logos does not hide losses inside the installed base.

4. Customer churn rate

Customer, or logo, churn measures lost paying accounts. Formula: customers lost during the month divided by paying customers at the start of the month, multiplied by 100. Exclude customers acquired during the same month from the starting denominator.

5. Gross revenue churn

Gross revenue churn measures recurring revenue lost before expansion. Formula: churned MRR plus contraction MRR, divided by starting MRR, multiplied by 100. This exposes downgrades that logo churn misses.

6. Net revenue retention (NRR)

NRR shows how recurring revenue from the starting customer base changes after expansion and losses. Formula: starting MRR plus expansion minus contraction minus churned MRR, divided by starting MRR, multiplied by 100. Exclude new-customer MRR.

7. Average revenue per account (ARPA)

ARPA is ending MRR divided by ending active paying accounts. Segment it by plan or customer type when a blended average hides major differences. Use account-level ARPA for B2B SaaS and user-level ARPU only when individual users are the economic unit.

8. Customer acquisition cost (CAC)

CAC is eligible sales and marketing spend divided by new paying customers acquired in the same measurement window. Match spend and customers to the same channel and allow for a realistic sales-cycle lag. A single blended CAC can conceal one profitable channel and one expensive one.

9. CAC payback period

CAC payback estimates how many months of gross profit recover acquisition cost. Formula: CAC divided by monthly ARPA multiplied by gross margin percentage. Put parentheses around the denominator in Excel. If ARPA is 100 and gross margin is 80%, the monthly gross profit is 80, not 100.

10. Customer lifetime value (LTV)

A simple subscription estimate is ARPA multiplied by gross margin percentage, divided by monthly customer churn rate expressed as a decimal. Treat this as a model, not an audited fact. It becomes unstable when churn is low or cohorts are young, so compare it with realized cohort revenue.

11. Trial-to-paid conversion

Trial-to-paid conversion is paid conversions divided by trials that became eligible to convert, multiplied by 100. Use completed trial cohorts. Including trials that started yesterday makes current performance look artificially weak.

12. Product stickiness

For a frequently used product, calculate daily active users divided by monthly active users. For a weekly workflow, use WAU divided by MAU. Define active as completing the product's core value action, not merely logging in.

Build the workbook in six steps

Use completed months for the main trend. Show the current partial month separately and label it clearly. Otherwise, churn, conversion, and revenue will appear to collapse on the first day of every month.

Five checks before you trust the dashboard

First, ending MRR must reconcile to your billing source within a documented tolerance. Second, starting accounts plus new accounts minus churned accounts must equal ending accounts. Third, NRR must exclude new-logo revenue. Fourth, every percentage denominator must guard against zero. Fifth, test-account and employee activity must be excluded consistently.

Also check dates. Billing platforms, application databases, and analytics tools often store timestamps in different timezones. Pick one reporting timezone and convert all sources before grouping by month. A subscription cancelled near midnight should not land in different months across tabs.

When Excel stops being the right tool

Excel is still excellent for early-stage planning, manual adjustments, and scenario models. Keep it when one owner updates the workbook monthly and the source data is small enough to inspect. Replacing a working spreadsheet with a complex BI stack is not progress.

Move to a live dashboard when multiple people edit formulas, CSV copying happens weekly, row counts slow the file, permissions become sensitive, or teams need alerts between reporting meetings. Those are operational failures, not cosmetic annoyances.

AI for Database can connect to PostgreSQL, MySQL, Supabase, MongoDB, BigQuery, and other databases so your team can ask metric questions in plain English. After validating a calculation, save it to a self-refreshing dashboard and trigger an email, Slack message, or webhook when a threshold changes. Excel can remain your modelling layer while live operational reporting moves closer to the source.

Quick answers about SaaS KPI dashboards in Excel

What should a SaaS KPI dashboard Excel workbook include?

Include MRR, ARR, net new MRR, customer churn, gross revenue churn, NRR, ARPA, CAC, CAC payback, LTV, trial-to-paid conversion, and one product-usage metric. Keep definitions and raw data on separate tabs.

How often should you update a SaaS KPI dashboard?

Update the executive view monthly using completed periods. Update operational metrics weekly when the team can act within days. Automate refreshes and alerts if manual copying delays decisions or creates errors.

Can a non-technical team build the dashboard without SQL?

Yes. Start with exports from billing and product systems, or use a natural-language database tool to calculate validated metrics directly from source tables. Clear definitions and reconciliation matter more than the interface.

When should you replace Excel with a live database dashboard?

Switch when the workbook needs frequent copying, several editors, row-level permissions, near-real-time answers, or automated alerts. Keep Excel for forecasts and what-if models where manual control is useful.

Start with one reliable operating view

Build the four tabs, validate the 12 metrics, and use the dashboard in one monthly review before adding anything. Remove any KPI that does not change a decision. If manual refreshes become the bottleneck, try AI for Database free at aifordatabase.com to query live data, maintain the dashboard, and route threshold changes to the right person.