Free 2027 template
Download a professional 2027 vacation planner for Excel and PDF: annual overview, 25 employees, requested and approved leave, neutral absence tracking, location-based public holidays and bridge-day suggestions. Useful for small teams and shift-based businesses.
Want to coordinate leave directly with your team? Try Shiftdesk's digital leave management.
Try Pro for 14 days. No credit card. No automatic subscription.
Download Excel or PDF directly. The optional email pack with planning tips is free and independent of the download.
Five sheets for 25 employees: every day of 2027, verified allowances, location-based holidays, bridge days and instructions with primary sources. Requested (B) and approved (U) leave stay separate; only U reduces the calculated balance.
Five-page landscape A4 template for team overview, requests, statutory holidays, bridge days and safe use. PDF/UA-validated, with clickable sources and a neutral absence code.
From template to Shiftdesk
The template gives you a clear overview. Shiftdesk connects leave requests, approvals, leave balances and schedules in one digital workflow without entering the same absence in several lists.
14 days free, no credit card required
Employees submit leave and other absences in the app or browser. The current status stays visible.
Managers review open requests and overlaps before approving or declining them.
Approved absences are available for further scheduling so everyone works from the same status.
Entitlement, used days and remaining leave stay together instead of being spread across several files.
You can try Shiftdesk alongside your template. See whether shared planning works for your business in everyday use.
Add employees and their leave entitlements. Invite your team so they can submit their own requests.
Have someone request leave and review it. Your team can see the status directly in the app.
Take approved absences into account in your schedule and keep track of leave balances.
Vacation planning 2027
The template is a practical planning aid. It does not replace legal advice, but it highlights key points that are often missed in vacation planning, confidential absences and public holidays.
Leave planning for your business: coordinate requests, cover and minimum staffing
German statutory minimum leave under BUrlG § 3 is described based on a six-day week. Part-time and other weekly models should be converted appropriately for your business.
Under BUrlG § 9, verified days of incapacity for work during vacation are not counted against annual leave. The team template only uses neutral code A; evidence and health details belong in a protected HR process.
The template marks nationwide and fully statewide public holidays for 2027 based on the selected location. Verify partial-state and local exceptions for the specific workplace.
Requested and approved leave, neutral absence, special leave and home office are planned separately so shortages and cover needs become visible earlier.
The file is structured so small teams can start immediately while still keeping key absences and planning risks visible.
Every day of 2027 in one Excel view with month row, weekends, public holidays and status codes.
Name, team, manually verified annual entitlement and verified carry-over. Select the federal state directly in the annual overview; regional public holidays are added automatically.
B and U are counted separately. Only approved leave reduces the calculated balance; overplanning remains visible as a negative value.
Five landscape A4 pages for team planning, leave requests, cover notes, holidays, bridge days and sources.
Yes. You can download the Excel and PDF files directly without signing up or providing your email address. The optional email pack is also free and uses double opt-in.
Yes. The Excel template includes nationwide and regional statutory holidays plus notes on local exceptions. Select the federal state of the workplace directly in the annual overview; applicable statewide holidays are marked automatically. Continue to verify local exceptions for the exact workplace.
Enter the already verified leave entitlement and carry-over manually for each person. Weekly models, entry or exit dates and statutory entitlement are not converted automatically; use the leave entitlement calculator and have special cases reviewed.
Under BUrlG § 9, verified days of incapacity for work during vacation are not counted against annual leave. The team template uses only neutral code A; evidence and health details should be processed confidentially outside the team overview.
A vacation planner focuses on vacation and remaining leave. An absence planner also covers special leave, home office and other absences. This template combines both while deliberately excluding personal reasons.
Yes, the structure is intentionally simple. After importing, quickly check data validation, formulas and date formats.
Once several people submit requests, managers approve them or absences need to be coordinated with the schedule, central digital leave management reduces duplicate work and conflicting file versions.
Would you like to connect leave requests, approvals and scheduling directly?
Try Pro for 14 days. No credit card. No automatic subscription.