Free fortnightly timesheet template (Excel)
Two weeks on one sheet, each with its own subtotal, then a fortnight total. One sheet per person, per fortnight.
Fortnightly timesheet
Excel format (.xlsx) • Ready to download
No signup required. Works with Excel, Google Sheets and LibreOffice.
This template is a record-keeping tool, not legal or payroll advice. It does not calculate annual holiday pay, public holiday pay or an alternative holiday balance for you, and it does not check that minimum wage has been met. Check Employment New Zealand, or take advice, before relying on a spreadsheet for compliance. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
Roster and track hours in one place
A timesheet only records what already happened. Roster the shifts first and the hours record themselves — free, no signup.
What's in this template
A fortnight that still counts in weeks
Two labelled weeks
Week 1 and Week 2 as separate blocks of seven days, so the sheet matches both the pay cycle and the roster.
A subtotal per week
Each week totals on its own line before the fortnight total. The weekly figure is the one entitlements are usually measured against.
Unpaid meal break deducted
Pre-filled at 30 minutes per day. Paid 10-minute rest breaks are working time and stay in paid hours.
Decimal hours
Times in, decimals out — the format payroll needs, calculated per day, per week and per fortnight.
Sign-off lines
One approval per fortnight, which is the natural moment because it is also when payroll runs.
Hours per day and per pay period
Both are what the Employment Relations Act 2000 wage and time record asks for, and this sheet carries both.
Why the weeks stay separate
A fortnight total alone hides the shape of the fortnight. Two 40-hour weeks and a 30/50 split both total 80, and they are not the same thing — for fatigue, for agreed hours, and for any overtime term in the employment agreement.
| Mon | Tue | Wed | Thu | Fri | Week total | |
|---|---|---|---|---|---|---|
| Week 1 | 8.0 | 8.0 | 8.0 | 8.0 | — | 32.0 |
| Week 2 | 8.0 | 8.0 | 11.5 | 11.5 | 8.0 | 47.0 |
| Fortnight | 79.0 |
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 not more than 40 excluding overtime, unless both parties agree to more — so what the agreement says, and what the record shows, is what governs.
How to fill in the fortnightly timesheet
Four steps, once a fortnight
1. Set the header
Employee name and the Monday the fortnight starts on. One sheet per person per fortnight.
2. Fill week 1, then week 2
Actual start and finish times. Each week subtotals on its own line as you go.
3. Adjust the meal break
30 minutes is the default. Set it to 0 on a short shift where no meal break was taken or owed.
4. Approve before payroll
Employee confirms, manager signs, then the fortnight total goes to Xero or Smartly.
The weekly subtotals and the fortnight total are formulas. Type into the white cells only.
Who uses this template
New Zealand teams paid fortnightly
Small business payroll
Where a fortnightly cycle halves the payroll admin but entitlements are still counted weekly.
Care and community services
Rotating rosters where the two weeks of a fortnight are deliberately different.
Contractors and labour hire
A signed fortnightly sheet per placement, which is usually what the client is invoiced against.
Paid weekly instead? Use the weekly timesheet — same calculations, one week per sheet.
Or stop collecting timesheets altogether
Two weeks is a long time to remember a Tuesday. RosterElf captures the clock-in and clock-out as they happen, so the fortnight total is already correct when payroll runs — and exports straight to Xero or Smartly.
The rest of the set
Other ways to record the same hours
Employee attendance register
A month grid of who was in, who was away and why, with present, absent and leave counted per person.
Download the templateWeekly timesheet
One person, one week. Start, finish, unpaid meal break and paid hours that add themselves up.
Download the templateDaily time clock sheet
One day, the whole team, initialled at the end of the shift.
Download the templateMore free New Zealand tools
Plan the shifts, then cost them
Free staff roster templates
Weekly, fortnightly, monthly, daily and blank rosters in Excel — the planning side of the same job.
Browse the rostersHolidays Act leave calculator
Annual holidays at the greater of ordinary weekly pay and average weekly earnings.
Open the calculatorAll free NZ tools
Calculators and builders for rostering, labour cost and payroll readiness.
See all toolsFortnightly timesheet FAQ
-
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 writing one 14-rowSUMand calling it done — you lose the weekly figure, which is the one that matters for agreed hours and for most overtime terms. This template keeps both. -
Yes. There is no legally required pay frequency in New Zealand — it is a matter for the employment agreement. Weekly is the most common cycle, used by around two thirds of employers, with fortnightly second at roughly a fifth. 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. Break entitlements run by hours in a shift, but agreed hours, availability provisions and most contractual overtime terms are framed weekly. A fortnight total alone cannot tell you whether one of the two weeks ran long.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets — both weekly subtotals and the fortnight total carry over. It works in LibreOffice Calc too.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws, employment agreements and workplace requirements.