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
- 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: General hand full-time employee, Monday 6:00 am–8:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 12.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: General hand part-time employee, Monday 6:00 am–8:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 12.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: General hand casual employee, Monday 6:00 am–8:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 12.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 Amusement and Events Award rule set from the Award Library and select the Exhibition 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
- Sunday ordinary work uses clause 20.6 at 150% (casual loaded-base multiple 175%/125%=1.4).
- Public holidays use 250% (casual 275%/125%=2.2).
- Default daily ordinary caps are clause 13.2 eight hours for full-time/part-time and clause 11.3 ten hours for casuals; agreements to average up to 10 or 12 ordinary hours a day are not auto-detected.
- Daily overtime is first 3 hours then double time against those caps (casual OT multiples 150%/125%=1.2 and 200%/125%=1.6).
- Weekly overtime uses the same first-3 / after-3 tiers after 38 hours.
- Public holiday daily and weekly overtime stay at the PH multiple with start_hour matching the daily cap (8 FT/PT, 10 casual) or 38 weekly.
- Clause 20.4 less than 10 consecutive hours between duties is a single GAP rule at flat 200% (casual 200%/125%=1.6), not tiered relevant OT.
- Sunday and public holiday minimum payments are 4 hours (clause 20.6(c) / PH).
- Casual minimum engagement of 3 hours (clause 11.6) is day-scoped ME on Monday to Saturday at ordinary; Sunday/PH casual 3-hour minima are satisfied by the 4-hour Sun/PH ME lines.
- Part-time minimum 3 hours (clause 10.5) is ME PART_TIME Monday to Saturday at ordinary.
- Exhibition employees use EVERY ordinary BASE with no Sunday penalty, public holiday 200% (casual 200%/125%=1.6), daily OT after 12 hours at 200% (casual 1.6), and FT/PT weekly OT after 56 hours at 200%; casual exhibition has no weekly OT in MAPD.
- Exhibition minimum engagement is 4 hours per shift (clause 13.6) at ordinary, with PH ME at the PH multiple.
- Exhibition excludes GAP and Sunday penalty under clause 20.7(a).
- All 21 MAPD wage/expense allowances are MANUAL in every variant with unique hourly/weekly rate_keys.
Not Supported by This Rule Set
- Agreements to work up to 10 or 12 ordinary hours on a day
- Clause 20.4 rest-period gap paid at the relevant overtime rate in tiers
- Exhibition fortnightly overtime after 76 hours in a fortnight
- Junior, apprentice, trainee, and supported wage classifications
- Rostered day off falling on a public holiday and unscheduled RDO work
- Time off instead of payment for overtime
- Unpaid meal break timing and delayed meal break penalties
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 - MA000080
- Pay rates and allowances: Fair Work pay guides