What is an ARR Waterfall?An ARR waterfall is a financial analysis that decomposes the change in Annual Recurring Revenue between two periods into its five constituent components: New ARR (revenue from newly acquired customers), Expansion ARR (additional revenue from existing customers through upsells and additions), Contraction ARR (lost revenue from existing customers due to
What is an ARR Waterfall?
An ARR waterfall is a financial analysis that decomposes the change in Annual Recurring Revenue between two periods into its five constituent components: New ARR (revenue from newly acquired customers), Expansion ARR (additional revenue from existing customers through upsells and additions), Contraction ARR (lost revenue from existing customers due to downgrades, shown as negative), Churned ARR (revenue lost from customers who canceled completely, shown as negative), and Reactivated ARR (revenue from previously churned customers who returned). The waterfall shows the beginning ARR, each positive and negative component, and the resulting ending ARR, visually explaining the movement in total ARR.
Why the ARR Waterfall is the Most Important SaaS Report
The ARR waterfall is the SaaS equivalent of a profit and loss statement for the growth model: it shows not just whether ARR grew but why it grew and where growth is coming from. A company growing ARR through strong New ARR but also experiencing accelerating Churn ARR has a fundamentally different health profile than one with moderate New ARR but strong Expansion exceeding Churn. Investors use the waterfall to assess: gross retention quality, expansion motion effectiveness, new customer acquisition efficiency, and the predictability and sustainability of ARR growth. Monthly waterfalls enable early identification of deteriorating trends in any component before they significantly impact total ARR.
Frequently Asked Questions
How do I build an ARR waterfall report?
Build an ARR waterfall in a spreadsheet or BI tool: (1) For each month, query your billing system (Stripe, Chargebee, custom system) to identify: new customers who started paying (New ARR), existing customers who increased their subscription (Expansion ARR), existing customers who decreased their subscription (Contraction ARR), and customers who fully canceled (Churned ARR). (2) Calculate the sum: Previous ARR + New ARR + Expansion ARR – Contraction ARR – Churned ARR = Current ARR. (3) Visualize as a waterfall chart with each component as a separate bar. Tools like Baremetrics, ChartMogul, and Maxio provide automated ARR waterfall reports if your billing data is properly structured.
What ARR waterfall metrics indicate a high-quality SaaS business?
Indicators of a high-quality ARR waterfall: (1) Expansion ARR greater than Churned ARR (net negative churn, strongest signal of product-market fit and CS quality), (2) New ARR growing while maintaining stable or declining Churn ARR (growing the bucket without leaking faster), (3) Contraction ARR below 5% of beginning ARR (minimal downgrade pressure indicating strong pricing power), (4) Reactivated ARR growing (indicates strong product quality that brings customers back after brief churn), and (5) New ARR seasonality patterns that indicate healthy pipeline development (versus lumpy, unpredictable new ARR that suggests pipeline quality issues).