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: C14 / V1 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: C14 / V1 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: C14 / V1 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 Manufacturing Award rule set from the Award Library and select the Day Worker 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
- CASUAL base rates already include the award 25% loading.
- Clause 11.1(d) and 32.1(f) apply penalty, overtime, and shift loadings to the casual ordinary hourly rate, so casual MULTIPLE lines reuse the same multiples as full-time/part-time (not award%/1.25).
- Day workers use clause 17.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 17.2(c)/(g) is excluded), so Saturday uses clause 32.5 whole-day overtime tiers (150% first 3 hours, 200% after) with a 4-hour minimum payment, Sunday uses clause 32.6 at 200% with a 3-hour minimum, and public holidays use 250% with a 3-hour minimum under clauses 17.2(h), 32.7(a) and 33.1(b).
- Monday to Friday outside-spread and daily overtime use clause 32.2 first-3 / after-3 tiers.
- Weekly overtime after 38 hours uses the same first-3 / after-3 tiers on EVERY so Sunday hours count.
- Non-continuous shiftworkers use clause 33.2 afternoon END_ONLY finish after 6:00 pm at or before midnight at 115%, night END_ONLY finish after midnight at or before 8:00 am at 115%, Saturday ordinary 150%, Sunday 200%, public holiday 250%, plus clause 32.2 overtime tiers.
- Continuous shiftworkers use the same afternoon/night detection with Saturday 150%, Sunday/public holiday 200% under clause 33.2(j)(i), and flat 200% overtime under clause 32.4(a).
- Permanent night shiftworkers apply clause 33.2(f) at 130% on night END_ONLY windows and otherwise follow the non-continuous overtime and weekend/PH structure.
- Clause 32.12 less than 10 consecutive hours between duties is a single GAP rule at flat 200%.
- Casual minimum engagement under clause 11.2 is 4 hours Monday to Friday at ordinary; weekend/PH minima are satisfied by the higher Sat/Sun/PH ME lines.
- Part-time minimum engagement under clause 10.2 is 4 consecutive hours Monday to Friday at ordinary.
- Choosing Day Worker versus shift variants remains a manual assignment; afternoon versus night within a shift variant is detected via END_ONLY finish windows.
- Float glass furnace repair, Supervisor/Trainer/Coordinator Technical, and underground mine work are percentage-of-rate allowances stored as 0 for manual application.
Not Supported by This Rule Set
- Agreement to reduce 10 hour break to 8 hours, and shiftworker 8 hour substitutions
- Agreement to work more than 8 ordinary hours or 12 hour days or shifts
- Apprentice, trainee, junior, cadet, and supported wage classifications
- Call-back and standing-by minimums
- Day Worker versus shift variant assignment
- Delayed meal break penalties
- Make up time
- Non-successive afternoon or night shift rates
- Plant readiness work before the spread counted as ordinary hours
- Spread of hours moved by up to one hour by agreement
- Time off instead of payment for overtime
- Unrelieved shiftwork on a rostered day off
- Vehicle manufacturing Part 9 hours, shift, and 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 - MA000010
- Pay rates and allowances: Fair Work pay guides