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–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 6.00 ordinary hours for this day pattern. The remaining 4.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–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 6.00 ordinary hours for this day pattern. The remaining 4.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–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 6.00 ordinary hours for this day pattern. The remaining 4.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 Animal Care Award rule set from the Award Library and select the 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 (clause 13.2 ordinary span 6:00 am-9:00 pm Monday to Sunday): model M-Sat BASE with outside-spread OT before 6:00 am and after 9:00 pm split as MON-FRI and SAT rules so published priority beats BASE.
- Pre-spread (00:00-06:00) uses clause 20.1 first-3/after-3 tiers (150%/200%; casual 175%/225% → 1.4/1.8).
- Saturday ordinary hours after 1:00 pm use clause 21.1 first-3/after-3 penalties within 1:00 pm-9:00 pm.
- Daily OT after the clause 13.1(b) 10-hour ordinary shift cap is scoped MON-SAT with Sunday/PH daily OT at the day multiple.
- Weekly OT after 38 hours uses MON-SAT first-3/after-3 tiers plus Sunday/PH weekly lines.
- Public holidays are 250% with a 4-hour minimum payment (clause 27.2).
- Casual minimum engagement is 3 hours (clause 11.4) day-scoped at the applicable day multiple.
- Shiftworkers: clause 21.2 afternoon (finish after 8:00 pm) at 115% and night (majority midnight-8:00 am) at 130% are approximated as time-window rules.
- Weekend/PH ordinary shift rates follow clause 21.3 (150%/200%/250%; casual 175%/225%/275% → 1.4/1.8/2.2).
- Clause 20.1(a)(ii) shiftwork OT is outside ordinary hours or in excess of 8 hours (first 3 at 150%, after at 200%), paid instead of shift penalties - daily OT threshold is therefore 8 hours (not Deputy’s 10).
- Veterinary surgeons: clause 20.2 compensates hours above 38 at the ordinary time rate (multiple 1.0), with public holidays at 200% (MAPD casual PH 225% → 1.8 against the loaded casual base).
- Christmas Day Saturday/Sunday loading (clause 27.3(b)) is excluded.
- On-call duty/allowances are MANUAL only.
- Casual MULTIPLE lines are scoped to CASUAL and use (award % of minimum) / 1.25.
- FULL_TIME/PART_TIME multiples remain award percentages of the unloaded minimum.
- Deputy ACVSA article aligns on day-worker spread/OT tiers, Sunday 200%, Sat-after-1pm tiers, casual loaded multiples, PH 4-hour ME, shift loadings, and vet weekly extra hours at 1.0.
- MAPD parent category allowance rows with no amount are included as zero-value MANUAL keys for inventory coverage.
Not Supported by This Rule Set
- Averaging of ordinary hours over 28 days or an agreed roster cycle
- Christmas Day falling on Saturday or Sunday loading for veterinary surgeons
- Junior, intern, resident, trainee, and supported wage classifications
- Morning shift commence at or before 6.30 am loading
- Night shift majority-of-hours detection
- On-call / active on-call duty automation
- Return to duty minimum of 3 hours
- Special public holiday provisions for associates who normally work weekends
- Time off instead of payment for overtime
- Transfer to or from shiftwork notice and temporary overtime
- Unpaid meal break timing and paid rest breaks
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 - MA000118
- Pay rates and allowances: Fair Work pay guides