Free template template · Word

Leave Accrual Sheet

A leave accrual sheet calculates how much leave each employee earns month by month, based on the accrual rule in the leave policy, and keeps a running balance. It handles pro-rata credit for new joiners and reduced accrual for months with leave without pay where the policy requires it.

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

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[Company Logo][Company Name]

LEAVE ACCRUAL SHEET – [LEAVE YEAR]

Company:: [Company Name]
Leave Head:: [Earned / Privilege Leave]
Accrual Rule:: [Number] day(s) per [month of service / Number days worked]
Rounding:: [Nearest 0.5 day]
Maximum Accumulation:: [Number] days

Employee	Emp. ID	DOJ	Opening Bal.	Q1 Accrued	Q2 Accrued	Q3 Accrued	Q4 Accrued	Availed	LWP Adj.	Closing Bal.
[Employee Name]	[Employee ID]	[DD/MM/YYYY]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]
[Employee Name]	[Employee ID]	[DD/MM/YYYY]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]
[Employee Name]	[Employee ID]	[DD/MM/YYYY]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]
[New Joiner Name]	[Employee ID]	[DD/MM/YYYY]	0	[Pro-rata]	[Number]	[Number]	[Number]	[Number]	[Number]	[Number]

Monthly Detail (for attendance-based accrual)

Employee	Month	Days Worked	Eligible Days	Leave Accrued
[Employee Name]	[Month]	[Number]	[Number]	[Number]
[Employee Name]	[Month]	[Number]	[Number]	[Number]
[Employee Name]	[Month]	[Number]	[Number]	[Number]

Notes

Closing balance = Opening balance + accrued − availed − LWP adjustment (if applicable).
Balances above the maximum accumulation are flagged for carry-forward review.
Leave liability for finance: closing balance × per-day rate as per encashment basis.

Prepared by
[HR Name]
Date: [Date]

Reviewed by
[Authorised Signatory]
Date: [Date]

Download Word (.docx) — free

What this template includes

Accrual rule stated at the top (per month or per days worked)
Employee-wise monthly credit columns
Days worked or eligible days where accrual depends on attendance
Adjustments for LWP months and joiners
Leave availed and running balance
Cross-check with the leave register

When to use it

Policies where earned leave accrues monthly or on days worked
Calculating pro-rata leave for mid-year joiners
Year-end checks of balances before carry-forward
Estimating leave liability for finance provisioning

How to customise this template

1State your accrual rule as a placeholder, for example [Number] day per [Number] days worked
2Choose calendar or financial year column order
3Add a column for maximum accumulation cap
4Move to Excel if you want formula-driven accrual

HR tips

Use one rounding rule (e.g. to the nearest half day) consistently
Accrual for new joiners should start from the date of joining as per policy
Check whether LWP days reduce accrual under the rules applicable to you
Reconcile with payroll and the register quarterly

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 is earned leave accrued?+

It accrues according to the rule in your policy and applicable law, for example a fixed number of days per month of service or per set number of days worked. This sheet uses placeholders for the rule.

How do I calculate pro-rata leave for a new joiner?+

Apply the accrual rule from the date of joining to the end of the leave year, using the same rounding method as for other employees.

Does leave accrue during leave without pay?+

It depends on your policy and applicable rules. Many policies reduce accrual for long LWP periods; state your rule in the sheet header.

All 50 leave management →

[Company Logo][Company Name]

LEAVE RECONCILIATION SHEET

Company:: [Company Name]
Period:: [Month, Year] / [Leave Year]
Sources Compared:: [HRMS / Leave Register] vs [Attendance System] vs [Payroll]
Prepared On:: [Date]

A. Employee-wise Comparison

Employee	Emp. ID	Leave per HRMS	Absent per Attendance	LWP per Payroll	Difference	Cause Code	Action	Owner	Status
[Employee Name]	[Employee ID]	[Number]	[Number]	[Number]	[Number]	[C1]	[Action]	[Name]	[Open/Closed]
[Employee Name]	[Employee ID]	[Number]	[Number]	[Number]	[Number]	[C2]	[Action]	[Name]	[Open/Closed]
[Employee Name]	[Employee ID]	[Number]	[Number]	[Number]	[Number]	[C3]	[Action]	[Name]	[Open/Closed]
[Employee Name]	[Employee ID]	[Number]	[Number]	[Number]	[Number]	[C4]	[Action]	[Name]	[Open/Closed]

B. Cause Codes

C1 – Leave approved after payroll cut-off
C2 – Missed punch / attendance not regularised
C3 – Wrong leave type recorded
C4 – Leave taken without application
C5 – Manual edit not synced between systems
C6 – Other (explain)

C. Summary

Template · Word

Leave Reconciliation Sheet

Download .docx

[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

Leave Accrual Sheet

Preview of the template

Monthly Detail (for attendance-based accrual)

Notes

What this template includes

When to use it

How to customise this template

HR tips

Frequently asked questions

A. Employee-wise Comparison

B. Cause Codes

C. Summary

Leave Reconciliation Sheet

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

Leave Accrual Sheet

Preview of the template

Monthly Detail (for attendance-based accrual)

Notes

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