NetLoan — Update Loan Ownership via CSV Upload
Overview
This article explains how to update loan ownership changes in mass using CSV files. Because NetLoan tracks ownership history by versioning records rather than overwriting them, this process requires two separate CSV imports: the first closes the existing ownership record(s) by setting an end date, and the second adds the new ownership record(s). Both imports are submitted through NetSuite's built-in CSV import tool.
Prerequisites
- The loan must be a Servicer entity type loan. This process is not available for other entity types.
- The NetSuite role used must have permission to perform CSV uploads via Setup > Import/Export > Import CSV Records.
- The effective date of the ownership change must be determined before starting. The new owner's Start Date is the effective date; the prior owner's End Date is the day before it.
Import 1 — End-Date Existing Ownership Records
This import updates existing ownership records by setting an end date, effectively closing them out before the new ownership takes effect.
Step-by-Step
Top navigation: Setup > Import/Export > Import CSV Records
1. Run a saved search on the NetLoan Investor Ownership record filtered to the relevant loan(s) with Ownership End Date empty to find the Internal IDs of the current active ownership records.
2. Build a CSV with two columns: Internal ID (the existing record's Internal ID) and Ownership End Date (the day before the new effective date).
3. Navigate to Setup > Import/Export > Import CSV Records.
4. Set Import Type to Custom Records, then select NetLoan Investor Ownership from the Record Type dropdown.
5. Upload your CSV file by clicking Select.
6. Click Next.
7. On the Import Options step, under Data Handling, select Update. Under Advanced Options, check the Run Server SuiteScript and Trigger Workflows checkbox.
8. Click Next.
9. On the Field Mapping step, map Internal ID to Internal ID and Ownership End Date to Ownership End Date. The fields from the CSV upload template should automatically map to the corresponding NetLoan Investor Ownership fields. If they don't, refer to the field mapping screenshot for guidance.
10. Click Next.
11. On the Save Mapping & Start Import page, hover over the dropdown arrow next to the Save & Run button and click Run to execute.
12. Optional — If you are planning to perform multiple CSV uploads, you can save the Import Map by populating the Import Map Name field and then click Save & Run. This will save the Field Mapping for future use and run the CSV upload.
13. Click on the Import Job Status link to view the Results.
14. When the import is complete, confirm that there are no errors by downloading the CSV Response file and verify that the Ownership End Dates were applied correctly on the relevant ownership records before proceeding to Import 2.
Import 2 — Add New Ownership Records
This import creates the new ownership records. Run this only after Import 1 has completed successfully.
Step-by-Step
Top navigation: Setup > Import/Export > Import CSV Records
1. Download and complete the NetLoan Servicing - Ownership Update CSV Upload Template with the new ownership details.
2. Navigate to Setup > Import/Export > Import CSV Records.
3. Set Import Type to Custom Records, then select NetLoan Investor Ownership from the Record Type dropdown.
4. Upload your CSV file by clicking Select.
5. Click Next.
6. On the Import Options step, under Data Handling, select Add. Under Advanced Options, check the Run Server SuiteScript and Trigger Workflows checkbox.
7. Click Next.
8. On the Field Mapping step, the fields from the CSV upload template should automatically map to the corresponding NetLoan Investor Ownership fields. If they don't, refer to the field mapping screenshot for guidance.
9. Click Next.
10. On the Save Mapping & Start Import page, hover over the dropdown arrow next to the Save & Run button and click Run to execute.
11. Optional — If you are planning to perform multiple CSV uploads, you can save the Import Map by populating the Import Map Name field and then click Save & Run. This will save the Field Mapping for future use and run the CSV upload.
12. Click on the Import Job Status link to view the Results.
13. When the import is complete, confirm that there are no errors by downloading the CSV Response file and verify that the new ownership records were created successfully on the relevant loan records.
Considerations
- Order matters: always run Import 1 before Import 2. Running them out of order may result in a loan temporarily showing two overlapping active owners.
- Interest % is not auto-calculated on CSV import. You must supply the value manually (Ownership Rate ÷ Loan APR × 100), or it will be left blank on the record.
- Owner field depends on ownership type: fill Owner (Vendor) for Third Party owners; fill Owner (Subsidiary) for Servicer or Subsidiary owners. Leave the unused owner fields blank.
- Leave End Date blank on new ownership records (Import 2) so they are treated as the current active owner.
- Run Server SuiteScript and Trigger Workflows must be checked on both imports. The server script sets the ownership record's Name on save.
- This process is only available for Servicer entity type loans. Attempting to import ownership changes for other loan types may result in errors or records not being updated as expected.
Record Structure
Import 1 CSV Fields
| Field Name | Field Type | Description | Example |
|---|---|---|---|
| Internal ID | Integer | The Internal ID of the existing active ownership record to be end-dated. Required. | 1 |
| Ownership End Date | Date | The last day of the existing owner's ownership — the day before the new effective date. Required. | 06/30/2026 |
Import 2 CSV Fields
| Field Name | Field Type | Description | Example |
|---|---|---|---|
| Loan | List/Record | The loan record this ownership belongs to. Required. | LN0001 Servicer Loan |
| Ownership Type | List | The type of ownership. Required. Third Party, Servicer, Subsidiary. | Subsidiary |
| Owner (Vendor) | List/Record | The vendor associated with the ownership. Fill when Ownership Type = Third Party. | ABC Lending Co. |
| Owner (Customer) | List/Record | Optional mirror of the vendor (same entity). The app auto-fills this in the UI; on CSV, populate manually if needed. | ABC Lending Co. |
| Owner (Subsidiary) | List/Record | The subsidiary associated with the ownership. Fill when Ownership Type = Servicer or Subsidiary. | Subsidiary A |
| Principal Ownership Percentage | Percent | Share of loan principal owned (0–100). | 50 |
| Owner Interest Rate | Percent | The owner's interest rate. | 5.5 |
| Interest Ownership Percentage | Percent | Ownership Rate ÷ Loan APR × 100. Not auto-calculated on CSV import — must be supplied manually. | 55 |
| Ownership Start Date | Date | The date the new ownership begins (the effective date). | 07/01/2026 |
| Ownership End Date | Date | Leave blank for the current active owner. | |
| Name | Text | Leave blank. The server script sets this automatically when Run Server SuiteScript is checked. |
