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

Fortnightly timesheet template for New Zealand (Excel)

A fortnightly timesheet records one person’s start and finish times, unpaid meal breaks and paid hours across two weeks, with a subtotal for each week and a fortnight total. This New Zealand template deducts only the meal break, works out decimal hours for payroll, and has employee and manager sign-off lines for the pay run.

rosterelf-nz-fortnightly-timesheet.xlsx
The fortnightly timesheet filled in for one employee: week 1 day by day with start and finish times, unpaid breaks and paid hours, and the week 1 total

File checked No signup

The download

What’s in the file

  • One employee, two weeks: start, finish and unpaid break per day
  • Paid hours per day by formula, less the meal break
  • A total for each week and for the fortnight
  • Employee and manager signature lines, and an Instructions tab
Download Excel (.xlsx)
Only on this page

Why the weeks keep their own subtotals

79 hours over a fortnight looks unremarkable. Week 2 at 47 hours, with two 11.5-hour days, does not, and only the weekly subtotals show it.

Section 11B of the Minimum Wage Act 1983 requires the employment agreement to fix maximum weekly hours at no more than 40, excluding overtime, unless both parties agree to more. Agreed hours, availability provisions and most overtime terms are also written weekly. So what the agreement says each week, and what the record shows each week, is what counts, whichever pay cycle you run.

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

Fortnightly timesheet questions

  • Two blocks of seven day rows, each ending in a SUM of its own week, then a final row adding the two subtotals. The trap is one 14-row SUM: you lose the weekly figure, which is the one that matters for agreed hours and most overtime terms.

  • Yes. No pay frequency is set by law; it is a matter for the employment agreement. What is fixed is that the wage and time record must show hours worked each day and each pay period, which is why this sheet totals both.

  • In practice yes. Agreed hours, availability provisions and most contractual overtime terms are framed weekly, and a fortnight total cannot tell you whether one week ran long.

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

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