A SaaS revenue waterfall, also called a bookings-to-revenue waterfall, is a financial model that forecasts how contracted subscription business translates into recognized revenue over time. It organizes bookings into cohorts based on when contracts begin and applies assumptions about contract terms, service delivery, and revenue recognition to estimate revenue for each period.
Planning in finance often requires aggregating data, spending hours in spreadsheets, and adjusting formulas and models to meet stakeholder needs, and adding cohort waterfalls makes that work even more demanding.
Take a SaaS revenue waterfall model, for example. It can uncover performance trends over time, and adding one to your ARR snowball model gives you a clearer, more insightful forecast from bookings to revenue. But building it accurately requires detailed assumptions, consistent cohort logic, and formulas that are easy to maintain.
To make your revenue forecasting more accurate and actionable, use this free SaaS revenue waterfall template that gives you a clearer view of how bookings flow into revenue over time.
What is a SaaS revenue waterfall?
A SaaS revenue waterfall, also known as a bookings-to-revenue waterfall, is a model that shows how booked revenue converts into generally accepted accounting principles (GAAP) revenue.
These models use time-based cohorts to visualize how total bookings turn into GAAP revenue over time. Total bookings include:
- New ARR: Recurring revenue from newly acquired customers.
- Expansion ARR: Additional recurring revenue from existing customers.
- Renewal ARR: Contract value renewed by existing customers, based on the model’s booking conventions.
- Contraction ARR: Recurring revenue lost when existing customers downgrade or reduce usage.
- Churn ARR: Recurring revenue lost when customers cancel or do not renew.
New business and expansion can increase contracted recurring revenue, while contraction and churn reduce it. Renewal bookings should be modeled consistently with the company’s definition of bookings and its existing contract base.
SaaS revenue waterfall model vs. deferred revenue waterfall vs. revenue waterfall chart
Terms like SaaS revenue waterfall model, deferred revenue waterfall model, and revenue waterfall chart sound similar, but they mean different things to finance teams. Knowing the differences is key to analyzing and optimizing revenue, retention, billing, and cash flow.
| Model | What it shows | Best used for |
|---|---|---|
| SaaS revenue waterfall model | How cohorts of bookings convert into recognized GAAP revenue over time | Forecasting recognized revenue period by period |
| Deferred revenue waterfall | The revenue recognition schedule compared against the deferred revenue balance, period over period | Balance sheet forecasting and tracking deferred revenue liabilities |
| Revenue waterfall chart (ARR bridge) | How a starting bookings balance changes across new, expansion, renewal, churn, and downgrades | Showing top-line growth to CFOs and other stakeholders, though it doesn’t capture recognition over time |
How is revenue recognition connected to ARR?
ARR captures the annualized value of your booked contracts, but you can’t record all of it as revenue the moment a customer signs. Under standards such as ASC 606 and IFRS 15, you recognize revenue as you deliver the service across the contract term.
That’s where the waterfall does its work. It bridges the gap between what you book and what you can recognize, spreading each cohort’s ARR across the months you earn it. A 12-month annual contract worth $12,000 in ARR, for example, recognizes $1,000 each month, or 8.33 percent of the total.
Bookings, ARR, revenue, billings, and cash collections each measure something different. Bookings track contracted business according to the company’s definition, while ARR measures the annualized value of recurring subscription revenue. Recognized revenue reflects the services delivered during a period. Billings track amounts invoiced to customers, and cash collections track payments received.
Since these events can occur at different times, a revenue waterfall helps forecast when contracted subscription business is expected to appear as recognized revenue.
How to create a SaaS bookings to revenue waterfall model
Cohort modeling is one of the most complex tasks finance teams take on, especially when building a SaaS revenue waterfall. Even if you’re highly skilled in Excel, cohort calculations can be tough to set up, tricky to explain to stakeholders outside finance, and challenging to maintain once the model is in place.
Whether you use spreadsheets or a specialized tool, you’ll want three essential inputs to build a SaaS revenue waterfall:
- New ARR bookings forecast: a reliable forecast of new business bookings, whether through a sales capacity model, an ARR snowball, or another top-line planning method
- Bookings from retention and churn: ARR from renewals, upsells, expansions, downgrades, and churn, which combine with new ARR to make up total bookings per period
- Revenue recognition schedule: a timeline that shows how booked ARR is recognized over time, for example 8.33 percent per month across a 12-month annual contract
The trickiest part of building a SaaS revenue waterfall in a spreadsheet is getting the formulas right. To calculate monthly recognized revenue for each cohort, divide its eligible subscription revenue by 12, assuming revenue is recognized evenly over a 12-month service period.
Your formula needs to account for the cohort’s start date and contract term, so revenue is recognized only during the applicable service period. If contracts have different durations or revenue recognition patterns, adjust the formula to reflect those differences.
A SaaS revenue waterfall also rarely operates in isolation. It often feeds into broader financial models, so make sure forecasted bookings align with your top-line projections and overall planning framework.
If you’re ready to move beyond spreadsheets, HiBob’s financial tools include ready-to-use waterfall templates that give finance teams a faster starting point, so you can spend less time rebuilding formulas by hand and more time acting on what the numbers tell you. You can book a demo to see how they fit into your planning process.
Why companies use SaaS revenue waterfalls
Finance teams reach for a SaaS revenue waterfall because it turns raw bookings into a forecast they can act on and defend. The payoff shows up in a few places:
- Accurate forecasting: you project recognized revenue period by period instead of guessing from bookings alone
- Early warning on churn and contraction: you spot downgrades and cancellations as they move through each cohort, which helps you manage customer retention cost
- Alignment across finance and stakeholders: you give leaders and investors one shared view of how bookings become revenue
- Balance sheet clarity: you connect recognized revenue to deferred revenue, which sharpens your balance sheet forecasting
Common pitfalls when building a SaaS revenue waterfall
Even experienced teams run into the same traps. Here are the most common ones and how to avoid them:
| Pitfall | How to avoid it |
|---|---|
| Relying on fragile manual spreadsheets that break as cohorts and formulas multiply | Standardize the model in a template or planning tool so formulas stay consistent as you scale |
| Mishandling one-time and setup fees under ASC 606 by spreading them like recurring revenue | Recognize one-time and setup fees on their own schedule, separate from subscription ARR |
| Forgetting contraction and downgrades, which quietly inflates the forecast | Model downgrades and contraction alongside churn so each cohort reflects real net revenue |
Recommended For Further Reading
Use this free SaaS revenue waterfall template
Don’t spend hours (or days) every month trying to recreate the waterfall model that translates ARR bookings into a recognized revenue forecast.
Download our spreadsheet-based SaaS bookings to revenue waterfall template to get started faster.
The template can help you structure the model, but spreadsheets have limits as planning gets more complex. As your business grows, Finance teams need faster access to actuals, clearer reporting, and models that are easier to update and share.
HiBob helps bring people and financial data together in one connected platform, giving Finance and FP&A teams a more accurate view of workforce costs, plans, and business performance. With connected data, reporting, and planning workflows, teams can spend less time maintaining manual models and more time using them to make better decisions.
<< Plan with HR and finance data in one place with HiBob. >>
SaaS revenue model FAQs
What is an ARR waterfall?
An ARR waterfall is a financial modeling approach that uses time-based cohorts to show how forecasted bookings turn into recognized revenue, based on your revenue recognition schedule. Modern financial modeling tools can streamline the process and improve both speed and accuracy.
Sometimes, the term “ARR waterfall” also refers to a simpler visualization that breaks down ARR growth by new, expansion, downgrade, and churn revenue. This is more commonly called an ARR or revenue bridge chart.
What are the SaaS waterfall metrics?
SaaS waterfall metrics track MRR and ARR growth broken into its moving parts: new, expansion, contraction, and churn MRR. Together, these show how much recurring revenue you gain and lose each period, alongside acquisition economics like customer acquisition cost (CAC) and customer lifetime value (LTV).
Net revenue retention (NRR) and gross revenue retention (GRR) give you the retention read on top of those movements, so you can see whether expansion is outpacing contraction and churn.
How do you model SaaS revenue?
Two common approaches for modeling SaaS revenue are the sales capacity model and the ARR snowball model. Sales capacity models forecast revenue based on new account executive hiring plans and expected quota attainment. ARR snowball models factor in new customer ARR, upsell and expansion ARR, and churn to calculate the running ARR balance for each period.
What is the difference between billings and revenue?
In SaaS forecasting, it’s important to differentiate between bookings, revenue, and billings. Bookings reflect total contracted ARR. Revenue is how that ARR is recognized over time. Billings represent when customers are invoiced and when cash is collected.