A roster template for Australian businesses must account for Fair Work obligations that other countries do not have — minimum engagement periods, award-specific rest breaks, penalty rates for weekends and public holidays, and maximum weekly hours that vary by award. A generic spreadsheet will not catch these rules. The templates in this article are designed specifically for Australian small businesses, with compliance baked into the structure.
Key Takeaways
- Australian roster templates must include minimum engagement periods (typically 2–4 hours depending on award).
- Penalty rates for weekends, public holidays, and overtime significantly affect labour costs — the roster should make these visible.
- Fair Work requires rosters to be published with adequate notice (7–14 days depending on the award).
- Google Sheets is better than Excel for collaborative rostering — multiple managers can edit simultaneously.
- A roster template stops being enough when your team exceeds 15 people or your award has complex pay rules.
What an Australian Roster Template Must Include
Australian employment law adds several requirements that generic templates ignore. Your roster needs:
Non-negotiable elements:
| Element | Fair Work Requirement |
|---|---|
| Minimum engagement period | 2–4 hours depending on award (e.g., Retail Award: 3 hours, Hospitality Award: 3–4 hours) |
| Maximum weekly hours | Typically 38 hours for full-time employees (or as per award) |
| Rest breaks between shifts | 10–12 hours depending on award |
| Meal breaks | 30 minutes for shifts over 5 hours (most awards) |
| Overtime indicators | Overtime rates apply after standard hours — flag these on the roster |
Financial elements:
| Element | Why It Matters |
|---|---|
| Shift type (weekday/Saturday/Sunday/public holiday) | Determines penalty rate applied |
| Estimated cost per shift | Helps you stay within budget |
| Overtime hours | Triggers higher pay rates |
Template 1: Hospitality Roster
Hospitality businesses — cafés, restaurants, pubs — face some of the most complex award requirements. The Hospitality Industry (General) Award has different rates for different days, times, and shift lengths.
Recommended Shift Patterns
| Shift | Time | Typical Use |
|---|---|---|
| Breakfast | 6:00–14:00 | Café morning shift |
| Lunch | 10:00–18:00 | Mid-day overlap shift |
| Dinner | 14:00–22:00 | Restaurant evening shift |
| Close | 17:00–23:00 | Pub or late-night venue |
| Split shift | 6:00–10:00, 17:00–22:00 | Breakfast + dinner coverage |
Template Structure
| Employee | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hrs | Cost |
|---|---|---|---|---|---|---|---|---|---|
| [Name] | Bkfst 6–14 | OFF | Bkfst 6–14 | Bkfst 6–14 | Dinner 14–22 | Bkfst 6–14 | OFF | 40 | $ |
| [Name] | OFF | Lunch 10–18 | Lunch 10–18 | OFF | Bkfst 6–14 | Dinner 14–22 | Lunch 10–18 | 40 | $ |
Fair Work compliance notes:
- Hospitality Award minimum engagement: 3 hours (casual), 4 hours (part-time, varies by classification).
- Saturday rates: typically 125% for first 3 hours, 150% after (casual loading additional).
- Sunday rates: typically 150% (casual), 175% for first 3 hours then 200%.
- Split shifts: minimum 4-hour engagement, with a break of at least 6 hours between split portions.
Template 2: Retail Roster
Retail businesses face the General Retail Industry Award, which has its own minimum engagement periods and penalty rates. Saturday and Sunday work attract significantly higher pay.
Recommended Shift Patterns
| Shift | Time | Typical Use |
|---|---|---|
| Early | 8:30–17:00 | Opening shift, stock replenishment |
| Mid | 10:00–18:30 | Standard trading hours |
| Late | 12:00–20:30 | Afternoon/evening coverage |
| Short | 9:00–15:00 | Part-time or student staff |
| Weekend | 9:00–17:30 (Sat), 10:00–17:00 (Sun) | Weekend trading |
Template Structure
| Employee | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hrs | Cost |
|---|---|---|---|---|---|---|---|---|---|
| [Name] | Early 8:30–17 | Early 8:30–17 | OFF | Early 8:30–17 | Early 8:30–17 | Mid 10–18:30 | OFF | 39.5 | $ |
| [Name] | OFF | Late 12–20:30 | Late 12–20:30 | OFF | Early 8:30–17 | Early 8:30–17 | 10–17 | 39.5 | $ |
Fair Work compliance notes:
- Retail Award minimum engagement: 3 hours (casual), 3 hours (part-time).
- Saturday: 125% (casual, first 3 hours), 150% after.
- Sunday: 150% (casual, first 3 hours), 175% after.
- Public holidays: 250% (casual), or a minimum payment for 4 hours even if not worked.
Template 3: General Office or Trades Roster
For businesses that follow the Clerks—Private Sector Award or general provisions, the roster is simpler because most staff work Monday to Friday with standard hours.
Template Structure
| Employee | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hrs | Cost |
|---|---|---|---|---|---|---|---|---|---|
| [Name] | 8:30–17 | 8:30–17 | 8:30–17 | 8:30–17 | 8:30–17 | OFF | OFF | 40 | $ |
| [Name] | 9–17:30 | 9–17:30 | 9–17:30 | 9–17:30 | 9–17:30 | OFF | OFF | 40 | $ |
Fair Work compliance notes:
- Clerks Award: 38 hours per week, with flexibility to average over a cycle.
- Overtime: 150% for first 2 hours, 200% after (for full-time employees working beyond ordinary hours).
- If the business operates on a public holiday, the roster must show the holiday and the applicable rate.
How to Build the Roster in Google Sheets
Google Sheets is the better choice for Australian rostering because multiple managers can view and edit it simultaneously. Here is the process:
- Create a new Google Sheet with one tab per roster period (e.g., “Week of 14 July 2026”).
- Set up columns: Employee Name, Mon, Tue, Wed, Thu, Fri, Sat, Sun, Weekly Hours, Estimated Cost.
- Add a “Leave” row or colour code to mark approved leave before assigning shifts.
- Use data validation for shift start/end times to prevent typos.
- Add a formula for weekly hours:
=SUM of (end time - start time) minus breaks. - Add a cost formula that multiplies hours by the appropriate rate based on the day of the week.
- Share the sheet with all managers and set permissions so only designated people can edit.
- Lock the previous week once published to prevent accidental changes.
Cost Tracking: Why the Cost Column Matters
Labour is typically the largest expense for Australian SMBs — often 25–35% of revenue. The roster is where you control that cost. Without a cost column, you discover overruns at payroll time, when it is too late to adjust.
A simple cost calculation:
| Day | Base Rate | Penalty Rate (Casual) | Hours | Cost |
|---|---|---|---|---|
| Monday | $25.00/hr | $31.25/hr (125% casual loading) | 8 | $250.00 |
| Saturday | $25.00/hr | $37.50/hr (150% casual first 3h) | 8 | $300.00 |
| Sunday | $25.00/hr | $50.00/hr (200% casual first 3h) | 6 | $300.00 |
| Public Holiday | $25.00/hr | $62.50/hr (250% casual) | 8 | $500.00 |
Building this into your roster template makes cost visible before you publish — not after.
When to Move Beyond a Spreadsheet
Signs you have outgrown a roster spreadsheet:
- You are spending more than 2 hours per cycle on the schedule.
- You are manually checking penalty rates against award conditions.
- Shift swaps require face-to-face coordination and manual edits.
- You cannot easily see who has exceeded their maximum weekly hours.
- You are maintaining a separate leave tracker alongside the roster.
When you hit these thresholds, a rostering tool that integrates leave management and Fair Work compliance saves significant time and reduces the risk of award breaches.
Leave Balance’s Workforce tier includes drag-and-drop rostering with leave data already populated, compliance guardrails for Fair Work rules, and integrated cost tracking.
leave emails? Track your employee's leave with Leave Balance
Frequently Asked Questions
What is the minimum shift length in Australia?
It depends on the award. Under the Retail Award, the minimum is 3 hours. Under the Hospitality Award, it is 3–4 hours. The Clerks Award minimum is 3 hours. Always check your specific award — the Fair Work Ombudsman website has a tool to look up minimum engagement periods.
Can I roster a full-time employee for more than 38 hours?
Yes, but additional hours attract overtime rates. Under most awards, overtime is 150% for the first 2 hours and 200% after. Track these hours on the roster so you can budget for the overtime cost.
How do I handle public holidays on the roster?
If the business is closed, block out the holiday on the roster. If the business is open, schedule staff at public holiday rates (typically 250% for casual, 150% for full-time). Some employees may refuse to work a public holiday — this is their right under the National Employment Standards.
Is Google Sheets or Excel better for rostering?
Google Sheets is better for collaborative rostering because multiple managers can edit it simultaneously. Excel is better for complex formulas and larger datasets. For most SMBs, Google Sheets is sufficient.
How do I share the roster with employees?
Share the Google Sheet with view access, or export to PDF and distribute via email or a team channel. Tools like Leave Balance push roster notifications directly to Slack or Microsoft Teams, eliminating the need to share a separate file.