Free daily time clock sheet (Excel)
One day, the whole team on one page. Clock in, clock out, unpaid meal break, paid hours — and a column for staff to initial their own row at the end of the shift.
Daily time clock sheet
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
One day, on one page, signed as it happens
The whole team on one sheet
20 rows with names and roles, so a shift supervisor has one page to manage rather than twenty.
Clock in and clock out
Recorded at the moment, not reconstructed at the end of the pay period. That is the entire point of a daily sheet.
Unpaid meal break per person
Deducted individually, because on a staggered shift people do not all take the same break.
An initials column
Staff initial their own row at the end of the shift. That is what makes it a record of hours worked rather than hours rostered.
Day total and headcount
Total paid hours for the day and a live count of how many people actually clocked on.
A site field
One sheet per site per day, so multi-site labour cost is comparable without opening every roster.
How a day is recorded
Print it, keep it at the pass or the back office, and fill it in as people arrive and leave. The initials column is the difference between a record and an assertion.
| Employee | Role | Clock in | Clock out | Unpaid break | Paid hours | Initials |
|---|---|---|---|---|---|---|
| Aroha Ngata | Supervisor | 7:45 | 16:15 | 30 min | 8.0 | AN |
| Tama Wiremu | Team leader | 9:00 | 17:30 | 30 min | 8.0 | TW |
| Mei Lin | Staff | 11:00 | 15:00 | 0 min | 4.0 | ML |
| Anika Patel | Casual | — | — | — | 0.0 | Not rostered |
Mei Lin’s four-hour shift has no meal break deducted, and that is correct — the 30-minute unpaid meal break is only owed once more than four hours are worked. A shift of exactly 2 to 4 hours earns one paid 10-minute rest break, which is working time and is never deducted.
How to use the daily time clock sheet
Four steps, every day
1. Print one per day
Date and site in the header. One sheet per site if you run more than one.
2. Record arrivals and departures
As they happen. A sheet completed at the end of the week is a memory exercise, not a record.
3. Get initials
Each person initials their own row before leaving. Disputes about hours mostly disappear at this step.
4. File it
Transfer the day total to payroll at the end of the pay period and keep the sheet for six years.
Paid hours, the day total and the headcount are formulas. Fill in the times and the sheet does the rest.
Who uses this template
New Zealand teams where the day is the unit
Construction and trades
Site attendance recorded on site, which is also who was present if anything goes wrong.
Kitchens and venues
Staggered starts and finishes that no roster predicts accurately.
Events and casual crews
A different crew every day, where a weekly sheet per person makes no sense.
Recording the same hours per person instead? The weekly timesheet runs one sheet per person across a week.
Or stop collecting timesheets altogether
A paper sheet at the pass still has to be typed up, and it cannot tell you whether the person was actually on site. RosterElf clocks staff in from their phone or a kiosk with GPS and photo verification, and the hours arrive in payroll already approved.
The rest of the set
Other ways to record the same hours
Employee attendance register
A month grid of who was in, who was away and why, with present, absent and leave counted per person.
Download the templateWeekly 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 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 toolsDaily time clock sheet FAQ
-
Recording the hours of a whole team for a single day, on one page, at the time they happen. It suits sites and venues where the crew changes daily and a weekly sheet per person would be mostly blank. It is the input to payroll, not the record payroll runs from — transfer the totals to a weekly or fortnightly sheet, or to your payroll system.
-
Because a timesheet filled in by a manager alone is the employer’s assertion about someone’s hours. Once the employee initials the row, it is an agreed record. If hours are ever disputed — and under New Zealand’s record-keeping rules the employee’s account tends to stand where the employer cannot produce a record — an initialled sheet is what settles it.
-
It will work, but it is built for paid hours rather than site safety. If you need a site sign-in for health and safety purposes you want a record of who is on site right now, including people you do not pay, which is a different sheet and a different retention question.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. It prints cleanly on A4 portrait, which is usually how this one gets used.
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.