To unify all of your lending business in TurnKey Lender, you can import external data batches TurnKey Lender allows companies to import external data batches that contain the details of different system components and entities. These includes:
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.
Loan Batch Import
For a loan to be registered in the system, you must define:
Login: Login or email of the customer for whom the loan or loan application was created
Credit product: The credit product chosen for the loan or loan application
Value: The total amount lent
Periodicity: Installment period (monthly, weekly, etc.)
Other (optional) loan details are:
Interest rate: The interest rate defined for the selected credit product or specified in the final loan offer
Branch: Branch to which the loan is assigned
Start date: The first date in the schedule. When the funds are provided directly to the customer, it is usually the same as the disbursement date. However, when the funds are provided to a third party (e.g. a retailer who has provided services to the customer, the start date will be the date when the service has been provided, regardless of how the retailer and lender agree on the actual disbursement)
First due date: Date to which the first payment is due; end of the first installment
Equal payment: An equated monthly installment (EMI); a fixed payment amount made by a borrower to a lender at a specified date each calendar month.
Retailer and Shop: Retailer (AKA Vendor) and/or Shop that has received or is to receive the payment borrowed by the Customer (see Vendors and Stores (loan for a purchase) )
Sales tax:
Disbursement → Date: The date on which the loan funds have been disbursed
Disbursement → Reference number: Unique id of the disbursement used to refer to it in the system
Disbursement → 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.)
Disbursement → Comment: Any free text comment
Loan Status
The loan status depends on the information in the optional field Disbursement Date:
If the Disbursement Date is left empty, the loan is created in the Origination status.
If the Disbursement Date is defined, the Loan is created in the Active status. After the payment information has been provided, the Loan may be moved to the Past Due status.
Credit Lines
When a credit line is added to the system, the Disbursement information shall be left empty. It can then be registered in the system with the Disbursement Batch 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 * |
Navigate to Tools > Import to access the functionality.
Select the necessary page based on the data type you want to import (Customers, Loans, or Payments).
Download the template and fill out the file with the necessary information.
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:
Customers
General information:
To import customers into the System, you need to get the Excel template ('Download template' button) fill the file with your data, and upload it (‘Chose file’ button).
After that, preview import results to fix any errors and see if all the records were processed successfully. New customers won’t be created in the System unless you confirm the import.
Photos and documents can't be migrated via customer import. In case photo(s) and documents are required, customers will be created and assigned the status Incomplete. Please, check the Application form section to adjust these settings. If required fields are empty, customers will be assigned the status Incomplete and the general loan flow will not be applied for them.
Only email is required for Customer creation. If the field is required in the application form but is empty in the load file, the Customer will be created with the status 'Incomplete'.
Once loans have been imported the Popup message 'Customers imported successfully' appears.
Example ‘customers_template’ file below:
The 1st Customer will be created with ‘Incomplete' status. You can complete the creation of the Customer from the Tools-> Customer management tab.
The 2nd Customer will be created with an ‘Active’ status
2. Loans
General information:
...