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
- 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 6:00 am–5: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 6:00 am–5: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 6:00 am–5: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.
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 General Retail Award rule set from the Award Library and select the Baking Production 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
- Default day-worker ordinary hours follow clause 15.1 Table 2: Monday to Friday 7:00 am to 9:00 pm, Saturday 7:00 am to 6:00 pm, and Sunday 9:00 am to 6:00 pm, with a 9-hour daily ordinary cap (clause 15.4) and 38 ordinary hours per week.
- Monday to Friday 7:00 am to 6:00 pm is BASE.
- Clause 22 Table 12 ordinary penalties apply inside the span: Monday to Friday 6:00 pm to 9:00 pm at 125%, Saturday 7:00 am to 6:00 pm at 125%, Sunday 9:00 am to 6:00 pm at 150%, and public holiday ordinary hours at 225% using the weekday 7:00 am to 9:00 pm span.
- Hours outside the Table 2 span are overtime under clause 21.2(a): Monday to Saturday first 3 hours at 150% then 200%, Sunday all at 200%, and public holidays at 250%.
- Monday to Friday after 9:00 pm is a 3-hour window, so that band is first-3 overtime only; hours after midnight are the next day’s pre-spread overtime.
- Daily overtime after 9 hours uses the same Table 11 tiers.
- Weekly overtime after 38 hours uses Monday to Saturday first 3 / after 3, Sunday 200%, and public holiday 250%.
- CASUAL base rates already include the 25% loading.
- Table 11 and Table 12 casual percentages are inclusive of that loading, so casual MULTIPLE lines are those percentages divided by 1.25 (for example evening and Saturday 150%/125%=1.2, Sunday ordinary 175%/125%=1.4, public holiday ordinary 250%/125%=2.0, OT first 3 hours 175%/125%=1.4, OT after / Sunday OT 225%/125%=1.8, PH OT 275%/125%=2.2).
- Clause 16.6 requires 12 consecutive hours between work periods at 200% of the minimum hourly rate; casual GAP uses 200%/125%=1.6 against the loaded casual base.
- Baking Production uses clause 25.2 START_ONLY early-morning 112.5% (2:00 am to before 6:00 am) and night 130% (midnight to before 2:00 am) instead of weekday shiftwork, with the same weekend, public holiday, daily, weekly, ME, and GAP structure.
- All 10 operative MAPD allowances are modelled as MANUAL rate keys.
Not Supported by This Rule Set
- Agreement to reduce the 12 hour break to 10 hours
- Automatic detection of baking versus other shiftwork
- Averaging 76, 114, or 152 ordinary hours and RDO cycles
- Full-time 5-day 7.6 hour roster as the daily overtime trigger
- Junior, apprentice, trainee, and supported wage classifications
- Late-trading ordinary hours until 11:00 pm
- Newsagency ordinary hours from 5:00 am
- One day of 11 ordinary hours per week
- Part-time hours in excess of guaranteed hours inside the span
- Public holiday span following Sunday Table 2 hours
- Public holiday time off or annual leave instead of the additional 125%
- Recall to work 3-hour minimum
- School-student 1.5 hour casual minimum engagement
- Shared first-3 overtime bucket across pre-span, post-span, and daily excess on the same day
- Six-day week in one week of a two-week cycle
- Time off instead of payment for overtime
- Unpaid meal and rest break timing
- Video shop ordinary hours until midnight
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 - MA000004
- Pay rates and allowances: Fair Work pay guides