Payroll Amendment Import Function

By using the Payroll Amendment Import function, user can amend the salary information of the current payroll batch from an Excel file.

The excel file is similar to the following format.

Import Pay Type Amount with Pay Type Description

Complete Field List (Sample), the actual Field List can be obtained by generate the Excel File by the Payroll Amendment Export Function

  • Employee No.
  • Autopay
  • Daily Salary
  • Work Days
  • Salary
  • Travelling Allowance 1
  • Attendance Allowance 2
  • Holiday Pay
  • Annual Leave Pay
  • Sickness Allowance
  • Maternity Leave Pay
  • OT Pay
  • OT Pay (Special)
  • Late Deduction
  • Double Pay
  • Bonus
  • Meal Allowance
  • Statutory Holiday Allowance
  • Gratuitous Bonus
  • Payment in lieu of notice
  • No Pay Leave
  • Gross Income
  • EE MC
  • ER MC
  • EE VC
  • ER VC
  • EE MC Retention
  • ER MC Retention
  • EE VC Retention
  • ER VC Retention
  • Pay Rate
  • Work Time
  • Work Pay
  • Pay Rate 2
  • Work Time 2
  • Work Pay 2
  • Pay Rate 3
  • Work Time 3
  • Work Pay 3
  • Pay Rate 4
  • Work Time 4
  • Work Pay 4
  • Pay Rate 5
  • Work Time 5
  • Work Pay 5
  • Pay Rate 6
  • Work Time 6
  • Work Pay 6
  • Total Net Pay
  • Internal Remarks
  • Remarks
  • PAY_TYPE?_DESC (where ? is 1 to 15)
  • PAY_TYPE?_AMT (where ? is 1 to 15)