What to enter
Starting MRR is the balance just before the month began. It is usually last month's ending MRR.
Type each change as a positive amount. The calculator adds new, expansion, and reactivation MRR, and subtracts contraction and churned MRR.
Use monthly amounts for every change. A new customer on a $1,200 yearly plan adds $100 to new MRR, not $1,200.
How to read the result
A month with all five changes
Example
Start at $10,000. Add $1,200 new, $400 expansion, and $150 reactivation. Subtract $250 contraction and $500 churned.
Ending MRR is $11,000.00. Net new MRR is +$1,000.00.
The table under the chart gives the balance after each step. If your billing report shows its own ending MRR, compare it with this one. A gap usually means a change is missing or counted twice.
What do the MRR movements mean?
Each movement is a change in MRR from one kind of customer event. These are the common meanings. If your billing tool defines them differently, use its numbers.
| Movement | What it records |
|---|---|
| New MRR | A customer's first paid subscription, such as a trial user who starts paying |
| Expansion MRR | An existing customer pays more, through an upgrade or more seats |
| Reactivation MRR | A former customer starts paying again |
| Contraction MRR | A customer pays less but stays, through a downgrade or fewer seats |
| Churned MRR | A customer stops paying entirely, through a cancellation or failed renewal |
ChartMogul's movement guide uses these five, plus a neutral movement for changes that leave MRR the same. It also counts a new discount as contraction.
How do you calculate ending MRR?
Add the gains to starting MRR and subtract the losses.
Ending MRR
Formula
Ending MRR = starting MRR + new + expansion + reactivation - contraction - churned
Net new MRR = ending MRR - starting MRR
The order of the bars is fixed: gains first, then losses. It isn't the order things happened during the month, and the order doesn't change the ending balance.
Ending MRR is a run rate on the last day of the month, not the revenue you earned during it. The MRR calculator explains what counts toward MRR.
Why doesn't my report's ending MRR match?
Usually because the figures follow different rules. Check that every amount covers the same month, currency, and definition of MRR.
Timing matters too. ChartMogul's churn recognition setting can record a cancellation when it's made, when it's scheduled, or when the paid period ends. Each choice can move churn into a different month.
What can you work out from these movements?
The same numbers feed most monthly SaaS metrics.
- The net revenue retention calculator shows how much starting MRR your existing customers kept, with expansion counted.
- The revenue churn calculator shows the share of starting MRR lost to contraction and churn.
- The SaaS metrics calculator puts growth and retention for the month on one page.