NetLease - Lease Interest Waterfall Report (Financing)
Purpose
The Lease Interest Waterfall Report presents the projected interest expense amounts for finance leases, categorized by lease type, for the selected period.
Navigation
NetLease > Reports > All (or Subledger) Reports > Lease Interest 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.
Recommended Approach
Select a 1-year date range to view the projected lease interest expense for the year.
Show FX Calculations Filter
Enabling this checkbox allows 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.
Results
When the schedule is run, users will see a summary of finance leases and their associated future interest 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.