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
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.
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.
| Employee | 20 | 21 | 22 | 23 | 24 | Present | Leave |
|---|---|---|---|---|---|---|---|
| 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.
The rest of the set
Other ways to record the same hours
Weekly timesheet
One person, one week. Start, finish, unpaid meal break and paid hours that add themselves up.
Download the templateFortnightly timesheet
Two weeks on one sheet with separate weekly subtotals — for a fortnightly pay cycle.
Download the templateDaily time clock sheet
One day, the whole team, initialled at the end of the shift.
Download the templateMore free New Zealand tools
Plan the shifts, then cost them
Free staff roster templates
Weekly, fortnightly, monthly, daily and blank rosters in Excel — the planning side of the same job.
Browse the rostersHolidays Act leave calculator
Annual holidays at the greater of ordinary weekly pay and average weekly earnings.
Open the calculatorAll free NZ tools
Calculators and builders for rostering, labour cost and payroll readiness.
See all toolsAttendance 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
COUNTIFper 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
COUNTIFacross 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
COUNTIFcolumns carry over unchanged. It works in LibreOffice Calc too.
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.