NetLoan - Historical method / full-history transition to NetLoan

Overview

There are two ways to upload loan data into NetLoan: (1) upload all historical information, or (2) upload as of a cutover date. This article covers the first option, the historical method. It explains how to fill in the Loan Upload Template so that each loan's full history is in NetLoan, from origination onward. For the cutover-date approach, see NetLoan - Cutover Method / Mid-Life Transition to NetLoan.

With the historical method, the NetLoan amortization schedule starts on the loan's actual origination date. All historical payments, rate changes and amortization amounts are kept on the NetLoan Loan record. That gives a complete schedule for reporting, validation and borrower statements.

This method suits organizations that have each loan's full history on hand. Lenders usually have it more readily than borrowers, so they use it most often. Borrowers often use the cutover method instead.

Key assumptions

  • Loan types and account mapping are set up before any loans are uploaded. See NetLoan - Implementation Materials.
  • The Go-Live Date is set in NetLoan global settings. No journal entries are recorded to the GL before this date, even though the schedule goes back to origination. See NetLoan - Global Settings.

Step-by-step process

1. Populate the 'Main' tab of the Loan Upload Template

  • In the 'Origination Date' column, enter the date the loan actually originated.
  • In the 'Initial Payment Date' column, enter one of the following:
    • The loan's first payment date, after the Origination Date.
    • The Origination Date, if the first payment and every later payment change will be entered on the 'Payments' tab.
  • In the 'Initial Loan Balance' column, enter the loan's principal balance at origination.
  • In the 'Annual Percentage Rate' column, enter the APR at origination.
  • Leave the 'Beginning Accumulated Accrued Interest' column blank or 0. NetLoan calculates accrued interest from the full payment and rate history.
  • Fill in the remaining required fields as described in NetLoan - Upload Template Headers.

2. Populate the 'Payments' tab

  • In the 'Effective Date' column, enter each payment change from origination onward, including changes before the go-live date. Each row sets the payment amount and frequency from its effective date until the next payment change.

3. Populate the 'Rates' tab

  • In the 'Effective Date' column, enter every rate change since origination, including rate changes before the go-live date.

4. Upload the templates

Save each tab as a .csv file and import it through Setup > Import/Export > Import CSV Records, in this order:

  1. Loan headers - NetLoan - Loan Header Data Upload
  2. Payments - NetLoan - Loan Payment Data Upload
  3. Rates - NetLoan - Loan Rate Data Upload

Payments and rates link to their loan by the loan's ID and name from the Loan Register. Upload the loan headers first.

5. Generate schedules and validate

After you upload payments and rates for loans in Pending status, generate (or regenerate) each loan schedule so the new records are included. Then validate the data, with particular attention to the balance remaining on each loan at the go-live date. See NetLoan - Data Validation.

6. Commence loans and run go-live journals

Commence the loans, then run the go-live transition journals from NetLoan > NetLoan Setup > Run Go-Live Journals. See NetLoan - Mass Create Go-Live Transition Journals. Then book a manual entry to reverse the existing loan balances into the go-live clearing account, so that no pre-NetLoan balances remain on the balance sheet.

Limitations / things to be aware of

  • Historical uploads need complete and accurate payment and rate history. Gaps or errors before the go-live date change the go-live balance NetLoan calculates.
  • If detailed history is not available for some loans, use the cutover method for those loans instead.

Related links


Was this article helpful?