Payroll Excel Import

This feature will help you to import the salary information (basic salary, increment, allowances, deductions) for the month or period.

✓Go to Monthly Activity > Payroll Excel Import

✓Generate Sample Excel File tab – select the employees > click

✓Select the payroll items that you would need to export into the excel file

✓Click and the excel file will be generated accordingly

✓Open the excel file and enter the necessary amount needed for each employee and payroll item

✓Save the excel file

**Note: If the allowance is not applicable to an employee, leave the column blank.

✓Go back to Monthly Activity > Payroll Excel Import > Import Excel Template

✓Click on and locate the excel file you have generated

✓Select whether to Append Allowance (add to existing allowance in Salary Adjustment) or Override Allowance (overwrite the existing allowance amount)

✓Click to upload the payroll items into the employee’s salary for the month and period

✓Status – indicates whether the file has been successfully uploaded or has encountered an error on which particular employee