Sign Up

Free tools and templates

Free annual leave planner Excel template

Use this independent workbook to plan leave for a selected year. Record employees, dates, manually checked day counts and the status of each request. Monthly totals include only entries marked approved.

No registration required

Download Excel template (.xlsx)

The workbook is independent of the app. It does not import or synchronise Collabin data. Keep employee data in a location your organisation approves.

Instructions and assumptions

  1. Set the year and enter requests in the yellow input cells. Keep formulas intact.
  2. Enter the number of leave days yourself after checking working days, holidays and half days. Split requests at month and year boundaries so monthly totals are meaningful.
  3. Use the status list consistently. The separate example sheet is fictional and is not included in your planning totals.

Worked example β€” fictional team

Example only: a fictional employee records 2 days in January as approved. The January total is 2; a draft entry does not increase it.

What to check before using it

The template does not calculate legal entitlements, holiday calendars, remaining allowances or approval permissions. It does not detect overlaps. A status entered in a spreadsheet is not an approval action in Collabin.

Content reviewed: 4 November 2026