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).

 


    • Related Articles

    • 1.2 Expense Layout - Creating Expense Detail Item Layout aka Batch Entry Excel Layout

      After creating Expense Layout, you can now continue to create the Expense Detail Item Layout. However, this is relatively simple and easy.  Step 1 ,2 & 3: Go to Expense -> General Setting-> Batch Entry Excel Layout, Step 4: Click 'Create'. Step ...
    • How to Use Batch Salary Upload?

      'Batch Salary Upload' is a feature that allows you to update multiple records at one go. This is particularly useful for companies that have variable allowance and big headcount, the User only need to update the variable allowance (such as Attendance ...
    • 1.1 Utilities - Batch Employee Custom Day Entry

      Step 1, 2 & 3: Attendance -> Utility -> Batch Employee Custom Day Entry This utility allow the admin user to key in Employee Custom Day Entry by batch. You will go to the screen below: Step 4: Select employees into the selected list to update the ...
    • Leave Batch Entry

      Leave Batch Entry allows the user to key in leave adjustment or leave Compulsory entry for a group of employees in batch instead of individual records. Below are the guides on how to key in batch leave adjustment and leave compulsory entry. ...
    • How to upload BONUS by batch, (Salary Upload Wizard)

      Step 1. Salary Upload Wizard To use Batch Salary Upload for bonus upload, kindly go to Payroll -> General -> Salary Upload Wizard .    The allowance - Bonus must be created before proceeding with the Batch Salary Upload for Bonus.  Part 1 - Download ...