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.
Historical periods do not post to the GL
Schedule entries dated before the Go-Live Date are for reference only. The go-live transition journal books each loan's balance as of the go-live date, so pre-NetLoan activity is not posted again.
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:
- Loan headers - NetLoan - Loan Header Data Upload
- Payments - NetLoan - Loan Payment Data Upload
- 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.
Record accrued interest before go-live
The go-live journal records the loan payable/receivable, accumulated accrued interest and the go-live clearing account. For loans with mid-month payments, NetLoan's schedule includes accrued interest from the last payment date to the go-live date. If that accrued interest is not already on the balance sheet, record it manually. Otherwise the reversing entry to the clearing account will not balance.
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
- NetLoan - Cutover Method / Mid-Life Transition to NetLoan
- NetLoan - Upload Template Headers
- NetLoan - Loan Header Data Upload
- NetLoan - Loan Payment Data Upload
- NetLoan - Loan Rate Data Upload
- NetLoan - Implementation Materials
- NetLoan - Data Validation
- NetLoan - Mass Create Go-Live Transition Journals
- NetLoan - Global Settings
