Each year, the Fair Work Ombudsman will release an update to their awards, outlining how to increase the pay for your employees through base rate increases and multiplier changes.
In order to offer a smoother rate update experience, Deputy is releasing the Pay Rate Updater for Deputy Enterprise clients.
This guide will cover the usage of this feature to ensure your compliance with Fair Work's updates, including the following:
Before you use the Pay Rate Updater
IMPORTANT: We recommend you use the Google Chrome browser to access Deputy when updating your pay rates for the best experience.
Please ensure you are logged in as a System Administrator in Deputy.
Fair Work changes apply to the first full pay run after the date of your award update. So if your pay run begins before and ends after the applicable date, you will not have to update your rates until this pay run is complete.
We recommend that you have approved all timesheets for your final pay run before you update your rates.
Where to find the Pay Rate Updater
The Pay Rate updater is only available for Deputy Enterprise accounts. You can access this feature by navigating to the Enterprise tab and selecting the Pay Rate Updater under Custom Applications.
Note: Only System Administrators will be able to use this feature.
How to download your pay rates
Open the Pay Rate Updater and select your Pay Rate Type from the drop-down menu.
There are 3 Pay Rate Types to choose from:
- Hourly Rates: These rates are paid on a per hour basis and have a dollar figure to define the cost, e.g "$22.11". These rates will generally be base rates or loadings.
- Multiplier Rates: These rates are also paid on a per hour basis but instead of a dollar figure, they have a multiplier value, that determines the scale of bonus from the base rate, e.g "1.5". These rates will generally be overtime, holiday pay or another penalty.
- Unit Rates: These rates are paid on a per unit basis and have a dollar figure similar to Hourly Rates. These rates will generally be loadings or allowances.
Once you have selected the required Pay Rate Type, click the Download Rates button to generate a CSV file of that rate type which will download to your computer.
Download files for the remaining pay rate types if they also require an update.
How to update your rates in the CSV file
To update your rates, locate the CSV file(s) you downloaded in the previous step and open with a spreadsheet tool, such as Excel or Google Sheets.
Fair Work will announce the changes to your specific award, including the base rate increases and any multiplier changes. To maintain compliance, you will need to find out if your award has been updated and what changes you will need to make to your rates.
You will need to update the empty New Value column in the downloaded CSV. This column will be named differently for different Pay Rate Types files:
-
Hourly Rates = New Hourly Rate
-
Multiplier Rates = New Multiplier Value
-
Unit Rates = New Unit Value
In this example, we are updating the rates in the spreadsheet by 1.75%. We also decrease the decimal places to 2. You can keep the longer decimal figure, however please note that Deputy will only save Pay Rates to 4 decimal places.
If you do not wish to update a certain rate, you can delete the pay rate row to exclude it from the upload.
You can also edit the Pay Rule Name and Pay Rule Export Code in this sheet. When you are submitting the rates, you will be given the option to overwrite the existing values with your edited names and codes.
Note: To avoid upload issues, DO NOT change the order or header names of the columns. These will be used to upload the data back into your account.
Once your rates are updated to your satisfaction, export the file to a CSV format. Excel formats or any non-CSV formats will not be accepted by the Pay Rate Updater.
How to upload the completed file to Deputy
Return to the Pay Rate Updater in Deputy and click Select File.
Then select your updated CSV file from your computer and click Preview updates.
Review your rate changes.
You will also be given the option to update the pay rate names and export codes of the rates from your sheet. Tick the checkbox of the values you'd like to change, or simply leave them unchecked for no changes to be made to these fields.
If you are satisfied with the previewed changes, scroll to the bottom of the page and click Submit Changes to run the update. Depending on how many rates you have to update, this could take a few minutes.
The preview table will be updated to show the updated status of your rates.
If any of your rates have not been updated, please verify your CSV columns have not been changed and that all updated base rates have a new value entered in the required column.
This process will need to be completed for the Hourly Rates and if applicable to your award update, the Multiplier Rates and the Unit Rates. Click on the Completed button to restart the process to upload and update the remaining files as applicable.
When to update and how to revert your changes
The Fair Work changes apply to the first full pay run after the date of your award update. So if your pay run begins before and ends after the applicable date, then you will not have to update your rates until this pay run is complete.
We recommend that you have approved all timesheets for your final pay run before you update your rates.
If you accidentally prematurely update your rates before the required changeover date and need to revert back to your old rates, you can use the uploader to return the original rates to your account.
If you move the figures from the Current Value column into the New Value column in your original file, you can re-upload the file and it will change back to the old rates until it's time to update them.
For any further assistance with rate updates, please reach out to our 24/7 Support team.