Update pay rate or amount with wizard and import file
How to update pay rate or amount with wizard and import file.
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 Cannot be zero | 9.999999 |
Steps to setup:
- 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.
- Type in "APPLY CHANGES" to the box to complete.
