NetLease - Lease Amortization Waterfall Report (Financing)
Purpose
The Lease Amortization Waterfall Report shows the projected amortization expense amounts for finance leases, broken down by lease type, for the selected period.
Navigation
NetLease > Reports > All (or Subledger) Reports > Lease Amortization Waterfall Report (Financing) > Run
Filtering
The report search can be refined by adjusting filters for subsidiary, department, currency, class, location, accounting period, or date. Once the desired filters are applied, click the Preview button to view the results.
Select a 1-year date range to view the projected lease expense 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 finance leases and their associated future amortization 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 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.