How to build a staff roster template that actually holds up
Most roster templates are a grid of names and days, and they work right up until someone swaps a shift. This is what to put in the template so that the second week is easier than the first, not harder — and the honest point where a spreadsheet stops being the right tool.
Last updated
The columns a roster template needs
A roster has one job: every person knows where to be, and you know what it costs before the week starts. Almost every template you can download does the first half and skips the second, which is why the wage bill is always a surprise on Monday.
Seven columns cover it. Anything beyond these is decoration; anything missing from these is a question somebody will have to ring you to ask.
- Name — one row per person, not one row per role. Roles change, people do not.
- Day and date — both. "Tuesday" alone is ambiguous the moment you file the sheet.
- Start and finish — as separate cells, so you can do arithmetic on them.
- Unpaid break — the minutes, not a tick. This is what makes paid hours wrong.
- Paid hours — finish minus start minus break, calculated, never typed.
- Role or section — bar, floor, kitchen. This is how you spot you have four people on the floor and nobody on the pass.
- Notes — "finishes early, exam". The column that stops the same conversation twice.
Calculate paid hours, never type them
The single most common roster error is a typed hours figure that no longer matches the start and finish times next to it. Someone moves a shift, forgets the total, and the roster now disagrees with itself. Nobody notices until payroll.
In a spreadsheet, if start is in C2, finish in D2 and the unpaid break in minutes is in E2, paid hours is:
- =(D2-C2)*24-E2/60
- Format C2 and D2 as time, and the result as a plain number.
- For a shift crossing midnight: =(D2-C2+(D2<C2))*24-E2/60
Put the cost on the roster, before the week starts
A roster that does not show a cost is a guess. Add one column for the hourly rate and one for line cost (paid hours × rate), then total the sheet. Now the roster answers the question you actually care about while you can still change something.
Two honest caveats. Penalty rates, casual loading, overtime and allowances mean the real cost is usually higher than a flat rate suggests — treat this total as a floor, not a payroll figure. And rates are personal information: if the roster gets shared with staff, keep the cost columns on a separate sheet.
Excel, Google Sheets, or paper
All three work. They fail in different ways, and it is worth choosing the failure you can live with rather than discovering it in week three.
| Good at | Fails when | |
|---|---|---|
| Paper on the wall | Everyone sees it. Nothing to log into. Never goes down. | Someone is not on site. A change means a phone call to each person. |
| Excel | Formulas, totals, printing. Works offline. | Two people edit it. The version emailed on Friday is not the current one. |
| Google Sheets | One live copy, shared by link, edits from a phone. | Anyone with the link can edit anything. Accidental deletions are quiet. |
| A rostering tool | Clash detection, live totals, staff see only their own shifts. | It is another account to manage, and usually another subscription. |
The mistakes that cost the most
These are the ones that turn a roster from a plan into a problem. None of them are about the template being pretty.
- Publishing before checking availability. One clash means a scramble on the day.
- No version marker. Put the week's start date in the filename and in a cell.
- Sharing an editable copy with everyone. Share a view, keep one editable original.
- Rostering to the roster, not to the trade. Look at last week's actual busy hours.
- Forgetting the unpaid break exists. It is the difference between the hours you rostered and the hours you pay.
- No record of what changed. When a shift is disputed, the argument is unwinnable without one.
Roster changes, notice and breaks
Minimum shift lengths, break entitlements, and how much notice you must give before changing a published roster are set by the award or agreement that covers your staff — they are not the same across hospitality, retail and clerical work, and they change.
We are not going to print a number here and have you rely on it. Check your award on the Fair Work Ombudsman's site, or use their Pay and Conditions Tool, and write your own rule into the template as a note so the next person rostering does not have to look it up again.
When the spreadsheet stops being the right tool
A spreadsheet is genuinely fine for a handful of people on one site. The point it breaks is not a headcount — it is when the roster starts having a second life in text messages.
If you recognise three or more of these, the template is no longer the thing that needs fixing:
- You re-send the sheet every time one shift moves.
- Somebody works off a screenshot from Tuesday.
- Availability arrives as texts you have to transcribe.
- You find a double-booking after publishing, more than once.
- Swap requests live in a group chat and get lost.
Or let Smart Roster do it
If you would rather not maintain the spreadsheet at all, Smart Roster does the same job with the totals, the clashes and the sharing already handled.
Questions
- What should a staff roster template include?
- Name, day and date, start time, finish time, unpaid break in minutes, calculated paid hours, role or section, and a notes column. Paid hours should be a formula rather than a typed number, so it cannot fall out of step with the times beside it.
- How do I calculate paid hours in a roster spreadsheet?
- With start in C2, finish in D2 and the unpaid break in minutes in E2, use =(D2-C2)*24-E2/60. For a shift that crosses midnight, use =(D2-C2+(D2<C2))*24-E2/60. Format the start and finish cells as time and the result as a plain number.
- How much notice do I need to give before changing a roster?
- It depends on the award or enterprise agreement covering your staff, and it differs between hospitality, retail and clerical work. Check your award on the Fair Work Ombudsman's website rather than relying on a general figure.
- Is Excel or Google Sheets better for a roster?
- Google Sheets if more than one person edits it or staff need to see it from a phone, because there is only ever one live copy. Excel if you work offline and print the roster. The risk with Sheets is that anyone with the link can edit, so share a view-only copy and keep one editable original.