RosterElf Logo New Zealand
Start trial
FREE DOWNLOADS

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 templates
6 Excel templates No signup or email NZ break rules included

Updated 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

WeeklyExcel

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 more
FortnightlyExcel

Fortnightly staff roster

Two Monday-start weeks with separate weekly totals — the common shape for a fortnightly pay cycle.

Read more
MonthlyExcel

Monthly roster

A whole month per person on one row, with public holidays marked so alternative days are visible a month ahead.

Read more
DailyPrintableExcel

Daily shift roster

One day planned hour by hour, with a live cover count and break slots placed rather than assumed.

Read more
PrintableBlankExcel

Blank roster

An empty Monday-to-Sunday grid with 20 rows, set to print on one landscape page. For filling in by hand.

Read more
AvailabilityExcel

Staff availability form

A form per person plus a team summary — and a place to record agreed hours, which an NZ agreement must state.

Read more

What 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

Hospitality
Retail
Aged care and health
Security and facilities

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.

Start free trial See rostering software
FAQ

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.