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: Introductory Level full-time employee, Monday 6:00 am–6:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.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: Introductory Level part-time employee, Monday 6:00 am–6:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.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: Introductory Level casual employee, Monday 6:00 am–6:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.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 Gardening 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 13.2 ordinary hours: Monday-Friday 6:00 am-6:00 pm and Saturday 6:00 am-12:00 noon, max 10 ordinary hours per day (clause 13.3).
- Model a single Mon-Sat BASE (engine allows one BASE template); outside-spread overtime under clause 19.1/19.2 overrides with first-2 / after-2 tiers: Mon-Fri before 6:00 am and after 6:00 pm; Saturday before 6:00 am and after 12:00 noon.
- Sunday has no ordinary window, so whole-day Sunday OT uses first-2 / after-2 at 150%/200% (casual 175%/225% of the unloaded minimum → 1.4/1.8 against the loaded casual base).
- Daily overtime after 10 hours is scoped MON-SAT (days with ordinary hours).
- Weekly overtime after 38 hours is scoped MON-SAT; Sunday hours are already overtime via the Sunday OT rules.
- Public holidays are 250% of the ordinary hourly rate with a 4-hour minimum payment (clause 25.2); casual PH is MAPD 275% of the minimum (275%/125%=2.2).
- Clause 19.2 casual OT is 175% first 2 hours and 225% after of the ordinary hourly rate (loading already built into those percentages), so loaded-base multiples are 1.4 and 1.8.
- FULL_TIME/PART_TIME multiples remain award percentages of the unloaded minimum (150%/200%/250%).
- Minimum engagement: casual 3 hours (clause 11.1) day-scoped at the applicable day multiple (M-F/Sat ordinary 1.0; Sunday tiered 1.4 then 1.8 for the 3-hour top-up; PH 4 hours at 2.2).
- Public holiday 4-hour minimum payment applies to all employment types at 250%/2.2.
- Clause 19.6 call-back 4-hour minimum is excluded (requires call-back detection).
- Deputy GLSA article (No Water Restrictions sectors) aligns on Mon-Fri 6am-6pm / Sat 6am-noon ordinary, outside-spread first-2/after-2 bands, Sunday first-2/after-2 OT, weekly OT after 38 on Mon-Sat, 10-hour GAP for non-casuals, casual 3-hour ME, and PH 4-hour ME at 250%.
Not Supported by This Rule Set
- Call-back minimum of 4 hours
- Casual rest period after overtime / GAP
- Four-week averaging of ordinary hours and rostered days off
- Junior, apprentice, trainee, and supported wage classifications
- Paid morning rest break
- Part-time hours in excess of the written agreed pattern
- Time off instead of payment for overtime
- Transport after overtime work
- Unpaid meal break timing, overtime meal breaks, and delayed meal break penalties
- Water restriction ordinary hours outside the clause 13.2 spread at 150%
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 - MA000101
- Pay rates and allowances: Fair Work pay guides