What It Means (Simple Explanation)
A deferred revenue waterfall is a month-by-month schedule showing how unearned revenue will be recognized over time. It turns your deferred revenue liability into a clear forecast of future revenue.
Example
You invoice $120,000 upfront for a 12-month contract. The deferred revenue waterfall shows $10,000 recognized each month—until the full amount is earned.
Why This Matters (To SaaS & Finance Teams)
One of the most attractive aspects of recurring revenue business models is the predictable flow of revenues throughout the contract term. Deferred revenue allows finance teams to quantify the future stream of revenues over the coming months of the contract term. It tracks revenue for which payment has been made, but have not been recognized under GAAP accounting rules. Ordway’s billing software automates deferred revenue waterfalls directly from contracts and billing schedules, ensuring ASC 606 compliance and real-time visibility into earned vs. unearned revenue.
How It Works (Break It Down Simply)
- Deferred revenue is recorded when cash is collected in advance
- The waterfall schedules revenue recognition over the contract term
- Each month, a portion of deferred revenue becomes earned revenue
- The schedule updates as contracts are modified (e.g. upgrades, pauses)
- Adjusts automatically for mid-period changes or partial invoices
Waterfalls tie directly to journal entries for deferred and recognized revenue.
Common Headaches
Many companies attempt to track deferred revenue waterfalls in spreadsheets which results in:
- Misstated revenue from manual waterfall schedules
- Spreadsheets breaking with contract modifications
- Inconsistencies between billing and rev rec logic
- Difficulties explaining rev rec timing to auditors or investors
- Lack of visibility for FP&A and board planning
Best Practices
- Automate deferred revenue waterfalls with a proper accounting system
- Use contract-based triggers to automatically apply adjustments
- Segment and track waterfalls by customer, product, and region
- Document every modification (renewals, credits, term changes) for audit trail purposes
Synchronize journal entries from the revenue subledger with the ERP automatically
When to Use Deferred Revenue Waterfalls
- For annual contracts with upfront payments
- During monthly close and revenue reconciliation
- In board decks and investor updates
- To support ASC 606 audit prep or financial diligence
- In FP&A forecasts for revenue timing
KPI Impact / What It Affects
- Accurate revenue accounting
- Successful external audit and ASC 606 compliance
- Faster close cycle
- Higher outside investor confidence
- Visibility into upcoming recognized revenue
Real SaaS Takeaway
SaaS teams with annual contracts need deferred revenue waterfalls to track the backlog of unrecognized revenue from prepaid invoices. Ordway builds real-time schedules from contract terms, billing cadence, and rev rec rules—no spreadsheet rebuilds needed at month-end.
FAQ Section (Quick Answers to Real Questions)
How do you create a deferred revenue waterfall report in Excel?
To create a deferred revenue waterfall report in Excel, list each contract with its total value and defined revenue recognition schedule (e.g., monthly over 12 months). Then, allocate the revenue recognized for each period, typically month by month, from the initial deferred balance. Summing these recognized amounts for each period will show the monthly reduction of deferred revenue and its corresponding recognition.
What’s the difference between deferred revenue and recognized revenue?
Deferred revenue represents money received from customers for goods or services that have not yet been delivered or performed, making it a liability. Recognized revenue, conversely, is the portion of that revenue that has been earned and recorded on the income statement as services are delivered or obligations are met. The deferred amount becomes recognized revenue over time.
How has ASC 606 impacted deferred revenue waterfall accounting?
ASC 606 significantly impacted deferred revenue waterfall accounting by establishing a five-step model for revenue recognition, focusing on when control of goods or services transfers to the customer. This standard requires companies to precisely identify performance obligations and determine when revenue should be recognized, thereby directly influencing the timing and scheduling within the deferred revenue waterfall.
What are the benefits of automating deferred revenue waterfalls?
Automating deferred revenue waterfalls offers several key benefits, including increased accuracy and reduced manual errors, significant time savings for finance teams, and improved compliance with revenue recognition standards like ASC 606. It also provides real-time visibility into revenue forecasts and financial performance, enabling better strategic decision-making.
Can you provide a deferred revenue waterfall example for a SaaS company?
For a SaaS company, a deferred revenue waterfall example would show an annual subscription fee (e.g., $12,000) initially recorded as deferred revenue. Each month, $1,000 would “fall” from deferred revenue into recognized revenue as the service is provided, illustrating the gradual earning of the annual contract value over its 12-month term.
How do you forecast deferred revenue for subscriptions?
Forecasting deferred revenue for subscriptions involves projecting future sales of new subscriptions, estimating renewal rates for existing customers, and considering average contract values and typical subscription durations. You also factor in any anticipated churn and the timing of cash receipts versus when the revenue will actually be earned and recognized over the service period.
What are the common challenges in deferred revenue reconciliation?
Common challenges in deferred revenue reconciliation include managing high volumes of complex contracts with varying terms, accurately matching cash receipts to specific performance obligations, and ensuring alignment between billing systems and revenue recognition schedules. Manual processes often lead to errors, discrepancies, and difficulties in maintaining compliance with accounting standards.
Want to Go Deeper?
See how Ordway automates deferred revenue schedules from the moment a contract is signed—no manual rev rec workbooks, ever. Request a demo
Other Glossary Terms
Subscription Pause
Credit Memo vs Debit Memo
Recent Blog Posts
