> ## Documentation Index
> Fetch the complete documentation index at: https://upsheets.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Children's Services Award Shiftworker Rates and Overtime 2026/27

> 2026/27 MA000120 shiftworker pay rates, overtime, weekend and public-holiday rules, classifications and allowances, and how UpSheets applies them in Xero Payroll.

[All awards](/docs/smart-formulas/award-library/awards/overview) → [Children's Services Award](/docs/smart-formulas/award-library/awards/childrena/overview) → Shiftworker

|                          |                                                                                      |
| ------------------------ | ------------------------------------------------------------------------------------ |
| **Award**                | [Children's Services Award](/docs/smart-formulas/award-library/awards/childrena/overview) |
| **Official name**        | Children's Services Award 2010                                                       |
| **Variant**              | Shiftworker                                                                          |
| **Rates effective from** | 1 July 2026                                                                          |
| **Version**              | 1                                                                                    |

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](#assumptions-and-limitations) before publishing this formula.

<Card title="Use this formula in UpSheets" icon="copy" href="/docs/smart-formulas/award-library/overview">
  Step-by-step guide to copy, review, simulate, publish, and assign an Award Library formula.
</Card>

## 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

<AccordionGroup>
  <Accordion title="Full time">
    ### Classification Pay Rates

    | Classification                  | Code  | Classification minimum |
    | ------------------------------- | ----- | ---------------------- |
    | Level 1 - Introductory Educator | CSE1  | \$28.81                |
    | Level 2 - Educator              | CSE2  | \$29.69                |
    | Level 3 - Qualified Educator    | CSE3  | \$32.47                |
    | Level 4 - Experienced Educator  | CSE4  | \$34.65                |
    | Level 5 - Advanced Educator     | CSE5  | \$36.57                |
    | Level 6 - Room Leader           | CSE6  | \$38.25                |
    | Level 7 - Assistant Director    | CSE7  | \$40.00                |
    | Level 8 - Director              | CSE8  | \$46.12                |
    | Support Worker Level 1.1        | SW1.1 | \$26.44                |
    | Support Worker Level 2.1        | SW2.1 | \$26.93                |
    | Support Worker Level 2.2        | SW2.2 | \$27.82                |
    | Support Worker Level 3.1        | SW3.1 | \$29.45                |

    ### Calculation Rules

    | Rule                            | Conditions                                     | Value                  | Notes |
    | ------------------------------- | ---------------------------------------------- | ---------------------- | ----- |
    | Ordinary                        | EVERY                                          | Classification minimum | -     |
    | Sat x1.5                        | SAT                                            | x1.5                   | -     |
    | Sun x2                          | SUN                                            | x2                     | -     |
    | M-F 12am-8am Night x1.175       | MON-FRI<br />00:00-08:00<br />Shift end only   | x1.175                 | -     |
    | M-F 5am-6am Early Morning x1.1  | MON-FRI<br />05:00-06:00<br />Shift start only | x1.1                   | -     |
    | M-F 6:30pm-12am Afternoon x1.15 | MON-FRI<br />18:30-00:00<br />Shift end only   | x1.15                  | -     |
    | PH x2.5                         | PH                                             | x2.5                   | -     |
    | M-Sat OT \< 2Hr x1.5            | MON-SAT<br />Hours 8-10<br />OT 0-2 hours      | x1.5                   | -     |
    | M-Sat OT > 2Hr x2               | MON-SAT<br />Hours 10-24<br />OT 0-14 hours    | x2                     | -     |
    | PH Daily OT x2.5                | PH<br />Hours 0-24                             | x2.5                   | -     |
    | OT \< 2Hr x1.5                  | EVERY<br />Hours 38-40<br />Weekly             | x1.5                   | -     |
    | OT > 2Hr x2                     | EVERY<br />Hours 40-168<br />Weekly            | x2                     | -     |
    | PH Weekly OT x2.5               | PH<br />Hours 38-168<br />Weekly               | x2.5                   | -     |
    | Less than 10 Hr Break x1.5      | EVERY                                          | x1.5                   | -     |
    | Sat Min Engagement x1.5         | SAT<br />OT 0-4 hours                          | x1.5                   | -     |
    | Sun Min Engagement x2           | SUN<br />OT 0-4 hours                          | x2                     | -     |
    | PH Min Engagement x2.5          | PH<br />OT 0-4 hours                           | x2.5                   | -     |

    ### Worked Example

    Input: Level 1 - Introductory Educator full-time employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.

    | UpSheets output                        | Hours | Rate                |
    | -------------------------------------- | ----- | ------------------- |
    | M-F 5am-6am 5am-6am Early Morning x1.1 | 10.00 | 1.1 × ordinary rate |
    | M-Sat OT \< 2Hr x1.5                   | 2.00  | 1.5 × ordinary rate |

    Why: UpSheets assigned these hours using the configured calculation rules for this employment type.
  </Accordion>

  <Accordion title="Part time">
    ### Classification Pay Rates

    | Classification                  | Code  | Classification minimum |
    | ------------------------------- | ----- | ---------------------- |
    | Level 1 - Introductory Educator | CSE1  | \$28.81                |
    | Level 2 - Educator              | CSE2  | \$29.69                |
    | Level 3 - Qualified Educator    | CSE3  | \$32.47                |
    | Level 4 - Experienced Educator  | CSE4  | \$34.65                |
    | Level 5 - Advanced Educator     | CSE5  | \$36.57                |
    | Level 6 - Room Leader           | CSE6  | \$38.25                |
    | Level 7 - Assistant Director    | CSE7  | \$40.00                |
    | Level 8 - Director              | CSE8  | \$46.12                |
    | Support Worker Level 1.1        | SW1.1 | \$26.44                |
    | Support Worker Level 2.1        | SW2.1 | \$26.93                |
    | Support Worker Level 2.2        | SW2.2 | \$27.82                |
    | Support Worker Level 3.1        | SW3.1 | \$29.45                |

    ### Calculation Rules

    | Rule                            | Conditions                                     | Value                  | Notes |
    | ------------------------------- | ---------------------------------------------- | ---------------------- | ----- |
    | Ordinary                        | EVERY                                          | Classification minimum | -     |
    | Sat x1.5                        | SAT                                            | x1.5                   | -     |
    | Sun x2                          | SUN                                            | x2                     | -     |
    | M-F 12am-8am Night x1.175       | MON-FRI<br />00:00-08:00<br />Shift end only   | x1.175                 | -     |
    | M-F 5am-6am Early Morning x1.1  | MON-FRI<br />05:00-06:00<br />Shift start only | x1.1                   | -     |
    | M-F 6:30pm-12am Afternoon x1.15 | MON-FRI<br />18:30-00:00<br />Shift end only   | x1.15                  | -     |
    | PH x2.5                         | PH                                             | x2.5                   | -     |
    | M-Sat OT \< 2Hr x1.5            | MON-SAT<br />Hours 8-10<br />OT 0-2 hours      | x1.5                   | -     |
    | M-Sat OT > 2Hr x2               | MON-SAT<br />Hours 10-24<br />OT 0-14 hours    | x2                     | -     |
    | PH Daily OT x2.5                | PH<br />Hours 0-24                             | x2.5                   | -     |
    | OT \< 2Hr x1.5                  | EVERY<br />Hours 38-40<br />Weekly             | x1.5                   | -     |
    | OT > 2Hr x2                     | EVERY<br />Hours 40-168<br />Weekly            | x2                     | -     |
    | PH Weekly OT x2.5               | PH<br />Hours 38-168<br />Weekly               | x2.5                   | -     |
    | Less than 10 Hr Break x1.5      | EVERY                                          | x1.5                   | -     |
    | Sat Min Engagement x1.5         | SAT<br />OT 0-4 hours                          | x1.5                   | -     |
    | Sun Min Engagement x2           | SUN<br />OT 0-4 hours                          | x2                     | -     |
    | M-F Part-Time ME x1             | MON-FRI<br />OT 0-2 hours                      | x1                     | -     |
    | PH Min Engagement x2.5          | PH<br />OT 0-4 hours                           | x2.5                   | -     |

    ### Worked Example

    Input: Level 1 - Introductory Educator part-time employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.

    | UpSheets output                        | Hours | Rate                |
    | -------------------------------------- | ----- | ------------------- |
    | M-F 5am-6am 5am-6am Early Morning x1.1 | 10.00 | 1.1 × ordinary rate |
    | M-Sat OT \< 2Hr x1.5                   | 2.00  | 1.5 × ordinary rate |

    Why: UpSheets assigned these hours using the configured calculation rules for this employment type.
  </Accordion>

  <Accordion title="Casual">
    ### Classification Pay Rates

    | Classification                  | Code  | Casual classification minimum (includes 25% loading) |
    | ------------------------------- | ----- | ---------------------------------------------------- |
    | Level 1 - Introductory Educator | CSE1  | \$36.01                                              |
    | Level 2 - Educator              | CSE2  | \$37.11                                              |
    | Level 3 - Qualified Educator    | CSE3  | \$40.59                                              |
    | Level 4 - Experienced Educator  | CSE4  | \$43.31                                              |
    | Level 5 - Advanced Educator     | CSE5  | \$45.71                                              |
    | Level 6 - Room Leader           | CSE6  | \$47.81                                              |
    | Level 7 - Assistant Director    | CSE7  | \$50.00                                              |
    | Level 8 - Director              | CSE8  | \$57.65                                              |
    | Support Worker Level 1.1        | SW1.1 | \$33.05                                              |
    | Support Worker Level 2.1        | SW2.1 | \$33.66                                              |
    | Support Worker Level 2.2        | SW2.2 | \$34.78                                              |
    | Support Worker Level 3.1        | SW3.1 | \$36.81                                              |

    ### Calculation Rules

    | Rule                            | Conditions                                     | Value                  | Notes |
    | ------------------------------- | ---------------------------------------------- | ---------------------- | ----- |
    | Ordinary                        | EVERY                                          | Classification minimum | -     |
    | Sat x1.4                        | SAT                                            | x1.4                   | -     |
    | Sun x1.8                        | SUN                                            | x1.8                   | -     |
    | M-F 12am-8am Night x1.14        | MON-FRI<br />00:00-08:00<br />Shift end only   | x1.14                  | -     |
    | M-F 5am-6am Early Morning x1.08 | MON-FRI<br />05:00-06:00<br />Shift start only | x1.08                  | -     |
    | M-F 6:30pm-12am Afternoon x1.12 | MON-FRI<br />18:30-00:00<br />Shift end only   | x1.12                  | -     |
    | PH x2.2                         | PH                                             | x2.2                   | -     |
    | M-Sat OT \< 2Hr x1.4            | MON-SAT<br />Hours 8-10<br />OT 0-2 hours      | x1.4                   | -     |
    | M-Sat OT > 2Hr x1.8             | MON-SAT<br />Hours 10-24<br />OT 0-14 hours    | x1.8                   | -     |
    | PH Daily OT x2.2                | PH<br />Hours 0-24                             | x2.2                   | -     |
    | OT \< 2Hr x1.4                  | EVERY<br />Hours 38-40<br />Weekly             | x1.4                   | -     |
    | OT > 2Hr x1.8                   | EVERY<br />Hours 40-168<br />Weekly            | x1.8                   | -     |
    | PH Weekly OT x2.2               | PH<br />Hours 38-168<br />Weekly               | x2.2                   | -     |
    | Less than 10 Hr Break x1.4      | EVERY                                          | x1.4                   | -     |
    | Sat Min Engagement x1.4         | SAT<br />OT 0-4 hours                          | x1.4                   | -     |
    | Sun Min Engagement x1.8         | SUN<br />OT 0-4 hours                          | x1.8                   | -     |
    | M-F Casual ME x1                | MON-FRI<br />OT 0-2 hours                      | x1                     | -     |
    | PH Min Engagement x2.2          | PH<br />OT 0-4 hours                           | x2.2                   | -     |

    ### Worked Example

    Input: Level 1 - Introductory Educator casual employee, Monday 6:00 am–4:00 pm, 10.00 paid hours, with no weekly overtime already accrued.

    | UpSheets output                         | Hours | Rate                 |
    | --------------------------------------- | ----- | -------------------- |
    | M-F 5am-6am 5am-6am Early Morning x1.08 | 10.00 | 1.08 × ordinary rate |
    | M-Sat OT \< 2Hr x1.4                    | 2.00  | 1.4 × ordinary rate  |

    Why: UpSheets assigned these hours using the configured calculation rules for this employment type.
  </Accordion>
</AccordionGroup>

## 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 14 manual allowances that must be entered separately when they apply. See [Manual Allowances](#manual-allowances) for amounts and conditions.

## Manual Allowances

| Allowance                    | Conditions | Value      | Notes |
| ---------------------------- | ---------- | ---------- | ----- |
| Broken Shift Allowance       | Manual     | \$21.38    | -     |
| Clothing Equipment Allow     | Manual     | \$0.00     | -     |
| Educational Leader Allowance | Manual     | \$4,784.28 | -     |
| Excess Fares Allowance       | Manual     | \$17.22    | -     |
| First Aid Allowance          | Manual     | \$12.65    | -     |
| First Aid Allowance OSHC     | Manual     | \$1.68     | -     |
| Laundry No Ironing Per Day   | Manual     | \$1.23     | -     |
| Laundry No Ironing Per Week  | Manual     | \$6.14     | -     |
| Laundry Per Day              | Manual     | \$1.95     | -     |
| Laundry Per Week             | Manual     | \$9.74     | -     |
| Meal Allowance OT 2+ Hours   | Manual     | \$16.12    | -     |
| Motor Vehicle Allowance      | Manual     | \$1.01     | -     |
| Motorcycle Allowance         | Manual     | \$0.34     | -     |
| Use of Vehicle Allowance     | Manual     | \$0.00     | -     |

## How to Use This Rule Set in UpSheets

1. Copy the **Children's Services Award** rule set from the Award Library and select the **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 (clauses 21.2-21.3): ordinary hours Monday to Friday inside 6:00 am to 6:30 pm with an 8-hour daily ordinary cap (agreement to roster up to 10 ordinary hours under clause 21.2 is not auto-detected).
* Saturday and Sunday have no day-worker ordinary window, so Saturday uses clause 23.5(a) whole-day overtime tiers (150% first 2 hours, 200% after; each day stands alone) and Sunday uses flat 200%.
* Pre/post-spread OT on Monday to Friday uses clause 23.2 first-2 / after-2 tiers.
* Daily OT after 8 hours is scoped MON-FRI only.
* Weekly OT after 38 hours uses EVERY first-2 / after-2 at Monday to Friday OT rates.
* Public holidays are 250%.
* Clause 23.5(e) Saturday/Sunday/public holiday minimum payment is 4 hours (Saturday ME is tiered 150%/200% to match OT tiers).
* Clause 10.5(c) casual minimum engagement is 2 hours and clause 10.4(e) part-time minimum roster is 2 consecutive hours, both day-scoped on Monday to Friday at ordinary (weekend/PH minima are satisfied by the higher Sat/Sun/PH ME lines).
* Clause 22.3 10-hour break is a single GAP at a flat first-2-hours overtime multiple (150% / casual 1.4) rather than tiered relevant OT.
* Shiftworkers (clause 23.4): ordinary hours may be worked across the week.
* Early morning START\_ONLY 5:00-6:00 am at 110% (casual 1.08), afternoon END\_ONLY finish after 6:30 pm at 115% (casual 1.12), and rotating night END\_ONLY finish after midnight by 8:00 am at 117.5% (casual 1.14), matching the award's finish-based night definition and avoiding a midnight-5:00 am START\_ONLY window that would steal early-morning starts.
* Saturday ordinary hours are 150% for all hours (clause 23.5(b)); daily overtime after 8 hours is scoped MON-SAT at 150%/200% so Sunday stays on the flat 200% day rate.
* Sunday 200%, public holiday 250%, with 4-hour Sat/Sun/PH minima at the applicable day multiple.
* Permanent night shiftworkers use the same END\_ONLY night structure with night loading 130% (casual 1.24) and without early-morning/afternoon loadings.
* Casual MULTIPLE lines are scoped to CASUAL and use (award % of minimum) / 1.25, including shift loadings as (100 + shift% + 25) / 125.
* FULL\_TIME/PART\_TIME multiples remain award percentages of the unloaded minimum.
* Modelling follows Fair Work award text and MAPD (single flat 10-hour GAP, tiered day-worker Saturday ME, delayed meal break excluded).

### Not Supported by This Rule Set

* Agreement to reduce the 10 hour break to 8 hours <Tooltip headline="Clause 22.3(c)" tip="Modeled as a single 10-hour GAP obligation"><Icon icon="bookmark" size={14} /></Tooltip>
* Agreement to roster up to 10 ordinary hours in a day <Tooltip headline="Clause 21.2" tip="Default daily ordinary cap is modeled at 8 hours"><Icon icon="bookmark" size={14} /></Tooltip>
* Averaging ordinary hours over two or four week cycles <Tooltip headline="Clauses 21.1, 23.4(b)" tip="Weekly overtime threshold is modeled as a simple 38-hour week"><Icon icon="bookmark" size={14} /></Tooltip>
* Broken shift 12-hour spread limit automation <Tooltip headline="Clause 21.3" tip="Broken shift allowance is MANUAL; spread-limit detection is not modeled"><Icon icon="bookmark" size={14} /></Tooltip>
* Day Worker versus Shiftworker versus Permanent Night variant assignment <Tooltip headline="Clauses 21, 23.4" tip="Choosing the variant remains manual; early morning uses START_ONLY and afternoon/night use END_ONLY windows per clause 23.4"><Icon icon="bookmark" size={14} /></Tooltip>
* Emergency overtime paid at ordinary rates (up to one hour per week) <Tooltip headline="Clause 23.2(c)" tip="Requires emergency-situation metadata not available from ordinary timesheet spans"><Icon icon="bookmark" size={14} /></Tooltip>
* Junior, apprentice, and supported wage classifications <Tooltip headline="Clauses 14.3, 14.4, 14.5, Schedule C, Schedule D, Schedule E" tip="Excluded from this adult CSE / Support Worker rule set"><Icon icon="bookmark" size={14} /></Tooltip>
* Non-contact time entitlements <Tooltip headline="Clause 21.5" tip="Rostering entitlement, not a pay-rate rule"><Icon icon="bookmark" size={14} /></Tooltip>
* Part-time agreed hours / short-notice change overtime under clause 10.4 <Tooltip headline="Clauses 10.4(d), 10.4(f)" tip="Requires agreed-pattern metadata not available in timesheet processing"><Icon icon="bookmark" size={14} /></Tooltip>
* Pre-March 2026 transitional CSE classification translation rows <Tooltip headline="Clause Schedule I" tip="Draft uses the clause 14.1 Level 1 to 8 structure operative from the March 2026 classification rewrite"><Icon icon="bookmark" size={14} /></Tooltip>
* Public holiday substitution / part-day public holiday continuity rules <Tooltip headline="Clauses 23.5(d), 23.5(f), 27" tip="Calendar/metadata dependent; not auto-detected"><Icon icon="bookmark" size={14} /></Tooltip>
* Superseded Support Worker pay-rate rows sharing current classification IDs <Tooltip headline="Clauses 14.1, 14.2" tip="Support Worker Levels 1.1–3.1 are modeled (YAML SW1.1–SW3.1) from MAPD AD hourlies operative_from 2026-07-01 on classification_fixed_id 4591–4594. Earlier open-ended MAPD rows for those same IDs (operative_from 2025-07-01, null operative_to) are superseded for this effective date and must not be reported as missing rates"><Icon icon="bookmark" size={14} /></Tooltip>
* Time off instead of payment for overtime <Tooltip headline="Clauses 23.3, Schedule H" tip="Not modeled"><Icon icon="bookmark" size={14} /></Tooltip>
* Unpaid meal break timing and paid rest breaks <Tooltip headline="Clauses 22.1, 22.2" tip="Not modeled"><Icon icon="bookmark" size={14} /></Tooltip>

<Note>
  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.
</Note>

<Info>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.</Info>

## Official sources

* Award text: [Fair Work Commission - MA000120](https://awards.fairwork.gov.au/MA000120.html)
* Pay rates and allowances: [Fair Work pay guides](https://www.fairwork.gov.au/pay-and-wages/minimum-wages/pay-guides)

## Other Children's Services Award Variants

* [Day Worker](/docs/smart-formulas/award-library/awards/childrena/2026-07-01/day-worker)
* [Permanent Night Shiftworker](/docs/smart-formulas/award-library/awards/childrena/2026-07-01/permanent-night-shiftworker)