NetLease - Weighted average term summary (deprecated)
This report is deprecated
The Weighted Average Term Summary saved search was moved to the Deprecated report category in the April 2025 release (2025.1.1.0). It has been replaced by the Weighted Average Term Report, a scripted report that combines the Weighted Average Term Summary and Weighted Average Term Detail Input saved searches. If you still use this saved search, switch to the Weighted Average Term Report.
Overview
The Weighted Average Term Summary was a saved search that calculated the weighted-average remaining lease term for the ASC 842-20-50-4(g)(3) lease footnote disclosure. It only worked for leases in a single currency. Leases in multiple currencies required the separate Weighted Average Term Detail Input search, exported to Excel. Both saved searches are now deprecated.
To produce the weighted-average remaining lease term, run NetLease > Reports > Disclosure Reports > Weighted Average Term Report > Run and filter by the last full month of the reporting period.
What changed
The Weighted Average Term Report replaces both saved searches and adds the following:
- Multi-currency support - each lease's liability balance is translated to the reporting currency before weighting, so leases in different currencies are weighted together in one report.
- Consolidation filters - Consolidation Subsidiary, Currency, Consolidated Exchange Rate (Average, Current, Historical, Custom or None) and Consolidation Date control how balances are translated.
- Show FX Calculations - displays balances in lease, subsidiary and consolidated currency, with the exchange rates used.
- Weighting by lease classification - each lease's remaining term is weighted within its own classification, giving separate weighted-average terms for finance and operating leases.
- Trailing no-payment periods excluded - periods at the end of a lease with no payment and no remaining liability are not counted in the remaining term.
- Months and years - the weighted-average term is shown in both months and years.
- Lease-level detail in the same report - expand a lease type to see each lease's remaining months, balance and weighted amount, without a separate detail search.
- Scheduling and export levels - the report can be scheduled and exported at any level, including Full Hierarchy.
