Beancount.io LogoBeancount.io

SaaS Revenue Metrics: Building the MRR Waterfall and Reading What It Says About Growth

12 min readMike ThriftMike Thrift
SaaS Revenue Metrics: Building the MRR Waterfall and Reading What It Says About Growth

A founder shows you a deck. ARR is up 35 percent year over year. The deal is a layup, right?

Not so fast. That single number can hide a business that is winning new logos faster than a bucket can hold them while a hole in the bottom quietly drains 4 percent of its base every month. Two SaaS companies can post the same headline growth and have completely different futures, depending on what is going on underneath. The companies that thrive learn to read the recurring-revenue waterfall, not just the topline.

This guide walks through the SaaS metrics that actually matter in 2026: how to calculate MRR and ARR cleanly, how to slice the monthly change into new, expansion, contraction, churned, and reactivation buckets, how to interpret net revenue retention, and how to pair retention with acquisition cost so the unit economics survive contact with a board meeting.

Start With MRR and ARR, but Build Them Carefully

Monthly Recurring Revenue (MRR) is the normalized amount of recurring revenue your subscriptions are contracted to generate in a given month. It excludes one-time fees, professional services, hardware sales, and any non-subscription line items.

The pitfall lives in the details. A customer on an annual plan billed at $12,000 a year does not show up as $12,000 of MRR the month they paid. They show up as $1,000 of MRR every month for the next twelve months. Mixing billing cadence and recognized recurring revenue is the single most common mistake on early-stage SaaS dashboards.

Annual Recurring Revenue (ARR) is simply MRR × 12. It is a run-rate, not a forecast. It assumes today's book of business continues unchanged for a year, which it never quite does. ARR is useful for comparing companies, planning hiring, and talking to investors who think in annual numbers. Internally, MRR is more honest because it changes every month.

A clean MRR definition has three properties:

  1. Recurring only. Exclude implementation fees, training, custom development, usage spikes that won't repeat.
  2. Normalized. Annual contracts get divided into monthly slices. Quarterly contracts the same.
  3. Net of discounts. If you give a customer 20 percent off, MRR is the discounted amount, not list price.

If those three rules are not followed consistently, every downstream metric — growth rate, retention, LTV — will be quietly wrong.

The Recurring-Revenue Waterfall: Five Buckets That Explain Every Change

Net MRR change in any month decomposes into five components:

Net New MRR = New + Expansion + Reactivation − Contraction − Churned

This is the SaaS equivalent of a trial balance. It is the single most diagnostic chart in the business, because it does not just tell you whether MRR grew. It tells you how it grew and what is holding it back.

New MRR

Revenue from customers who pay for the first time in the period. A customer is "new" exactly once. The month after their first invoice, any further changes to their account flow through the other four buckets. Sales and marketing efficiency lives here; if New MRR is rising but CAC is rising faster, you are buying growth at a worsening exchange rate.

Expansion MRR

Additional recurring revenue from existing customers — upgrades to a higher pricing tier, seats added, modules purchased, usage that pushed them into a higher band on a tiered plan. Expansion is the highest-quality growth dollar in SaaS because it has no acquisition cost attached. A company with strong expansion can grow even if New MRR stalls, which is exactly what mature SaaS businesses do.

Reactivation MRR

Revenue from customers who were previously active, churned out, and came back. Reactivation tends to be small in most businesses but worth tracking separately. If reactivation is meaningful, your churn might be more "pause" than "permanent loss," which changes how you should think about retention investments.

Contraction MRR

Recurring revenue lost when existing customers reduce spend — downgrades, seat reductions, dropped add-ons, negotiated discounts at renewal. Contraction is dangerous because it is quieter than churn. A customer who downgrades is often a customer about to leave; a wave of contraction is an early warning that the value story has weakened.

Churned MRR

Recurring revenue lost when customers cancel entirely in the period. Churn is the most damaging component because, absent reactivation, that revenue is gone permanently and the CAC paid to acquire that customer becomes a sunk cost.

A simple example. You start the month with $100,000 of MRR. You close $12,000 in New MRR, your existing base adds $5,000 of Expansion, $500 of dormant customers reactivate, $2,000 of accounts downgrade, and $4,500 of customers cancel. Ending MRR is $111,000. The headline change is +$11,000, or 11 percent month over month, which looks great. The waterfall tells a different story: gross loss was $6,500 against $17,500 of gross add. Quick math says you are losing roughly 37 cents on the dollar before you grow. If that ratio drifts, your growth engine will sputter long before the topline shows it.

Net Revenue Retention: The Number Investors Actually Underwrite

If you only get one retention metric on your dashboard, it should be Net Revenue Retention (NRR), sometimes called Net Dollar Retention.

NRR = (Starting MRR + Expansion + Reactivation − Contraction − Churned) ÷ Starting MRR

Note what's missing: New MRR. NRR isolates the existing book of business. It answers the question, "If we stopped acquiring new customers tomorrow, would our revenue grow, hold flat, or shrink?"

NRR above 100 percent means your existing customers are paying you more over time than they are leaving with. That is the holy grail of SaaS: a business that compounds without buying more growth. NRR below 100 percent means you are leaking, and every new customer dollar has to first plug the leak before it produces net growth.

2026 benchmarks vary sharply by segment:

  • Enterprise SaaS (above $100K ACV): median ~118 percent, top quartile 130 percent+
  • Mid-Market ($25K–$100K ACV): median ~108 percent
  • SMB (below $25K ACV): median ~97 percent

The reason enterprise NRR runs higher is that contracts grow with the customer — seats, modules, usage all expand inside accounts that are slower to churn. SMB SaaS has to fight harder because small customers churn for reasons unrelated to your product (they go out of business, get acquired, change strategy).

There is a sister metric, Gross Revenue Retention (GRR), which strips out expansion and reactivation entirely:

GRR = (Starting MRR − Contraction − Churned) ÷ Starting MRR

GRR is capped at 100 percent and reveals raw retention quality. NRR can hide a business that retains poorly but upsells aggressively. GRR will not. Sophisticated investors look at the gap between the two: a wide gap is a tell that growth depends on squeezing more out of fewer customers.

Quick Ratio, Magic Number, and Rule of 40

Beyond MRR and NRR, three composite metrics tie revenue movement back to growth quality:

SaaS Quick Ratio

Quick Ratio = (New MRR + Expansion MRR) ÷ (Contraction MRR + Churned MRR)

The Quick Ratio is a single number that says: for every dollar of recurring revenue I am losing, how many dollars am I adding? Benchmarks are remarkably uniform across SaaS niches — under 1.0 is bad (you are shrinking), 1.0 to 4.0 is acceptable, and 4.0 or higher signals efficient growth. A Quick Ratio of 4 means you add four dollars for every dollar of churn and contraction, which is the rate at which compounding really kicks in.

Magic Number

Magic Number = (Net new ARR in quarter × 4) ÷ Sales and marketing spend in prior quarter

The Magic Number measures sales efficiency. It asks how much annualized recurring revenue you produced this quarter for each dollar of S&M spend last quarter. Above 1.0 is the classic "pour fuel on the fire" zone. Between 0.75 and 1.0 is acceptable. Below 0.5 is a red flag that the engine is breaking down. A perennial venture-investor refrain: if you are above 1.5, you are leaving growth on the table by under-investing.

Rule of 40

Rule of 40 = Revenue growth rate (%) + Profit margin (%)

The Rule of 40 reflects the tradeoff every SaaS founder eventually faces between growth and profitability. A company growing 60 percent at minus-20 percent margin scores 40. A company growing 20 percent at 20 percent margin also scores 40. Either path is acceptable. Below 40 means you are not growing fast enough to justify burning cash, or not profitable enough to justify slow growth.

In 2026, IPO-ready SaaS companies tend to combine $100M+ ARR, growth above 30 percent, NRR above 115 percent, gross margin above 72 percent, and a Rule of 40 score above 40 — with a credible path to GAAP profitability within 12 to 18 months of going public.

CAC, LTV, and the Payback Question

Acquisition cost and customer value close the loop on whether the recurring revenue is actually worth what you paid for it.

Customer Acquisition Cost (CAC) = Fully-loaded sales and marketing spend ÷ New customers acquired

"Fully-loaded" matters. Include salaries, commissions, paid media, agency fees, sales tools, and any other cost directly attributable to producing new logos. A common mistake is to count only paid media and undercount real CAC by half.

Customer Lifetime Value (LTV) = Average gross profit per customer ÷ Churn rate

The simplest LTV formula uses monthly gross profit divided by monthly customer churn. Use gross profit, not revenue — the dollars that survive after hosting, support, and direct delivery costs.

LTV:CAC Ratio is the unit-economics scoreboard. The traditional benchmark is 3:1 — for every dollar spent on acquiring a customer, you should earn three dollars of gross profit over their lifetime. In 2026, healthy ranges run 3:1 to 5:1, with top-quartile B2B SaaS achieving 5:1 or better. Below 3:1, you may not be charging enough or you are over-spending to acquire. Way above 5:1, you might be under-investing in growth.

CAC Payback Period = CAC ÷ (Monthly recurring gross profit per customer)

How many months of revenue does it take to pay back the cost of acquisition? Sub-12 months is excellent. 12–18 months is acceptable for most SaaS. Beyond 24 months and you are running a cash-intensive business that needs deep capital reserves.

Where Bookkeeping Meets the Metrics

The waterfall is only as reliable as the books underneath it. SaaS founders frequently discover that their "MRR" in their billing tool, their "revenue" in their accounting system, and their "ARR" in the board deck do not actually agree with each other. Under ASC 606, the U.S. GAAP standard for revenue recognition, subscription revenue is recognized over the service period — not when the customer pays. A customer who pays $12,000 upfront for an annual subscription creates $12,000 of deferred revenue on day one, then recognizes $1,000 of revenue each month over the contract.

That means three things have to be tracked separately:

  1. Cash collected (what hit the bank, useful for runway)
  2. Deferred revenue (cash collected but not yet earned, a liability)
  3. Recognized revenue (the GAAP top-line number, the basis for your income statement)

MRR is an operational metric that tracks the contracted run-rate of subscriptions, but it should reconcile to recognized revenue once seasonality, prorations, and one-time items are stripped out. If your MRR and your GAAP revenue diverge over time and you cannot explain why, one of the two is wrong.

Cleanly separating these flows from day one prevents the "we have to redo a year of bookkeeping before the diligence call" nightmare that derails more SaaS rounds than founders care to admit.

A Practical Reporting Cadence

A monthly review that fits on one page:

  • Top line. Ending MRR, ARR, month-over-month change.
  • Waterfall. New, Expansion, Reactivation, Contraction, Churned — in dollars and as percent of starting MRR.
  • Retention. NRR and GRR for the trailing 12 months, segmented by customer cohort if you have the data.
  • Efficiency. Quick Ratio for the month. Magic Number for the quarter. CAC Payback. LTV:CAC.
  • Cash. Cash collected vs. recognized revenue, deferred revenue balance, runway in months.

Two charts make most of this readable: a stacked-bar waterfall showing the five MRR components by month, and a cohort retention curve showing how each month's signups have aged.

Common Traps Worth Flagging

  • Counting bookings as MRR. A signed annual contract is a booking. The MRR portion is the monthly slice, not the contract value. Mixing them inflates current MRR and produces a phantom growth cliff when bookings normalize.
  • Excluding contraction from churn. Some dashboards count only cancellations as "churn" and bury downgrades elsewhere. Contraction is real revenue lost and belongs in the same conversation.
  • Annualizing one good month. ARR is MRR × 12, not best-month MRR × 12. Cherry-picking the seasonal peak is the fastest way to embarrass yourself in diligence.
  • Mixing currencies without FX normalization. International contracts move with exchange rates. Lock the FX rate at the start of the period and reconcile separately, or you will mistake currency swings for real growth and contraction.
  • Forgetting professional services in CAC. If you are providing free implementation to close deals, that's CAC, not COGS. Front-load it and your LTV:CAC will tell the truth.

Keep the Numbers Honest from Day One

The metrics in this guide only work if the underlying data is clean: subscriptions tagged consistently, deferred revenue reconciled monthly, expansion separated from new, churn flagged the day it happens. Beancount.io provides plain-text accounting that gives you complete transparency and version control over your books — every transaction is text you can grep, diff, and audit, with no black box and no vendor lock-in. For founders who want their MRR waterfall to reconcile cleanly to their GAAP income statement without a quarterly reconstruction project, plain-text accounting makes that audit trail effortless. Get started for free and see why developers and finance teams are switching to plain-text books.