betterjobs

Free report template · Word

Monthly Leave Report

A monthly leave report summarises leave taken across the organisation for a month, by leave type and department, with absenteeism rate, leave without pay, long absences and actions. HR shares it with management to monitor attendance trends and plan staffing.

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

Preview of the report

[Highlighted] = fill in
[Company Logo][Company Name]

MONTHLY LEAVE REPORT – [MONTH YYYY]

Company:
[Company Name]
Prepared By:
[HR Name]
Report Date:
[Date]

1. Overview

MetricThis MonthLast Month
Headcount (average)[Number][Number]
Working days[Number][Number]
Total leave days[Number][Number]
Unplanned leave days[Number][Number]
Absenteeism rate (unplanned days ÷ scheduled days × 100)[Number]%[Number]%
LWP days[Number][Number]
Unauthorised absence days[Number][Number]

2. Leave by Department and Type

DepartmentHeadcountCLSLELMaternity / PaternityComp OffLWPTotal
[Department][Number][Number][Number][Number][Number][Number][Number][Number]
[Department][Number][Number][Number][Number][Number][Number][Number][Number]
[Department][Number][Number][Number][Number][Number][Number][Number][Number]
Total[Number][Number][Number][Number][Number][Number][Number][Number]

3. Long Absences (over [Number] days)

Employee IDDepartmentLeave TypeFromExpected ReturnAction / Support
[Employee ID][Department][Leave Type][DD/MM/YYYY][DD/MM/YYYY][Welfare call / Cover arranged]
[Employee ID][Department][Leave Type][DD/MM/YYYY][DD/MM/YYYY][Action]

4. Observations and Actions

  1. [Observation, e.g. unplanned leave rose in Department around Festival / Season] – Action: [Plan leave rota earlier].
  2. [Observation on unauthorised absence] – Action: [Managers to follow up as per policy with fair hearing].
  3. [Observation on leave balances or lapses] – Action: [Encourage planned EL use before year-end].
Prepared by
[HR Name]
Date: [Date]
Reviewed by
[Authorised Signatory]
Date: [Date]

What this template includes

  • Headcount and working days for the month
  • Leave days by type and department
  • Absenteeism rate with a stated formula
  • Planned versus unplanned leave split
  • LWP and unauthorised absence summary
  • Long absences and actions taken

When to use it

  • Monthly HR MIS to leadership
  • Plants and BPOs tracking absenteeism against targets
  • Spotting departments with unusually high unplanned leave
  • Flagging employees on long leave for welfare follow-up

How to customise this template

  1. 1Define your absenteeism formula in the report header
  2. 2Replace departments with your structure
  3. 3Add a month-on-month comparison column
  4. 4Keep individual names out of the summary unless needed for action

HR tips

  • Report trends, not just numbers; add a short commentary
  • Avoid treating legitimate leave such as maternity as absenteeism
  • Use the report to support employees, for example welfare calls on long sick leave
  • Share department data with department heads for action

For HR & hiring managers

Hire top talent from BetterJobs

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

  • 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 absenteeism rate calculated?+

A common formula is unplanned absence days divided by total scheduled working days for all employees, multiplied by 100. State the formula you use in the report.

What should a monthly leave report include?+

Headcount, working days, leave by type and department, absenteeism, LWP, unauthorised absence, long absences and commentary with actions.

Should maternity leave be counted in absenteeism?+

Generally no. Statutory and planned leave such as maternity should be reported separately from unplanned absence.

All 50 leave management →