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 the Preview button 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.
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.