UpSheets uses this Smart Formula to turn imported start and finish times into ordinary hours, overtime, weekend, public-holiday and allowance lines ready for Xero Payroll.
Review the assumptions and limitations before publishing this formula.
Use this formula in UpSheets
Step-by-step guide to copy, review, simulate, publish, and assign an Award Library formula.
What UpSheets Calculates Automatically
- Ordinary hours from imported start and finish times
- Overtime tiers based on hours worked
- Saturday penalty and overtime rates
- Sunday penalty and overtime rates
- Public holiday penalty rates
- Minimum engagement payments
- Automatic allowance calculations where configured
Pay Rates and Smart Formula Rules
Full time
Full time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Introductory full-time employee, Monday 6:00 am–7:30 pm, 13.50 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.50 ordinary hours for this day pattern. The remaining 2.00 hours are assigned to overtime or penalty lines.
Part time
Part time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Introductory part-time employee, Monday 6:00 am–7:30 pm, 13.50 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.50 ordinary hours for this day pattern. The remaining 2.00 hours are assigned to overtime or penalty lines.
Casual
Casual
Classification Pay Rates
Calculation Rules
Worked Example
Input: Introductory casual employee, Monday 6:00 am–8:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 12.00 ordinary hours for this day pattern. The remaining 2.00 hours are assigned to overtime or penalty lines.
What Requires Customer Configuration
- Variant assignment: Choose the Smart Formula variant that matches each employee’s work pattern.
- Classification selection: Assign the correct classification level for each employee.
- Public holidays: Configure public holidays for your organisation so public-holiday rules apply on the correct dates.
Manual Allowances
How to Use This Rule Set in UpSheets
- Copy the Hospitality Award rule set from the Award Library and select the Adult variant during review.
- Assign the correct classification and employment type to each employee using this variant.
- Simulate representative shifts, then publish and assign the rule set to affected employees.
Assumptions and Limitations
Assumptions
- Clause 29.2 Monday to Friday evening additives (7:00 pm to midnight 4.42 per hour or part thereof) auto-apply as TOP_UP allowances on ordinary hours in those windows, rounded up to the next whole hour.
- They do not apply to Saturday, Sunday, public holiday, or overtime hours.
- Saturday and Sunday are ordinary days at Table 14 penalties (Saturday 125% full-time/part-time and 150% casual; Sunday 150% full-time/part-time and 175% casual).
- Public holidays are 225% full-time/part-time and 250% casual.
- Daily overtime uses the clause 15.1 / 15.2 11.5-hour ordinary cap for full-time/part-time and the clause 11.2 12-hour cap for casuals.
- Weekly overtime after 38 hours uses Monday to Friday first-2 / after-2 tiers (150%/200%) and a flat 200% Saturday/Sunday band from 38 hours, matching Table 13 day scopes.
- Public holiday hours over the daily or weekly cap stay at Table 14 public holiday percentages (225%/250%) because Table 13 has no public holiday overtime row and clause 29.3 pays the highest applicable rate.
- CASUAL base rates already include the 25% loading; casual MULTIPLE lines use award%/1.25 against that loaded base (Saturday 1.2, Sunday 1.4, PH 2.0, OT first 2 hours 1.2, OT after / weekend OT 1.6).
- Junior casual bases are the loaded adult casual rate multiplied by the Table 5 age percentage.
- Split shift allowances are scoped to full-time and part-time per clause 26.14(a).
- Clause 13.5 liquor-service juniors must be paid as adult; assign the Adult variant.
Not Supported by This Rule Set
- Annualised wage arrangements
- Apprentice classifications and apprentice rates
- Averaging arrangements with 8-hour daily overtime or more than 20 days in 4 weeks
- Casino gaming stream classifications and rates
- Clause 15.2(e) 10-hour break between ordinary days and 8-hour roster changeover
- Junior office employee classifications
- Loaded rates
- Managerial staff (Hotels)
- Part-time overtime for hours in excess of rostered hours
- Public holiday substitution by agreement
- Public holiday time-off instead of 225% and Christmas Day weekend arrangements
- Rostered day off or accrued day off overtime and 4-hour minimum
- Supported wage system
- Time off instead of payment for overtime
- Unpaid meal and rest break timing and delayed meal break penalty
Need one of these scenarios? Contact us to discuss your requirements. Some may be supported through configuration, a custom Smart Formula, or an extension to the Award Library.
This is general information about how UpSheets has configured this award rule set. It is not legal or payroll advice. You are responsible for ensuring your employees are paid correctly.
Official sources
- Award text: Fair Work Commission - MA000009
- Pay rates and allowances: Fair Work pay guides