Skip to main content
All awards → Miscellaneous Award → Day Worker 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
  • Automatic allowance calculations where configured

​
Pay Rates and Smart Formula Rules

​
Classification Pay Rates

​
Calculation Rules

​
Worked Example

Input: Level 1 full-time employee, Monday 7:00 am–7:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.00 ordinary hours for this day pattern. The remaining 2.00 hours are assigned to overtime or penalty lines.

​
Classification Pay Rates

​
Calculation Rules

​
Worked Example

Input: Level 1 part-time employee, Monday 7:00 am–7:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.00 ordinary hours for this day pattern. The remaining 2.00 hours are assigned to overtime or penalty lines.

​
Classification Pay Rates

​
Calculation Rules

​
Worked Example

Input: Level 1 casual employee, Monday 7:00 am–7:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 10.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.
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 Miscellaneous Award rule set from the Award Library and select the Day Worker 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 20 Monday to Friday ordinary hours inside 7:00 am to 7:00 pm at the minimum hourly rate, with clause 20 outside-span penalties at 120% before 7:00 am and after 7:00 pm.
  • Saturday and Sunday ordinary-day work uses clause 20 all-day penalties at 120% and 150%.
  • Public holidays use clause 20 at 250%.
  • Overtime under clause 19.1 is 150% for the first 3 hours and 200% after 3 hours for time beyond the clause 13.5 10-hour daily ordinary cap or beyond an average of 38 hours per week; weekly overtime uses EVERY so Sunday hours count toward and can attract weekly OT, with PH weekly OT at higher priority on public holidays.
  • Casual loading is not paid on overtime (clause 11.1(b)), so casual OT multiples are 150%/125%=1.2 and 200%/125%=1.6 against the loaded casual base.
  • Casual outside-span, Saturday, and Sunday multiples are 145%/125%=1.16 and 175%/125%=1.4.
  • Casual public holiday remains 250% of the minimum hourly rate in MAPD (250%/125%=2.0), including casual PH daily and weekly OT.
  • The award has no shiftwork penalty schedule and no minimum break-between-shifts GAP obligation beyond meal breaks under clause 14.

​
Not Supported by This Rule Set

  • Agreement to work up to 12 ordinary hours on a day or shift
  • Junior, apprentice, trainee, and supported wage classifications
  • Time off instead of payment for overtime
  • Unpaid meal break timing and delayed meal break penalties
  • Variation of starting and finishing times by agreement or 7 days notice
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