NetLoan - Custom Schedule Creation

NetLoan Custom Schedule Creation

Use case: In the rare case that you are not able to tie out the information received from a bank to the schedules created in NetLoan you have the option of creating a schedule and manually editing it to reflect the correct values you would like the system to use when booking entries.

Step By Step Process

  1. First, you will want to ensure you have the correct schedule information on hand so you can input that information into the schedule.

  2. You will begin by creating a new loan record with the necessary payment and rate records for any changes or one-time payments by navigating to NetLoan > Loan Management > New Loan. Click save when all the needed loan, payment, and rate information has been provided. This article, Create a New Loan Record, might prove helpful if you need more guidance on how to do this.



  3.  Now that the loan has been created we will need to trigger the schedule generation by clicking the Generate Schedule button.

  4.  If doing this on the loan record you will need to click the Refresh button until it disappears and the system has finished processing the schedule.

  5.  Now, click the Export button at the top of the Loan record to export the schedule into Excel.

  6. Open the exported schedule and edit the information in the schedule lines from columns F to M for the correct information.

  7. Once you have made the necessary edits make sure to save the file as a Comma Delimited (.csv) file type.

  8. In NetSuite, navigate to Setup > Import/Export > Import CSV Records.

  9. Select Custom Records as the import type, Netloan Schedule Line as the record type, attach the CSV comma delimited file and click Next.

  10.  Select Update under the import options, make sure the checkbox for Run Suitescripts is checked, and click Next.

  11.  The field mapping should pull through automatically but if this is not the case match the fields in the spreadsheet to the correct fields in NetLoan. Then click Next.

  12.  If you would like to save the import for future use fill in the Import Map Name field and click Save & Run. Otherwise, just click Run.

  13. You can check on the status of the upload by navigating to Setup > Import/Export > View CSV Import Status.
  14. Once the upload has been processed you will see the changes reflected on the loan schedule. You can now follow the regular operations of the loan by commencing and running journal entries.

    Note that you will not want to use the regenerate schedule or modification features moving forward since this would delete the edit you made to the schedule line. Instead, use the same process as outlined here for future schedule changes.



Was this article helpful?