NetLease - Undiscounted Lease Maturity Waterfall
This report reflects the leases in the system at the time it is generated. For accurate financial reporting, ensure this report is run for each reporting period before processing any modifications for the subsequent period. For example, run this report for 12/31/21 before processing any lease modifications for January or February 2022.
Purpose
The Undiscounted Lease Maturity Waterfall report provides a summary of future payments for operating and financing leases, including the required reconciliation to the current lease liability in a disclosure format.
Navigation
NetLease > Reports > Disclosure Reports > Undiscounted Lease Maturity Waterfall > Run
Filtering
The report search can be refined by adjusting filters for accounting book, subsidiary, currency, consolidated exchange rate, department, class, location, accounting period, or by modifying the "to" and "from" dates:
Consolidated exchange rates ensure proper currency translation from child to parent subsidiaries for consolidated reports. NetSuite maintains a record of consolidated exchange rates for each accounting period. Below are the types of consolidated exchange rates used for reporting purposes:
- Average – Based on the average consolidated exchange rate for the period.
- Current – Based on the currency exchange rate effective at the end of the reported period.
- Historical – Based on the currency exchange rate effective at the start of the reported period.
- Custom – The exchange rate is pulled based on the date entered in the Consolidated Exchange Rate Date field by the user.
- None – No consolidation occurs; values are taken directly from the subledger in the lease’s contract currency, regardless of the selected currency.
Once the filtering options are selected, click the Preview button to view the updated report.
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
Upon running the report, the user will see details of their Financing, Operating, and Short-Term / Low-Value leases, along with the associated future payment amounts. Each lease type can be expanded to view the related transactions. To download the report in Excel, select the Export button: