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: Level 1 full-time employee, Monday 7:00 am–6:00 pm, 11.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 9.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 7:00 am–6:00 pm, 11.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 9.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 7:00 am–7:30 pm, 12.50 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.50 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 Hair and Beauty 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
- Full-time and part-time ordinary hours follow clause 14.4 spans (Monday to Friday 7:00 am to 9:00 pm, Saturday 7:00 am to 6:00 pm, Sunday 10:00 am to 5:00 pm) with a default daily ordinary cap of 9 hours under clause 14.7.
- Saturday ordinary hours inside the span use clause 23.1 at 133%.
- Full-time and part-time work outside the clause 14.4 span is overtime under clause 22.2(b)/22.3(b): Monday to Friday before 7:00 am uses first-3 / after-3 tiers at 150%/200%, Monday to Friday after 9:00 pm uses a flat 150% band (the 9:00 pm to midnight window is only 3 hours so an after-3 tier cannot fire), and Saturday before 7:00 am / after 6:00 pm use first-3 / after-3 tiers.
- Casual ordinary Monday to Friday inside 7:00 am to 9:00 pm uses the loaded base.
- Casual outside-span ordinary penalties under clause 23.2 are 150% of the minimum hourly rate (loaded-base multiple 1.2) on Monday to Friday before 7:00 am / after 9:00 pm and on Saturday before 7:00 am / after 6:00 pm; Saturday inside span is 158% (1.264); Sunday any time and public holidays are 225% and 250% (1.8 and 2.0).
- Casual overtime under clause 22.4/22.5 uses a 10.5-hour daily cap and 38-hour weekly threshold with Mon-Sat first-3 / after-3 multiples 175%/225% (1.4/1.8); Sunday/PH overtime at 225%/250% (1.8/2.0) is covered by the all-day Sunday/PH rates plus PH weekly OT.
Not Supported by This Rule Set
- Agreement to roster 10.5 ordinary hours on one or two days per week
- Breaks between shifts (12 hours)
- Junior, apprentice, trainee, graduate, and supported wage classifications
- Part-time hours in excess of the written agreed pattern
- Rostered day off work and 4-hour minimum payment
- Six-day week / consecutive days-off roster constraints
- Time off instead of payment for overtime
- Unpaid meal and rest break timing
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 - MA000005
- Pay rates and allowances: Fair Work pay guides