The MRR Waterfall Most MSPs Never Build
Ric Hall, CRO
One MRR number tells you almost nothing about why it moved. A recurring revenue line can grow from new clients, shrink from churn, and quietly erode from downgrades in the same month, and a single total hides which one is happening. The SaaS fix, rarely built by MSPs, is breaking MRR into its component movements and tracking each separately.
What is the MRR waterfall, and why does one MRR number hide too much?
Add new MRR and expansion MRR to your starting total, subtract contraction and churned MRR, and the result is your ending MRR for the period. Most MSPs only ever look at that ending number. They almost never see which of the four movements actually produced it, which means two MSPs reporting identical MRR growth this month could be in completely different financial health underneath that number.
Consider a hypothetical pair of MSPs, both reporting $10,000 in new MRR growth this month. The first got there with $14,000 in new business MRR from signing new clients, offset by $4,000 in churned MRR from clients who left entirely. The second got there with $3,000 in new business MRR and $9,000 in expansion MRR from existing clients buying more, with only $2,000 lost to churn. Both numbers look identical on a one-line revenue report. One of those businesses is replacing lost clients just fast enough to look healthy. The other is growing the accounts it already has while barely losing anyone. A CRO who only sees the ending total cannot tell which business they are actually running.
How does this gap actually show up in MSP data?
Only 35 percent of MSPs track client churn as a metric at all, even though 58 percent track MRR itself, according to ScalePad's 2026 MSP Trends Report. That same report defined its actual top performers, the top 10 percent of respondents, as firms with at least 60 percent recurring revenue, client churn at 10 percent or less, and a projected growth rate above 11 percent.
The same report found 44 percent of MSPs track average revenue per unit at all, with the single most common band sitting between $151 and $200 per unit at 20 percent of respondents, followed by $201 to $250 at 18 percent. ARPU on its own only tells you the average size of a client relationship today. It says nothing about whether that average is climbing because existing clients are buying more, which is expansion MRR, or climbing only because you are replacing smaller churned clients with larger new ones, which the waterfall would show as new business and churn moving in opposite directions rather than one smooth upward line.
Tracking MRR without tracking churn is like watching your bank balance without ever opening a statement. The number moves, but you cannot say whether new deposits or quiet withdrawals are doing the moving, and you have no way to tell leadership which one to fix.
What's actually driving recurring revenue growth right now?
The 2026 MSP 501 survey found recurring revenue grew 11.9 percent among more than 600 surveyed organizations, outpacing total revenue growth of 9.6 percent, while the number of customer accounts served grew 12.73 percent against workforce growth of only 6.9 percent. That combination, recurring revenue outpacing total revenue while headcount grows slower than the client base, is only good news if the extra growth is coming from expansion and new business rather than one-time project work getting mislabeled as recurring. The MRR waterfall is what actually tells you which one it is.
ScalePad's report also found that growing existing client accounts rose from fourth to second place on MSPs' list of top growth drivers for 2026, with its own top performers specifically balancing new client acquisition against account expansion rather than leaning on one or the other. If existing-account growth is becoming a bigger driver industry-wide, expansion MRR is exactly the number that tells you whether your own existing accounts are actually growing with you, or just staying the same size while new clients carry all the weight. A sales team can hit a new-business quota every month while expansion MRR sits flat or negative the whole time, and a top-line revenue report would never show the difference until renewal season arrives and the contraction finally shows up as churn instead.
How should a CRO actually build this waterfall?
Start with a plain list, not a dashboard. For every client, log the MRR change that shows up each billing cycle and tag it as new, expansion, contraction, churn, or reactivation, using the definitions above as your rule book so two people on your team never classify the same event two different ways. A spreadsheet handles this fine for the first few months. The value is in the habit of tagging consistently, not the tool you tag it in.
Review expansion and contraction MRR separately from new business and churn in every revenue meeting you run. New business tells you how sales is doing. Churn tells you how retention is doing. Expansion and contraction together tell you something neither of those captures on its own: whether the clients you already have are growing with you or slowly shrinking in ways a clean logo-retention number can hide completely.
Put the waterfall on a monthly cadence, not a quarterly one, so a contraction trend shows up while there is still time to act on a specific account rather than after a renewal has already gone sideways. Whoever owns account management should be the one walking leadership through the expansion and contraction lines each month, since those are the numbers closest to the day-to-day client relationship, while whoever owns new logos reports on new business and whoever owns support and delivery reports on what is driving churn. Splitting ownership that way keeps any one team from quietly smoothing over a bad month in a number nobody else is checking closely.
Where that growth actually comes from matters too. Referral and partner-driven deals tend to land as clean new-business MRR with less contraction risk down the line than channel deals won on price alone, since a referred client arrives already sold on the relationship rather than the discount. AI University MSP is built around teaching that kind of referral and partner economics to your own sales motion, so more of your new business MRR starts out durable instead of needing to be re-won at every renewal.
Expansion MRR has to come from somewhere specific too, not just general goodwill. Running your current offer mix through the stack builder is a fast way to see which of your service lines are actually positioned to expand inside an existing account instead of only ever being sold once per client. The way you price and package what you resell affects every bucket in the waterfall at once, and reviewing the full product catalog is a reasonable way to see which white-labeled lines are built for that kind of expansion revenue rather than a single flat sale.
A single MRR number will keep telling you revenue went up or down. The waterfall underneath it is what tells you why, and why is the only version of that number a CRO can actually act on, plan a renewal around, or defend in a board meeting when someone asks what is really behind this quarter's growth. See the full stack to find offerings built to grow inside the accounts you already have.