NetLease - Adaptive schedule sublist

Overview

Adaptive schedule columns replace the old setup, which had a separate schedule sublist for each lease classification and use case. When the feature is on, the first sublist on the lease’s Amortization Schedule subtab becomes a single list labelled Schedule Lines. It shows only the columns that apply to that lease. Which columns stay depends on the lease’s classification, currency and accounting books, and on the NetLease features enabled in your account.

The columns, labels and sort order come from a saved search you can customize without losing your changes on upgrade. The Export button on the lease uses the same search and rules, so the CSV matches what is on screen.

Prerequisites

NetLease 2026.2.4.0 or later.
Enable Adaptive Schedule Columns is checked at NetLease > NetLease Setup > System Setup. New installs start with this setting on; existing accounts must check it.
The lease has at least one schedule line.

Step-by-step process

Enable adaptive schedule columns

Navigate to NetLease > NetLease Setup > System Setup. On the General tab, scroll down to Schedule Settings, check the Enable Adaptive Schedule Columns checkbox. The Adaptive Schedule Columns Search field automatically fills in with the default search, "NetLease Adaptive Schedule Columns".
Optional: set Amortization Schedule Lines Per Page (1 to 1000, default is set at 250).

Optional: Select the Customize Columns button to open your own copy of the search, "NetLease Adaptive Schedule Columns - Custom", in a new tab.
- Add, remove, relabel or reorder columns on the Results tab and save the search.
- Once saved, the custom search will appear as an option to select in System Setup on the dropdown list in the Adaptive Schedule Columns Search field.
- If a custom search has been already been saved in the Adaptive Schedule Columns Search field, that search opens instead.

Edit your copy, not the bundled search.

The bundled "NetLease Adaptive Schedule Columns" search is replaced on every NetLease upgrade, so changes made directly to it are lost. Always customize through Customize Columns, which opens your copy.

Customizing removes columns or adds your own fields

Use the custom search to remove columns from every schedule, or to add your own custom fields, which show on every schedule. Adding a standard NetLease column does not make it show on leases that do not qualify for it. For example, the historical FX rate column still does not show on a lease in the base currency. See Column requirements table below for what each standard column needs.

Click Save.

Column requirements

A column can only appear if it is a column in the selected search. NetLease never adds columns; it removes the search columns the lease does not qualify for. Adding a standard column to your search does not change these requirements. The table below lists what each column needs in order to show.

Columns	Shown when
Payment, dates, period and other general columns	Always, if they are in the search. Cash Basis leases hide every classification column below; feature columns such as FX, billing, percentage rent and non-lease payments still follow their own rows.
Operating columns: lease expense, liability accretion and reduction, operating liability balance, ROU asset adjustments and balances (gross, accumulated, net)	Classification is Operating
Financing columns: interest, principal, amortization, financing liability balance, asset adjustments and balances (gross, accumulated, net)	Classification is Financing, GASB Long Term, GASB SBITA or GASB Sublease
Straight-line columns: straight-line lease expense, allocated to deferred rent, deferred rent balance	Classification is Short-Term / Low-Value or Sublease Operating, or the lease's classification is 840 or it is flagged as an ASC 840 lease
GASB columns: interest paid, interest payable	Classification is GASB Long Term, GASB SBITA or GASB Sublease
Posted balance columns: liability balance, asset balance, gross, accumulated and net balance	Classification is Operating, Financing or any GASB classification
Short-term / long-term reclass amount and reclass journal	Classification is Operating, Financing or any GASB classification. The journal column also needs the lease to have G/L impact.
Book-specific columns: book-specific JE, book-specific ST reclass journal, book-specific custom reclass journal, book-specific FX adjustment JE	Multi-Book is checked on NetLease Setup > System Features, the lease has a Secondary Book or Second Classification, and the lease has G/L impact. The book-specific FX adjustment JE also needs the lease currency to differ from the base currency, and the book-specific custom reclass journal also needs an active reclass type tagged to it.
FX columns: FX adjustment JE, historical FX rate, FX audit	The lease currency is different from the base currency. The JE columns also need G/L impact; the book-specific FX JE also needs Multi-Book.
Elimination journal	The lease has an Elimination Subsidiary and G/L impact. The global elimination setting has no effect.
Bill (vendor bill or invoice)	Automated Billing is checked on NetLease Setup > System Features
Custom reclass journal	The lease type has an account in any of its four custom reclass account fields, and an active reclass type tags its journal to this column for the lease's classification (a reclass type with no classifications applies to all). The lease also needs G/L impact.
Percentage rent columns: payment, expense, expense audit, due, accrued, sales, breakpoint, percentage, payable contract	Percentage Rent is checked on NetLease Setup > System Features
Journal entry, reversal journal, processed with no journal entry	No G/L Impact is not checked on the lease, and the account is not on a NetLease Go tier
Non-Lease Payment 1, 2 and 3	Non-Lease Payments is on and Non-Lease Payment Name is filled in for that payment. The column uses the configured name as its label.
Joined columns and your own custom columns	Always. NetLease never hides or relabels them.

On a multi-book lease whose Second Classification differs from the primary classification, the columns for both classifications are shown. If a lease's classification is not recognized, no columns are hidden for classification.

Some column labels follow the lease's classification. For example, GASB Long Term shows "Lease Liability" and "Lease Asset Amortization", GASB SBITA shows "Subscription Liability" and "Subscription Asset Amortization", GASB Sublease shows "Interest Income" and "Lease Receivable Balance", and Sublease Operating shows "Lease Income" and "Accrued Rent Balance". A configured non-lease payment name overrides both these labels and the search's own labels.

Troubleshooting

Why isn't the Schedule Lines sublist showing?

Enable Adaptive Schedule Columns is off. With it off, the lease shows its standard schedule sublists, even if a search is selected. See setup above.
The lease has no schedule lines yet. Generate the schedule first.
If the sublist hits a display error, the lease falls back to the standard sublists rather than failing to open.

Why isn't a column showing?

Check the column's requirements in the Column requirements table above. A standard column shows only on leases that meet them.
If the lease meets them, check that the column is in the selected search. If it is not, click Customize Columns on the NetLease Setup page and add it to the search's Results tab.
Check that Adaptive Schedule Columns Search on NetLease Setup points to the search you edited. Editing a different copy has no effect on the lease.

Why isn't the Bill column filled in?

The column shows whenever Automated Billing is on, and stays blank on lines that have not been billed yet.

Why did my column changes disappear after an upgrade?

The bundled "NetLease Adaptive Schedule Columns" search was edited directly and the upgrade replaced it. Click Customize Columns to create your own copy and make the changes there.

Why doesn't a column label match my search?

Classification-specific labels and configured non-lease payment names take precedence over the search's labels. See the Column requirements above.

Why don't all schedule lines appear?

The sublist shows up to 10,000 lines per lease. Use Export for the full schedule; it has no line limit.

Export follows the same columns

The lease Export button uses the same search, columns and labels as the sublist. Hidden columns are left out of the CSV too.