Before You Start
Please note that this guide is for our Deputy Premium customers. If you’re an Enterprise customer, please contact our support team for any assistance regarding Xero.
Before you get started, please make sure that you have set up both your Xero and Deputy accounts.
Next, please go to your Location Settings from your Home page. Next, please go to Settings for Payroll, then click Connect to connect to Xero.
If you have not already imported your employees from Xero, please do so now. If you have already added staff without importing from Xero, please first make sure that your employees’ names and email addresses match up between Deputy and Xero, then follow the steps to import your employees. This will ensure that your employees are not duplicated.
Please note: Award Interpretation is only necessary if you require Award rates. If you do not, please set an Ordinary Hours rate, as well as these Saturday, Sunday and Public Holiday rates, which do not require numbering.
- Saturday [SAT][ALLDAY]
- Sunday [SUN][ALLDAY]
- Public Holiday [PH][ALLDAY]
What Is Award Interpretation
Award interpretation is a custom system created by Xero and Deputy, offering unprecedented flexibility for your rates. It will allow you to:
- Pay different rates for different days of the week
- Pay different rates for different times of the day
- Pay only a maximum or minimum number of hours
- Only pay certain rates if they are working in certain areas or a specific Xero tracking code
Where Do I Write The Rates?
In Xero, please go to your Settings. Next, please select Payroll Settings. From Payroll Settings, please select Pay Iƒtems, then “+Add Earnings Rate”.
After creating the rate, please apply it to your employees. To do this, please go to Payroll, then Employees. From there, please select an employee. Next, go to their Pay Templates and add an Earnings Line. Please note that in your Employee’s Employment Page, they must have the same Ordinary Rate applied as they have in their Earnings Line.
To set a salary item in Xero, please create the rate as “Ordinary time earnings” with the unit type set to “Hours”. Then, when applying it to employees, you will be given the option to designate it as an annual salary. Salary rates do not require Award syntax. If you have applied a Salary rate as your employee’s Ordinary Rate in Xero, you may still export their timesheets, however the employee will not be paid any extra, unless you choose to apply an overtime rate to that employee, which we will cover below.
If you wish to export any salaried employees to Xero, please reach out to our Deputy Support staff for any assistance.
How To Name Your Rates
When Deputy evaluates someone’s roster or timesheet to calculate the associated cost, it will calculate the wages based on how the rate is named. The way Deputy handles this depends on two things: how you name the rates in Xero and how you allocate them in employee’s pay template in Xero. All that you will need to do to set up your Award Interpretation is to write your rates in a specific manner. For example, you have probably written a pay item in Xero as “Casual Adult Public Holiday”. Now you will write it as “Casual Adult [PH][ALLDAY]”.
Here’s how it works:
NUMBER Anything you want [DAY][FROMTIME-TOTIME][MIN – MAX][TRACKING]
The Number determines the order in which the Deputy will sort the rate, with 0 being the most common rate. Generally, this will be your Ordinary rate.
You can set the title of the rate as whatever you’d like.
The [Day] bracket determines the days on which the rate will apply.
The [FROMTIME-TOTIME] bracket allows you to set a specific time of day for the rate to apply.
The [MIN-MAX] bracket sets the hours of a shift that a rate may apply for. This is generally used for allowances and overtime.
The [TRACKING] bracket will restrict the pay rate to a certain rostering area, for example if you have set up a “kitchen” rostering area in Deputy, you can set the tracking category so that it will only apply to people working in the kitchen. The Area Export Codes and Tracking Codes will need to be set up first. You may also use the name of the Rostering Area in this bracket, which will be used to pay employees working from that area.
For the award interpretation to work, you must use specific language when naming your rates. Below is a list of the terms you may use and which bracket it must be used in. Please note that even for a bracket you want to leave empty, you must write the bracket itself into the rate. Please open it and close it with no space in the middle, like this: . You must have all four brackets present in the rate for the system to work.
When you assign these pay items in employee’s profile, you must place the most common pay item at the top (e.g., ordinary hours) and the least common item at the bottom (e.g., public holiday rate). Please note that Xero may order the pay items back to front. To ensure that this doesn’t happen, please order your rates with a number before the rate, with 0 being the most common rate. There is also a 50 character limit.
When Deputy evaluates a Timesheet to check which rate should be paid, it will look at the bottom-most condition first, then work it’s way to the top. When it finds an applicable rate, it will check which portion of the shift applies before going on to next pay item.
- PH – Indicates public holiday
- DAILY – all the hours of the day is counted towards as one
- !PH – not public holiday.
- WEEKDAY,!PH – Applies every weekday but no public holiday
- WED,FRI – Only applies Wednesday and Friday
- WEEKLY – If you wanted to count the entire week towards these hours. Handy for 40 or 38 hours per week items. You must also specify the weekly total hours and daily hours exclusion below.
- ALLDAY- The default, which will make the rate apply for the whole day.
- 0000-2359 – must be 4 digit 24-hour time.
- 0.0~2.0 – The rate will apply from the beginning (0.0) to the second hour (2.0) of the shift. For this to apply, you will need to set MON/TUE/WED/PH as above. Aggregates such as DAILY, WEEKDAY, WEEKEND can also be used.
- 40|8 – On the left of the bracket should be your weekly hours, then a vertical line with the number of hours per day to include. For example, pay overtime for more than 40 hours per week but don’t count more than 8 hours per day as they will be counted by other overtime scripts.
- NONE- You can use this, or leave the bracket empty.
- 1-4 – This rate will be paid for a minimum of 1 hour and maximum of 4 hours. Note that it’s only applicable if the Xero rate type is “Allowance“.
- TOUCHFULL- If part of the shift matches the TIME bracket, then the whole shift will be paid in this rate. For example, if you have Rate A that applies between 3 PM and 6 PM, then a Rate B that applies from 6 PM til midnight, and B is set to TOUCHFULL, a shift that is worked from 3 PM till 9 PM would be paid entirely at the B rate.
In the tracking bracket, you can write the name of one of your Tracking Codes or Rostering Areas. If you do so, the rate will only apply if a shift has been worked in the corresponding area. This is useful for settings multiple rates on an individual who works in more than one area, such as a barista who also works in the bar.
There are occasionally scenarios that the above syntax cannot cover, such as split shifts and period loadings. For scenarios like this, we use custom scripts that have their own syntax, which looks like this:
15 Uniform allowance [SCRIPT][once_per_day_0914][0.0-1.0]
You can view our available scripts in Deputy’s github repository. If you have a scenario that is not yet covered by a script, please get in touch with us.
Here we will show you examples of rates that you may write in Xero.
You may type the following awards into Xero as is. You can then type in your own dollar value as per the award you are paying. Assuming you have the Ordinary hours as your base rate, you may set most of the other rates as multipliers of the base rate. For example Overtime could be either a 1.5x or 2x multiplier.
Hospitality Industry (General) Award (HIGA)
- 1 Ordinary Hours [WEEKDAY][0700-1900]
- 2 HIGA CAS L1 [WEEKDAY] [0000-0700]
- 3 HIGA CAS L1 [WEEKDAY] [1900-0000]
- 4 HIGA CAS L1 [SAT] [ALLDAY]
- 5 HIGA CAS L1 [SUN] [ALLDAY]
- 6 HIGA CAS L1 [PH] [ALLDAY]
Ideally, you can leave everything as a multiplier rate of the Ordinary Rate. This will be necessary if your employees accrue leave through hours worked.
Restaurant Award 2010
Similar to the HIGA above, you can also configure Restaurant Award 2010:
- 1 Ordinary Hours
- 2 RA2010 PT L1 [WEEKDAY,!PH][0000-0700]
- 3 RA2010 PT L1 [WEEKDAY,!PH][2200-0000]
- 4 RA2010 PT L1 [SAT] [ALLDAY]
- 5 RA2010 PT L1 [SUN] [ALLDAY]
- 6 RA2010 PT L1 [PH] [ALLDAY]
There are a number of different construction awards, however, we will tackle some common ones here. For example, if you work more than 7.6 hours in a day, you will be paid 1.5x your Ordinary Rate. After 9.6 hours, it’s double time. If you work more than 40 hours per week. you also get 1.5x.
- 1 Ordinary Hours
- 2 Construction Over 7.6 Hours Weekday [WEEKDAY][7.6~9.6]
- 3 Construction Over 40 Hours per week [WEEKLY][40|7.6]
- 4 Construction Over 9.6 [WEEKDAY][9.6~24]
You can copy and paste these rates into Xero as Pay Items.
Syncing Deputy And Xero
First, please double-check that your employees’ Pay Rates are set to Automatic. The option to do so if you are connected in your Location Settings, as shown in the “Before You Start” settings.
You can see which employees are connected to Xero from the People page, by clicking “Show Fields” at the top of the list, then “Pay Rates”.
Please select each employee with the Xero icon next to their name, then click “Bulk Actions” at the top right hand corner of the list and click “Sync with Xero”. If one of the employees you have selected is not connected to Xero, this option will be greyed out.
Please note that if you re-sync the rates, you will also need to unapprove and re-approve your timesheets for the new rates to apply.
Common Xero Errors
Common Xero Errors
|Validation Exception Error||Possible: Leave names not matching between Deputy and Xero; Hire Date is after the start of the pay period.||
|Employees not found||Xero connection dropout OR name/email of employee doesn’t match between Xero and Deputy||Disconnect and reconnect to Xero via Location Settings|
|Invalid Leave Period||Xero pay calendar does not match with Deputy’s date range||Match pay period between Deputy and Xero|
|Timesheet is not a draft timesheet||Customer has approved timesheets in Xero||Revert timesheet to draft from Xero|
|Timesheet already exists/Timesheet cannot be overwritten||Employee has submitted timesheet in Xero||Decline and revert to draft in Xero and try the export again|
|Exporting wrong rates even AFTER re-syncing and reapproving||Employee is syncing to previous (discarded) employee profile in Xero||
|Superannuation error||No superannuation in employee’s template in Xero||Add superannuation in employee’s pay template in Xero|
|Scope not recognised||Xero account is from a country that we do not integrate with||Deputy only integrates with the US, UK and Australian iterations of Xero|