Upload Pay Rates Tool

Upload Pay Rates Tool

Upload Pay Rates 

This upload file will allow you to change pay rates for several people at once. The pay rate for anyone on the upload file will be applied to the next pay period when you open the pay. If your pay is already open, it will update the existing pay.
Review the employee's Personal Details page after the upload. Use the Reports > HR > Staff Pay Rates.
This can be used if you need to change all your active casual employees for the minimum wage changes on 01 April.
If your pay rate change does not apply to the whole pay, 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.
With any upload sheet, use caution and review your information carefully before you upload. Test it on one or two employees if you need to.
For more information here - Pay Rates -  Edit An Existing Employee
For more information here - Minimum Wage

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. Use Paste Values if you are copying information, it will not upload with formulas in the sheet.
  9. Save the file

Uploading the Template 

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

People Tools



Upload File 


    • Related Articles

    • Pay Rates - Edit An Existing Employee

      Increase an Employee's Pay Rate You may need to edit an employee's pay rate due to a change to their employment conditions, employment agreement or due to a legislative change i.e. The Minimum Wage has increased. By changing the information on their ...

    • What is the minimum wage?

      Minimum Wage From 01 April 2024 the minimum wage will increase to $23.15 per hour (before tax) for employees aged 16 years or over. The starting out and training wages will increase to $18.52 per hour (before tax). This is a legislative requirement ...

    • Salary Sacrifice Pay Element

      A Salary Sacrifice deduction can be set up to allow you deduct from an employee's pay before any tax calculations are made. Using this type of deduction will reduce a person's PAYE, Student Loan and Kiwisaver calculations and you should seek legal ...

    • Pay Rate and Hours of Work

      People 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).  Hourly Rates / Wages People are paid their Ordinary Time using their hourly rate. ...

    • Top Up Allowance Upload

      Enable the Top Up Allowance Upload tool Go to Setup > Organisation > Defaults to turn this tool on. See here: Organisation Defaults Top up a person's normal pay to a minimum wage This clever tool is to enable employers to pay staff correctly and meet ...