Free template· Excel, opens in Google Sheets · New Zealand

Attendance sheet template for New Zealand employers

An attendance sheet records, for every employee and every day of the month, whether they were present and, if not, why. This New Zealand register uses fixed codes, including separate codes for a public holiday taken (PH), a public holiday worked (PHW) and an alternative holiday (ALT), and counts days present, absent and on leave per person.

rosterelf-nz-employee-attendance-register.xlsx
The employee attendance register filled in for October at a cafe: six staff and their roles, with a P or OFF code for each day from the 1st to the 14th

File checked No signup

The download

What’s in the file

  • One row per employee, one column per day, for a whole month
  • Present, Absent and Leave counted per person by formula
  • Room for 20 staff, with monthly totals at the foot
  • An Instructions tab: attendance codes and public holidays worked
Download Excel (.xlsx)
Only on this page

The codes, and what each one counts as

A fixed vocabulary is what makes the counting possible. The three count columns update as you type.

CodeMeansCounts as
PPresentPresent
AAbsentAbsent
ALAnnual holidaysLeave
SICKSick leaveLeave
BEREAVEBereavement leaveLeave
ALTAlternative holiday takenLeave
PHPublic holiday, not workedNot counted
PHWPublic holiday workedPresent
OFFNot rosteredNot counted

Aroha and Hemi worked Labour Day (PHW). The register shows the first obligation, at least time and a half for the hours. Write down the second the day it happens: if the 26th would otherwise have been a working day for them, each is owed a whole paid day off.

Free templates

More NZ timesheet templates

All 4 NZ timesheet templates

Wage and time records and breaks: Employment Relations Act 2000; holiday and leave records: Holidays Act 2003. See employment.govt.nz. The template counts hours only; it does not work out pay.

FAQ

Attendance sheet questions

  • A register records whether someone was there and why they were not. A timesheet records how long they worked. New Zealand’s wage and time record needs the hours, so a register alone does not satisfy it: keep both.

  • Put employees down the rows and days across the columns, then use a fixed set of codes, because you cannot count free text. Each count column is a COUNTIF across that person’s day cells, such as =COUNTIF(C5:AG5,"P"). This template has 31 day columns, the codes and the counts already set up.

  • Record the days they worked, but take care with the absent code. A casual employee who is not offered a shift is not absent; they were not rostered, which is what OFF is for.

  • Two things, not one. The hours worked are paid at a minimum of time and a half. And if the day would otherwise have been a working day for that employee, they also earn a whole paid day off, an alternative holiday. Record it in the month it is earned: it does not expire, and any balance is paid out when employment ends.

  • At least six years, and you must be able to produce them for a labour inspector. If you cannot, section 132 of the Employment Relations Act 2000 lets the Employment Relations Authority accept the employee’s claims about their hours as proved.

In RosterElf

Timesheets filled from the time clock

Staff clock on and off; the hours land on the timesheet.

A woman at her computer beside timesheets for the week to Sunday 1 November: Mia Chen matches her roster, Jack Osei worked an hour over, with an Export to Xero button

Approve the hours instead of adding them up

Roster vs actualXero and MYOB
  • Staff clock on and off on their phone or a kiosk
  • Each timesheet shows the rostered and the clocked hours
  • Corrections made before approval
  • Approved hours exported to Xero, MYOB and more