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 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: 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 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: Introductory 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 Clubs Award rule set from the Award Library and select the General 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 24.4 Monday to Friday evening additives (7:00 pm to midnight 4.42 per hour, pro-rata for a part hour) auto-apply as TOP_UP on ordinary Monday to Friday hours and do not stack on Saturday, Sunday, public holiday, or overtime hours (clause 24.5).
- Daily overtime uses the clause 15.3(a)/(b) 8-hour ordinary daily cap for full-time and part-time and the clause 11.4 12-hour cap for casuals.
- Clause 22.3 overtime is day-scoped: Monday to Friday 150% then 200%, Saturday 175% then 200%, Sunday 200%, public holiday 250%.
- Weekly overtime after 38 hours uses the same day-scoped 22.3 tiers.
- CASUAL base rates already include the 25% loading; casual MULTIPLE lines use award%/1.25 against that loaded base, and casual overtime uses clause 22.3 percentages of the unloaded minimum (11.4).
- Clause 22.5 10-hour rest after overtime is a single GAP at a flat first-2-hours overtime multiple (150% / casual 1.2) rather than split first-2/after-2 GAP windows or day-specific overtime rates.
- Maintenance and horticultural employees use clause 15.6 ordinary hours 6:00 am to 6:00 pm Monday to Friday and 6:00 am to 12:00 noon Saturday (maximum 8 ordinary hours Monday to Friday and 4 on Saturday).
- Saturday after noon and Sunday are paid at the higher of clause 24.2 and clause 22.3, so Saturday outside-span uses 175% and Sunday uses 200%.
- Outside-span Monday to Friday and Saturday time bands use a flat first-tier overtime multiple so the 2-hour overtime tier is not reset in multiple windows; daily overtime after 8 hours (Monday to Friday) or 4 hours (Saturday) supplies the after-2-hours 200% band on longer mixed shifts.
- Afternoon-only Saturday shifts longer than 2 hours may stay on the flat 175% band until daily overtime after 4 hours applies.
- Clause 19.2(b) first aid is all-purpose when appointed; it is published as a MANUAL allowance rather than baked into every base rate.
Not Supported by This Rule Set
- Accrued rostered days off including club manager RDO arrangements
- Apprentice classifications and apprentice rates
- Averaging ordinary hours over roster cycles longer than one week
- Casual bingo caller, assistant bingo caller, and fitness instructor minimum engagements
- Christmas Day weekend work when it is not a public holiday
- Clause 15.3(c) 9.5-hour days, 15.3(d) 7.6-hour days, and 15.5 21st-day overtime
- Club manager annualised salary and professional development leave
- Club manager recall to duty 1-hour overtime minimum
- Delayed meal break penalties and crib-break substitutions
- Higher duties
- Junior employee classifications and junior penalty tables
- Maintenance and horticultural paid tea and overtime crib breaks
- Maintenance span increase of up to one hour by agreement
- Make-up time
- Part-time 3-hour and 12-hour rostering limits
- Part-time overtime for hours in excess of rostered hours
- Public holiday substitution by agreement
- Public holiday work at 150% plus equivalent time or a substitute day
- Rostered day off overtime and 4-hour RDO minimum
- School-based apprentices and management trainees
- Supported wage system and national training wage
- Time off instead of payment for overtime
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 - MA000058
- Pay rates and allowances: Fair Work pay guides