Free staff roster templates for New Zealand
Six Excel rosters built for New Zealand rules — public holidays and alternative days coded properly, ERA rest and meal breaks on every Instructions tab, and hours totals in NZD.
Browse the templatesUpdated September 2026. Break rules, public holidays and wage rates checked against Employment New Zealand.
These roster templates are planning tools, not legal or payroll advice. They do not calculate holiday pay, alternative days or minimum wage for you. Check Employment New Zealand, or take advice, before relying on a roster for compliance. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
A New Zealand roster carries obligations an Australian or British one does not, and the differences are not cosmetic.
Zero-hour contracts have been unlawful here since 1 April 2016. An employment agreement has to record agreed hours, and if you want an employee available beyond them, that availability provision needs genuine reasonable compensation. A roster that quietly assumes people will pick up whatever appears is not a scheduling habit — it is an agreement problem.
Then there are alternative holidays. If someone works on a public holiday that would otherwise have been a working day for them, they are paid at least time and a half and they get a whole paid day off to take later. The roster is where that entitlement is created, and it is the single most common thing a generic template gets wrong, because neither Australia nor the UK has anything like it.
Key takeaways
- Six Excel templates: weekly, fortnightly, monthly, daily, blank and a staff availability form
- Public holiday (PH) and alternative holiday (ALT) codes, because working a public holiday creates a day off owed
- The "otherwise working day" test decides both public holiday pay and whether an alternative day is earned
- Rest and meal breaks under the Employment Relations Act 2000: 10 minutes paid, 30 minutes unpaid, by hours worked
- New Zealand has no award system — pay rules come from the employment agreement and the Minimum Wage Act
The templates
Pick the planning horizon that matches how you work
Weekly staff roster
A Monday-to-Sunday grid with names, roles, shift times and an automatic weekly hours total. The one most teams want.
Read moreFortnightly staff roster
Two Monday-start weeks with separate weekly totals — the common shape for a fortnightly pay cycle.
Read moreMonthly roster
A whole month per person on one row, with public holidays marked so alternative days are visible a month ahead.
Read moreDaily shift roster
One day planned hour by hour, with a live cover count and break slots placed rather than assumed.
Read moreBlank roster
An empty Monday-to-Sunday grid with 20 rows, set to print on one landscape page. For filling in by hand.
Read moreStaff availability form
A form per person plus a team summary — and a place to record agreed hours, which an NZ agreement must state.
Read moreWhat every template includes
The same New Zealand conventions across all six
PH and ALT codes
Public holiday and alternative holiday are separate codes, because working the first one earns the second.
The break schedule printed in the file
10-minute paid rest breaks and 30-minute unpaid meal breaks, set out by hours worked as the Employment Relations Act requires.
A shared code legend
OFF, AL, SICK, BEREAVE, PH, ALT and TR mean the same thing in all six files.
Totals that calculate
Enter hours as numbers and per-person and per-day totals add themselves up.
An agreed-hours field
Because a New Zealand employment agreement must record agreed hours, and rostering beyond them is an availability question.
No signup
Every file downloads directly. No email address, no gated form, no follow-up sequence.
Who these are for
New Zealand teams planning cover across a seven-day week
More free New Zealand resources
Tools and product pages that sit alongside the roster
Free tools
Calculators and AI generators for planning and costing your workforce.
See all toolsLeave management
Holidays Act annual holidays, sick leave, bereavement leave and alternative days in one place.
See leave managementKnowledge base
Step-by-step help articles for building rosters, approving timesheets and running payroll exports.
Browse the knowledge baseDoing it in software instead
The product pages behind each part of the job
Hours and attendance
Leave and records
Sources
The New Zealand rules referenced in these templates
The three things a generic roster template gets wrong here
Alternative holidays. Work a public holiday that would otherwise have been a working day and the employee earns a whole paid day off, on top of being paid at least time and a half for the day itself. Australian and British templates have no code for this because neither country has the entitlement — so the day gets worked, paid, and the day off owed is never recorded. It does not expire.
The “otherwise working day” test. Almost every leave and public holiday payment in New Zealand turns on whether that day would otherwise have been a working day for that person. For someone on a fixed pattern it is obvious. For someone whose hours vary it is a genuine judgement based on the agreement, the roster history and what the parties intended — and the roster is the evidence. Keeping old rosters is not administrative tidiness; it is how you answer the question later.
Agreed hours. Zero-hour contracts have been unlawful since 1 April 2016. The agreement must state agreed hours, and any provision requiring availability beyond them has to carry reasonable compensation. A roster built on the assumption that people will take whatever comes up is describing an arrangement the Act does not allow.
All three are reasons the roster and the leave record need to be the same system rather than two spreadsheets — see leave management and rostering.
Or stop rebuilding the roster every week
RosterElf keeps the roster, shift swaps, clock-in records and the payroll export in one place — and records the alternative day the moment someone works a public holiday, rather than hoping it gets noticed.
Roster template questions
-
Yes. Every file downloads directly with no signup, no email address and no follow-up sequence. Use them, edit them, share them with your managers.
-
Use the weekly one if cover changes week to week, which suits most hospitality and retail teams. Use the fortnightly one if you pay fortnightly. Use the monthly one if you plan leave and cover a month ahead. Use the daily one for a single trading day where cover varies by the hour, and the blank one to print and fill in by hand.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets — the layout, the drop-down codes and the formulas all carry over. They work in LibreOffice Calc too.
-
New Zealand specific. The codes include public holidays and alternative holidays, which Australia does not have; the break schedule is the Employment Relations Act one rather than an award; and there is an agreed-hours field because a New Zealand employment agreement must state agreed hours. There is no award content anywhere in these files, because New Zealand has no award system.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws, employment agreements and workplace requirements.