In this article

Waterfall

Modules > Advanced revenue & expense deferrals > Inquiries > Waterfall

Use this page to generate a report that shows the recognition amount or deferral balance for a deferral schedule over a specified date range.

Tip: To create a recurring batch job to generate a report, use the Waterfall Reports Batch Processing page.

Revenue Waterfall

The revenue amount is reported within a specified period. The report can show the monthly details of recognized and unrecognized revenue. You can use the report to review when the recognition actually occurred and to also forecast when future recognition is to occur.

Declining Balance

The monthly deferral balance amount is reported within a specified period. As an option, the report can show the future deferral amount. The report can show the monthly details of the deferral balances for recognition schedules. You can review the report to see how deferred revenue balances decline every month over a specified period. You can also forecast future deferred revenue balances for future periods (for example, unrecognized amounts).

Each line displayed corresponds to a single deferral schedule. Only straight line deferral schedules are included. To see specific transactions for a deferral schedule used in the calculation, use the Audit Trail page.

Example

A deferral schedule has an amount 1200.00, with 100.00 recognized each month for 12 months. January and February have been recognized. February was then reversed with the transaction date in March. The amounts for January to April are as shown in the following tables assuming that Forecast past amounts in current period is not selected.

Note icon. Note: Because the February amount was reversed, it is again forecast as being recognized in February.

Actual

	January	February	March	April	May
Recognized	100.00	100.00	-100.00	0.00	0.00
Deferral	1100.00	1000.00	1100.00	1100.00	1100.00

Forecasted

	January	February	March	April	May
Recognized	0.00	100.00	100.00	100.00	100.00
Deferral	1100.00	1000.00	1100.00	1100.00	1100.00

Both

	January	February	March	April	May
Recognized	100.00	200.00	0.00	100.00	100.00
Deferral	1100.00	900.00	900.00	800.00	700.00

Generate Inquiry

To generate a inquiry, follow these steps:

Select the Waterfall type of report you want to generate.
Specify the date range.
Select the Amounts to show.

If you choose to show Forecasted amounts, you can also select whether to Forecast past amounts in current period.

Select Select and add data filters for the data you want on the report.

When the data appears in the lines, the Waterfall tab shows all the lines of data that matches the criteria you specified.

The Totals tab shows the actual or forecast totals for each month.

Select how you want to report to Group by, and select Report.

All deferral schedules that satisfy the criteria that you enter appear in the Waterfall tab of the list area. You can select a deferral schedule to view the details the in the Schedule Lines page.

Fields

This page contains the following fields:

Field	Description
Waterfall type	Select the type of report you want to generate: Revenue waterfall: Shows the revenue or expense amount for the period. Declining Balance: Shows the deferral balance at the end of the period.
Start date	Specify the start date for the period. The exact date is not used in the calculation, only the fiscal period in which the date exists.
End date	Specify the end date for the period. The exact date is not used in the calculation, only the fiscal period in which the date exists. Note: A range can have a maximum of 26 periods.
Amounts to show	Select the amount you want to show: Actual: Shows only the actual amount. Forecasted: Shows only the forecasted amount. Both: Shows a total of the amount in each period. The amount is composed of both the actual and forecasted amounts.
Forecast past amounts in current period	Select to consolidate the amounts in the periods before the current period into the current period. The current period is determined by the session date.
Group by	Select how the data in the report is organized. The report data can be organized by customer, item, billing schedule number or deferral or recognition account.
List
Waterfall tab	Displays the actual or forecasted revenue, or both amounts, for the deferral schedules that satisfy the criteria that you entered.
Totals tab	Displays the totals for the start and end dates of all the deferral schedules that appear in the Waterfall tab. Note: The amounts for each schedule are always positive numbers regardless of whether the recognition type is debit or credit. Therefore, to ensure that the totals are meaningful, you must use filters on the results.

Buttons

This page contains the following buttons:

Button	Description
Select	Opens a query window, where you can add user-defined parameters to the query. When you select OK, the query is applied to the data, and the lines are updated.
Report	Generates and displays the report organized according to the Group by option selected.