3.5 Salary Entry Batch Update

3.5 Salary Entry Batch Update

For Payroll processing, it is compulsory to migrate employees' previous month salary details as the tax calculation has to include total accumulate remuneration of the year.  

How to migrate employees' salary details? 

  1. Download migration template file at Payroll -> Payroll Main -> Batch Salary Upload -> Click on Download Sample File button.
  2. Open with Microsoft Excel 2003 & above.
  3.  The excel consists of sheets named Basic, Allowance, Deduction, Overtime, DailyRate, UnitRate, NPL, DeductionRate and Statutory. Below are the explanations for each column with the sheet:

Basic Sheet:

Column Name
Description
Remark
EMP NO
Employee Identified Number
Compulsory.
EMP NAME
Employee Name
Optional. The system will migrate the data accordingly to the Employee Number.
DATE
Transaction Date

Ignore. The transaction date is used to calculate the basic rate.

For example, the staff's salary has increase from RM100 to RM110 per day on 15 Jun 2012,

thus the transaction date as 5 Jun 2012 and the basic rate per day will getting RM100 instead of RM110.

BASIC DAY UNIT
Unit of Day for Daily Pay
Ignore.
BASIC HOUR UNIT
Unit of Hour for Hourly Pay
Ignore.
BASIC TOTAL
Basic Total Amount
Compulsory. The total basic paid need to be fill in order for the system to migrate for payroll history.


Allowance / Deduction Sheet:

Allowance / Deduction sheet consist of Employee No, Employee Name column with all the allowances for the company. User need to fill up for the employees' allowances or deductions amount within the spreadsheet.As same with basic sheet, the compulsory column is employee no. 

 


Overtime / Daily Rate / Unit Rate / NPL / Deduction Rate Sheet:

Overtime, Daily Rate, Unit Rate, NPL or Deduction Rate sheets, the compulsory column is the Employee No column. The total of the items need to be fill for the columns with TOTAL naming. For example, you have a Rest Day for OT and you will found 2 columns which are Rest Day Unit and Rest Day Total. For migration, the system will be capture the total figure to be import to system. 

 

Statutory Sheet:   

Column Name
Description
Remark
EMP NO
Employee Identified Number
Compulsory.
EMP NAME
Employee Name
Optional. The system will migrate the data accordingly to the Employee Number.
EPF EMPLOYEE
Employee EPF Contribution
Compulsory.
EPF EMPLOYER
Employer EPF Contribution
Compulsory.
SOCSO EMPLOYEE
Socso Amount Paid by Employee
Compulsory.
SOCSO EMPLOYER
Socso Amount Paid by Employer
Compulsory.
TAX EMPLOYEE
Tax Amount Paid by Employee
Compulsory.
TAX EMPLOYER
Tax Amount Paid by Employer
Optional. If the tax is paid by employer.
VOL EMPLOYEE
Voluntary EPF Contribution Employee
Optional.
VOL EMPLOYER
Voluntary EPF Contribution Employer
Optional.
HRDF EMPLOYEE
HRDF Contribution Employee
Optional.
HRDF EMPLOYER
HRDF Contribution Employer
Optional. If HRDF is applicable to.
EX-EMPLOYMENT INCOME
Ex-employment Salary Paid
Only need to fill up for new join staff who join in the year.
EX-EMPLOYMENT EPF PAID
Ex-employment EPF Paid
Only need to fill up for new join staff who join in the year.
EX-EMPLOYMENT TAX PAID
Ex-employment Tax Paid
Only need to fill up for new join staff who join in the year.
EX-EMPLOYMENT ZAKAT PAID
Ex-employment Zakat Paid
Only need to fill up for new join staff who join in the year.
EX-EMPLOYMENT TAX RELIEF
Ex-employement Tax Relief Amount
Only need to fill up for new join staff who join in the year.
TAX AS EPF NORMAL
EPF Paid for Normal Wages in Tax Calculation
EPF paid for Normal Wages include basic and other payroll items which payable to EPF and normal tax income.
TAX AS EPF ADDITIONAL
EPF Paid for Additional Wages in Tax Calculation
EPF paid for Additional Wages is refer to the payroll items which payable to EPF and additional tax income.


    4.  Save the migration file in XML Spreadsheet 2003 (*.xml).