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: Worker Level 1(a) - new entrant full-time employee, Monday 12:00 am–12:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: UpSheets assigned these hours using the configured calculation rules for this employment type.
Part time
Part time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Worker Level 1(a) - new entrant part-time employee, Monday 12:00 am–12:00 pm, 12.00 paid hours, with no weekly overtime already accrued.Why: UpSheets assigned these hours using the configured calculation rules for this employment type.
Casual
Casual
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 Plumbing Award rule set from the Award Library and select the Sprinkler Shift Short Notice 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
- Day workers use clause 15.2(c) ordinary spread of 7:00 am to 6:00 pm Monday to Friday with an 8-hour daily ordinary cap.
- Saturday and Sunday are outside ordinary hours.
- PMS overtime follows Schedule C / MAPD Monday-to-Saturday tiers (150% first 2 hours; 200% after 2 hours, after 12:00 pm Saturday, and for work commenced after midnight before ordinary hours), Sunday 200%, and public holiday 250%.
- Sprinkler overtime follows Schedule D / MAPD Monday-to-Friday 150%/200% tiers with flat 200% Saturday and Sunday overtime.
- Regular shiftworkers use clause 23.1(a) 133% Monday to Friday when 5 or more consecutive shifts are worked with at least 48 hours notice; short-notice shiftworkers use clause 23.1(b) 150%/200% Monday to Friday tiers.
- Minimum payments follow clauses 12.2 and 22.1(b)-(c): casual Monday to Friday 3 hours, Saturday 3 hours, Sunday and public holiday 4 hours, with top-up multiples aligned to the applicable day rate (PMS Saturday ME is tiered 150%/200%).
- CASUAL base rates include the 25% loading.
- Casual MULTIPLE lines are scoped to CASUAL and use MAPD casual percentages of the unloaded minimum divided by 1.25 (175%->1.4, 225%->1.8, 275%->2.2, shift 158%->1.264).
- FULL_TIME/PART_TIME multiples use the unloaded award percentages.
- Tradesperson PMS rates use the registered State-legislation MAPD ordinary hourly table.
- AT1 (Advanced tradesperson Level 1) uses Schedule D ordinary hourly $36.40 because MAPD ordinary-hourly pay-rates omit that classification while Schedule D publishes it.
Not Supported by This Rule Set
- Apprentice, trainee, and supported wage classifications
- Automatic detection of consecutive-shift or 48-hour-notice eligibility
- Call-back minimum engagements
- Daily hire employees
- Early start agreements moving the ordinary spread
- Fire sprinkler on-call stand-by automation
- Release-and-pay ordinary time during enforced rest, and 20-hour continuous work / 12-hour break
- Rostered day off accrual and banking
- 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 - MA000036
- Pay rates and allowances: Fair Work pay guides