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

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

20 staff rows, one day per sheet
Paid hours calculated per person
Initials column so staff confirm their own hours
Day total and a count of who clocked on

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

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.

EmployeeRoleClock inClock outUnpaid breakPaid hoursInitials
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.

Start free trial See time and attendance software
FAQ

Daily 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.