How to Track SaaS MRR and Churn Without Expensive Tools (Google Sheets Template)

Tracking MRR and churn is essential for any bootstrapped SaaS business, but not everyone can justify $200/month for Baremetrics or ChartMogul.

The good news? A well-built Google Sheets dashboard can do 80% of what those tools do — for free.

The 5 metrics you must track:

1. Net New MRR — New + Expansion - Churn - Contraction
2. Monthly Churn Rate — Customers lost / Customers at start
3. Quick Ratio — (New + Expansion) / (Churn + Contraction). Target > 4 for healthy growth
4. LTV:CAC Ratio — Should be at least 3:1 for sustainable business
5. Payback Period — How many months to recoup CAC. Target < 12

The biggest mistake founders make: tracking MRR without also tracking churn cohorts. A 5% monthly churn rate destroys 46% of your customer base in one year. You need to see which acquisition channels produce the stickiest users.

How the dashboard works:

• Enter 5 numbers per month (new, expansion, churn, contraction, customers)
• It auto-generates the waterfall, trend charts, and cohort analysis
• Pre-benchmarked against industry standards

Template available here: The SaaS MRR & Churn Dashboard linked below gives you all this — pre-formatted, with formulas, demo data, and benchmarks.

For $39 one-time, you get a tool that pays for itself in the first week of better decision-making.