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
- Shift gap handling
- Automatic allowance calculations where configured
Pay Rates and Smart Formula Rules
Full time
Full time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Level 1 full-time employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 8.00 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: Level 1 part-time employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 8.00 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: Level 1 casual employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 8.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 Food Manufacturing Award rule set from the Award Library and select the Non-Continuous Shiftworker 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
- Day workers use clause 12.2 Monday to Friday ordinary hours inside 6:00 am to 6:00 pm with an 8-hour daily ordinary cap.
- Default modelling treats Saturday and Sunday as outside ordinary hours (weekend ordinary under clause 12.2(c)/(f) is excluded), so Saturday uses clause 23.4 whole-day overtime tiers (150% first 3 hours, 200% after) with a 4-hour minimum payment, Sunday uses clause 23.5 at 200% with a 3-hour minimum, and public holidays use 250% with a 3-hour minimum under clauses 12.2(g) and 23.6(a).
- Monday to Friday outside-spread and daily overtime use clause 23.2 first-3 / after-3 tiers.
- Non-continuous shiftworkers use clause 24.3 early-morning 112.5% (START_ONLY 03:00-05:59), afternoon/night 115%, plus night-start START_ONLY to 02:59 so inclusive start-window matching does not collide with early morning, plus clause 23.2 overtime tiers and clause 24.4/24.5 weekend and public holiday substitution rates.
- Continuous shiftworkers use flat 200% overtime under clause 23.3 and 200% Sunday/public holiday substitution under clause 24.5(a).
- Permanent night shiftworkers apply clause 24.3(d) at 130% with START_ONLY before END_ONLY night windows.
- Clause 10.4 applies casual penalty, overtime, and shift loadings to the casual ordinary hourly rate, and MAPD casual tables match those percentages of the loaded base, so casual MULTIPLE lines reuse the same multiples as full-time/part-time (not award%/1.25).
- Casual minimum engagement under clause 10.5 defaults to 4 consecutive hours.
Not Supported by This Rule Set
- Agreement to reduce 10 hour break to 8 hours, and shiftworker 8 hour substitutions
- Apprentice, trainee, junior, and supported wage classifications
- Automatic roster continuity and shift-type detection
- Baking production early-morning start variation
- Call-back and standing-by minimums
- Make up time
- Non-continuous afternoon or night shift not continuing rates
- Rest break during overtime meal arrangements beyond GAP
- Spread of hours moved by agreement
- Time off instead of payment for overtime
- Weekend ordinary hours by agreement for day workers
- Work on shifts other than rostered shifts
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 - MA000073
- Pay rates and allowances: Fair Work pay guides