At the start of new financial years, after annual reviews, or any time you need to update multiple pay rates, use the Manage Employment Conditions CSV export and import to make changes in bulk.
Note: We recommend making pay rate changes at the start of a pay period, and locking historical timesheet data beforehand to ensure changes don't reflect on previous timesheets.
Updating pay rates via CSV importing
Step 1: Export current employment conditions
Navigate to Workforce > Staff > Tools > Manage Employment Conditions.
On the Export CSV tab, click Download CSV. This downloads a file containing all active employees' current employment conditions, including their pay rates.
Step 2: Update the pay rates in the CSV Make changes in the CSV file
Open the downloaded file and update the HOURLY RATE and/or ANNUAL SALARY columns for each employee whose rate is changing.
A few important rules:
Do not change the NAME or PASSCODE columns — these are used to match each row to the correct employee
Update the START DATE column to the date you want the new rate to take effect
Use numbers and decimal points only — no currency symbols or formatting
You can leave any column you're not changing as-is; only columns with values will be updated
Save the file as a CSV when done.
Step 3: Import the updated CSV file
Go back to Workforce > Staff > Tools > Manage Employment Conditions and select the Import CSV tab.
Upload your updated CSV file (5MB max, CSV files only) and click Import CSV.
The import runs in the background — a progress bar will show while it processes.
Step 4: Review the import results
Once complete, the page shows a summary of how many rows were successfully imported and any rows that failed with an error.
If any rows failed, you can click Download Failed Rows to get a CSV of only the failed rows, correct the issues, and re-import.
Common reasons a row may fail:
The NAME and PASSCODE don't match an active employee
The START DATE is earlier than an existing future employment condition for that employee
A POSITION or INDUSTRY AWARD value doesn't exactly match what's set up in your account
Header | Imported into... |
NAME | Name |
SALARY | Annual Salary |
HOURLY RATE | Base Hourly Rate |