Import System Troubleshooting and Best Practices
Importing data into LoanPro in exactly the right way can be a difficult undertaking, especially when dealing with thousands of accounts or transactions. This article will help you use the LoanPro import system in the best way possible.
If you're doing several related imports, using the correct order can save you a lot of time and effort. In order to do this, it’s helpful to understand a little about how LoanPro works. In LoanPro, many entities exist separately but can be linked to each other. For example, collateral, customers, and loans are all separate things, but can be linked together. That means that you can import a collateral record, a customer, or a loan on their own, but if you are using the importing data that connects to information already in LoanPro, it’s important to look at the available fields for both entities to see how they will connect.
Take, for example, the loan setup import. This .csv file has columns for primaryCustomerId, secondaryCustomerId, and additionalCustomerId. When you create the loan setup import, you can connect the loans to an existing customers. In the customer import .csv, however, there is no field for loanId; you won't be able to link customers back to existing loans. Instead, you would have to do a third import to link the loans to the customers. If you do your imports in the right order, you can save yourself a lot of time. We recommend the following order:
- Create a Customer
- Create a Loan
- Potential Loan Tools (Roll Schedule, Custom Fields, etc.)
- Loan Settings
- Activate Loan
This order is a bit different from how you might do things in the user interface, but it's definitely the most efficient path for imports or the API. Our article Create a Loan - Full Process (Import & API) goes over the details.
When you upload data to LoanPro in order to import it, you will have to verify the data before it’s imported. If the data is not correct in some way, the system will show that there are errors with the data.
To view the errors, click !E.
The data displayed here should give specifics on what the problems are with your import files. You will need to open and edit your import files in order to fix these errors. For example, if you see something like this message:
Unable to validate extra property: The value you selected is not a valid choice. (payment.extra.tx.prinicpal)
You will know that payment.extra.tx.prinicpal is not a valid choice for the extra field. In this case, the reason for that is because the value is misspelled. It should be payment.extra.tx.principal where principal is spelled correctly.
When you import transactions in order to update or delete them, you are required to include an ID for the transactions so LoanPro knows which payments, charges, etc. you are referring to. When you are adding more than a handful of transactions, it’s recommended that you include an ID for each transaction. These should be numeric IDs between one and five digits in length.
Adding ID’s for new transactions will help you to know if the transactions made it into the system. Once an import is completed, you can easily download transactions from a report such as payment breakdown. You can then use the VLOOKUP function in your spreadsheet program to compare the list of transactions you intended to import with the list of transactions that actually made it in the system to make sure they are all there.
The Purposes of Different Imports
There's a lot of different imports, and at first glance it might not be obvious how or why you should use each one. The remainder of this article categorizes the different imports and explains a bit about what each of them does.
- 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:
- r = Annual Interest Rate
- n = number of periods in a year for that frequency (i.e. 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 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.
Loan Transactions Imports
- 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.
- Escrow 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.