Smart Formulas

What are Smart Formulas?

Smart Formulas can be used to calculate earnings rates based on the dates and times worked by an employee.

They can calculate different rates for such things as:

  • different times of the day
  • daily overtime
  • weekly overtime
  • minimum shift engagement
  • split shifts
  • public holidays
  • breaks

Enabling Smart Formulas

Option 1: Custom Smart Formulas Sourced from Xero

This option lets you define your pay items in Xero with a specific format that describes the rules and apply them to employees via their pay template.

For more information and setup, please see these instructions

Option 2: Pre-defined Smart Formulas Sourced from UpSheets

This option lets you select pre-defined Smart Formulas and assign them to your employees from within UpSheets. It updates the employee pay template and creates the required pay items in Xero automatically.

This functionality is currently in development and a limited number of awards are available:

  • AERA - Amusement, Events, and Recreation Award (MA000080) (Casual)
  • CleanA - Cleaning Award (MA000022)
  • FFIA - Fast Food Industry Award (MA000003)
  • HBIA - Hair and Beauty Industry Award (MA000005)
  • HIGA - Hospitality Industry General Award (MA000009)
  • HPSSA - Health Professionals and Support Services Award (MA000027) (Private Medical, Dental & Pathology)
  • MiscA - Miscellaneous Award (MA0000104)
  • RIA - Restaurant Industry Award (MA000119) (Casual)
  • RTDA Road Transport and Distribution Award (MA000038) (Casual)
  • SCHADS - Social, Community, Home Care and Disability Services Industry Award (MA000100) (Home Care)
  • SPOA - Sporting Organisations Award (MA000082)

Click here to request the addition of a new award to the Smart Formula library

For more information and setup, please see these instructions

Availability

SMART FORMULAS ARE CURRENTLY AVAILABLE IN AUSTRALIA ONLY

Please contact us if you need this in the UK/NZ