NetLease - Lease Interest Waterfall Report (Financing)
Purpose
The lease interest waterfall report provides the future interest expense amounts for finance leases by lease type in the selected period.
Navigation:
NetLease > Reports (All or Subledger) > Lease Interest Waterfall Report (Financing) > Run
Filtering:
The report search can be narrowed down by adjusting the filters for subsidiary, currency, department, class, location, lease, accounting period, or date. Once desired filters are set, click Preview button to view the reconciliation.
Select a date range of 1 year to see projected lease interest expense for the year
Results
Upon running the schedule the user will see a summarized detail of finance leases and associated future single interest expense amounts by lease type for the selected period. The schedule can drill-down to individual leases and the underlying future expense detail. Users use this as a forward-looking report. Select the Export button to download report into Excel.
Troubleshooting
Is the report missing leases?
1. If desired leases do not appear in the report, check the selected filters to ensure leases are not being restricted from view.
2. Verify leases status has been updated from pending to commenced or further.