Free template· Excel, opens in Google Sheets · New Zealand

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.

rosterelf-nz-daily-time-clock-sheet.xlsx
The daily time clock sheet filled in for a Saturday in a cafe: each person’s role, clock-in and clock-out times, unpaid break, paid hours and initials

File checked No signup

How to

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
Download Excel (.xlsx)
Free templates

More NZ timesheet templates

All 4 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.

FAQ

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.

In RosterElf

Timesheets filled from the time clock

Staff clock on and off; the hours land on the timesheet.

A woman at her computer beside timesheets for the week to Sunday 1 November: Mia Chen matches her roster, Jack Osei worked an hour over, with an Export to Xero button

Approve the hours instead of adding them up

Roster vs actualXero and MYOB
  • 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