RosterElf Logo New Zealand
Start trial
FREE TEMPLATE Last updated 21 September 2026

Free employee attendance register (Excel)

One row per employee, one column per day of the month. Enter a code in each cell and the sheet counts days present, days absent and days of leave for you.

Attendance register

Excel format (.xlsx) • Ready to download

31 day columns, 20 staff rows
Present, absent and leave counted automatically
Codes for annual, sick, bereavement and alternative holidays
Public holiday worked recorded separately

No signup required. Works with Excel, Google Sheets and LibreOffice.

This template is a record-keeping tool, not legal or payroll advice. It does not calculate annual holiday pay, public holiday pay or an alternative holiday balance for you, and it does not check that minimum wage has been met. Check Employment New Zealand, or take advice, before relying on a spreadsheet 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.

Roster and track hours in one place

A timesheet only records what already happened. Roster the shifts first and the hours record themselves — free, no signup.

Open the free tool

What's in this template

A month of attendance that counts itself

A full month across

31 day columns so the grid fits any month without re-cutting, with names and roles frozen on the left.

Codes, not free text

P, A, AL, SICK, BEREAVE, PH, PHW, ALT and OFF. A fixed vocabulary is what makes the counting possible.

Counted per person

Present, absent and leave totals calculate from the codes as you type them — no tallying by hand at month end.

Public holiday worked is its own code

PHW is separated from PH, because working a public holiday triggers time and a half and may earn an alternative day.

Alternative holidays tracked

ALT records the day being taken. The instructions sheet explains recording it when it is earned, which is the half most templates miss.

Part of your leave record

The Holidays Act 2003 requires a holiday and leave record. This is the summary view of it.

How a month is recorded

Enter one code per person per day. The three count columns on the right update as you type — PHW counts as present, because the person worked.

Employee2021222324PresentLeave
Aroha Ngata P P P P P 5 0
Tama Wiremu P P SICK SICK P 3 2
Mei Lin PHW P P OFF OFF 3 0
Sione Tupou AL AL AL P P 2 3

Mei Lin worked the public holiday on the 20th. That is two separate obligations: at least time and a half for the hours worked, and — if the 20th would otherwise have been a working day for her — a whole paid day off owed. The register shows the first. Write the second down the day it happens, because an alternative holiday does not expire and is paid out on termination.

How to fill in the attendance register

Four steps, once a month

1. List the team

Names and roles down the left. Set the month and site in the header. Everything else is a code.

2. Code each day

Mark the day as it happens, not at month end. A register reconstructed from memory is the one that gets disputed.

3. Flag public holidays worked

Use PHW, then check the otherwise-working-day test for each person and note any alternative day earned.

4. File it for six years

It forms part of the holiday and leave record the Holidays Act 2003 requires you to keep and produce on request.

The count columns are formulas. Type in the day cells only; the shaded columns calculate.

Who uses this template

New Zealand teams that need the month at a glance

Hospitality

Where casual absence patterns matter and the public holiday calendar is the busiest part of the year.

Aged care and health

Rostered coverage where an unfilled shift is a safety question, not just a cost one.

Multi-site retail

One register per site, so a regional manager can see patterns without opening every roster.

Need the hours as well as the days? The weekly timesheet records start and finish times and paid hours. The register is the summary; the timesheet is the detail.

Or stop collecting timesheets altogether

A register is filled in after the fact, from memory or from a roster that may not be what happened. RosterElf records the clock-in and clock-out as they occur, tracks leave balances against them, and keeps the six-year record without anyone filing anything.

Start free trial See time and attendance software
FAQ

Attendance register FAQ

  • Yes — this one, with no signup, no email and no limit. The difference from the generic templates that fill this search is jurisdiction: Canva, Microsoft Create and Smartsheet all ship a perfectly good grid, but none of them knows that a public holiday worked in New Zealand can earn an alternative holiday, that the 10-minute rest break is paid and the 30-minute meal break is not, or that the record has to survive six years. Those are the parts that cost money to get wrong.

  • Put employees down the rows and the days of the month across the columns, then commit to a fixed set of codes rather than free text — you cannot count free text. Add one COUNTIF per person for each thing you want totalled: =COUNTIF(C5:AG5,"P") for days present. Give public holidays worked their own code, separate from public holidays taken, or you will lose track of alternative holidays owed. Everything above is already built into this template.

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

  • 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. The register is what you look at when you want a month at a glance; the timesheet is what payroll is run from.

  • Record the days they actually worked, but be careful with the absent code. A casual employee who is not offered a shift is not absent — they were simply not rostered, which is what OFF is for. Marking it as absence builds a misleading pattern, and with zero-hour contracts unlawful since 1 April 2016, agreed hours and availability are worth recording accurately.

  • Yes. Upload the .xlsx to Google Drive and open it with Google Sheets — the COUNTIF columns carry over unchanged. It works in LibreOffice Calc too.