TurnKey Lender allows companies to import external data batches that contain the details of different system components and entities without API (as Excel files). This article contains a brief overview of the import processes. Please see its child articles for more details descriptions of each type of import.

...

For more details please see Migrate Customer Data Into TurnKey Lender via Import Work with Excel Files to Import Data

Import Flows

There are three basic import flows:

...

These are the same lists that can be defined from the Settings → Application process → Dictionaries.

• Customers

• Loans

• Disbursements

• Payments

• Write Off Reasons

• Cancellation Reasons

• Rejection Reasons

• Suspicious Phones

• Industry Categories

Customer Batch Import

The only mandatory field is email. It will also be used as the customer’s login.

The rest of the fields depend on your company’s Application Form. If the application form foresees more mandatory fields and they have not been provided, the Customer is created with the status “Incomplete”. In particular, this will happen if the form requires any photos and documents - as photos and documents cannot be migrated via customer import.

Disbursement Batch Import

To register a disbursement in the system, you must provide the following details:

• Loan Id: Unique identifier of the loan, for which the disbursement has been performed. Loan Id may be defined for loans in the course of the loan batch import (as an optional field) or will be automatically assigned to the loans populated into the system.

• Date: Date of the disbursement. If the optional “Disbursement → Date” field has been defined for the corresponding loan, the date defined in the disbursement must be the same,

• Reference: Disbursement reference number used to refer to this disbursement in the system. If the optional “Disbursement → Reference” field has been defined for the corresponding loan, the reference defined in the disbursement must be the same.

Other (optional) disbursement details are:

• Type: In general there are two types of disbursement called:

  • Automatic: in-the-system disbursement, initiated from inside the system and performed via a payment service provider

  • Manual: out-of-the-system disbursement. Regardless of the name, it doesn’t have to be performed manually - it is any disbursement performed beyond our system (via an external payment provider, face-to-face, with any kind of financial interests and mutual set-offs, etc.)

If the optional “Disbursement → Type” field has been defined for the corresponding loan, the reference defined in the disbursement must be the same.

• Amount: Amount disbursed

• Comment: Comment on the disbursement. If the optional “Disbursement → Comment” field has been defined for the corresponding loan, the reference defined in the disbursement must be the same.

Credit Lines

As none of the disbursement details have been provided during the Loan Batch Import for credit lines, you can create multiple disbursements for them using the Disbursement Batch import.

Payments Batch Import

To populate a payment into the system, the following fields are mandatory

• Loans: Loan ID, disbursement date, amount, reference and payment type required to register the loan in the system.

• Disbursements

• Payments

• Write Off Reasons

• Cancellation Reasons

• Rejection Reasons

• Suspicious Phones

• Industry Categories

• with customers, loans, or payments to your TurnKey Lender portal. The data import process includes external data transfer, error checking and fixing, and import of the necessary info.

...

Loan Id *

...

Date *

...

Amount *

...

Reference *

...

Payment type *

1. Navigate to Tools > Import to access the functionality.

2. Select the necessary page based on the data type you want to import (Customers, Loans, or Payments).

3. Download the template and fill out the file with the necessary information.

4. Then upload an .XLS or a .CSV file to the System in the same window.

The import consists of 3 steps in the following order:

2. Loans

General information:

• To import loans into the System, you need to get the Excel template ('Download template' button), fill the file with your data, and upload it (‘Choose file’ button).

After that, preview import results to fix any errors and see if all the records were processed successfully. New loans won’t be created in the System unless you confirm the import. 

• Loans are created in Origination status if the Disbursement date is empty.

• Loans are created in Active/Past due status if the Disbursement date is filled.

• Once loans have been imported the Pop-up message 'Loans imported successfully' appears.

• The loan ID column is added to the export excel file.

Example ‘loans_template’ file below:

The 1st Loan:

First Payment Date can't be earlier or equal to the Disbursement Date.

First Payment Date can't be earlier or equal Start Date.

The 2nd Loan:

The Lloan Amount does not correspond to the Credit product.

The Loan Term does not correspond to the Credit products.

First Payment Date can't be earlier or equal the Disbursement Date.

First Payment Date can't be earlier or equal Start Date.

The 3rd loan will be ready for import 

The loan ID column is added to the export excel file.

You will find this loan on the Servicing Workplace by Loan ID with Active Status because of the filled Disbursement date.

The 4th loan will be ready for import

Loan ID column is added to the export excel file.

Loan is created in Origination Workplace with Origination status because Disbursement date is empty. 

3. Payments

General information:

Payments can be imported for loans in Active or Past Due, waiting for Initial payment statuses. The payments parameters must match the loan (amount, date, loan status etc).

• Date:  Date can't be in the future and Payment date can't be earlier then disbursement

• Once Payments have been imported the Pop-up message 'Payments imported successfully' appears

Example ‘payments_template’ file below:

The 1-st Loan will appears on the ‘Archive’ WP with  ‘Repaid’ status because of full payment.

The 2-nd Loan will appears on the Servicing WP with ‘Active’ status.

...