An MRR waterfall is a simple bridge between the recurring revenue you started the month with and the number you ended on. For a SaaS founder, that’s far more useful than one tidy headline.
It separates new sales, upgrades, downgrades, cancellations, and reactivations. So you can see, fast, whether growth is solid or whether you’re replacing lost ground.
Once you understand the pattern, the waterfall stops feeling like finance admin. It becomes a clear story about what’s driving the business.
What an MRR waterfall actually shows
Think of it like a bank statement for recurring revenue. You begin with opening MRR, add the good movements, subtract the bad ones, and land on ending MRR.
That matters because MRR rarely moves for one reason. A good month can hide weak retention. A flat month can still be healthy if churn improved and expansion picked up. The waterfall shows the moving parts, not only the finish line.
The core building blocks of the waterfall
Most SaaS waterfalls use the same categories:
- Beginning MRR is the recurring revenue carried into the month.
- New MRR comes from brand-new customers.
- Expansion MRR comes from existing customers upgrading, adding seats, or moving to a higher plan.
- Contraction MRR is revenue lost from downgrades or lower usage.
- Churn MRR is revenue lost when customers cancel.
- Reactivation MRR is revenue from customers who left and then came back.
These lines are what make the chart useful. They turn one number into something you can manage.
The simple formula behind the numbers
The maths is straightforward:
Ending MRR = Beginning MRR + New MRR + Expansion MRR + Reactivation MRR – Contraction MRR – Churn MRR
That formula lets you trace every pound in the final figure. If the ending number looks odd, you don’t guess. You follow the lines.
A solid waterfall tells you how growth happened, not only that it happened.
How to read an MRR waterfall without getting lost in the detail
Start at the left, or the top, depending on the chart. Look at beginning MRR first. Then follow each change in order until you reach ending MRR.
Don’t get distracted by colour and formatting. Ask a simpler question: what added revenue this month, and what took it away? That’s where the answers live.
Spotting growth that comes from acquisition versus expansion
New MRR tells you sales and marketing are bringing fresh customers in. Expansion MRR tells you existing customers are spending more.
You want both, but they mean different things. New MRR shows demand and pipeline strength. Expansion shows product fit, pricing power, and customer satisfaction. Strong SaaS businesses usually have both working at the same time.
Seeing where revenue is leaking out
Contraction and churn are the warning lights. Downgrades may point to poor onboarding, weak usage, or pricing that doesn’t match value. Churn is blunter, customers have left.
If top-line MRR is growing, it’s easy to miss those leaks. The waterfall makes them hard to ignore. A business can add £20k of new MRR and still have a bad month if £18k slipped out the back.
Why MRR waterfalls are so useful for SaaS founders
Founders don’t need more reports. They need better ones. A waterfall helps with decisions, forecasting, fundraising, and board conversations because it shows the quality of revenue movement.
A clearer view of growth quality
Two SaaS companies can both grow MRR by 10% and look similar on paper. But one may be adding sticky customers and expanding accounts, whilst the other is covering heavy churn with new sales.
That’s why the waterfall matters. It adds texture to the headline number. When you combine it with tracking core SaaS performance indicators, you get a much cleaner read on whether growth is efficient and repeatable.
Better conversations with investors and board members
Investors rarely stop at “what’s MRR now?” They want to know what’s inside it. How much came from new logos? How much came from the base? What’s being lost to churn?
A clean waterfall gives you a credible answer. It also makes board packs tighter and less argumentative. If you’re raising, preparing SaaS metrics for investors starts with consistent definitions and a revenue bridge people can trust.
A simple example of an MRR waterfall in action
Here’s a basic month using easy numbers.
| MRR movement | Amount |
|---|---|
| Beginning MRR | £50,000 |
| New MRR | £8,000 |
| Expansion MRR | £3,000 |
| Reactivation MRR | £1,000 |
| Contraction MRR | £1,500 |
| Churn MRR | £4,500 |
| Ending MRR | £56,000 |
The takeaway is simple. Growth happened, but some of it was lost on the way.
How the month is calculated step by step
- Start with £50,000 of beginning MRR.
- Add £8,000 from new customers, taking MRR to £58,000.
- Add £3,000 of expansion and £1,000 of reactivation, taking MRR to £62,000.
- Subtract £1,500 of contraction, leaving £60,500.
- Subtract £4,500 of churn, landing on £56,000 ending MRR.
Once you lay it out like this, the chart stops looking abstract. It’s simple arithmetic with a useful story attached.
What the example reveals about the business
This company grew, but not all growth was equal. New business did most of the lifting. Expansion helped, which is a good sign, and reactivation gave a small boost.
The weak point is churn. Losing £4,500 in one month is meaningful against £50,000 opening MRR. A founder should ask why those customers left, and whether the sales team is bringing in accounts that stick.
Common mistakes founders make when using MRR waterfalls
Mixing up MRR with ARR or cash flow
MRR is recurring monthly revenue. ARR is the annualised version. Cash is what actually hits the bank. Those are not the same thing.
If a customer pays annually up front, cash jumps before monthly revenue does. If you lump all three together, your reporting gets muddy fast. That’s when forecasting starts to wobble.
Forgetting to separate churn from contraction
A downgrade and a cancellation are different events. One customer is still with you, only paying less. The other has gone.
Those lines need separating because the fixes are different. Contraction can point to packaging or usage issues. Churn often points to retention, onboarding, or product fit.
How to use the waterfall to make better decisions each month
What to look at during your monthly finance review
During the monthly review, ask blunt questions. Where did growth come from? What was lost? Are downgrades rising? Is expansion improving? Are reactivations real progress, or are they masking a churn issue?
If you ask those questions every month, trends show up early. That gives you time to adjust pricing, tighten onboarding, revisit sales quality, or fix the product experience before the problem grows.
When to bring in outside finance help
If your definitions change each month, or the board spends half the meeting arguing about numbers, get help. The same goes if you’re fundraising and need reporting that stands up under scrutiny.
This is where Consult EFC adds value. The goal isn’t prettier charts. It’s a clean waterfall, better decisions, and an investor-grade SaaS financial model that ties revenue movement back to runway, hiring, and growth plans.
Final thoughts
A good MRR waterfall gives you one of the clearest views in SaaS. You can see growth quality, churn risk, and expansion potential in one place.
When founders understand that story, they stop managing by headline numbers. They lead with more clarity, and the business usually follows.
Over 12 years across Big Four audit, investment banking and corporate advisory. Kishen works with UK SaaS and AI companies on financial strategy, fundraising and board-level CFO support. ICAEW regulated. Big Four trained. Based in London.