How I Built a SaaS MRR Dashboard in Google Sheets (Free Template at End)

I got tired of paying for expensive SaaS analytics tools when all I needed was a simple dashboard to track MRR and churn.

After 3 evenings of work, here's what I built:

The Core Metrics

1. MRR (Monthly Recurring Revenue) — calculated from active customer subscriptions
2. Churn Rate — rolling 30-day churn %
3. ARPU — Average Revenue Per User
4. LTV — Lifetime Value (assuming 24-month average retention)
5. Cohort Retention — how long different join months stay

The Structure
4 Google Sheets tabs:

• Raw Data: Just paste your customer spreadsheet
• MRR Dashboard: Auto-calculated metrics with monthly trend table
• Cohort Retention: Month-by-month retention curves
• Key Insights: Natural language recommendations

The formulas are dead simple. For example, MRR is just SUMPRODUCT of active customers × plan price. Churn rate is count of recent churns divided by total customers.

The Best Part
It's available right now on Gumroad — fully filled with 30 sample rows so you can see exactly how it works before adding your own data.

Grab the template here: https://microtoolsb2b.gumroad.com/l/[your-product-id]

(Replace [your-product-id] with the actual product ID after publishing)

Built 100% in Google Sheets — no code, no plugins, no monthly fees.