To update the employees pay rates using the Employee Pay Rate Wizard by importing a file you must prepare a comma delimited file (CSV) using the following formats.
This can be easily done by formatting it in excel.
Employees pay rate import file should be a comma delimited file with the following layout:
EmployeeNumber,CategoryNumber,PayRate/Amount
Employee pay rate import layout for (Comma Delimited) .
No header is required for the file. Ensure the Employee number and Payroll category number is a text field.
Sample of the file Rate:
001,101,1111
003,102,35.00
Sample of the file Amount:
001,801,50.25
003,802,55
Field | MAX LEN | TYPE | COMMENT | FORMAT |
Employee number | 8 | Alphanumeric | Mandatory Existing employee number | |
Payroll category number | 4 | Alphanumeric | Mandatory Existing category number | |
Pay rate / Amount | 10 | numeric | Mandatory Can not be zero | 9.999999 |
Go to > Employees > Pay rate update wizard
Backup company data before processing pay rate update. Click ‘Next’ after backup
Select the third option to do the import the new pay rate from a file. Click ‘Next’ to continue
Select the parameters from the screen > Click ‘Next’
Browse and select the file
Select ‘Update master paycard’. Enter the effective date and Pay change reason. Then click ‘Process’ to proceed with the update.