Daily timesheet template for New Zealand teams (Excel)
A daily timesheet records one day for the whole team on one page: clock in, clock out, the unpaid meal break and paid hours for each person, with a column for staff to initial their own row. This New Zealand sheet deducts only the meal break, totals the day and counts how many people clocked on.

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.
From a daily sheet to the record you must keep
Initials make it agreed
A sheet filled in by a manager alone is the employer’s account of the hours. Once staff initial their own row, it is an agreed record.Deduct the meal break only
Mei’s four-hour shift has no meal break deducted, which is correct: the unpaid 30-minute break starts once more than four hours are worked. Paid 10-minute rest breaks stay in.Carry the totals to the pay period
The wage and time record needs hours each day and each pay period, so move the totals to a weekly or fortnightly timesheet or your payroll system.Keep it six years
If you cannot produce the record, section 132 of the Employment Relations Act 2000 lets the Authority accept the employee’s account of their hours.What’s in the file
- Clock in, clock out and unpaid break for 20 staff on one day
- Paid hours worked out per row by formula, less the meal break
- A day total and a count of staff clocked on
- An Instructions tab: codes, the record you must keep, public holidays
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.
Daily timesheet questions
-
Recording the hours of a whole team for a single day, on one page, as they happen. It suits sites where the crew changes daily and a weekly sheet per person would be mostly blank. 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, and that is what settles a dispute.
-
No, only the meal break. Under the Employment Relations Act 2000 the 10-minute rest breaks are paid working time and stay in paid hours; the 30-minute meal break is unpaid and comes out. A shift of 2 to 4 hours has a paid rest break and no meal break to deduct.
-
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