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 3 full-time employee, Monday 6:00 am–7:30 pm, 13.50 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.50 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 3 part-time employee, Monday 6:00 am–7:30 pm, 13.50 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.50 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 3 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 Restaurant Award rule set from the Award Library and select the Levels 3 to 6 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.2 Monday to Friday evening additives (10:00 pm to midnight and midnight to 6:00 am) are MAPD wage-allowance amounts and are published as MANUAL allowances rather than auto hour bands.
- Saturday and Sunday ordinary penalties follow Schedule B / Table 8 (Saturday 125%; Sunday 150% for full-time and part-time).
- Casual Saturday is 150% of the minimum (loaded-base multiple 1.2).
- Casual Sunday is 150% for Introductory to Level 2 (1.2) and 175% for Levels 3 to 6 (1.4).
- Public holidays are 225% full-time/part-time and 250% casual (loaded-base 2.0).
- Daily overtime uses the clause 15.1 11.5-hour ordinary cap for full-time/part-time and the clause 11.2 12-hour cap for casuals, with Table 7 day-scoped tiers (Mon-Fri 150%/200%, Saturday 175%/200%, Sunday 200%).
- Weekly overtime after 38 hours uses EVERY first-2 / after-2 tiers at the Monday-Friday Table 7 rates (150%/200%; casual 1.2/1.6), so Saturday weekly hours in the first 2 OT hours may be paid at 150% rather than 175%, and Sunday weekly hours in that band may be paid at 150% rather than 200%; Saturday/Sunday daily OT tiers remain day-correct.
- Public holiday weekly OT stays at 225%/200%.
- CASUAL base rates already include the 25% loading; casual MULTIPLE lines use award%/1.25 against that loaded base.
- Clause 23.2 rest after overtime is a single 8-hour GAP at a flat first-2-hours overtime multiple (150% / casual 1.2) rather than Deputy’s split first-2/after-2 GAP windows.
- Rostered-day-off overtime and the clause 23.1(e) 4-hour RDO minimum require roster metadata and are excluded.
Not Supported by This Rule Set
- Apprentice classifications and apprentice rates
- Averaging ordinary hours over roster cycles longer than one week
- Clause 15.1(e) 10-hour break between ordinary days
- Delayed meal break penalties
- Junior employee classifications and junior penalty tables
- Public holiday substitution by agreement
- Rostered day off overtime and 4-hour RDO minimum payment
- Supported wage system
- 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 - MA000119
- Pay rates and allowances: Fair Work pay guides