▪️Loans
The Loan Importer lets you easily upload loan data in bulk. Import loan details like amounts, terms, and interest rates directly into the system to save time and ensure accurate records for efficient
Last updated
The Loan Importer lets you easily upload loan data in bulk. Import loan details like amounts, terms, and interest rates directly into the system to save time and ensure accurate records for efficient
Last updated
The Excel file is divided into sheets based on the loan status. Fill in the relevant sheet depending on the loan's status: Active, Pending Review, Pending Disbursement, Closed, or Declined.
The Client Accounts sheet links a client to their savings account or loan wallet, along with the branch and phone number. To make entering loan data easier, you can copy the two columns showing the savings account/loan wallet ID and the client's name, allowing you to see the client as you enter the data.
Savings Account/Loan Wallet ID: Enter the savings account or Loan Wallet ID number, which you can copy from the "CLIENT ACCOUNTS" sheet.
Loan Number: Enter the specific loan number for that loan.
Loan Officer ID: Enter the ID of the officer responsible for the loan. You can copy this from the importer instructions.
Loan Product ID: Enter the Loan Product ID, which can be copied from the importer instructions.
Loan Amount: Enter the loan amount (principal) that the client received.
Interest Amount: Enter the total interest amount for the loan.
Amount Paid: Enter the total amount the client has paid so far.
Repayment Frequency: Enter the repayment frequency, e.g., DAILY, WEEKLY, BI-WEEKLY, BI-MONTHLY, MONTHLY, or YEARLY. (Ensure that the input is in capital letters.)
Duration: Enter the duration of the loan in days, weeks, months, or years, e.g., 8.
Duration Type: Enter the duration type, e.g., DAYS, WEEKS, MONTHS, or YEARS. (Ensure that the input is in capital letters.)
Interest Method: Enter the interest method, e.g., FLAT, DECLINING_BALANCE, or AMORTIZATION. (Ensure that the input is in capital letters.)
Interest Rate: Enter the interest rate per annum. For example, if the interest rate is 10% monthly, enter 120 (10% x 12 months).
Disbursement Date: Enter the date the loan was disbursed to the client in the format YYYY-MM-DD.
Penalty Balance: Enter the penalty amount for the loan. If there are no penalties, enter 0.
Principal Balance: Enter the remaining amount the client has to pay on the principal.
Interest Balance: Enter the remaining amount the client has to pay on the interest.
Principal in Arrears: Enter the amount of principal that is in arrears. If there is none, enter 0.
Interest in Arrears: Enter the amount of interest that is in arrears. If there is none, enter 0.
Next Due Date: Enter the next payment due date in the format YYYY-MM-DD.
