Free template template · Word

Leave Reconciliation Sheet

A leave reconciliation sheet compares leave data across sources (HRMS or register, attendance system and payroll) to find mismatches, such as leave approved but not recorded or LWP deducted without a matching absence. Each difference is listed with its cause and the correction made.

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

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[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

Item	Count
Employees reviewed	[Number]
Employees with differences	[Number]
Corrections completed before payroll	[Number]
Carried to next month as arrears / recovery	[Number]

Prepared by
[HR Name]
Date: [Date]

Verified by Payroll
[Name]
Date: [Date]

Download Word (.docx) — free

What this template includes

Period and data sources compared
Employee-wise figures from each source
Difference column
Root cause classification
Correction action and owner
Closure date and sign-off

When to use it

Month-end before payroll is finalised
Year-end before carry-forward and encashment
After migrating from Excel to an HRMS
Preparing for an internal or statutory audit of leave records

How to customise this template

1Name the actual systems you compare (e.g. biometric, HRMS, payroll software)
2Use standard cause codes to analyse trends
3Add a materiality threshold for escalation
4Run it monthly for LWP and quarterly for balances

HR tips

Reconcile before payroll lock to avoid arrears and recoveries
Fix the root cause, not just the individual entry
Keep evidence for each correction
Share recurring issues with managers who approve late

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

What is leave reconciliation?+

It is the process of comparing leave balances and leave-without-pay days across HR, attendance and payroll records and correcting any differences.

How often should leave be reconciled?+

Monthly for LWP and attendance against payroll, and at least at year-end for balances before carry-forward or encashment.

What are common causes of leave mismatches?+

Late approvals, missed punches, leave applied after payroll cut-off, wrong leave type, and manual edits in one system not reflected in another.

All 50 leave management →

[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.

Template · Word

Leave Accrual 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 Reconciliation Sheet

Preview of the template

A. Employee-wise Comparison

B. Cause Codes

C. Summary

What this template includes

When to use it

How to customise this template

HR tips

Frequently asked questions

Monthly Detail (for attendance-based accrual)

Notes

Leave Accrual 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 Reconciliation Sheet

Preview of the template

A. Employee-wise Comparison

B. Cause Codes

C. Summary

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