NetLease - Weighted average term report
Overview
The Weighted Average Term report calculates the weighted-average remaining lease term of a lessee's leases as of the end of a reporting period. The weighted-average remaining lease term is a required lease footnote disclosure under ASC 842-20-50-4(g)(3), presented separately for finance and operating leases.
The report reads each lease's lease liability balance and remaining term from the NetLease subledger for the selected period, then weights each lease's remaining term by its share of the lease liability within its lease classification:
| Weighted average | How it is calculated |
|---|---|
| Weighted Average Term By Liability Balance (Months) | Each lease's remaining months x (lease liability balance / total lease liability balance of the lease classification). The weighted amounts for the leases in a classification add up to that classification's weighted-average remaining term in months. |
| Weighted Average Term By Liability Balance (Years) | The same calculation divided by 12. |
Weighting is done within each lease classification (for example Operating and Financing separately), so the report produces a separate weighted-average term for each classification, as the disclosure requires. Liability balances are translated to the reporting currency before they are weighted, so leases in different currencies can be weighted together.
Remaining months and trailing periods with no payments
Since the April 2025 release (2025.1.1.0), the remaining term excludes trailing periods at the end of a lease that have no payment and no remaining lease liability. For example, if the last three months of a lease schedule have no payments and the liability is already paid down to zero, those three months are not counted in the lease's remaining months. This applies to leases other than Short Term / Low Value, Sublease - Operating, Cash Basis and 840 classifications. Remaining months never go below zero.
Report details
| Report type | Scripted report (runs in the NetLease report engine, not a saved search) |
| Category | Disclosure reports |
| Data source | NetLease subledger (lease schedule lines) |
| Standard | ASC 842-20-50-4(g)(3) - weighted-average remaining lease term |
| Can be scheduled | Yes - see NetLease - Scheduled Scripted Reports |
When to use this report
- Quarter-end and year-end reporting - to populate the weighted-average remaining lease term for finance and operating leases in the lease footnote.
- Audit requests - when auditors ask how the weighted-average remaining term was calculated, with the lease-level remaining months and balances behind it.
- Multi-currency or consolidated reporting - to weight leases held in different currencies or subsidiaries on a consistent, translated basis.
- Reviewing renewals, terminations and new leases - to explain movements in the weighted-average term between periods.
Prerequisites
- A role with access to NetLease reports (the NetLease Report record).
- Leases are classified and their schedules are generated through the reporting period.
- For multi-currency accounts, exchange rates are set up in NetSuite for the period being reported.
Running the report
- Navigate to NetLease > Reports > Disclosure Reports > Weighted Average Term Report > Run.
- Set the filters (see below). Select the last full month of the reporting period.
- Click Preview to view the results, or Export to download them to Excel.
| Filter | Description |
|---|---|
| Subsidiary | Limits results to leases for the selected subsidiary. |
| Consolidation Subsidiary | Subsidiary to consolidate the results as. This drives FX conversion to that subsidiary's base currency. Multi-currency accounts only. |
| Currency | Currency to display the report in. Multi-currency accounts only. |
| Consolidated Exchange Rate | Rate type used to translate balances: Average, Current, Historical, Custom or None. Accounts that are not OneWorld see this as Currency Exchange Rate, with Current (To Date), Historical (From Date), Custom or None. |
| Consolidation Date | Date to pull the exchange rate from when Custom is selected. |
| Export Level | Level of detail in the export: one option per report level (Level 1, Level 2 and so on), or Full Hierarchy (all levels). |
| Export Format | Specifies what format the report should be exported in (Excel or CSV). |
| Department / Class / Location | Limits results to leases with the selected segment values. Multi-select. |
| Lease | Limits results to a single lease. |
| Accounting Period | Period to report on. If a quarter or year period is selected, the report uses the balances of the final month of that quarter or year. |
| From Date / To Date | Alternative to the accounting period. Enter the first and last day of the last full month being reported. |
| Hide Currency Symbol | Removes currency symbols from the output. |
| Show FX Calculations | Shows balances in lease, subsidiary and consolidated currency, with the exchange rates used. Multi-currency accounts only. |
Filter by the last full month of the reporting period. For example, for a December 31 year-end disclosure, filter from 12/01 to 12/31 of the reporting year.
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
The report shows the consolidated liability balance and the weighted-average remaining term by liability balance, in months and in years, separated by lease classification and organized by lease type. Lease types can be expanded to drill down into individual leases and their underlying details. Click Export to save the report as an Excel file.
| Column | Description |
|---|---|
| Subsidiary | Lease subsidiary. OneWorld accounts only. |
| Lease Type | Lease type of the lease. |
| Active Leases | Count of leases included. |
| Date | Period end date of the schedule line used. |
| Remaining Months | Remaining periods on the lease schedule, less any trailing periods with no payment and no liability balance. |
| Liability Balance | Lease liability balance at the end of the period, translated to the reporting currency. |
| Currency | Lease currency. |
| Weighted Average Term By Liability Balance (Months) | Remaining months weighted by the lease's share of the classification's total liability balance. The classification total is the weighted-average remaining term in months. |
| Weighted Average Term By Liability Balance (Years) | The months figure divided by 12. |
When Show FX Calculations is checked, the Liability Balance column is replaced by Lease Currency, Subsidiary Currency and Consolidated versions, and FX Rate and Consolidation Rate columns are added. Weighting then uses the Consolidated balance.
Audits, disclosures and footnotes
The report is designed to produce the weighted-average remaining lease term required by ASC 842-20-50-4(g)(3).
ASC 842-20-50-4 For each period presented in the financial statements, a lessee shall disclose the following amounts relating to a lessee’s total lease cost, which includes both amounts recognized in profit or loss during the period and any amounts capitalized as part of the cost of another asset in accordance with other Topics, and the cash flows arising from lease transactions:
a. Finance lease cost, segregated between the amortization of the right-of-use assets and interest on the lease liabilities.
b. Operating lease cost determined in accordance with paragraphs 842-20-25-6(a) and 842-20-25-7.
c. Short-term lease cost, excluding expenses relating to leases with a lease term of one month or less, determined in accordance with paragraph 842-20-25-2.
d. Variable lease cost determined in accordance with paragraphs 842-20-25-5(b) and 842-20-25-6(b).
e. Sublease income, disclosed on a gross basis, separate from the finance or operating lease expense.
f. Net gain or loss recognized from sale and leaseback transactions in accordance with paragraph 842-40-25-4.
g. Amounts segregated between those for finance and operating leases for the following items:
- Cash paid for amounts included in the measurement of lease liabilities, segregated between operating and financing cash flows
- Supplemental noncash information on lease liabilities arising from obtaining right-of-use assets
- Weighted-average remaining lease term
- Weighted-average discount rate
The following is an example of a Weighted Average Term Summary in financial statements. The report within NetLease is designed to fulfill the disclosure requirement:
| Disclosure requirement | Where to find it |
|---|---|
| (g)(1)-(2) Cash paid and noncash ROU additions | NetLease - Supplemental Cash Flow Information |
| (g)(3) Weighted-average remaining lease term | This report - Weighted Average Term By Liability Balance (Years or Months), per lease classification |
| (g)(4) Weighted-average discount rate | NetLease - Weighted Average Rate Report |
Tips for audit support
- Export at Full Hierarchy to give auditors the classification totals and the lease-level remaining months and balances behind them in one file.
- Run the report for each period presented with the same filters, so the footnote figures are consistent.
- If a prior-period figure was produced before the April 2025 release, rerunning that period can give a lower remaining term for leases with trailing no-payment periods. Note the change if prior-period figures are re-presented.
Frequently asked questions
Why did the weighted-average term change after the April 2025 release?
From release 2025.1.1.0, trailing periods at the end of a lease with no payment and no remaining liability are excluded from remaining months. Leases whose schedules end with periods that have no payments now show a shorter remaining term than before.
Why is the term shown separately for each lease classification?
ASC 842-20-50-4(g) requires the weighted-average remaining lease term to be presented separately for finance and operating leases. The report weights each lease against the total liability of its own classification, so each classification has its own weighted-average term. Use the classification totals rather than adding them together.
Should I disclose the term in months or years?
The report shows both. The years figure is the months figure divided by 12. Use the unit your financial statements present.
What if I select a quarter or a full year?
The report uses the balances of the final month of the selected quarter or year, which is the point-in-time position needed for the disclosure.
How are leases in different currencies handled?
Each lease's liability balance is translated to the reporting currency using the Consolidated Exchange Rate selection before weighting. If None is selected, balances stay in each lease's own currency, so weighting across leases in different currencies would not be on a common basis.
Is this report a saved search? Can I edit its columns?
No. It is a scripted report, so its rows and columns are fixed by NetLease. You can narrow results with the filters, or add custom filters. To build a different layout, see NetLease - Custom Scripted Report.
What happened to the Weighted Average Term Summary saved search?
The Weighted Average Term Summary and Weighted Average Term Detail Input saved searches were moved to the Deprecated report category in the April 2025 release. This report replaces both. See NetLease - Weighted Average Term Summary.
Troubleshooting
If the desired lease is not appearing, verify that the lease status is not set to "Pending" and that the lease has not been marked as inactive.
Weighted averages look wrong - confirm the filter covers only the last full month of the reporting period. A multi-month From Date / To Date range is not the same as selecting the final month.
Remaining months are lower than the schedule shows - check the end of the lease schedule for periods with no payment and a zero liability balance. These trailing periods are excluded from remaining months.
If the exchange rate does not appear as expected, review the selection in the "Consolidated Exchange Rate" filter. The exchange rates used in the report can be configured by adjusting the filter to one of the following options:
- Average - Based on the average currency exchange rate effective over the filtered period.
- Current - Based on the currency exchange rate effective at the end of the reported period.
- Historical (From Date) - Based on the currency exchange rate effective at the start of the reported period.
- Custom - The exchange rate is pulled as of the date entered in the "Consolidated Exchange Rate Date" field.
- None - No consolidation occurs; values are pulled directly from the subledger in the contract currency of the lease, regardless of the selected currency.
