Skip to main content
All awards → Legal Services Award → Continuous Shiftworker 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

​
Classification Pay Rates

​
Calculation Rules

​
Worked Example

Input: Level 1 - Clerical/admin full-time employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: UpSheets assigned these hours using the configured calculation rules for this employment type.

​
Classification Pay Rates

​
Calculation Rules

​
Worked Example

Input: Level 1 - Clerical/admin part-time employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: UpSheets assigned these hours using the configured calculation rules for this employment type.

​
Classification Pay Rates

​
Calculation Rules

​
Worked Example

Input: Level 1 - Clerical/admin casual employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.Why: UpSheets assigned these hours using the configured calculation rules for this employment type.

​
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.
This variant includes 7 manual allowances that must be entered separately when they apply. See Manual Allowances for amounts and conditions.

​
Manual Allowances

​
How to Use This Rule Set in UpSheets

  1. Copy the Legal Services Award rule set from the Award Library and select the Continuous Shiftworker variant during review.
  2. Assign the correct classification and employment type to each employee using this variant.
  3. Simulate representative shifts, then publish and assign the rule set to affected employees.

​
Assumptions and Limitations

​
Assumptions

  • Day workers use clause 13.1 Monday to Friday ordinary hours inside 7:00 am to 6:30 pm (no Saturday or Sunday ordinary).
  • Outside-span and weekend/public holiday work is overtime under clause 20.2: Monday to Saturday until 12:00 pm first 3 hours at 150% then 200%; Saturday after 12:00 pm and Sunday at 200% with a 3-hour minimum payment; public holidays at 250% with a 3-hour minimum.
  • Each day stands alone under clause 20.3(c).
  • There is no separate daily ordinary-hour cap; weekly overtime after an average of 38 hours uses the same first-3 / after-3 tiers, with public holiday weekly lines at 250%.
  • Casual minimum engagement is 4 hours per day engaged (clause 11.3), day-scoped at the applicable day multiple.
  • Non-continuous shiftworkers (other than continuous) use clause 21.3 afternoon/night 115%, early morning 110% (START_ONLY 5:00-6:00 am), permanent-night eligibility via the permanent-night variant at 130%, plus clause 21.4 Saturday 150% ordinary (not overridden by day-worker Saturday-after-noon OT), Sunday 200%, and public holiday 250%.
  • Overtime beyond a typical 8-hour shift uses clause 20.2(a) first-3 / after-3 tiers (start_hour 8.0).
  • Continuous shiftworkers use flat 200% overtime under clause 20.2(b) and 200% Sunday and public holiday substitution under clause 21.4(b)(i).
  • Non-successive afternoon/night 150%/200% tiers under clause 21.3 are not auto-detected.
  • Casual OT and shift percentages in clauses 20.2 / 21.3 already include loading (for example OT first 3 hours 175%, after / Sunday 225%, PH 275%).
  • Casual MULTIPLE lines are scoped to CASUAL and use (award % of minimum) / 1.25.
  • FULL_TIME/PART_TIME multiples remain award percentages of the unloaded minimum.
  • Deputy Help Centre has no dedicated Legal Services Award (MA000116 / LSA) article in the Australian awards library, so no Deputy pay-condition cross-check was available; Fair Work award text and MAPD are the sole sources.

​
Not Supported by This Rule Set

  • Agreement to reduce 10 hour break to 8 hours, and shiftworker 8 hour substitutions
  • Annualised wage arrangements
  • Automatic detection of continuous versus non-continuous shiftwork or permanent night eligibility
  • Averaging of ordinary hours over 28 days
  • Call-back and standing by
  • Junior, trainee, and supported wage classifications
  • Law graduate study leave
  • Make-up time
  • Non-successive afternoon or night shift penalties
  • One-hour movement of ordinary span by agreement
  • Overtime time rounding to the next 30 or 60 minutes
  • Part-time 3 hour minimum engagement
  • Pre-spread readiness work counted as ordinary hours
  • Public holiday shift major/minor portion allocation across midnight
  • RDO accrual and taking arrangements
  • Time off instead of payment for overtime
  • Unpaid meal break timing, delayed meal penalties, and overtime crib breaks
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