NetLease - Undiscounted Lease Maturity Waterfall

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.

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:


Was this article helpful?