Playbooks 11 min readApril 29, 2026

How to track Monthly Recurring Revenue (MRR) for your small business

MRR is the heartbeat of any subscription business. Here's how to track it correctly — New, Expansion, Contraction, Churned — and what to do when each moves.

Why MRR matters

For any subscription or SaaS business, MRR is the single most important metric. Unlike one-time revenue, MRR is predictable: if your MRR was $50K last month and your monthly churn is 3%, you can confidently forecast $48.5K of revenue this month before you even open the laptop.

This predictability is why subscription businesses are valued at 5-15x revenue while one-time-sale businesses are valued at 1-3x. MRR is the foundation of that premium.

The four MRR components

Tracking only top-line MRR is like tracking only your bank balance — it tells you nothing about why the number changed. The four components:

1. New MRR

MRR from brand-new customers acquired this month. The acquisition engine.

2. Expansion MRR

Additional MRR from existing customers who upgraded plans, added seats, or bought add-ons. The single most profitable form of growth — no CAC, instant revenue.

3. Contraction MRR

MRR lost from existing customers who downgraded plans, removed seats, or dropped add-ons. The early warning signal that often precedes churn.

4. Churned MRR

MRR lost from customers who cancelled entirely.

Net New MRR = New + Expansion − Contraction − Churned

If Net New MRR is positive, the business is growing. If it's negative, the business is shrinking. Knowing which component is doing the heavy lifting tells you what to fix.

The MRR waterfall chart

The most useful single chart in subscription analytics. It shows:

  • Starting MRR
  • (+) New MRR
  • (+) Expansion MRR
  • (−) Contraction MRR
  • (−) Churned MRR
  • = Ending MRR

A quick scan tells you whether your growth this month came from acquisition, expansion, or both — and how much was offset by churn. Illuminated Intelligence [blocked] builds this waterfall automatically from Stripe [blocked], Chargebee, Recurly, or your billing system of choice, updated daily.

What to do when each moves

New MRR drops

  • Check top-of-funnel: visits, leads, demo requests.
  • Check conversion rates at each stage.
  • Compare against ad spend on Google [blocked] and Meta [blocked].

Expansion MRR drops

  • Account managers / CSMs need to be doing structured expansion outreach.
  • Check whether your upsell paths still work in product.
  • Survey existing customers about unmet needs.

Contraction MRR rises

  • Customers are downgrading. Why? Survey them.
  • Often a leading indicator of churn 60-90 days out.

Churned MRR rises

  • See the full churn analysis playbook [blocked].
  • Run the 3-question exit survey immediately.
  • Identify if it's a cohort issue (a recent cohort is decaying faster).

How to track all of this without engineering effort

Building a real MRR dashboard from scratch typically takes a data engineer 4-6 weeks. With Illuminated Intelligence, the entire MRR waterfall plus all four components plus cohort retention is live in under 10 minutes from connecting Stripe.

Ready to see your business, illuminated? Start a free 14-day trial [blocked] of Illuminated Intelligence — no credit card required, full setup in under an hour. Or meet JARVIS [blocked], our AI business advisor that turns your data into next-step recommendations.

● FAQ

Frequently asked questions

What is MRR?

MRR (Monthly Recurring Revenue) is the predictable revenue your subscription business expects to receive each month from active customers. It's the most important metric for any SaaS or subscription business because it's both a financial measure (revenue) and a leading indicator of business health (growth, retention, expansion).

What's the difference between MRR and ARR?

MRR is monthly; ARR (Annual Recurring Revenue) is the annualized version (typically MRR × 12). Use MRR for operating dashboards and weekly reviews; use ARR for board reporting and valuation conversations. They're the same data, different timeframes.

How do I calculate MRR with annual subscriptions?

For annual plans, divide the annual contract value by 12 to get its MRR contribution. A customer paying $1,200 annually contributes $100 of MRR. Don't recognize all $1,200 as MRR in the month they signed up — that overstates true monthly recurring revenue and distorts cohort analysis.

See your business, illuminated.

Start your free 14-day trial. Connect your tools in under an hour. Get your first AI insight by tomorrow morning.