Templates
Annual Leave Planner Template for Excel and Google Sheets free & workplace-ready
Free · Version 2026.10
Plan the whole team’s leave for a year, with balances, public holidays and an annual calendar. The free vacation planner template works in Excel and Google Sheets and covers the United Kingdom, Ireland and the United States.
- 100% free
- Workplace-ready
- Excel & Google Sheets
Plan leave with Ordio
Automatic balances and approvals save time
Automatic leave calculation
Track entitlements without manual spreadsheets
Digital approvals
Submit and approve leave requests online, no paperwork
Overview for everyone
Staff see balances; managers approve in one click
Linked to scheduling
Approved leave updates shift plans automatically
With Ordio:
See how Ordio digitizes leave management
See digital approvals simplify your workflow · No obligation · 15 minutes
More free templates
Discover more Excel templates for planning, time tracking and HR.
Frequently asked questions about Vacation Planner
How many bank holidays are there in 2027?
England and Wales have 8, Scotland 9 and Northern Ireland 10. Christmas Day and Boxing Day 2027 fall on a weekend, so the substitute days are Monday 27 and Tuesday 28 December. Ireland has 10 public holidays. (Source: [gov.uk](https://www.gov.uk/bank-holidays))
Can employers tell staff when to take holiday?
Yes. In Great Britain an employer can require holiday on set dates, for example over Christmas, with notice of at least twice the length of the leave (Working Time Regulations 1998, reg. 15). (Source: [gov.uk](https://www.gov.uk/holiday-entitlement-rights/booking-time-off))
Is the annual leave planner template free, and does it work in Excel and Google Sheets?
Yes. You download it free of charge after a short form and get an Excel file (.xlsx, Excel 2016 or Microsoft 365) and a Google Sheets copy. Excel and Sheets contain the same 10 sheets: Instructions, Requests, Employees, Balances, Calendar, Dashboard, Settings, Bank holidays, Legal basis, Ordio.
Which countries does the template cover?
The United Kingdom, Ireland and the United States. Pick the country and region on the “Settings” sheet; check values, holidays and currency then switch automatically.
Which values does the template use for the United Kingdom?
The defaults include: Notice above h/day: 8; Maximum h/day: 13; Notice above h/week: 48; Minimum daily rest h: 11; Break 1 above h: 6; Break 1 min: 20; National Living Wage £/h (21+): 12.71 £/h. Each value links to its source on the “Settings” sheet and can be overridden.