Deferred Revenue Waterfall Calculator
Model SaaS deferred revenue amortization waterfalls under ASC 606. Calculate monthly earned revenue recognition, unearned contract balances, and cash collections.
Contract Billing & Revenue Recognition Terms
ASC 606 / IFRS 15 straight-line amortization and deferred liability balance sheet sizing
$10,000
ASC 606 monthly earnout$170,000
17 months unearned$70,000
Month 7 cumulativeCurrent: $120,000
Non-Current: $50,000
ASC 606 Revenue Schedule Ready
Export deferred revenue ledger schedules for monthly financial close audits
Managing Deferred Revenue Under ASC 606 and IFRS 15
For subscription and contract-based businesses, collecting cash upfront for multi-month or multi-year contracts creates a balance sheet liability known as Deferred (or Unearned) Revenue. Under GAAP ASC 606 and IFRS 15 standards, revenue cannot be recognized immediately upon invoicing; it must be recognized systematically over time as the performance obligations are fulfilled.
Key Features
Multi-Contract Duration Engine
Handles 3, 6, 12, 24, and 36-month subscription contracts with customized upfront payment terms.
12-Month Detailed Waterfall Schedule
Generates a full monthly table showing Beginning Balance, New Billings, Earned Revenue, and Ending Deferred Balance.
ASC 606 Straight-Line Amortization
Applies ratable daily/monthly revenue recognition complying with GAAP and IFRS audit standards.
Cash Collections vs Recognized Revenue Delta
Clearly highlights the divergence between cash flow timing and GAAP income statement performance.
Cohort Churn & Renewal Adjustment
Models mid-term cancellation risk and projected annual renewal expansions across customer cohorts.
Audit-Ready CSV/Accounting Export
One-click copy of the complete recognition waterfall formatted for NetSuite, QuickBooks, or Excel audit workpapers.
Common Use Cases
- ✓SaaS Financial Controllers & Accountants
Reconcile monthly general ledger journal entries between unearned revenue liability and software subscription income.
- ✓FP&A Teams & Financial Analysts
Project future recognized revenue runs based on anticipated new booking cohorts and annual upfront billings.
- ✓Venture Capital & Private Equity Due Diligence
Inspect deferred revenue schedules during M&A due diligence to verify quality of earnings and avoid post-close revenue cliffs.
- ✓Tech Startup Founders
Understand why cash in the bank does not equal taxable or reportable top-line revenue under GAAP accounting.
Frequently Asked Questions
What is deferred revenue in SaaS?
Deferred revenue is money collected by a company for products or services that have not yet been delivered. Under GAAP, it is classified as a liability on the balance sheet until the service is delivered.
Why does ASC 606 require deferred revenue schedules?
ASC 606 mandates that revenue be recognized when control of the promised goods or services is transferred to the customer. A revenue waterfall ensures revenue is recognized evenly over the contractual performance period.
How does deferred revenue impact SaaS company valuation?
High deferred revenue indicates customers are paying upfront annually, which provides non-dilutive working capital cash flow. During acquisitions, buyers scrutinize deferred revenue to ensure they don't inherit fulfillment obligations without corresponding cash.
What is the difference between billings, bookings, and revenue?
Bookings is the total contract value signed. Billings is the amount actually invoiced to the customer. Revenue is the earned portion recognized over the subscription period under GAAP.
Need a Brain Break? ☕
Done working on your task? Take a quick 60-second break, test your reflexes, and flap through infinite pixel obstacles in Sky Flap!