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
NOTE: Importing information (e.g. checklist data) does not run real-time rules applied. This is because doing so would significantly slow the import. The same is true for running the loan calculator.
Finding Import Instructions
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 in the upper right corner and select the import type that you want to run. Then, upload your csv file.
Once done, click 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).
Note: When importing a file, a progress bar with show the general progress of the data being uploaded into LoanPro.
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.
- 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. Note: For "Select" type custom fields, you must use the key, not the value to make the update. For example, if a selection option is "1, Yes" you will have to use "1" in the import file and not "Yes".
- 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:
- 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. Note: For "Select" type custom fields, you must use the key, not the value to make the update. For example, if a selection option is "1, Yes" you will have to use "1" in the import file and not "Yes".
- 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 Credits – This lets you enroll the loan for specific credit 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.
- Enroll Rules Applied Account Tool – This lets you enroll the loan for specific account tools rules applied.
- Enroll Rules Applied Customer Tool – This lets you enroll the loan for specific customer tools rules applied.
- Actions And Results – Add/manage action and result codes on the loan account.
- Bankruptcy – Update bankruptcy fillings associated with the loan account.
- Actions – This import lets you run an Archive, Resurrect, Delete, Activate, Deactivate, or Calc. Most of these actions are obvious, but calc allows you to run calculations on the loan. This is most often used to update real-time rules applied.
- Link Portfolios – This lets you assign and un-assign portfolios and sub-portfolios.
- 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. Note: For "Select" type custom fields, you must use the key, not the value to make the update. For example, if a selection option is "1, Yes" you will have to use "1" in the import file and not "Yes".
- 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.