NetLoan - Waterfall report beginning and ending balances
Overview
The Waterfall Roll Forward setting adds two columns to a Waterfall report: Beginning Balance and Ending Balance. These turn a standard waterfall into a roll forward, showing the opening amount, the monthly activity for the selected date range, and the resulting closing amount for each loan.
NetLoan ships the Loan Balance Roll Forward Waterfall Report, which already uses this setting to show principal adjustments with beginning and ending loan balances. You can also turn the setting on for any other Waterfall report.
Key assumptions
- The setting is available only on reports with a Report Type of Waterfall. It is hidden for all other report types.
- The columns are calculated from the report's Waterfall Type:
- Beginning Balance - the total for the Waterfall Type on schedule lines whose period starts before the beginning of the report's date range.
- Monthly columns - the amount for each month in the date range, as on any Waterfall report.
- Ending Balance - Beginning Balance plus the monthly amounts in the date range.
- The Thereafter column, when it appears, is not included in Ending Balance.
Use with activity-based waterfall types
Ending Balance adds up the amounts in each column. This works for activity Waterfall Types such as Principal, Interest, and Payments. For balance Waterfall Types such as Remaining Principal Balance, Remaining Payments, or Total Interest, the monthly balances are added together, so Ending Balance does not show a meaningful figure.
Step-by-step process
Turn on the setting
- Navigate to NetLoan > Reports > All Reports.
- Click View next to the Waterfall report you want to update, then click Edit.
- Open the Advanced Configuration subtab.
- Confirm that Waterfall Type is set to the data you want to report on.
- Check Waterfall Roll Forward.
- Click Save.
Copy delivered reports before changing them
To keep your changes through bundle updates, make a copy of a delivered report and edit the copy. See NetLoan - Editing Reports in NetLoan.
Run the report
- Navigate to NetLoan > Reports > All Reports and click Run next to the report.
- Set the filters, including a date range or accounting period.
- Click Preview.
The report shows Beginning Balance before the first month column and Ending Balance after the last month column. Click Export to download the report.
Record structure
| Field Name | Field Type | Description | Example | Field ID |
|---|---|---|---|---|
| Waterfall Roll Forward | Checkbox | Adds Beginning Balance and Ending Balance columns to a Waterfall report. Shown only when Report Type is Waterfall. | Checked | custrecord_da_report_wf_roll_forward |
