NetClose - Upload Amortizations
Overview
Netgain provides standard upload templates that allow amortization details to be uploaded in batch. This functionality is most commonly used during implementation to migrate amortizations that were previously tracked outside of NetClose. It can also be used to mass update existing amortizations as needed.
Step-by-Step Process
- Fill out the applicable information in the NetClose Historical Amortization Upload Template
Amortization Cutover
When migrating amortizations that had been amortized elsewhere previously, keep in mind the following:
Capitalization date is the date the amortization was originally capitalized.
Start date is the date the amortization will start to amortize in NetClose.
Term is the remaining term as of the Start date.
Amount is the remaining amount to amortize as of the Start date.
Once your historical amortizations have been uploaded, simply stop making journal entries in your previous system and start making journal entries within NetClose.
2. Create the applicable Amortization Types
- If not created already, you can upload Amortization Types via the instructions below with Record Type NetClose Amortization Type.
3. Prepare the "Amortizations" tab as a CSV file for upload
- Delete any informational or example rows
- When finished updating the Excel File, save it in a known location as a .csv file
4. Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
5. With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Amortization
6. Under the CSV files section, click on the Select button and upload the .csv file you saved
7. Select Next to progress to the Step 2 Import Options
8. Within the Import Options section, make sure Add is selected (or Update if doing a bulk update to Amortization Types) and "Run Server SuiteScript and Trigger Workflows" is checked
9. Select Next to progress
10. After progressing through File Mapping, you will be prompted for Field Mapping
11. Note that NetSuite tries to directly map all the fields it can recognize. When fields are not recognized, they must be manually matched between the .csv upload file and NetSuite fields
- The recommendation is to match based on Internal ID for applicable fields
12. If the fields are mapped correctly and the field contents match the field values in NetSuite, select Save & Run or Run as desired
13. To view the status of the upload, select "Import Job Status" in the Confirmation banner or navigate to Setup > Import/Export > View CSV Import Status
14. When complete, the status will change to complete and show the records imported successfully
15. In the event of a failed upload, review the logs for the specific reasons, make necessary updates to the CSV file, and repeat the above steps