NetLease - Lease import converter tool

Overview

The Lease Import Converter is an AI-assisted tool that turns an existing Excel lease workbook into lease and lease payment CSV files that are ready for the NetLease Data Import Wizard or normal CSV import. Users upload the workbook their team already keeps for ASC 842, IFRS 16, or GASB 87, with each lease's full payment schedule on its own tab. The tool identifies which tabs hold lease data, extracts the lease terms, and condenses each payment schedule into as few lease payment records as possible. It does not create one record per schedule line. Lease type, subsidiary, vendor, currency, and location values are matched to NetSuite lists. Users review and correct every lease before exporting the files or sending them straight to the Data Import Wizard.

The tool removes the manual work of rebuilding lease schedules into the one-row-per-record format that the Lease Bulk CSV Upload and Lease Payment Bulk CSV Upload require, which reduces hours of spreadsheet work to a few minutes of review.

The tool has four stages:

Stage	Purpose
1. Upload	Upload the workbook and confirm how each tab is classified
2. Extract	Extract the lease terms and payment schedules, and match values to NetSuite lists
3. Review	Review and edit each lease, resolve flagged issues, and remove leases from the export
4. Export	Download the lease and payment CSVs or continue in the Data Import Wizard

Only part of each tab is sent to AI

The workbook is parsed in the browser. Only each tab's lease terms, column headers, and a few sample rows are sent to AI. The full payment schedule is read and condensed by the tool itself, without any AI calls.

Key assumptions

Each tab classified as a lease schedule holds one lease and its payment schedule.
The Lease Import Converter only prepares data. Lease and lease payment records are created in NetSuite only after the output is imported through the Data Import Wizard.

Prerequisites

The user has access to the NetLease Setup page, where the tool is opened, and to the Data Import Wizard to complete the import.
AI is enabled in NetLease > NetLease Setup > System Setup > AI Settings. If it is not, the tool shows an AI features are disabled banner and cannot be used.
The lease types, subsidiaries, vendors, currencies, and locations that the workbook references already exist in NetSuite.
The workbook is in .xlsx or .xls format. Macro-enabled .xlsm files are not supported.

Step-by-step process

Open the tool

Navigate to NetLease > NetLease Setup > System Setup.
Click the Import Tools tab.
In the Wizard section, click Tool Link under Lease Records Import.

Stage 1 - Upload

On the Upload page, drop the workbook (.xlsx or .xls) into the Drop your Excel workbook here box, or click Browse files to select it. One tab per lease works best.

After uploading your Excel workbook, the tool parses the workbook and AI classifies each tab. When it finishes, an AI sorted your tabs banner will display at the top and show how many tabs look like lease schedules, how many are summaries, and how many have nothing to import.
Under the banner, review the Tabs in this workbook table to confirm that each tab is classified correctly. To change a classification, select a different option from the Use as dropdown within the Tabs in this workbook table.

Column	Description
Tab	The tab name from the uploaded workbook.
AI classification	How AI classified the tab. See the classification table below.
Why	The reason AI gave for the classification.
Size	The number of rows and columns in the tab.
Use as	Changes the classification. Select Lease schedule, Summary, or Skip.

Each classification determines how the tab is used:

Classification	What the tab contains	What happens to it
Lease schedule	One lease's terms and payment table	Becomes a lease record
Summary	A list of several leases	Fills in values that are missing from the lease schedule tabs
Skipped	Nothing to import	Ignored

Click Extract leases to continue. To upload a different workbook, click Replace file.

Stage 2 - Extract

On the Extract page, titled Reading your lease schedules, the tool extracts the lease terms from each lease schedule tab, fills in missing values from any summary tabs, and matches lease types, subsidiaries, vendors (lessors), currencies, and locations to the NetSuite lists.
A progress bar shows how many tabs are done, and each lease schedule tab is marked Extracting… and then shows as Done before moving to the Review stage. Larger workbooks can take a minute or two.

Stay on the page

No action is needed during extraction. The tool moves to the Review stage automatically when it finishes. Leaving or reloading the page discards the session, and the workbook must be uploaded again.

During the Extract stage, the tool also:

Condenses each payment schedule into payment runs and checks the payment total against any total stated in the workbook. A mismatch is flagged in the Review stage.
Calculates the end date or lease term when only two of the three (commencement date, end date, and lease term) are provided

Stage 3 - Review

At the top of the Review page, the summary cards show the number of Leases to Import, Payment Records, and leases that Need Attention. A banner below them shows how many leases are flagged, how many values are unmapped, and how many cross-check failures were found.
Under the banners, each lease appears as a card. Review the Lease terms section and edit any value as needed. Scroll down the page to see all lease cards.

Group	Fields	What to check
Lease name	Name	The name of the lease record. The tab it was extracted from appears next to it.
NetSuite matches	Lease type, Subsidiary, Vendor, Currency, Location	Matched to the NetSuite lists. A fields to match badge on the card shows how many still need a value. Select a value for each.
Classification	Classification	Select Operating or Finance.
Dates and term	Commencement date, End date, Term months	Calculated from the other dates appears when the end date or term was worked out from the other two values.
Discount rate	Discount rate %	The incremental borrowing rate.
Cost inputs	Prepaid lease payment, Initial direct costs, Lease incentives	These export as 0 when the workbook has no value.

Then review the Payment schedule table next to the right of the Lease Terms section. Each row is one payment run: a series of equal payments made at the same frequency. Each payment run becomes one lease payment record.
To add a payment run, click Add a payment run at the bottom of the table. To remove one, click its delete icon next to the Count column. A Rent holiday badge on the card means the schedule includes a period with no payments.
Review the flags at the bottom of each card. A flag is marked Fixed after the underlying value is corrected. Click Dismiss on any flag that does not apply.
To leave a lease out of the export, click the remove icon on its card.

Column	Description	Example
From	The date the first payment in the run is due.	01/01/2026
Amount	The amount of each payment in the run.	12000.00
Every	How often the payment is made: Monthly, Quarterly, Semi-Annually, Annually, or One-time.	Monthly
Count	The number of payments in the run.	12

After reviewing each lease card, click Continue to export.

Stage 4 - Export

The Export stage provides two files: Lease records (lease-records-YYYY-MM-DD.csv) and Lease payments (lease-payments-YYYY-MM-DD.csv). For each file, choose one of the following options:

Download: Click Download to save the CSV. If any leases still have unresolved flags, the lease file starts with a review_flags column. Sort or filter on this column in Excel to fix the data, then import the file through the Data Import Wizard.
Continue in Data Import Wizard: Click Continue in Data Import Wizard. The wizard opens in a new tab with the data already loaded. On the Lease records card, this sends both files, with each lease payment linked to its lease. Import the lease payments from the Data Import Wizard Status page after the leases are imported.

Import the leases before the payments

Each lease payment record references its lease by name. Import the Lease records file first, then the Lease payments file.

For the NetLease Data Import Wizard next steps, please reference the article here:

https://support.netgain.tech/article/985233/netlease-data-import-wizard

Limitations / callouts

Summary-only leases: A lease that appears on a summary tab but has no lease schedule tab cannot be imported. These leases are listed in the Leases in summary tab without schedule tabs banner on the Review page.
No occurrence count in the payments file: Each lease payment record runs until the next record's effective date, so the payments CSV does not include the number of payments.
Progress is not saved: Leaving the page before export discards the session, and the workbook must be uploaded again.

Troubleshooting

Issue	Resolution
"AI features are disabled"	Ask a NetSuite Administrator to enable AI in NetLease > NetLease Setup > System Setup > AI Settings.
"Macro-enabled Excel files (.xlsm) are not supported"	In Excel, click File > Save As > Excel Workbook to save the file as .xlsx, then upload the new file.
"Couldn't load account context"	Reload the page before reaching the Extract stage. Without it, values are not matched to NetSuite lists and must be selected manually in the Review stage.
Extraction stops with an error message	Reload the page and upload the workbook again. If the error continues, contact Netgain Support.
Fields still need a NetSuite match	The value in the workbook does not match a record in NetSuite. Select the correct value on the lease card, or create the missing record.
"Totals differ from the workbook"	The extracted payments do not add up to the total stated in the workbook. Correct the payment runs, or dismiss the flag if the difference is expected.
"Handover failed"	Download the CSV and import it manually through the Data Import Wizard.

Was this article helpful?