RosterElf Logo
Start trial
FREE TEMPLATE

Free fortnightly timesheet (Excel)

A two-week timesheet template aligned with Australian fortnightly pay cycles. Perfect for businesses that pay employees every two weeks. Download, add your team, and start tracking hours immediately.

Fortnightly timesheet

Excel format (.xlsx)

Two-week layout (Week 1 + Week 2)
Employee name and fortnight dates
Daily hours for each week
Automatic fortnight total

No signup required. Works with Excel and Google Sheets.

What's in this template

A complete fortnightly timesheet layout

Employee name

Full name of each staff member

Fortnight starting

Date the fortnight begins

Week 1 hours

Daily hours for first week (Mon-Sun)

Week 2 hours

Daily hours for second week (Mon-Sun)

Fortnight total

Sum of hours for both weeks

Notes

Space for comments or exceptions

How the fortnight is structured

Week 1 and Week 2 are tracked separately with subtotals, then combined into a fortnight total. This matches standard Australian fortnightly pay periods.

Employee Week Mon Tue ... Week Total Fortnight
Sarah Jones Week 1 8 8 ... 40 76
Week 2 8 6 ... 36

How to use this template

Get started in four simple steps

1

Download

Get the Excel file and open it

2

Add employees

Enter names and fortnight dates

3

Record hours

Fill in both weeks

4

Export for payroll

Send to payroll processing

Template disclaimer

This template tracks time and attendance only. It does not calculate wages, penalties, or entitlements. For automated calculations and compliance support, use time and attendance software.

When spreadsheets stop working

Manual timesheets work for small teams. But as you grow, chasing paper, fixing errors, and manually totalling hours becomes painful. For automatic clock-ins, GPS tracking, and payroll-ready exports, try time and attendance software.

Explore time & attendance software
FAQ

Fortnightly timesheet template FAQ

  • Fortnightly timesheets align with Australian pay cycles. Most Australian businesses pay employees fortnightly, so this template matches that standard pay period.
  • Yes, simply add new rows to include additional staff members. The template is fully editable to suit your team size.
  • No, this template tracks hours only. It does not calculate wages, penalties, or entitlements. For automated pay calculations, consider time and attendance software.
  • The template has separate sections for Week 1 and Week 2. Each week has columns for Monday through Sunday, with subtotals for each week and a grand total for the fortnight.
  • You can upload the Excel file directly to Google Sheets. Go to Google Drive, click New > File upload, and select the downloaded .xlsx file.

Ready to track your team's fortnightly hours?

Download the template now and start recording employee hours.