NetLease - Lease Payment Waterfall Report
Purpose
The Lease Payment Waterfall Report presents the projected payment amounts by lease type for the selected period.
Navigation
NetLease > Reports > All (or Subledger) Reports > Lease Payment Waterfall Report > Run
Filtering
The report search can be refined by adjusting filters for subsidiary, currency, department, class, location, accounting period, or date. After selecting the desired filters, click Preview to view the results.
Select a 1-year date range to view the projected lease payments for the year.
Show FX Calculations Filter
This checkbox enables users to view lease balances in the lease currency, subsidiary currency, and consolidated currency. It also displays the exchange rates used to calculate these balances.
This option is useful for viewing and reconciling balances for leases that have undergone remeasurement or have been consolidated into a different subsidiary currency.
Results
When the schedule is run, users will see a summary of leases and their associated projected payment amounts by lease type for the selected period. The schedule allows users to drill down into individual leases and view detailed future payment information. This serves as a forward-looking report. To download the report in Excel, click the Export button.
Customizing the Report
The standard Lease Payment Waterfall Report displays lease payment data based on the default waterfall type configuration. Users may create customized copies of the report to include additional data, such as non-lease payments. The steps below describe how to create and configure a customized version of the report.
Including Non-Lease Payments
By default, the Lease Payment Waterfall Report does not include non-lease payments. To include non-lease payments, a copy of the report must be created and configured using the Advanced Configuration settings.
Navigate to NetLease > Reports > All (or Subledger) Reports and locate the Lease Payment Waterfall Report. Click View on the report to open it.
Hover over the Actions menu and select Make a Copy.
Assign the copied report a descriptive name, such as Lease Payment Waterfall with Non-Lease, to distinguish it from the standard report.
Navigate to the Advanced Configuration tab and update the Waterfall Type field to the desired non-lease payment type. Two approaches are available:
- Individual non-lease payment type: Select a specific non-lease payment type to report on that category in isolation. A separate copy of the report may be created for each non-lease payment type as needed.
- Total Payment: Select the Total Payment option to combine the standard lease payment and all associated non-lease payments into a single summed value reflected in the report.
Click Save. The customized report will now appear in the NetLease report list under the name provided and can be run in the same manner as the standard report.
Troubleshooting
Are leases missing from the report?
Check the selected filters to ensure they are not restricting the visibility of the desired leases.
Verify that the lease status has been updated from "Pending" to "Commenced" or a later status.