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.

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.
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
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.
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.
Fortnightly timesheet questions
-
Two blocks of seven day rows, each ending in a
SUMof its own week, then a final row adding the two subtotals. The trap is one 14-rowSUM: 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.
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