...
| Note | ||
|---|---|---|
| ||
Only users who have access permissions to use the System, Servicing, and Collection workplaces can import payments. |
Now we'll walk you through the importing process, step-by-step.
Step 1 File format and structure
...
| Warning | ||
|---|---|---|
| ||
TurnKey Lender only supports XLS and CSV file formats for external import. |
After checking the file format, you have to arrange and adjust the internal structure of the file.
- Check the column order inside the document. It must be as follows:
...
Check the information inside each column. Note that each column has its own data type and you will get an error in case it doesn't meet the requirements.
| Tip | ||
|---|---|---|
| ||
...
When you're ready to import a repayment batch file, follow these steps.
...
Wait for the file to upload. The process may take some time depending on the size of the document.
...
Once the file is successfully uploaded, you can review the results using the System interface.
TurnKey Lender displays an additional column with error notifications. There you can see what's wrong with the records that will be skipped during import.
...
Step 4 - Perform final synchronization
When the payments data import is complete, you can integrate it into the system, and synchronize the corresponding records.
In the Import Payments window, press the Import button below the table.
Wait for the data to be synchronized. You will see a notification about successful process completion at the bottom of the window.
Payments Batch Import
To populate a payment into the system, the following fields are mandatory
Loan ID: ID of the loan
Date: Date when the payment has been registered
Amount: Value of the payment (in the currency defined for your company)
Reference: Reference code, as in the UI - it is often a number of the receipt, invoice, or other identifier assigned to the payment
Payment type: cash, check, direct bank transfer or card
These details fully correspond to the details of manual payment registration in the UI
...