Importing loan data
Use loan import to bring loans that are already running into KAMI from a spreadsheet or your old system, so payroll carries on deducting the repayments. For each loan you choose whether KAMI calculates the schedule from a loan type, or takes the schedule and balance exactly as they stand. You can also import loan payments made outside payroll, in bulk, from the Installments page.
Where:
- Loans: Benefits › Team Benefits › Team Loans › Download Template and Import
- Loan payments: Benefits › Team Benefits › Installments › Bulk upload
You need: the Loan Manager right with write access
Before You Start
- Every employee must already be in KAMI, with the same Employee ID as in your file.
- One bad row stops the whole file. If any row has an error, nothing is imported. Fix the file and import it again.
- Importing the same loan twice creates two loans. KAMI doesn't check for duplicates.
- Imported loans are approved straight away. They skip the loan type's approvers.
- Import before the first payroll you run in KAMI, so no instalment is missed.
Which way to import a loan
| Calculate Loan | KAMI does | Use it when |
|---|---|---|
| Yes | Builds the schedule from the loan type, exactly as for a new request, and marks the months already paid | The loan followed one of your loan types' terms |
| No | Saves the instalment amount, dates and balance from your file as they are | The loan has its own terms, or you need the balance to match your old system to the cent |
How to import loans
- Open Team Loans and select Download Template. You get Loan_Import_Template.xlsx.
- Fill in one row per loan. Every row needs EmployeeID, Loan Amount, Drawdown Date and Calculate Loan (Yes or No).
- For a Yes row, also fill in Loan Type (the exact name), Number of Months and Number of Paid Months. Add Loan Account Number if the type requires one.
- For a No row, also fill in First Installment Start Date, Installment Period, Installment Amount, Outstanding Balance, Total Interest Paid, Total Principal Paid, Number of Paid Installments, and either Number Of Installments or Scheduled Maturity Date.
- If a Yes row breaks a rule only because the loan is old, tick the matching box under Import Settings on its loan type: probation, no wage, or a contract that ends first.
- Save the file as .xlsx. Select Import and choose it.
- KAMI confirms it has the file and imports it in the background. Check Import History in Bulk Import / Export to see whether it succeeded.
- Open Team Loans and check a few loans: the Imported badge, the balance and the next instalment.
How to import loan payments
Use this for repayments made outside payroll, for example cash or bank transfers.
- Open Installments and select Bulk upload.
- Select Download Template and fill in one row per payment: Loan ID, Installment Number, Payment Date, Payment Amount and, if you like, Payment Details. The loan ID and instalment number are in the Installments export.
- Select Import and choose the file.
A payment can't make an instalment more than fully paid, and can't go on an instalment that is already Paid. The loan must be Current, Current (Manually added) or Default. Part-payments are fine: the instalment turns Paid once its payments add up to its amount. Each payment is recorded as paid outside payroll.
Loan template columns
| Column | Used for | What to enter |
|---|---|---|
| EmployeeID | Both | The employee's ID in KAMI |
| Loan Type | Yes (optional for No) | The loan type's name, as in KAMI. A No row without it shows as Imported Loan (No Loan Type) |
| Loan Account Number | Both, optional | The lender's account number for the loan |
| Loan Amount | Both | The original amount borrowed |
| Drawdown Date | Both | The date the loan started, in your company's date format |
| Number of Months | Yes | The full term in months. It must be within the type's minimum and maximum |
| Number of Paid Months | Yes | Months already repaid. KAMI marks that many instalments Paid, doubled for split instalments |
| Calculate Loan | Both | Yes or No |
| Yearly Interest Rate | No, optional | The loan's yearly rate, in % |
| First Installment Start Date | No | The first instalment date. Not before the drawdown date, and before maturity |
| Scheduled Maturity Date | No | The last instalment date. Give this, Number Of Installments, or both |
| Installment Period | No | Equal period installments, Bi-weekly, Semi-monthly, Monthly, Quarterly or Yearly. Equal period needs both the maturity date and the number of instalments |
| Number Of Installments | No | The total number of instalments over the whole loan |
| Installment Dates | No, optional | The day of the month instalments fall, such as 25. Two days for semi-monthly or bi-weekly, such as 15, 30 (the default). Leave blank for equal period |
| Installment Grace Period and Installment Grace | No, optional | Daily or Monthly, and how many, before an unpaid instalment is overdue. Both or neither |
| Installment Amount | No | The amount of each instalment |
| Number of Paid Installments | No | Instalments already repaid. KAMI marks that many Paid |
| Outstanding Balance | No | What is still owed today |
| Total Interest Paid and Total Principal Paid | No | What has been repaid so far, split into interest and principal. 0 if nothing |
What Happens Next
- Yes rows become Current, or Repaid if every instalment is paid. Each paid month gets a payment marked as a mass import. The loan type's terms and limits apply, except Drawdown notice (Days). A loan that would end after the employee's termination date is still refused.
- No rows become Current (Manually added). The outstanding balance is the one in your file. KAMI doesn't add default interest or late penalties to these loans.
- Payroll deducts the unpaid instalments from the next payroll whose dates they fall in, like any other loan.
- Imported loans show an Imported badge on Team Loans and My Benefits, and Imported is a column in the Other Loan Report.
Tips
- Import five loans first. A date format or column problem shows on five rows and is buried in five hundred.
- Reconcile the total outstanding balance against your old system before the first payroll. If it doesn't match, find out why before payroll deducts anything.
- Use No when in doubt about the old terms. A Yes row rebuilds the schedule from today's loan type, which may not be how the loan was agreed.
- Turn Import Settings off again after migrating. They only affect imports, but next time you want the checks.
- Tell employees their loans have moved to KAMI before the first deduction, so a new line on the payslip isn't a surprise.
Troubleshooting / FAQ
Q: The import failed. Open Import History in Bulk Import / Export. The import's errors give the row of each problem. Fix them all and import the whole file again; nothing from the failed file was saved.
Q: "Employee with the given EmployeeID doesn't exist." The ID doesn't match anyone in KAMI. Check spaces and leading zeros.
Q: "… required in case you want to calculate the loan." or "… required in case you do not want to calculate the loan." The row is missing a column its Calculate Loan choice needs. See the table above.
Q: "You may not apply for a loan during your Probation Period." on an old loan. Tick Allow loan in probation period on the loan type, or use Calculate Loan = No.
Q: A loan imported twice. Delete the copy from its loan details. This needs the Delete Loans right with write access. See Managing team loans.
Q: "Over payment of an installment is not allowed." The payment is more than what's left on that instalment. Split it across the next instalment numbers.