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.

Next week you’ll add these hours up by hand again.
In RosterElf staff clock in and out on their phone, you approve the hours against the roster, and approved timesheets go to Xero, MYOB or a Smartly file.
Your download has started.
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
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.
| Code | Means | Counts as |
|---|---|---|
| P | Present | Present |
| A | Absent | Absent |
| AL | Annual holidays | Leave |
| SICK | Sick leave | Leave |
| BEREAVE | Bereavement leave | Leave |
| ALT | Alternative holiday taken | Leave |
| PH | Public holiday, not worked | Not counted |
| PHW | Public holiday worked | Present |
| OFF | Not rostered | Not 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.
More 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.
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
COUNTIFacross 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.
Timesheets filled from the time clock
Staff clock on and off; the hours land on the timesheet.
Approve the hours instead of adding them up
- 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