Skip to main content

Bulk import date effective pay rates

Use bulk import and update to create or update date-effective pay rates for multiple team members using a CSV or XLSX file.

Before you read

  • Target audience: This article is for System Administrators and Location Managers.
  • Access restrictions: Location Managers can only import and update pay rates for team members at the Locations they manage.
  • Recommended resources: Before you begin, read Getting started with bulk import and update using CSV/Excel.

This article covers

Before you begin

Date-effective pay rates let you apply a new pay rate from a specific date. You can use this bulk update tool to create new date-effective pay rates or update existing ones.

Before you import your file:

  • Team members must have an email address saved in Deputy. Deputy uses the email address to match the pay rate data in your file with the correct team member.
  • Team members and pay rates must already exist in Deputy.
  • Not all Deputy pay rates are supported for bulk import and update.
  • Prepare your data in a CSV or XLSX file. You can download your current date-effective pay rate data from Deputy, or use the sample CSV template.

What data fields can be imported?

Use the following fields when creating or updating date-effective pay rates.

Field Example Validation
DeputyId 1 Matches the internal ID of an existing date-effective pay rate. Leave this blank to create a new date-effective pay rate.
First Name Fred The team member's first name.
Last Name Flintstone The team member's last name.
Email fred.flintstone@example.com Matches the date-effective pay rate data to the team member in Deputy.
Pay Centre Bedrock The team member's Pay Centre. This is not required if your account does not use Pay Centres.
Effective Date 2026-01-20 The date the new pay rate takes effect.
Location Bedrock Cafe The Location where the pay rate applies. Add one Location per row. This is not required if your account does not use multiple agreements.
PayrollId 12345 The team member's Payroll ID.
Pay Rate TP [MA000080] - AERA - Casual - Exhibition - 1-July-2026 The pay rate to assign to the team member.
Classification Grade 2 - Exhibition general hand Must apply to the selected pay rate.
Base Rate 27.15 If blank, Deputy uses the classification value. If no classification value is available, Deputy uses the default value from the selected pay rate.

How to bulk import or update date-effective pay rates

  1. In the People tab, select Bulk import and update.The Bulk import and update option in the People tab.
  2. Select Assign date-effective pay rates, then choose one of these options:
    • Download your existing data(.CSV/.XLSX) to update pay rates already in Deputy or add new rates using employee information.

    • Download the sample CSV template from below to see the required format and manually add new date-effective pay rates. Adding new rates this way won’t overwrite or change existing rates.

  3. Open the file and make your changes:
    • To update an existing date-effective pay rate, update the required values in its row. You cannot use an existing row to transfer a rate to a different team member.
    • To add a future-dated pay rate, add a new row and complete the required fields. Leave DeputyId blank.

  4. Save the file as a .CSV or .XLSX file, then select Continue to upload.

  5. Click Upload File and select the .CSV or .XLSX file from the computer.

  6. Review the column mapping. Deputy matches most columns for you. Check that each column is matched to the correct Deputy field, then click Continue.

  7. Review the results. 
    • The Valid tab shows records ready to import. 
    • The Invalid tab shows records with errors.

    • Correct any errors in Deputy or update your original file, or in the window, and upload it again. When all records are valid, click Submit.

 

Deputy updates your data in the background. You can close the import screen and continue working in Deputy while the import is in progress.

Sample CSV template

Download the sample CSV template to prepare your import file.