ERPro User Portal

2days until
Next Release 6.11

Payroll Adjustment 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 CSV file is similar to the following format.

 

 

Complete Field List

 

[EE_NO]

Existing Employee No. in the Payroll Batch

[CHEQUE_NO]

Cheque No.

[BASIC_SAL]

Basic Salary

[HDY_DAYRATE]

Holiday Pay Daily Rate

[HDY_LEAVE]

Holiday Pay Leave Days

[HDY_PAY]

Holiday Pay

[ANN_DAYRATE]

Annual Leave Daily Rate

[ANN_LEAVE]

Annual Leave Leave Days

[ANN_PAY]

Annual Leave Pay

[SICK_RATE]

Sickness Allowance Daily Rate

[SICK_LEAVE]

Sickness Days

[SICK_PAY]

Sickness Allowance Pay

[BASIC_PAY]

Normal Pay Daily Rate

[MATERNITYLEAVE_DAYRATE]

Maternity Leave Daily Rate

[MATERNITYLEAVE_DAY]

Maternity Leave Days

[MATERNITYLEAVE_PAY]

Maternity Leave Pay

[OT_RATE]

OT Hourly Rate

[OT_HRS]

OT Hours

[OT_PAY]

OT Pay

[ALLOWANCE_DAYRATE]

Allowance 1 Daily Rate

[ALLOWANCE]

Allowance 1 Pay

[ALLOWANCE2_DAYRATE]

Allowance 2 Daily Rate

[ALLOWANCE2]

Allowance 2 Pay

[DOUBLE_PAY]

Double Pay

[BONUS]

Bonus

[PAY_TYPE1_AMT]

User Defined Pay Type 1 Pay Amount

[PAY_TYPE2_AMT]

User Defined Pay Type 2 Pay Amount

[PAY_TYPE3_AMT]

User Defined Pay Type 3 Pay Amount

[PAY_TYPE4_AMT]

User Defined Pay Type 4 Pay Amount

[PAY_TYPE5_AMT]

User Defined Pay Type 5 Pay Amount

[PAY_TYPE6_AMT]

User Defined Pay Type 6 Pay Amount

[PAY_TYPE1_DESC]

User Defined Pay Type 1 Description

[PAY_TYPE2_DESC]

User Defined Pay Type 2 Description

[PAY_TYPE3_DESC]

User Defined Pay Type 3 Description

[PAY_TYPE4_DESC]

User Defined Pay Type 4 Description

[PAY_TYPE5_DESC]

User Defined Pay Type 5 Description

[PAY_TYPE6_DESC]

User Defined Pay Type 6 Description

[NOPAY_RATE]

No Pay Hourly Rate

[NOPAY_HRS]

No Pay Hours

[NOPAY_PAY]

No Pay Leave Deduction

[MPF_CPERD1]

MPF Period From

[MPF_CPERD2]

MPF Period To

[PFUND_EE]

MPF Contribution % EE

[PFUND_ER]

MPF Contribution % ER

[PFUND_EE_PAY]

MPF EE Pay

[PFUND_ER_PAY]

MPF ER Pay

[MPF_VLYEE]

MPF Voluntary Contribution EE

[MPF_VLYER]

MPF Voluntary Contribution ER

[PAY_RATE]

Pay Rate for Hourly/Daily Workers Only

[WORK_TIME]

Work Time for Hourly/Daily Workers Only

[WORK_PAY]

Total Worker Pay for Hourly/Daily Workers Only

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