| Note: From October 1st, we're introducing new plans that better reflect how our customers use Deputy: Lite, Core, and Pro. If you're an existing customer, look out for an email soon with all the details you’ll need. Learn more about the new plans and what this change means for you. |
- Before you begin
- What data fields can be imported?
- How do I bulk import or bulk update the assignment of my team member employment terms data?
- Sample CSV template
Before you begin
In Deputy, you are able to assign employment terms to your team to ensure they are paid the correct amount (including the correct overtime, allowances and other entitlements). You can do this one employee at a time or use our bulk updater feature to add or update multiple employment terms to your team members at once.
When using the bulk importer or update tool please note:
- if you are bulk importing or updating a team member's pay rate information record then that team member must have their email address recorded in Deputy as we use their email address as the unique identifier to match the employment term records in the data sets for each employee. Read Getting started with bulk import and update using data from a CSV file.
- not all Deputy pay rates are supported for bulk import and update
- Before you can bulk import or bulk update information in your Deputy account please ensure you have the access level permission of a System Administrator or Location Manager. Location Managers can only bulk import and update team members for the locations that they manage.
- You will also need a spreadsheet prepared with your data in it and saved as a CSV file. To do this you can either:
- create the spreadsheet dataset you need with our CSV sample template
- export your existing Deputy data as a CSV file and edit or add to that data in the spreadsheet before re-importing it back into Deputy.
Note: Employment terms and team members must already exist in your Deputy account to use the bulk update feature.
What data fields can be imported?
For a complete list of all fields imported during a team member bulk update in Deputy please see Bulk import or Bulk update team member data.
| Field | Example | Mandatory | Validations |
| Library award | [MA000009] HIGA - Full Time - 1-October-2022 | No | Must match the name of a valid Deputy pay rate. |
| Base rate | "20" | No | a valid number (to 4 decimal places) |
Note: Enterprise customers: Learn more about importing employment terms.
How do I bulk add/update the employment terms of my team?
When needing to bulk import or update employment terms for team members, please follow the steps outlined in Bulk import or bulk update team member data as this template contains the fields to specify:
- a library award
- a base rate
for each employee with an email address assigned and utilized as the unique identifier for that employee.
Note: Many generic employment terms are ready to use as part of Deputy's Pay Rule Library.
Employment terms that are part of the Pay Rule Library are all able to be bulk uploaded via the Team Member data upload. It supports adding one employment term assigned to the main location.