Deferred Revenue Waterfall Summary Report
The Deferred Revenue Waterfall Summary report reconciles the deferred revenue account balance on the balance sheet and provides a forecast of the expected revenue stream. Run this report after you create revenue recognition and deferred revenue reclassification journal entries for the current period. For more information, see Month-End Revenue Processing.
The Deferred Revenue Waterfall report divides deferred revenue into the following categories:
-
Prior Unrecognized – Deferred revenue planned for recognition by the end of the current period but not yet recognized. If you have not completed the month-end revenue recognition journal entries for the current period, those amounts are included. When all amounts have been recognized, this column is not displayed.
-
Short-term deferred revenue – Deferred revenue planned for recognition in the short term. This category is further divided into columns for each of the months. The number of months is determined by the accounting preference Number of Short-Term Revenue Periods. The default is 12.
-
Long-term deferred revenue – Deferred revenue planned for recognition after the number of months set for short-term deferred revenue. This is the Thereafter column of the report.
-
Unplanned deferred revenue – Billed, unrecognized, and not yet in actual revenue plans. This amount is usually equal to the deferred revenue balance minus the total unrecognized amount. The total unrecognized amount is the prior unrecognized plus the short-term deferred revenue and the long-term deferred revenue. The maximum unplanned deferred revenue is capped at the total revenue amount for each element.
The report includes the following additional columns:
-
Deferred Revenue Account
-
Revenue Account
-
Deferred Revenue Balance
Report results are summarized by deferred revenue account and by revenue account.
To view this report:
-
Go to Revenue > Revenue Reports > Deferred Revenue Waterfall.
-
Accept the default value in the As of filter. The default is the current period.
The accounting preference Number of Short-Term Expense Periods determines the maximum number of months displayed after this period. For example, for the current period December 2021 with 12 short-term expense periods, the 12 months shown are January 2022 – December 2022. You see fewer months if schedules and plans do not extend through all the possible months.
-
Select a value in the Subsidiary Context filter if you have a OneWorld account and access to multiple subsidiaries.
-
Select a value in the Accounting Book filter if you are using Multi-Book Accounting and have access to multiple accounting books.
-
Click Refresh to apply your filters.
Related Reports
- Deferred Revenue by Customer Report
- Deferred Revenue by Item Report
- Revenue by Customer Report
- Revenue by Item Report
- Deferred Revenue Waterfall Detail Report
- Revenue Recognition Forecast Summary Report
- Revenue Recognition Forecast Detail Report
- Billing and Revenue Summary Report
- Deferred Revenue Reclassification Activity Report
- Deferred Revenue Reclassification Report
- Deferred Revenue Rollforward Report
- Deferred Expense Waterfall Summary Report
- Deferred Expense Waterfall Detail Report
- Deferred Expense Rollforward Report