How to migrate employees' salary details?
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).