SaaS Subscription Revenue Tracker Excel with monthly MRR walk, churn rate by plan, LTV and CAC, cohort retention, and dashboard. Know what you actually keep — after churn — and which plan earns it. Built for SaaS…
About this template
SaaS Subscription Revenue Tracker Excel with monthly MRR walk, churn rate by plan, LTV and CAC, cohort retention, and dashboard. Know what you actually keep — after churn — and which plan earns it. Built for SaaS founders and operators who need real MRR, churn, and unit economics without accounting software. Log new and churned customers each month, and the workbook does the rest.
$49
Excel & Google Sheets template — instant download on Etsy
Monthly Metrics — the MRR walk, month by month, Jan-Dec: starting MRR, new, expansion, contraction, churned, net new, and ending MRR, plus MRR growth, logo churn, revenue churn, ending customers, and ARPU. New and churned MRR come from the customers sheet by formula.
Customers by Plan — starting, new, churned, and ending customers for Starter (29 per month), Growth (79 per month), and Scale (199 per month), plus base plan MRR. Change a plan price and every MRR figure in the workbook updates.
Unit Economics — per plan: ARPU, gross profit per customer, LTV, CAC, LTV:CAC, and payback months, plus ending customers and ending MRR. Blended LTV, CAC, LTV:CAC, and payback at the bottom, with an acquisition-cost summary.
Cohort and Churn — churned customers and churned MRR by plan and by month, why customers churn (enter your own reasons — the total is checked against churned customers for the year), and retention of the January 2026 signup cohort.
Dashboard — starting and ending MRR, ARR, MRR growth, customers, churn, best plan by MRR and by LTV:CAC, blended LTV:CAC, cash runway, and how much of your monthly operating costs MRR covers.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the SaaS Subscription Revenue & Churn Tracker track?
The SaaS Subscription Revenue & Churn Tracker tracks Monthly Metrics; Customers by Plan; Unit Economics; Cohort and Churn; Dashboard.
What do the example numbers show?
The included example shows: Starting MRR in January: 9,660 from 180 customers. Ending MRR in December: 31,927. Ending ARR: 383,124. MRR growth for the year: 22,267, up 230.5 percent.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.