1. Help Portal
  2. Using Deputy
  3. Payroll
  4. Xero Award Interpretation (Australia)

Xero Award Interpretation (Australia)

Updated on March 27, 2017

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][][]

To view more predefined pay template examples, please visit Xeroshare, where other Deputy users have uploaded their rates for you to view. You can copy the rates directly to your Xero account by selecting the rate and clicking “Deploy To Your Xero Account”.

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 Items, then “+Add Earnings Rate”.

Deputy: exporting to Xero
Xero Settings: Pay items > Earnings

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 a complete list rates, visit https://xeroshare.deputy.com

Syntax

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.

Number Ordering

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.

Day

  • MON
  • TUE
  • WED
  • THU
  • FRI
  • SAT
  • SUN
  • WEEKDAY
  • WEEKEND
  • 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.

Time

  • 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.

Min-Max

  • 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.

Tracking

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.

Advanced Scripts

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.

Examples

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.

Xero examples: pay template
Xero: Pay Templates (Hospitality Industry (General) Award (HIGA))

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][][]
Xero examples: pay template 2
Xero: Pay Templates (Restaurant Award)

Construction
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][][]
Xero examples: pay template 3
Xero: Pay Templates (Construction)

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.

Pay Rates: Handling > Automatic
Pay Rates: Handling > Automatic

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.

Deputy: Sync with Xero

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

Reason

Solutions

Validation Exception Error Possible: Leave names not matching between Deputy and Xero; Hire Date is after start of pay period.
  1. Check leave items in timesheets. These must match in Xero
  2. Pay rates have been changed? If so, re-sync and reapprove
  3. Leave names are identical between Deputy and Xero? If not, edit these from within Xero
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
  1. Turn off Auto-Sync
  2. Duplicate employee in Xero under history?
  3. Does employee share email in Xero with another?
  4. Email our developers to delete the employee’s Xero token (last resort option)
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

Watch A Video

Have any feedback for our Help Portal? Anything we can fix to improve your Help Portal visit? Fill in our Deputy Help Portal Feedback Form!

Can’t find what you’re looking for? Fill in our Deputy Help Documentation Request Form to leave any feedback or suggestions for our help documents.

comments powered by Disqus