NetLease - Lease termination proposals (CSV)
Overview
Lease terminations end a lease prematurely, resulting in the removal of the Lease Liability and ROU Asset from the books. When multiple terminations need to be processed at once, NetLease supports two ways of inputting that information.
- Terminations that have the same inputs can be processed via the Mass Termination Suitelet.
- Terminations where the inputs are unique per lease can be uploaded and processed via a CSV of termination proposal records. This article walks through this use case.
Approval flow
Termination proposals are also occasionally used as part of client workflows when an official approval process needs to be used. Terminations entered directly from the lease record are auto-approved and processed. Terminations entered via the termination proposal process can have a "pending approval" status that is then moved to "approved".
Individual termination proposal process
Use this flow if you want to enter a termination proposal one off, typically because of the approval flow described above.
- Navigate to NetLease > Lease Management > Termination List > New.
- On the Lease Termination page, change Status to Pending Approval if needed.
- Select the Lease that will be terminated.
- Once a lease is selected, the current lease attributes will pre-populate into the Prior to Termination section.
- Update the fields as necessary for the Lease Termination
Field | Description | Example |
Termination Date | Defaults to the first period without amortization recorded. To update to a later period, monthly journals will have to be run up to that point - please consider carefully before skipping ahead. If the default termination date on the screen is later than the desired termination date, deleting amortization entries for month of termination will be necessary. Mid-Month Terminations are supported when the global setting is on. See the NetLease - Mid-Month Terminations article. | 04/01/2026 |
GL Account for Gain/Loss | GL override option for the Gain/Loss posted on the termination transaction. If left blank, the Gain/Loss account will default to the mapping from the Lease Type of the lease being terminated. | 8200 Gain/Loss |
Cash Paid | Input the amount to be paid in the lease termination month. Note that this amount should include both (1) standard lease payments, as well as (2) termination penalties or other consideration to be paid upon termination. | 3,500 |
Cash Received | Input the amount to be received from the termination. | 0 |
Reason | Provide a brief description of the reason for the termination. | Early termination |
Note | Provide any additional description or details for the termination. | Excess supply and under-utilized; to return to lessor |
- After double-checking updates and inputs for the Lease Termination, click Save.
- Navigate to NetLease > Lease Management > Termination List to see all terminations and their current status.
No mass approval page for proposals
There is no mass approval page for Lease Termination Proposals. They need to be reviewed and changed to "Approved" by editing the Lease Termination record directly. Leases will not show in the Mass Processing Screen until they are in an Approved status.
Mass termination proposal process (CSV import)
When multiple leases need to be terminated at once and they all have different inputs, the easiest method is to do a CSV import of the termination proposal record.
- Download and populate the NetLease Termination Proposal CSV Template
- Set it up with one row per lease termination proposal and one column per field entry.
Field | Description | Example |
Lease | Reference ID to the Lease record that will be terminated. Best practice is to use the internal ID. If using the name of the lease, make sure to format it as the external ID followed by the full name (Example: LA0001 Hello NetLease). | 1 |
Status | Approved or Pending Approval. Don't import any other status; those are set by NetLease during processing and reversal. If left blank, it will default to Approved. | Approved |
Termination Date | Defaults to the first period without amortization recorded. To update to a later period, monthly journals will have to be run up to that point - please consider carefully before skipping ahead. If the default termination date on the screen is later than the desired termination date, deleting amortization entries for month of termination will be necessary. Mid-Month Terminations are supported when the global setting is on. See the NetLease - Mid-Month Terminations article. If left blank, it will default to the first open period for the lease. The field stays blank on the imported proposal, even after processing. The termination date used is shown on the lease record. | 04/01/2026 |
GL Account for Gain/Loss | GL override option for the Gain/Loss posted on the termination transaction. If left blank, the Gain/Loss account will individually default to the mapping from the Lease Type of the lease being terminated. The field stays blank on the imported proposal and is set when the termination is processed. | 8200 Gain/Loss |
Cash Paid | Input the amount to be paid in the lease termination month. Note that this amount should include both (1) standard lease payments, as well as (2) termination penalties or other consideration to be paid upon termination. This field is required. If no cash is paid, enter 0. | 3500 |
Cash Received | Input the amount to be received from the termination. This field is required. If no cash is received, enter 0. | 0 |
Reason | Provide a brief description of the reason for the termination. | Early termination |
Note | Provide any additional description or details for the termination. | Excess supply and under-utilized; to return to lessor |
There are two options for uploading the CSV file.
- Use the standard NetSuite CSV import process (we will show this route)
- Use the NetLease Data Import Wizard. See the article for that process if unfamiliar. This is an internal import option for files that validates data before official upload.
- Save the file as a CSV (not excel) and make sure the dates are in the correct format for your NetSuite environment, amounts have no commas, and there are no additional rows (delete the example row from the template). See the CSV cleaning import tips if needed.
- Navigate to Setup > Import/Export > Import CSV Records
- Import Type = Custom records
- Record Type = NetLease Termination
- Click Select and then choose your upload CSV file from your desktop. Click Next.
- The Import Option will default to Add. Leave that selection and click Next.
- The next page is the field mapping. If you are using the template, the field names should map exactly. If using your own internal upload CSV, use the drag and drop functionality to match the CSV column names to the fields on the NetLease termination record.
Internal IDs
If you are using the Internal ID for the Lease field or any other field, you need to change the reference value for it. Click the pencil icon next to the field name, then select Internal ID in the drop down for Choose Reference Type.
- Once mapping is complete, click Next.
- You can either create a template (if using unique mapping this can be helpful since the mapping will be remembered with the import template) or you can click the arrow next to the Save & Run button and click Run.
- Click Okay when the warning pops up that your mapping won't be saved.
- Check the status of the import by clicking the Import Job Status link that appears in the banner message.
- Once imported, the proposals will be visible on the individual leases and via NetLease > Lease Management > Termination List.
- To process the terminations, follow the steps below for Process termination proposals in mass.
Process termination proposals in mass
Regardless of how termination proposals are entered into NetLease, they have to be processed before they are effective.
- Navigate to NetLease > Mass Update Leases > Mass Terminate Leases and select Proposals Only to see all approved termination proposals.
- Filter to the terminations you want to process or click Mark All to select all termination proposals. Click Terminate.
- Once the termination has been initiated, the lease page will be refreshed to the processing status page. Refresh the page periodically until the Processing Status is Complete. Links to the terminated leases will be listed and any errors will be in the Script Execution Log column.
