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

Weekly timesheet template for New Zealand (Excel)

A weekly timesheet records one person’s week, Monday to Sunday: start and finish times, the unpaid meal break and paid hours each day, totalled for the week. This New Zealand template converts times to decimal hours for payroll, deducts only the meal break, and ends with employee and manager signatures.

rosterelf-nz-weekly-timesheet.xlsx
The weekly timesheet filled in for one employee: start and finish times each day, unpaid breaks, decimal paid hours and the week total, with employee and manager signature lines

File checked No signup

The download

What’s in the file

  • One employee, Monday to Sunday: start, finish and unpaid break
  • Paid hours per day and a week total by formula
  • A code and notes column for leave and public holidays
  • Employee and manager signature lines, and an Instructions tab
Download Excel (.xlsx)
Only on this page

Clock time to decimal hours, and shifts past midnight

Payroll wants decimal hours. Typing minutes as decimals is one of the most common payroll errors.

On the clockDecimal hoursNot
7 h 45 min7.757.45
8 h 15 min8.258.15
9 h 20 min9.339.20
6 h 50 min6.836.50
5 h 30 min5.505.30

The sheet works this out for you: =MOD(Finish-Start,1)*24 less the meal break ÷ 60, so a shift that finishes after midnight still totals correctly. Enter the times actually worked, not the rostered ones: the 15 minutes before opening on Thursday is working time, and unrecorded time is the usual route to an accidental minimum wage shortfall.

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

Weekly timesheet questions

  • Subtract start from finish and multiply by 24 for decimal hours: =(Finish-Start)*24. For a shift that crosses midnight use =MOD(Finish-Start,1)*24. Deduct the meal break as minutes ÷ 60. Format the time cells as h:mm and the result as a number.

  • Enter times as h:mm, because that is how people read a clock, and let the sheet convert to decimals. 7 hours 45 minutes is 7.75, not 7.45.

  • If you round at all, round to the nearest five or ten minutes in both directions. Rounding down consistently means some hours are worked and not paid, and the minimum wage has to be met for every hour worked.

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

  • 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