Deferred Expense Waterfall Detail Report
The Deferred Expense Waterfall Detail report is available when either of these features is enabled:
-
Amortization
-
Advanced Revenue Management
The Deferred Expense Waterfall Detail 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 Detail 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:
-
Entity – For rows from amortization schedules, the entity is the vendor. For rows from cost amortization plans, the entity is the customer.
-
Currency (when the Multiple Currencies feature is enabled). This is the transaction currency. Amounts are in base currency.
-
Source Document #
-
Source Type
-
Item
-
Deferred Expense Account
-
Expense Account
-
Deferred Expense Balance
Click the values in the Source Document # and Item columns to open the associated records.
Report results are grouped by entity.
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 |
|---|---|---|---|---|
|
Bill Credit |
Bill Credit |
|
|
Bill Credit |
|
Vendor Bill |
Vendor Bill |
|
|
Bill
Note:
A vendor bill appears as Bill in the Source Type column. |
|
Bill Credit created from a Vendor Bill |
Bill Credit |
Vendor Bill |
|
Bill Credit |
|
Amortization Journal Entry created from a Vendor Bill |
Amortization Journal Entry |
Vendor Bill |
|
— |
|
Amortization Journal Entry created from a Bill Credit and Vendor Bill |
Amortization Journal Entry |
Bill Credit |
Vendor Bill |
— |
|
Journal Entry |
Journal Entry |
|
|
Journal |
|
Vendor Return Authorization |
Vendor Return Authorization |
|
|
— |
|
Bill Credit created from a Vendor Return Authorization |
Bill Credit |
Vendor Return Authorization |
|
Vendor Return Authorization |
|
Amortization Journal Entry created from a Bill Credit and Vendor Return Authorization |
Amortization Journal Entry |
Bill Credit |
Vendor Return Authorization |
Vendor Return Authorization |
|
Vendor Bill created from a Purchase Order |
Vendor Bill |
Purchase Order |
|
Bill
Note:
A vendor bill appears as Bill in the Source Type column. |
|
Amortization Journal Entry created from a Vendor Bill and Purchase Order |
Amortization Journal Entry |
Vendor Bill |
Purchase Order |
Bill Purchase Order
Note:
The transactions appear on two lines in the Source Type column. |
To view this report:
-
Go to Reports > Financial > Deferred Expense 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.