SaaS finance / RevOps

SaaS MRR Waterfall Builder

Deterministic monthly MRR schedule with chained starts, retention metrics, CSV export, and print output.

Ending MRR
$0
$0 ARR
Net New MRR
$0
$0 avg / month
Overall NRR
n/a
Expansion minus losses over starting MRR
Overall GRR
n/a
Starting MRR retained before expansion
Quick Ratio
n/a
$0 losses
Movement Total
$0
$0 gross adds

Monthly Waterfall

Starting MRR is carried from the prior month ending MRR.

Month Starting New Expansion Reactivation Contraction Churn Net New Ending GRR NRR Quick
Total
Average

Self-Tests

Not run

About the SaaS MRR Waterfall Builder

Financial analysts and SaaS founders rely on detailed revenue tracking to evaluate startup growth and churn dynamics. A SaaS MRR waterfall builder visualizes monthly recurring revenue movements, segmenting new sales, expansions, contractions, and lost accounts. Compiling these metrics automatically calculates critical health indicators like Net Revenue Retention (NRR) and the SaaS Quick Ratio.

How it works

  1. Input the starting Monthly Recurring Revenue (MRR) for the given period.
  2. Add revenue gains from new customer acquisitions and existing account expansions or cross-sells.
  3. Deduct revenue losses stemming from account contractions, downgrades, and full customer churn.
  4. Review the generated waterfall chart, final ending MRR, and calculated NRR/GRR metrics.

Frequently asked questions

What is the difference between Net Revenue Retention (NRR) and Gross Revenue Retention (GRR)?

GRR measures the retained revenue from existing customers excluding expansions, capping at 100%. NRR includes expansions and cross-sells, meaning it can exceed 100% if upgrades outpace churn.

Why is the SaaS Quick Ratio important?

The SaaS Quick Ratio compares revenue growth (new + expansion) against revenue decline (churn + contraction). A ratio above 4.0 generally indicates healthy, sustainable growth despite churn.

Should one-time implementation fees be included in MRR?

No, MRR should exclusively track recurring subscription fees. Non-recurring engineering (NRE) or setup fees skew the consistency of recurring revenue projections.

How does contraction differ from churn?

Churn occurs when a customer cancels their subscription entirely. Contraction happens when an active customer remains but downgrades to a lower pricing tier or reduces their license count.

References