Tracking SaaS metrics manually is a nightmare. I built this Google Sheets MRR & Churn Dashboard to save founders 10+ hours/month.
What it tracks:
- MRR (starting, new, churned, ending)
- Monthly churn rate (customer and revenue)
- Net Revenue Retention (NRR)
- 12-month forecast
- 4 pre-built charts
The trick: use FORECAST.LINEAR for projections, GROWTH for MRR extrapolation, and IFERROR to avoid divide-by-zero on churn calculations.
Example formula:
=IFERROR(G2/D2, 0) — churned MRR per churned customer, no errors
Conditional formatting: red if churn > 5%, green if NRR > 100%, yellow if MRR growth > 10%.
I packaged it as a 5-tab Google Sheet with 28 formulas — grab the template at microtoolsb2b.gumroad.com/l/... (fully automates everything above).
Happy to answer questions about the formulas in comments!
Top comments (0)