Free template template · Word

Leave Tracker

A leave tracker is a team-level sheet that shows, at a glance, how much leave each employee has taken month by month and what balance remains. Managers and HR use it to spot heavy absence, plan cover and give payroll accurate LWP figures.

Editable Word (.docx)
Made for India
10 fill-in fields highlighted
Free, no sign-up

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[Company Logo][Company Name]

TEAM LEAVE TRACKER

Company:: [Company Name]
Department / Team:: [Department]
Leave Year:: [YYYY] or [Apr YYYY – Mar YYYY]
Manager:: [Reporting Manager]

Record days of leave taken in each month using the codes below, for example "2 CL, 1 SL". Half days are entered as 0.5.

Employee Name	Emp. ID	Annual Entitlement	H1 Total
[Employee Name]	[Employee ID]	[Number]	[Number]
[Employee Name]	[Employee ID]	[Number]	[Number]
[Employee Name]	[Employee ID]	[Number]	[Number]
[Employee Name]	[Employee ID]	[Number]	[Number]

Employee Name	Total Taken	LWP Days	Balance
[Employee Name]	[Number]	[Number]	[Number]
[Employee Name]	[Number]	[Number]	[Number]
[Employee Name]	[Number]	[Number]	[Number]
[Employee Name]	[Number]	[Number]	[Number]

Legend

CL – Casual Leave
SL – Sick Leave
EL – Earned / Privilege Leave
CO – Compensatory Off
ML / PL – Maternity / Paternity Leave
LWP – Leave Without Pay (report to payroll)
WFH – Work from Home (not leave; tracked for information)

Prepared by
[HR Name]
Date: [Date]

Reviewed by
[Reporting Manager]
Date: [Date]

Download Word (.docx) — free

What this template includes

One row per employee with ID and entitlement
Monthly columns showing days taken
Year-to-date total and remaining balance
Leave type legend so entries are consistent
LWP column flagged for payroll
Prepared-by and reviewed-by sign-off

When to use it

A manager wants one view of the whole team's leave instead of individual registers
HR needs month-end LWP and leave figures for payroll
You want to identify patterns such as frequent Monday or Friday absence
Small companies without an HRMS leave dashboard

How to customise this template

1Add all team members and their annual entitlement from the leave policy
2Use the codes in the legend inside monthly cells (e.g. 2 CL, 1 SL)
3Switch to a financial-year order (April to March) if your leave year follows it
4Copy the table into Excel if you want automatic totals

HR tips

Update the tracker weekly, not just at month-end
Use the tracker to plan cover, not to pressure employees about legitimate leave
Cross-check totals with the leave register before payroll
Restrict edit access to HR and the line manager

For HR & hiring managers

Experienced and fresher candidates across India — blue, grey and white collar. Post a job in 5 minutes and start receiving applications.

Post a job free See plans

Post in 5 minutesDescribe the role in one line — we write the job description.
Verified applicantsEvery applicant has a verified mobile number.
Resume databaseSearch experienced candidates by skill, city and experience.

Frequently asked questions

How do I track employee leave in Word or Excel?+

Create one row per employee, columns for each month, and totals for leave taken and balance. Record leave with type codes so the totals can be split by leave head when needed.

What is the difference between a leave tracker and a leave register?+

The register is the formal, employee-wise record kept for compliance. The tracker is a working summary for the whole team that helps with planning and payroll.

How often should a leave tracker be updated?+

Weekly is ideal, and always before the payroll cut-off so that leave without pay is captured correctly.

All 50 leave management →

[Company Logo][Company Name]

LEAVE APPLICATION FORM

Company:: [Company Name]
Form No.:: [Reference Number]
Date of Application:: [Date]

Part A – Employee Details

Employee Name
Employee ID
Designation
Department
Reporting Manager
Work Location
Mobile Number

Part B – Leave Details

Type of Leave	[ ] Casual [ ] Sick [ ] Earned/Privilege [ ] Compensatory Off [ ] Leave Without Pay [ ] Other: [Specify]
From Date (DD/MM/YYYY)
To Date (DD/MM/YYYY)
Number of Working Days
Half Day	[ ] First Half [ ] Second Half [ ] Not Applicable
Reason for Leave
Address and Phone Number During Leave

Part C – Work Handover

Form · Word

Leave Application Form

Download .docx

[Company Logo][Company Name]
LEAVE REQUEST FORM
Company:
[Company Name]
Request Date:
[Date]
Employee
Name [Employee Name]
Employee ID [Employee ID]
Team / Department [Department]
Shift (if applicable)
Manager [Reporting Manager]
Leave Requested
Leave Code From (DD/MM/YYYY) To (DD/MM/YYYY) Total Days
[CL/SL/EL/CO/LWP] [DD/MM/YYYY] [DD/MM/YYYY] [Number]
[Leave Code] [DD/MM/YYYY] [DD/MM/YYYY] [Number]
Purpose (brief)
Reachable on (phone / email)
Form · Word
Leave Request Form
Download .docx
Form · Word
Leave Approval Form
Download .docx
[Company Logo][Company Name]
LEAVE APPLICATION – NOT APPROVED
Ref. No.:
[Reference Number]
Date:
[Date]
To,
[Employee Name]
[Designation], [Department]
Employee ID: [Employee ID]
Subject: Your Leave Application dated [Date] for [DD/MM/YYYY] to [DD/MM/YYYY]
Dear [Employee Name],
Thank you for submitting your application for [Number] days of [Leave Type] from [DD/MM/YYYY] to [DD/MM/YYYY]. We have reviewed it carefully along with the team schedule for that period.
We regret that we are unable to approve the leave for these dates for the following reason:
Letter · Word
Leave Rejection Letter
Download .docx

Name	[Employee Name]
Employee ID	[Employee ID]
Team / Department	[Department]
Shift (if applicable)
Manager	[Reporting Manager]

Leave Code	From (DD/MM/YYYY)	To (DD/MM/YYYY)	Total Days
[CL/SL/EL/CO/LWP]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]
[Leave Code]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]

Purpose (brief)
Reachable on (phone / email)

Leave Type Applied
Period Applied: From [DD/MM/YYYY] To [DD/MM/YYYY]
Days Applied

[Company Logo][Company Name]

REQUEST FOR CANCELLATION OF SANCTIONED LEAVE

Date:: [Date]

To,
[Reporting Manager]
[Designation]
[Department], [Company Name]

Subject: Request to Cancel Sanctioned Leave – Ref. [Reference Number]

Dear [Reporting Manager],

My application for [Leave Type] from [DD/MM/YYYY] to [DD/MM/YYYY] ([Number] days) was sanctioned on [Date] vide reference [Reference Number]. Due to [brief reason, e.g. change in family plans / completion of personal work earlier than expected], I would like to withdraw this leave as below:

[ ] Full cancellation – I will be on duty for the entire period
[ ] Partial cancellation – I will report for duty from [DD/MM/YYYY]; leave from [DD/MM/YYYY] to [DD/MM/YYYY] will continue
Number of days to be cancelled	[Number]

Letter · Word

Leave Cancellation Request

Download .docx

[Company Logo][Company Name]

APPROVAL OF LEAVE CANCELLATION

Ref. No.:: [Reference Number]
Date:: [Date]

To,
[Employee Name]
[Designation], [Department]
Employee ID: [Employee ID]

Subject: Approval of Cancellation of Leave Sanctioned vide Ref. [Reference Number]

Dear [Employee Name],

This refers to your request dated [Date] to cancel the [Leave Type] sanctioned to you from [DD/MM/YYYY] to [DD/MM/YYYY]. Based on confirmation from [Reporting Manager] that you reported for duty on [DD/MM/YYYY], your request has been approved as follows:

Particulars	Details
Leave originally sanctioned	[Number] days ([DD/MM/YYYY] to [DD/MM/YYYY])
Leave cancelled	[Number] days ([DD/MM/YYYY] to [DD/MM/YYYY])
Leave availed (if partial)	[Number] days
Leave head re-credited	[Leave Type]
Revised balance	[Number] days

Letter · Word

Leave Cancellation Approval

Download .docx

[Company Logo][Company Name]

LEAVE BALANCE STATEMENT

Company:: [Company Name]
Statement Period:: [DD/MM/YYYY] to [DD/MM/YYYY]
Issued On:: [Date]

Employee Name	[Employee Name]
Employee ID	[Employee ID]
Designation	[Designation]
Department	[Department]
Date of Joining	[Date of Joining]

A. Summary by Leave Type

Leave Type	Opening Balance	Credited	Availed	Lapsed	Encashed	Closing Balance
Casual Leave	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]
Sick Leave	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]
Earned / Privilege Leave	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]
Compensatory Off	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]

B. Leave Availed During the Period

Sl. No.	From	To	Days	Leave Type	Approval Ref.
1	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Leave Type]	[Reference Number]
2	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Leave Type]	[Reference Number]
3	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Leave Type]	[Reference Number]

Report · Word

Leave Balance Statement

Download .docx

[Company Logo][Company Name]

LEAVE REGISTER

Name of Establishment:: [Company Name]
Address:: [Company Address]
Leave Year:: [YYYY]

Employee Name	[Employee Name]
Employee ID / Token No.	[Employee ID]
Father's / Spouse's Name
Designation	[Designation]
Department	[Department]
Date of Joining	[Date of Joining]

Opening Position

Leave Type	Balance Brought Forward	Credit for the Year	Total Available
Earned / Privilege Leave	[Number]	[Number]	[Number]
Casual Leave	[Number]	[Number]	[Number]
Sick Leave	[Number]	[Number]	[Number]

Leave Entries

Sl.	Date of Application	Leave Type	From	To	Days	Balance After	Sanctioned By	Remarks
1	[DD/MM/YYYY]	[Leave Type]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Number]	[Initials]	[Remarks]
2	[DD/MM/YYYY]	[Leave Type]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Number]	[Initials]	[Remarks]
3	[DD/MM/YYYY]	[Leave Type]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Number]	[Initials]	[Remarks]
4	[DD/MM/YYYY]	[Leave Without Pay]	[DD/MM/YYYY]	[DD/MM/YYYY]	[Number]	[Number]	[Initials]	[Remarks]

Leave Register

Download .docx

Leave Tracker

Preview of the template

Legend

What this template includes

When to use it

How to customise this template

HR tips

Frequently asked questions

Part A – Employee Details

Part B – Leave Details

Part C – Work Handover

Leave Application Form

Employee

Leave Requested

Leave Request Form

1. Employee Details

2. Leave Applied For

3. Leave Sanctioned

Leave Approval Form

Subject: Your Leave Application dated [Date] for [DD/MM/YYYY] to [DD/MM/YYYY]

Leave Rejection Letter

Subject: Request to Cancel Sanctioned Leave – Ref. [Reference Number]

Leave Cancellation Request

Subject: Approval of Cancellation of Leave Sanctioned vide Ref. [Reference Number]

Leave Cancellation Approval

A. Summary by Leave Type

B. Leave Availed During the Period

Leave Balance Statement

Opening Position

Leave Entries

Leave Register

Leave Tracker

Preview of the template

Legend

What this template includes

When to use it

How to customise this template

HR tips

Hire top talent from BetterJobs

Frequently asked questions

Related HR templates