Free fortnightly staff roster (Excel)
A two-week roster template designed around fortnightly pay cycles. Perfect for hospitality, retail and shift-based teams in Australia. Plan both weeks together and align with your pay runs.
Fortnightly staff roster
Excel format (.xlsx)
No signup required. Works with Excel and Google Sheets.
What's in this template
A complete fortnightly roster layout
Employee name
Full name of each staff member
Role / position
Job title or department
Week 1 (Mon-Sun)
Start and end times for each day
Week 2 (Mon-Sun)
Start and end times for each day
Week 1 total hours
Hours worked in first week
Week 2 total hours
Hours worked in second week
Fortnight total
Combined hours for both weeks
Notes
Space for special instructions
How shifts are displayed
Each week has columns for Monday to Sunday. Enter shift times (e.g., "9am-5pm") or leave blank for days off. The template calculates hours for each week and the fortnight total.
| Employee | Role | W1 Mon | ... | W2 Mon | ... | W1 Hrs | W2 Hrs | Total |
|---|---|---|---|---|---|---|---|---|
| Sarah Jones | Manager | 7am-3pm | ... | 7am-3pm | ... | 38 | 40 | 78 |
How to use this template
Get started in four simple steps
Download
Get the Excel file and open it
Add staff
Enter employee names and roles
Plan both weeks
Fill in shifts for Week 1 and 2
Share or print
Distribute to your team
Who uses this template
Ideal for businesses with fortnightly pay cycles
Hospitality
Align rosters with fortnightly pay runs
Retail
Plan two weeks of floor coverage at once
Shift-based teams
Manage rotating patterns across pay periods
Template disclaimer
This template is a planning tool only. It does not calculate wages, penalties, or entitlements. For automated calculations and compliance support, use roster and payroll software.
When spreadsheets become difficult
Fortnightly spreadsheets work for simple planning, but become difficult when shifts change. An online roster tool updates schedules automatically and keeps staff in sync — no more chasing updated spreadsheets.
Try the free online roster toolFortnightly roster template FAQ
- Many Australian businesses run fortnightly pay cycles. A fortnightly roster aligns your scheduling with pay periods, making it easier to track hours and plan ahead.
- No, this template calculates hours only. It does not include wage calculations, penalty rates, or award interpretation. For automated pay calculations, consider rostering software with payroll integration.
- Yes, you can use just one week if needed. However, if you only need weekly planning, our weekly roster template may be simpler.
- Simply enter different shift times in Week 1 and Week 2. The template will calculate each week's hours separately and show the fortnight total.
Related templates
Explore more roster templates
Ready to plan your fortnight?
Download the template now and start scheduling your team.
Disclaimer
This template is provided as a general planning tool only. It does not calculate wages, penalties, or entitlements. RosterElf Pty Ltd accepts no liability for any loss arising from reliance on this template. For automated calculations and compliance support, use roster and payroll software.