MRR Formula: The 5 Components You’re Probably Missing

The MRR formula that gets quoted most often is deceptively simple: multiply your number of customers by what they pay on average. That version is fine for a back-of-the-envelope estimate, but it hides the five moving components that make MRR actually useful. If you only track the headline number, you will miss where your revenue is really coming from and where it is quietly leaking away.

This guide starts with the simple MRR formula, then breaks down the five components, new, expansion, reactivation, contraction, and churn, that turn a single number into a diagnostic tool.

The Basic MRR Formula

At its simplest, the MRR formula is:

MRR = Number of active customers × Average Revenue Per Account (ARPA)

If you have 250 customers paying an average of $90 per month, your MRR is $22,500. This works cleanly only when every customer is on a monthly plan at a known price. The moment you introduce annual billing, upgrades, discounts, and cancellations, you need a more precise approach: sum the normalized monthly value of every individual subscription. For the conceptual background, see our overview of what MRR is.

Normalize Before You Sum

Normalizing means converting every plan to its monthly equivalent before adding it up. A $1,200 annual plan is $100 of MRR. A $300 quarterly plan is $100 of MRR. A customer on a 20 percent discount pays the discounted amount, so a $100 list plan at that discount contributes $80. Skip this step and your MRR chart will spike every time an annual invoice clears, which tells you nothing about the actual business.

The 5 Components of the Full MRR Formula

Total MRR at the end of a month is last month’s MRR plus the changes that happened in between. The complete formula looks like this:

Ending MRR = Starting MRR + New + Expansion + Reactivation − Contraction − Churn

Each of those five components tells you something different, and most teams that only track total MRR are missing at least two or three of them.

1. New MRR

Revenue from customers who subscribed for the first time this month. If eight new customers signed up at a combined $2,400 per month, your New MRR is $2,400. This is the clearest read on whether your acquisition engine is working.

2. Expansion MRR

Additional recurring revenue from existing customers who upgraded, added seats, or bought add-ons. If a customer moves from a $100 plan to a $150 plan, Expansion MRR is $50, not $150, because the original $100 was already counted. Expansion is the most efficient growth you can earn, and our expansion MRR guide goes deep on maximizing it.

3. Reactivation MRR

Revenue from previously churned customers who came back. Many teams forget this component entirely and lump returning customers in with New MRR, which overstates acquisition and hides the effectiveness of win-back efforts. If two lapsed customers reactivate at $120 each, Reactivation MRR is $240.

4. Contraction MRR

Revenue lost from customers who downgraded or removed seats but did not cancel. If a customer drops from a $200 plan to a $120 plan, Contraction MRR is $80. Contraction is a leading indicator: customers rarely cancel out of nowhere, they downgrade first. Watching this number closely gives you a chance to intervene.

5. Churned MRR

Revenue lost from customers who cancelled entirely. If three customers paying a combined $540 per month cancelled, Churned MRR is $540. This component ties directly to your churn rate, and keeping it low is the single biggest lever on long-term growth.

Putting the MRR Formula Together: A Worked Example

Numbers make the formula click. Suppose you start the month at $50,000 in MRR. During the month:

• New customers add $6,000 in New MRR
• Upgrades add $2,000 in Expansion MRR
• A returning customer adds $500 in Reactivation MRR
• Downgrades cost you $1,200 in Contraction MRR
• Cancellations cost you $3,300 in Churned MRR

Plug those into the formula:

$50,000 + $6,000 + $2,000 + $500 − $1,200 − $3,300 = $54,000

Your ending MRR is $54,000, a net gain of $4,000. But notice the story inside that number: you gained $8,500 in new, expansion, and reactivation revenue while losing $4,500 to contraction and churn. Your net new MRR growth of $4,000 is real, but more than half of your gains were eaten by the base leaking. That is the insight the simple formula can never show you.

Net New MRR: The Number That Matters Most

Combining the growth and loss components gives you Net New MRR:

Net New MRR = (New + Expansion + Reactivation) − (Contraction + Churn)

In the example above, Net New MRR is $4,000. Tracking this single figure over time tells you whether your growth is accelerating or stalling, and splitting it into its parts tells you why. When expansion consistently exceeds churn plus contraction, you have reached net revenue retention above 100 percent, the mark of a truly durable SaaS business.

Why the Formula Breaks in a Spreadsheet

The formula is straightforward on paper. Applying it to live Stripe data is where teams struggle. Proration on mid-cycle upgrades, annual plans that need normalizing, coupons, failed payments, and the difference between a downgrade and a cancellation all have to be handled correctly and consistently. One mislabeled event and your components no longer reconcile to your total.

StripeReport applies the full MRR formula to your Stripe data automatically, computing every component, new, expansion, reactivation, contraction, and churn, and delivering the breakdown in a daily email or Slack report. You connect with a read-only key and get numbers that actually reconcile, plus related metrics like ARR and ARPU. If you would rather build it yourself first, our guide to calculating MRR from Stripe walks through the mechanics step by step.

Key Takeaways

• The basic MRR formula, customers times ARPA, is fine for estimates but hides where revenue really moves.
• The full MRR formula has five components: new, expansion, reactivation, contraction, and churn.
• Ending MRR = Starting MRR + New + Expansion + Reactivation minus Contraction minus Churn.
• Net New MRR combines the components and is the single best gauge of whether growth is accelerating.
• The formula is easy to state but hard to apply to raw Stripe data; automation keeps the components reconciled.