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
- Shift gap handling
Pay Rates and Smart Formula Rules
Full time
Full time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Electrical worker grade 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: Electrical worker grade 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: Electrical worker grade 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 Electrical Award rule set from the Award Library and select the 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 13.3 ordinary spread of 6:00 am to 6:00 pm Monday to Friday with an 8-hour daily ordinary cap under clause 13.7.
- Day workers use clause 20.3(a) four-hour minimum payments on Saturday, Sunday, and public holiday overtime.
- Non-continuous shiftworkers use clause 13.13 afternoon/night penalties at 115%, non-successive shift tiers at 150%/200%, and clause 13.16 overtime.
- Continuous shiftworkers use flat 200% overtime under clause 13.16(a)(i) and clause 13.15(a) public holiday substitution at 200%.
- Permanent night shiftworkers apply clause 13.13(d) at 130% on night windows.
- CASUAL base rates already include the 25% loading.
- Day-worker and most overtime/public-holiday MULTIPLE lines reuse full-time percentages because MAPD publishes those casual rates multiplicatively (for example PH 312.5% = 250% × 1.25).
- Afternoon/night and permanent-night shift penalties are additive in MAPD (140% / 155% of minimum), so casual-scoped MULTIPLE lines use 1.12 and 1.24 against the loaded casual base.
Not Supported by This Rule Set
- Apprentice, trainee, and supported wage classifications
- Automatic detection of continuous versus non-continuous shiftwork or permanent night eligibility
- Availability for duty
- Call-back minimums
- Living away allowance
- Multistorey allowance - 0 to 15 floors
- Multistorey allowance - 16 to 30 floors
- Multistorey allowance - 31 to 45 floors
- Multistorey allowance - 46 to 60 floors
- Multistorey allowance - more than 60 floors
- Percentage-based all-purpose allowances that vary by classification
- Rostered day off banking
- Rostered day off minimum payments
- Time off in lieu
- Towers allowance - construction over 15 metres in height
- Towers allowance - each further 15 metres
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 - MA000025
- Pay rates and allowances: Fair Work pay guides