Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBusiness FinanceSubscription Revenue (MRR) Tracker

SpreadsheetBusiness FinanceFree

Subscription Revenue (MRR) Tracker

Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.

Shown with sample data

Colour

Subscription Revenue (MRR) Tracker

Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.

Current MRR
$281,700
ARR
$3,380,400
MRR growth, last month
5.0%
Average gross MRR churn
1.3%
Per month
Annual NRR (compounded estimate)
103%
Quick ratio, 12 months
4.5
Above 4 is efficient
Active customers
6
Average MRR per active customer
$2,832
Ending MRR by month
Dec 2025Nov 2026

Latest: $281,700

Net new MRR by month
  • Dec 2025$6,200
  • Jan 2026$4,300
  • Feb 2026$7,800
  • Mar 2026$8,500
  • Apr 2026$8,500
  • May 2026$8,400
  • Jun 2026$10,300
  • Jul 2026$10,900
  • Aug 2026$10,300
  • Sep 2026$12,500
  • Oct 2026$12,500
  • Nov 2026$13,500

How to use it

  1. 1On Settings, type MRR at the start of the first month.
  2. 2Each month, enter MRR from new customers, upgrades (expansion), downgrades (contraction) and cancellations (churn) as positive numbers.
  3. 3Read Ending MRR, churn, NRR and quick ratio for the month, and ARR in the key figures.
  4. 4Keep the Customers sheet current so each month’s movements can be traced to accounts.
  5. 5Compare churn and NRR month to month; one bad month is noise, three is a trend.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Investors read a SaaS business through its MRR bridge. Enter new, expansion, contraction and churned MRR each month; the tracker builds starting and ending MRR, gross churn, net revenue retention and the SaaS quick ratio for every month, shows current ARR and growth, and keeps a customer list that classifies each account as expanded, contracted, flat or churned.

Who it’s for

  • Monthly board and investor updates
  • Spotting whether growth comes from new logos or existing customers
  • Subscription businesses moving off spreadsheets of invoices

What’s included

  • MRR bridge sheet: The month-by-month MRR bridge.
  • Customers sheet: Each customer account and how its MRR has moved.
  • By plan sheet: Current MRR and the number of entries for each plan.
  • Settings sheet: Your starting point.

How to use it

  1. 1On Settings, type MRR at the start of the first month.
  2. 2Each month, enter MRR from new customers, upgrades (expansion), downgrades (contraction) and cancellations (churn) as positive numbers.
  3. 3Read Ending MRR, churn, NRR and quick ratio for the month, and ARR in the key figures.
  4. 4Keep the Customers sheet current so each month’s movements can be traced to accounts.
  5. 5Compare churn and NRR month to month; one bad month is noise, three is a trend.

Tips

  • Count MRR at the normalised monthly value: an annual plan of $12,000 is $1,000 MRR, not $12,000 in the month it is billed.
  • Exclude one-off fees, services and usage overages from MRR, or track them separately.
  • A quick ratio above 4 is considered efficient growth; below 1 means you are shrinking.

Questions

How do you calculate MRR churn?

Gross MRR churn = (contraction + churned MRR) ÷ starting MRR for the month. Customer (logo) churn counts accounts instead of revenue.

What is net revenue retention?

NRR = (starting MRR + expansion − contraction − churn) ÷ starting MRR. Above 100% means existing customers grow even without new sales. The annual figure here compounds the monthly rates as an estimate; a true cohort NRR compares the same customers 12 months apart.

What is the SaaS quick ratio?

(New MRR + expansion MRR) ÷ (contraction MRR + churned MRR). It shows how much revenue you add for every dollar you lose.

How do I convert MRR to ARR?

ARR = MRR × 12, using recurring revenue only.

Related searchesmrr trackersaas metrics templatemrr churn calculatornet revenue retentionarr calculatorsaas quick ratiosubscription revenue tracker

Details

Format
Spreadsheet
Category
Business Finance
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBusiness FinanceFree

Subscription Revenue (MRR) Tracker

Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Business Finance
Sheets
4
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More business finance templates

View all
Capital Budgeting NPV and Payback Analysis5 sheets

NPV

$118,225

IRR (approx.)

15%

Profitability index

1.2

Cumulative cash by year
SpreadsheetBusiness Finance

Capital Budgeting NPV and Payback Analysis

Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.

10 min setupPreview
Freelance Income & Tax Set-Aside4 sheets

Income this year

$33,050

Tax reserved

$9,254

Tax still to pay

$2,234

Income by client
44%
  • Brightline Media
  • Granite Partners
  • Cedar Health
  • Oak & Pine Studio
SpreadsheetBusiness Finance

Freelance Income & Tax Set-Aside

Split every client payment into tax, savings and spending, and plan each quarterly tax payment.

10 min setupPreview
Startup Runway & Burn Rate Tracker2 sheets

Cash today

$821,600

Average net burn (3 months)

$71,900

Runway (months)

11.4

Net burn by month
$71k
$71k
$71k
$73k
$74k
Jun 2026Jul 2026Aug 2026Sep 2026Oct 2026
SpreadsheetBusiness Finance

Startup Runway & Burn Rate Tracker

Monthly revenue, spend and cash with net burn, runway in months and the date the money runs out.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ