NetLease - Lease Expense Waterfall Report (Operating)
Purpose
The Lease Expense Waterfall Report displays the projected lease expense amounts for operating leases, categorized by lease type, for the selected period.
Navigation
NetLease > Reports > All (or Subledger) Reports > Lease Expense Waterfall Report (Operating) > 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 expenses 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 generated, users will see a summary of operating leases and their associated future lease expense amounts, categorized by lease type for the selected period. The schedule allows users to drill down into individual leases and view the detailed future expense breakdown. This report serves as a forward-looking view of lease expenses. 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.