MRR waterfall calculator: from starting to ending MRR

Version 1.0.0

This calculator walks one month of monthly recurring revenue (MRR) from its starting balance to its ending balance, one change at a time.

Have MRR at the start of the month and that month's new, expansion, reactivation, contraction, and churned MRR from your billing report. You get ending MRR, net new MRR, and a waterfall chart of each step.

Currency Required
Labels all amounts; it does not convert them.

MRR amounts

USD

Enter 0 if a movement did not occur.

Added during the month

Lost during the month

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.

MovementWhat it records
New MRRA customer's first paid subscription, such as a trial user who starts paying
Expansion MRRAn existing customer pays more, through an upgrade or more seats
Reactivation MRRA former customer starts paying again
Contraction MRRA customer pays less but stays, through a downgrade or fewer seats
Churned MRRA 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.