Upload multiple loan data at once on KAMI Benefits modules!

Good to use by Admins when migrating current loans on KAMI or when there are new multiple loans that needs to be deducted to employees.

How to Import Loans

Follow the instructions below on how to successfully import loan details:

Step 1: Download the  template - under Benefits > Team Benefits > Team Loans

Step 2: Input the needed data on the template. Here are the data to add:

• EmployeeID & Name of Employee

Make sure that the EmployeeID is the same data added on Employment Info.

• Calculate - identify if the loan will be calculated or not

Input YES if loan will follow current computation configured on the loan type
Input NO if loan will only follow computation based on inputted rates on the template

• If Calculate column is tagged as YES, please add the following data:
  • Drawdown Date** - the date of the loan request
  • Loan Amount** - principal loan amount
  • Loan Type** - please check on the available loan types configured in the benefits module
  • Number of Months** - number of installment months
  • Number of Paid Months** - number of months that have already been paid. Please input 0 if there's no installment month that has been paid yet.
  • Yearly Interest Rate - given interest rate added on the computation 
  • Outstanding Balance - remaining amount to be paid by the employee
  • Total Interest Paid - the amount paid for the interest fee
  • Total Principal Paid - Loan amount - (monthly installment amount * paid months)  

Items with (**) are the required fields.

Please make sure you encoded the correct Loan Type based on available loan type in Benefits module.

• If Calculate column is tagged as NO, please add the following data:
  • Drawdown Date** -  the date of the loan request 
  • Loan Amount** - principal loan amount 
  • Loan Type - please check on the available loan type configured in the benefits module 
  • Yearly Interest Rate - given interest rate added on the computation 
  • First Installment Start Date**  - date on when the loan will be deducted from employee
  • Installment Period** - please input Monthly (semi-monthly & weekly periods will be available in the future)
  • Number of Installments** - number of installment months
  • Installment dates** - will depend on the day of the Installment start date
    
    

    If installment start date is June 15, Installment date should be 15

    
    

    Loan will be automatically deducted from payroll batch where Installment date is part of.

    
    

  • Installment Grace Period** - input if payment can be delayed by DAILY or MONTHLY basis
  • Installment Grace** - the exact number of days or months  in delaying payment

  For Example, if Daily is selected as Grace Period & 15 is added as Installment Grace, payment can be delayed by 15 days from Installment date.

  • Installment Amount** - amount to be paid every month 
  • Number of Paid Installments** - number of months that have already been paid. Please input 0 if there's no installment month that has been paid yet. 
  • Outstanding Balance - remaining amount to be paid by the employee 
  • Total Interest Paid - the amount paid for the interest fee 
  • Total Principal Paid - Loan amount - (monthly installment amount * paid months)

  Items with (**) are the required fields

  
  

  If Loan type is BLANK, IMPORTED LOAN will be the description of the loan once uploaded on the system

Step 3: Save the file once done inputting the details and import 

If upload is unsuccessful, please go to your email to see what row causes the error. Revised and reupload the file once done.

If upload is successful, uploaded loans will be available under Team Benefits > Team Loans.

And that's it. You're done!

Any changes on Loan type configuration will only be applied to newly uploaded loans.

Once loan has been imported, it will automatically be added on payroll run when status becomes DEFAULT