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)

If the import file includes EE MC, ER MC, EE VC, ER VC, EE MC Retention, ER MC Retention, EE VC Retention, and ER VC Retention, HRPro will assume that you intend to override the auto-calculated results and apply your own data. Consequently, the AutoCalc flag will be turned off to ensure your data is used.

Additionally, importing an entire worksheet with all columns is strongly discouraged, as HRPro must process and update each cell in the import file individually in the database. This significantly increases processing time and unnecessarily consumes resources by validating and modifying data that may not require updates.