Upload Pay Rates Tool

Upload Pay Rates Tool

Upload Pay Rates

This upload file will allow you to change pay rates for several employees at once. The pay rate for anyone on the upload file will be applied to the next pay period or if your pay is already open, it will update the existing pay.
We recommend reviewing the employee's Personal Details page after the upload or view the Reports > HR > Staff Pay Rates Report.
If your pay rate change does not apply to the whole pay period, you will need to split the hours. Add an additional line into your timesheet entry for the hours that it does not apply to and override with the old pay rate. The 2 lines should add up to the total hours worked in the pay.

Downloading the Template 
      1. People > Tools > Upload Pay Rates
      2. Select Download Template
      
      3. Open the file
      4. Save the file 
      5. Review the existing pay rates for all employees. 
      6. Edit any employees that you wish to update the pay rate for - (Enable Editing may need to be selected)
      7. Delete any employees that you do not intend to change the pay rate.
      8. Make sure there are no formulas in the file, as it will not upload with formulas in the sheet.
      9. Save the file

File example below, column D being the employees current payrate. 


Uploading the Template 

      1. People >  Tools > Upload Pay Rates
      2. Select > Choose File 
      3. Find your saved file
      4. Select > Upload