Deferred Expense Waterfall Summary Report
The Deferred Expense Waterfall Summary report is available when either of these features is enabled:
-
Amortization
-
Advanced Revenue Management (Essentials)
The Deferred Expense Waterfall Summary report reconciles the deferred expense account balance on the balance sheet and provides a forecast of the expected expense stream. The report displays the results of all transactions to users with permission to see it, regardless of any role restrictions on transactions. The report is accessible to those whose role includes the Deferred Expense Reports permission.
Run this report after the following processes:
-
Revenue recognition journal entry creation if you use Advanced Revenue Management (Essentials) with the Enable Advanced Cost Amortization accounting preference checked
-
Amortization journal entry creation if you use Amortization
Manual journal entries posted directly to a deferred expense account are included regardless of whether automated amortization or revenue recognition journal entries have been generated.
The Deferred Expense Waterfall report divides deferred expense into the following categories:
-
Prior Unrecognized – Deferred expense planned for recognition by the end of the current period but not yet recognized. If you have not completed the month-end revenue recognition or amortization journal entries for the current period, those amounts are included. When all amounts have been recognized, this column is not displayed.
-
Short-term deferred expense – Deferred expense 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 Expense Periods. The default is 12.
-
Long-term deferred expense – Deferred expense planned for recognition after the number of months set for short-term deferred expense. This is the Thereafter column of the report.
-
Unplanned deferred expense – Billed, unrecognized, and not yet in actual cost amortization plans or amortization schedules.
The report includes the following additional columns:
-
Deferred Expense Account
-
Expense Account
-
Deferred Expense Balance
Report results are summarized by deferred expense account and by expense account.
To view this report:
-
Go to Reports > Financial > Deferred Expense 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.