Deferred Revenue Waterfall Detail Report
The Deferred Revenue Waterfall Detail 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 Detail 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:
-
Customer (from the revenue element on the revenue arrangement)
-
Unbilled Receivable Group
-
Currency (when the Multiple Currencies feature is enabled). This is the transaction currency. Amounts are in base currency.
-
Source Document #
-
Source Type
-
Item
-
Deferred Revenue Account
-
Revenue Account
-
Deferred Revenue Balance
Only revenue elements with a deferred revenue balance appear in this report. Click the values in the Customer and Transaction Number columns to open the associated records.
Report results are grouped by customer.
You can identify the source type in the report and drill down to the original source. The following table shows how the source type in the report is derived from transactions.
|
Transactions |
1st Level Parent |
2nd Level Parent |
3rd Level Parent |
Source Type |
|---|---|---|---|---|
|
Sales Order |
Sales Order |
|
|
— |
|
Invoice created from a Sales Order |
Invoice |
Sales Order |
|
Sales Order
Note:
The source type is the sales order if you have not updated the revenue arrangement. |
|
Revenue Arrangement created from a Invoice and Sales Order |
Revenue Arrangement |
Invoice |
Sales Order |
Revenue Arrangement |
|
Return Authorization |
Return Authorization |
|
|
— |
|
Credit Memo created from a Return Authorization |
Credit Memo |
Return Authorization |
|
Return Authorization |
|
Invoice |
Invoice |
|
|
Invoice
Note:
The source type is the invoice if you have not updated the revenue arrangement. |
|
Revenue Arrangement created from a Invoice |
Revenue Arrangement |
Invoice |
|
Revenue Arrangement |
|
Journal entry |
Journal entry |
|
|
Journal
Note:
The source type is the journal entry if you have not updated the revenue arrangement. |
|
Revenue Arrangement created from a Journal Entry |
Revenue Arrangement |
Journal Entry |
|
Revenue Arrangement |
|
Credit Memo |
Credit Memo |
|
|
Credit Memo
Note:
The source type is the credit memo if you have not updated the revenue arrangement. |
|
Revenue Arrangement created from a Credit Memo |
Revenue Arrangement |
Credit Memo |
|
Revenue Arrangement |
|
Cash Sale |
Cash Sale |
|
|
Cash Sale
Note:
The source type is the cash sale if you have not updated the revenue arrangement. |
|
Revenue Arrangement created from a Cash Sale |
Revenue Arrangement |
Cash Sale |
|
Revenue Arrangement |
|
Cash Refund |
Cash Refund |
|
|
Cash Refund
Note:
The source type is the cash refund if you have not updated the revenue arrangement. |
|
Revenue Arrangement created from a Cash Refund |
Revenue Arrangement |
Cash Refund |
|
Revenue Arrangement |
To view this report:
-
Go to Revenue > Revenue Reports > Deferred Revenue Waterfall > Detail.
-
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 Summary 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