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 

    • Related Articles

    • Timesheet Template Upload

      This upload file will allow you to bulk change any pay or deduction element, with the calculation rule "Rate as Keyed" for multiple employees at once. The new rate for anyone on the upload file, will be applied to the next pay period or if your pay ...

    • Linking Pay Export Codes

      Too ensure the correct amounts are applied and paid to your employees, it is important that the different rates, penalties and allowances are assigned to the correct element in CloudPayroll. In CloudPayroll 1. To find out what the export code is that ...

    • Pay Rate and Hours of Work

      Employees can have a variety of pay rates, which provide several methods to correctly calculate their pay. (Select the 'More Pay Rates' button to see additional rates). This article covers: Hourly Rates / Wages Monthly Pays Part-Time or Casual ...

    • The 4 Steps to Running a Pay

      It is easy to pay your employees in CloudPayroll. 1. Open a Payroll Open either a normal payroll or a one-off payroll. 2. Enter Timesheets Enter any changes for the payroll, or upload from a time and attendance system or excel spreadsheet (must be in ...

    • Uploading Hours into an Open Payroll

      There are two types of timesheet files that can be uploaded into an open payroll in CloudPayroll. Both files can be uploaded once a payroll has been opened, under Payroll > 2. Enter > Upload. File Type 1 To download this template, please go to ...