Import

General

The import system is based around comma separated values (CSV) files. There are a few rules about using CSVs in LoanPro to be wary of:

  • Double Quotes (“) are used to denote strings
  • Only Commas are used as delimiters
  • For a given import, all described columns must be present somewhere in the file, even if all values are blank for that column
  • Fields with embedded line breaks are not supported
  • Spaces are not allowed in the first row
  • Decimal separators must be dots (.) following the US convention
  • Dollar signs and other currency or unit markers are not permitted in numerical fields
  • ASCII files are preferred, however UTF-8 files are supported

For detailed examples of specific imports see Import ExampleLoan/Lease Import, or Customer Information Import.

Finding Import Instructions

Import System

To find import instructions, go to Settings > Company > Import > Instructions & Samples. There you will find a description of the fields required for each type of import, the necessary format for field data, and a sample file for the import. The sample file doesn’t include data, but does include the columns that are required for the import. This should serve as a starting point for you in creating an import file.

Running an Import

This section assumes you have already created a valid CSV file that you wish to import into LoanPro that is formatted according to the import instructions on the site.

Creating an Import

To create an import, go to Settings > Company > Import > Upload & History. Next, click Add in the upper right corner and select the import type that you want to run. Then, upload your csv file. Once done, click Save in the upper right corner. At any time you can download an import file by clicking on the download button (), and if the system is not working on an import you can delete it by clicking on the delete button ().

Validating an Import

You should see a list of imports that have been uploaded. Find the import that you uploaded (it is usually the first one in the list, but not always). Once you have found it, click the validation button (). The system will then validate it to see if the CSV file is in the valid format. If it is, you will receive a success notification and the validation symbol will be replaced with an import symbol ().

Otherwise, you will receive a failure notification and a list of all of the errors that were found that can be looked at by clicking on the error icon (E). Fix the errors that are found in your CSV file, and then create a new import with the corrected file.

Importing a Validated File

Once it is done, it will give you a finished notification with an output of how many errors (if any) there were and how many successes there were. To view errors, click the error icon (E).

To import a validated file, click on the import button (). Depending on the import, you may be given the option to Skip Calculation. Choosing this option means that when the import is running, LoanPro will not run the calculations that update associated loans. This will make things much faster because it will take an extra few seconds per row of your import to run the loan calculations. If you choose to skip the calculation step, the loan will be updated when daily maintenance runs overnight, or when the loan is accessed by any user.

At this point, it is recommended only to import corrected records and not the whole file again to avoid duplicates (unless it is an update import only).

Order of Operations on Import

There is a general logic to the order that files should be imported in. For example you must do the import to create the customer before you can add values to be saved to that customer such as customer notes, or references, etc.. This is also true that you must first import the creation of the loan before you can add things to be saved or associated at the loan level such as payments, charges, notes, etc.

Customer Import

  • Information — this is the import to create the customer account, or update personal information associated with the customer.
  • Payment Profiles — this import is to create or manage the payment profiles associated with this customer’s “wallet”.
  • References — this import is to create or manage the reference(s) associated with this customer.
  • Notes — Any notes to be owned at the customer level (be aware we also do note at the Loan level), customer level notes would include anything that is relevant to the particular customer & not the loan account.
  • Custom Fields — These are custom fields associated with the customer account.
  • Tool Actions — These are tools that you can run on a customer account such as OFAC, USSP address verify, etc..
  • Customer Access & Links to Loans — this import will allow you to manage the enrollment of the customer for various notifications on the loan account, such as web access, email, & SMS.

Loan Account Import

  • Setup — this import creates & manages the loan account setup terms. This includes its association to any customer accounts. This also includes the setup terms & enables the creation of the loan account. It is required that this is ran before any other Loan Import can be done to add things to the loans. (they must exist before you can do imports to associate things to them).
    • The customer account must exist PRIOR to creation of the loan account to link it in the creation post. This import is where you will include the setup terms of the loan account.
    • If you are doing a historical import then provide the ORIGINAL loan terms: loan amount, discount, term, frequency, annual interest rate, etc..
    • If you are doing a SNAPSHOT import then you will provide the snapshot values in those fields. For example, you’d provide the remaining principal balance as the “Loan Amount” and then roll payment for remaining term make the payment amount correct. You can use the following formula to figure out remaining term:Remaining = \frac{-LOG(1-(r/n*P/pmt))}{LOG(1+r/n)}
      • r = Annual Interest Rate
      • n = number of periods in a year for that frequency (ie 12 = monthly, 24 = semimonthly, 26 = biweekly, 52 = weekly)
      • P = Loan Amount (or, under the snapshot method, the remaining principal balance)
      • pmt = Payment Amount
  • Settings – This is the import for loan settings.  Please note that any custom fields that are part of the settings are considered loan custom fields and should be part of the custom fields import.
  • AutoPay – Create or manage the Autopays associated with the loan account.
  • Checklist – Manage which checklist items will be checked for this loan account.
  • Collateral – If applicable, you can manage the collateral information associated with the loan.
  • Custom Fields – Update loan custom fields. See instructions for formatting on IDs and select-style custom fields.
  • Insurance – If applicable, manage insurance tracking on this loan account.
  • Notes – Create and manage notes associated with the loan.
  • Loan Alerts – Manage active loan alerts for the loan.
  • Promises – Create or manage existing promises on the loan account.
  • Linking – This allows you to manage how loans are linked to one another including each linking option.
  • Enroll Recurring Charge – The import lets you enroll the loan for a specific recurring charge.
  • Enroll Rules Applied Settings – This lets you enroll the loan for specific loan-settings rules applied.
  • Enroll Rules Applied Charge Off  – This lets you enroll the loan for specific charge-off rules applied.
  • Enroll Rules Applied APD Reset -This lets you enroll the loan for specific amount past due (APD) reset rules applied.
  • Enroll Rules Applied Checklist -This lets you enroll the loan for specific checklist rules applied.
  • Enroll Rules Applied Change Due Date -This lets you enroll the loan for specific change due date rules applied.
  • Enroll Rules Applied Stop Interest Date -This lets you enroll the loan for specific stop interest date rules applied.
  • Tools
    • Actions – This import lets you run an Archive, Resurrect, Delete, Activate, Deactivate.
    • Link Portfolios – This lets you assign and un-assign portfolios and sub-portfolios.

Loan Transactions

  • Payments  – This import is used to import payments to your accounts. THIS DOES NOT PROCESS LIVE MERCHANT SERVICE PAYMENTS this is simply to post transactional history to a loan account. You can also import payments that have been reversed if you want to have reversed payments for historical purposes. It is STRONGLY recommended that you assign the paymentId for the import before the payment is created to be able to find payments for audit in the system later.
  • Payments Custom Fields  – Import custom field values for EXISTING payments. You must have existing payment custom fields in order for this import to work.
  • Recovery Payments – This is similar to the payments import, however, instead of the payments applying towards the loan they apply as towards the net charge off balance.
  • Charges  – This import can be used to post historical charges, such as late fees, to the loan account.
  • Advancements  – Use this import to post advancements to accounts.
  • Credits  – This is used to post historical credits towards the loan. These apply to accounts like a payment, but will show up in the credits area and not the payment history. However, both will show on the loan transactions report.
  • End Interest  – This will allow you to manage any stop or resume interest dates on the loan account.
  • Change Due Date  – This will allow you to create or manage changed payment due dates on the loan. NOTE: You can NOT change the first due date on a loan as it affects the calculation of the loan payment schedule and accrued interest.
  • Escrow Adjustments  – This is used to control if and how much escrow comes due in each payment period.
  • Subset Options (Settings)  – Manage escrow bucket settings for your accounts.
  • Escrow Transactions  – Create and manage deposit and withdrawal transactions for escrow buckets on your accounts.  These do not affect the loan account.
  • Cash Drawer Transactions  – Create and manage deposit and withdrawal transactions for your cash drawers.  These do not affect any loan account.
  • Charge Off Transactions  – This import is used to flag any EXISTING payment or credit as a charge off and will then add the payment or credit amount to the net charge off balance.
  • APD Adjustments  – Manage and create amount past due (APD) adjustments on your loan accounts.
  • DPD Adjustments – Manage and create days past due DPD adjustments on your loan accounts.

Company Settings

  • Source Company – Create source companies.
  • Portfolio – Create portfolios.
  • Sub Portfolio – Create sub portfolios.

 

Related Articles

Leave A Comment?