SaaS Metrics Tracking Spreadsheet: The Exact Template for $0–$500K MRR Founders

A spreadsheet is not an inferior metrics solution — it is the right solution for the right stage. Founders who graduate to ChartMogul at $20K MRR are often paying for depth they do not need and getting less diagnostic value than a well-maintained spreadsheet would provide. Founders who stay on a spreadsheet at $300K MRR with 500 customers are fighting data quality problems that will eventually produce wrong decisions.

The architecture of a SaaS metrics spreadsheet matters more than the tool. Google Sheets or Excel — the choice is irrelevant. The tab structure, the formula logic, and the data discipline are what produce reliable metrics. This guide covers the exact structure, the specific formulas, the common errors, and the graduation criteria.

The Six-Tab Architecture

A complete SaaS metrics spreadsheet has six functional tabs:

1. MRR Movement — the core billing reconciliation
2. CAC by Channel — acquisition cost tracking
3. LTV:CAC — unit economics summary
4. NRR Cohort — retention heatmap
5. Burn Multiple — capital efficiency
6. Dashboard — rolling 12-month summary for weekly review

Each tab has a specific data source, update cadence, and formula logic. Mixing them into a single tab is the most common mistake — it makes the spreadsheet unreadable and formulas fragile.

Tab 1: MRR Movement

This is the most important tab and the most commonly built wrong. The data model:

Columns (one row per month):

The critical formula: Ending MRR must equal your billing platform's MRR at month-end. If it does not, there is a categorization error. Build a reconciliation check: =IF(Ending_MRR = Stripe_Export_MRR, "OK", "RECONCILE"). Never close a month without this check passing.

Common errors to avoid:

Error 1: Counting annual plan payments as MRR A customer pays $1,200 for an annual plan upfront. Their MRR = $100/month. Record $100 in new MRR for the signup month, not $1,200. If you record $1,200, your MRR in month 1 is inflated and months 2–12 show phantom churn. See SaaS revenue recognition and MRR for full treatment.

Error 2: Expansion MRR that includes new customers If a customer signs up for $100/month and immediately adds $50 in seats, the $50 is new MRR (part of the signup), not expansion MRR. Expansion MRR only counts incremental MRR from customers who were already paying in a prior month.

Error 3: Churned MRR calculated from ending MRR instead of starting MRR If a customer paying $200/month cancels, churned MRR = $200 (what they were paying before they left). Using their "current" MRR (which is $0 after cancellation) produces zero churn — obviously wrong.

Data source for this tab: Export your MRR bridge from your billing tool (Stripe, Chargebee) monthly. If you are pulling from Stripe natively, use the Stripe Sigma queries covered in the stripe metrics setup guide to get the MRR components.

Tab 2: CAC by Channel

The MRR Movement tab tells you revenue. The CAC tab tells you what you spent to get it.

Columns (one row per month per channel):

The attribution lag problem: If you spend $10K in January on paid search and customers take 30 days to convert, the customers signing up in February are partly attributable to January spend. Simple CAC = Monthly Spend / Monthly New Customers ignores this lag. A more accurate approach:

Lagged CAC = (Spend in Month M + Spend in Month M-1) / 2 / New Customers in Month M

For most channels with 30–45 day sales cycles, a two-month rolling average of spend in the denominator is sufficient.

The CAC payback period formula (for this tab):

CAC Payback (months) = CAC / (Average MRR per Customer × Gross Margin %)

Track this by channel. Content marketing CAC payback is typically 12–24 months (low upfront, long lag). Paid search is typically 8–14 months. Outbound SDR is typically 6–12 months but depends heavily on deal size.

Tab 3: LTV:CAC

The LTV:CAC ratio tab summarizes unit economics across customer segments.

Columns:

The churn input accuracy problem: LTV is extremely sensitive to churn rate. A 2% monthly churn produces LTV 2x higher than 4% monthly churn (at the same MRR). Use at least 6 months of cohort data before committing to a churn rate input — one-month churn numbers are too noisy for LTV calculations.

By-segment LTV:CAC: Calculate this for each customer segment (SMB, mid-market, plan tier). A blended LTV:CAC of 4x can hide a 2x on your SMB segment and 8x on mid-market — a very different strategic picture.

Tab 4: NRR Cohort

The NRR cohort tab is a heatmap: cohorts in rows, months in columns, retention percentage in cells.

Structure:

NRR formula (not gross retention):

NRR for Cohort at Month N = (MRR from cohort in Month N) / (MRR from cohort in Month 0) × 100

If cohort MRR grows due to expansions, NRR can exceed 100%. If it shrinks due to churn and contraction, NRR is below 100%. This is the most important diagnostic number in the spreadsheet — see NRR calculator guide for interpretation benchmarks.

The customer lifetime value connection: Your cohort retention curve directly drives LTV. If Month 12 retention is 79%, the implied average customer lifetime is roughly 1/(1 - 0.79^(1/12)) per month — approximately 57 months at that retention shape.

Conditional formatting: Color-code the heatmap. Green for NRR above 100%, yellow for 85–100%, red for below 85%. This makes the table scannable at a glance for weekly review.

Tab 5: Burn Multiple

Burn Multiple is the capital efficiency metric that investors care most about in 2025–2026.

Columns (monthly):

For the full Burn Multiple framework and benchmarks by stage, see Burn Multiple guide.

Critical formula note: Net New ARR should be calculated net of churn. If you added $50K in new ARR but churned $30K, Net New ARR = $20K. This makes Burn Multiple properly penalize companies with high gross adds but also high churn.

Tab 6: Dashboard

The Dashboard tab is the weekly read. It pulls references from all other tabs into a single rolling 12-month view.

Structure (one column per month, last 12 months):

Add sparklines next to each metric — a small inline chart of the trailing 12 months. In Google Sheets: =SPARKLINE(B5:M5, {"charttype","line"}). This makes trend direction visible without reading every number.

Data Discipline: The Rules That Keep It Reliable

Rule 1: One person owns the update, always. The moment two people are independently updating different sections, reconciliation errors appear. Assign one person to close each month's data within 5 business days of month end.

Rule 2: Lock closed months. Once a month is closed and reconciled, lock the cells. In Google Sheets: select the range, right-click → Protect Range. Retroactive changes to historical data are how phantom growth appears.

Rule 3: Source everything. In each cell that comes from a manual entry, add a comment or an adjacent column with the source: "Stripe export 2025-02-05" or "Gusto payroll run." When numbers are questioned (and they will be), you need to trace back to source.

Rule 4: Reconcile MRR to your billing platform every month. Your spreadsheet MRR should match your billing platform MRR exactly. Any discrepancy means a categorization error exists somewhere. Find it before closing the month.

When to Graduate from Spreadsheet to Tool

The upgrade decision is not primarily about MRR level — it is about time cost and data quality.

Graduate when any of these are true:

• You spend more than 3 hours/month maintaining the spreadsheet vs. reading it
• You have more than 200 active customers and manual data entry errors are appearing regularly
• Your billing has complexity (multiple plans, usage-based components, annual + monthly mix) that requires custom Stripe queries to normalize correctly
• Investors are requesting cohort data with more granularity than your spreadsheet provides
• You want plan-level or acquisition-source segmentation in your cohort analysis

Baremetrics is the natural first upgrade — affordable, fast to set up on Stripe, covers all six tabs of this spreadsheet automatically. See the ChartMogul alternatives comparison for tool options at each stage.

Stay on the spreadsheet when:

• You are under 100 active customers with clean, simple billing
• Your team is not going to use the depth of a dedicated analytics tool
• The 3 hours/month of maintenance is not a bottleneck

A well-maintained spreadsheet with disciplined data is more reliable than a misconfigured ChartMogul instance. The tool does not produce accuracy — the data discipline does.

The Forecasting Layer

The spreadsheet template above covers historical tracking. For forward projection, add a seventh tab: ARR Forecast.

Structure the forecast with:

• Starting ARR (current)
• Monthly new ARR assumption (from pipeline × conversion rate)
• Monthly churn assumption (from cohort retention data)
• Monthly expansion assumption (from CS expansion pipeline)
• Ending ARR by month for 12 months forward

See the SaaS ARR forecasting guide for the bottom-up methodology and the SaaS financial model template for the full three-statement model that extends beyond this operational tracking sheet.

Conclusion

A SaaS metrics spreadsheet with six tabs, disciplined data entry, and monthly reconciliation produces reliable metrics for the decisions that matter at $0–$200K MRR. The architecture matters more than the tool. The discipline matters more than the architecture.

Build it once, maintain it rigorously, and it will tell you your NRR trend, your CAC payback trajectory, your Burn Multiple trajectory, and your unit economics — everything a Series A investor or a strategic operator needs to understand the business.

Graduate to a dedicated tool when the maintenance cost exceeds the value of maintaining it. Not before.

Frequently Asked Questions

What tabs should a SaaS metrics spreadsheet have?

The six essential tabs are: (1) MRR Movement — new, expansion, contraction, churn, reactivation; (2) CAC by Channel — spend, new customers, blended CAC per channel; (3) LTV:CAC — by cohort and plan; (4) NRR Cohort — monthly retention heatmap; (5) Burn Multiple — net burn vs net new ARR; (6) Dashboard — rolling 12-month view of all key metrics.

How do I calculate MRR correctly in a spreadsheet?

MRR for any month = Prior MRR + New MRR + Expansion MRR - Contraction MRR - Churned MRR + Reactivation MRR. New MRR is only from first-time paying customers. Expansion is incremental MRR from existing customers upgrading. Churn is MRR from customers who canceled in the period, measured from their MRR in the prior period.

What is the formula for NRR in a spreadsheet?

NRR = (Starting MRR + Expansion MRR - Contraction MRR - Churned MRR) / Starting MRR × 100. Measure this monthly using a cohort of customers who were active at the start of the period. A rolling 12-month NRR averages out monthly noise.

When should I stop using a spreadsheet for SaaS metrics?

Graduate when: (1) you have more than 200 active customers and manual data entry is error-prone; (2) you spend more than 3 hours/month maintaining rather than reading the spreadsheet; (3) you have multiple billing sources that need consolidation; or (4) investors are asking for audit-grade cohort data. Baremetrics or ChartMogul are the natural next step.