Free SaaS Metrics Dashboard Spreadsheet
Track MRR, new/churned revenue, customers, and LTV proxies month by month.
What this is
A lightweight MRR dashboard for indie founders: new MRR, churned MRR, customers, and ARPU by month — without waiting on a full BI stack.
Best for
- Bootstrapped SaaS and indie hackers
- Founders reporting monthly to themselves or advisors
- Pre-Series A teams aligning on one metric sheet
What’s included
- Monthly MRR movement columns
- Customer count and ARPU
- Notes for experiments
Preview
| Month | MRR | New MRR | Churned MRR | Customers | ARPU | Notes |
|---|---|---|---|---|---|---|
| 2026-02 | 3100 | 400 | 100 | 68 | 45.6 | |
| 2026-03 | 3450 | 450 | 100 | 74 | 46.6 | |
| 2026-04 | 3800 | 500 | 150 | 78 | 48.7 | Churn spike from billing bug |
| 2026-05 | 4200 | 600 | 150 | 84 | 50 | |
| 2026-06 | 4550 | 500 | 150 | 90 | 50.6 | |
| 2026-07 | 4900 | 550 | 200 | 95 | 51.6 | Price test |
| 2026-08 | 5200 | 500 | 200 | 99 | 52.5 | Expansion MRR from yearly plans |
How to use
- Export MRR figures from Stripe or your billing tool monthly.
- ARPU ≈ MRR ÷ Customers.
- Use Notes for experiments that might explain swings.
Tips
- Export from Stripe Atlas / ChartMogul / Baremetrics or calculate manually from invoices.
- Separate expansion MRR in Notes if you don’t have a column yet.
- Chart MRR in Sheets once you have 6+ months.
FAQ
Is ARPU a formula?
Yes — typically MRR ÷ Customers. Add it as a formula so it can’t drift.