Your privacy choices

KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy

Skip to main content
Excel template

Staff Leave Tracker

StaffXLSXEnglish

What's inside

A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.

Staff leave log

Days counts every calendar day from first to last day. Subtract weekends yourself if your policy requires it.

School year
No.Staff nameLeave typeFirst dayLast dayDaysStatusCover arrangedNotes
Example: Sara AhmedAnnualApprovedYes

Sheet: Leave log · 40 rows

Leave balances

Copy the totals from the Leave log into Days taken and Days booked.

No.Staff nameYearly entitlement (days)Days takenDays bookedDays remaining
Example: Sara Ahmed2585

Sheet: Balances · 40 rows

How to use it

  1. On the Leave log sheet, add each request with start date, end date and leave type.
  2. Choose Approved, Pending or Declined in the Status column.
  3. The Days column counts calendar days between the dates.
  4. On the Balances sheet, enter each person's yearly entitlement and the days they have taken.

About this document

A leave log for school staff. Add each request with its start and end date and the sheet counts the days; a second sheet shows each person's entitlement and balance.

Comments

    Staff Leave Tracker – Free Excel Template | KiwiBee