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
Full time
Full time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Assistant Level 1 full-time employee, Monday 8:00 am–10:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.00 ordinary hours for this day pattern. The remaining 3.00 hours are assigned to overtime or penalty lines.
Part time
Part time
Classification Pay Rates
Calculation Rules
Worked Example
Input: Assistant Level 1 part-time employee, Monday 8:00 am–10:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.00 ordinary hours for this day pattern. The remaining 3.00 hours are assigned to overtime or penalty lines.
Casual
Casual
Classification Pay Rates
Calculation Rules
Worked Example
Input: Assistant Level 1 casual employee, Monday 8:00 am–10:00 pm, 14.00 paid hours, with no weekly overtime already accrued.Why: This variant allows up to 11.00 ordinary hours for this day pattern. The remaining 3.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 Pharmacy Award rule set from the Award Library and select the Adult 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
- Ordinary hours may be worked on any day between 7:00 am and midnight with a 12-hour daily cap and 38 ordinary hours per week (clauses 13.1, 13.3, 13.4).
- Monday to Friday 8:00 am to 7:00 pm is BASE.
- Clause 22 time-of-day ordinary penalties apply inside the span: Monday to Friday 7:00 am to 8:00 am at 150%, 7:00 pm to 9:00 pm at 125%, and 9:00 pm to midnight at 150%; Saturday 7:00 am to 8:00 am at 200%, 8:00 am to 6:00 pm at 125%, 6:00 pm to 9:00 pm at 150%, and 9:00 pm to midnight at 175%; Sunday 7:00 am to 9:00 pm at 150% and 9:00 pm to midnight at 200%; public holidays 7:00 am to midnight at 225%.
- Hours between midnight and 7:00 am are overtime under clause 21.2(d): Monday to Saturday first 2 hours at 150% then 200%, Sunday all at 200%, and public holidays at 250%.
- Daily overtime after 12 hours uses the same Table 5 tiers (Mon-Sat first 2 / after 2, Sunday 200%, public holiday 250%).
- Weekly overtime after 38 hours uses Mon-Sat first 2 / after 2, Sunday 200%, and public holiday 250%.
- CASUAL base rates already include the 25% loading.
- Casual ordinary penalties use MAPD rates inclusive of casual loading divided by 1.25 (for example Monday to Friday morning 175%/125%=1.4, evening 150%/125%=1.2, Saturday 8:00 am to 6:00 pm 150%/125%=1.2, Sunday 7:00 am to 9:00 pm 175%/125%=1.4, public holiday 250%/125%=2.0).
- Clause 21.4(c) provides that casual loading is not payable on overtime, so casual OT multiples are 150%/125%=1.2, 200%/125%=1.6, and 250%/125%=2.0 rather than stacking a further 25% on the overtime percentage.
- The award has no paid minimum-break-between-shifts GAP obligation beyond meal and rest breaks under clause 15.
Not Supported by This Rule Set
- Annualised wage arrangements for pharmacist and pharmacy assistant level 4
- Averaging 76 ordinary hours over 2 consecutive weeks
- Junior pharmacy assistant levels 1 and 2
- Moving expenses and transport reimbursement
- National training wage / trainees
- On-premise meal allowance for pharmacists
- Overtime for non-continuous hours or hours outside clause 14 rostering arrangements
- Part-time hours in excess of the written agreed pattern
- School-student 2-hour minimum engagement
- Supported wage system
- Time off instead of payment for overtime
- Unpaid meal and rest break timing
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 - MA000012
- Pay rates and allowances: Fair Work pay guides