User Guide‎ > ‎

Payroll Amendment Import Function

By using the Import function, user can amend the salary information of the current payroll batch from an Excel CSV 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
  • Wages in lieu of notice
  • No Pay Leave
  • Gross Salary
  • 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)


See also: HRPro 使用教學 - 如何使用 Payroll Amendment 中的 export/import 功能