A leave tracker Excel template records each employee’s opening leave balance, leave taken, and balance left for every leave type. This free leave tracker for Indian companies keeps casual, earned, and sick leave in separate columns with live balance formulas, so the numbers never go out of sync. Use it to answer "how many leaves do I have left" instantly, then move to self-service leave once approvals pile up.

Free Leave Tracker Excel Template for Indian Companies

A leave tracker Excel template records each employee’s opening leave balance, leave taken, and balance left for every leave type. This free leave tracker for Indian companies keeps casual, earned, and sick leave in separate columns with live balance formulas, so the numbers never go out of sync. Use it to answer "how many leaves do I have left" instantly, then move to self-service leave once approvals pile up.

What a Leave Tracker Excel Template must include

  • Employee ID, name, and department
  • Opening balance, taken, and balance for each leave type (CL, EL, SL)
  • Balance = Opening minus Taken, as a live formula
  • Total taken and total balance across all leave types
  • A clear leave-year start date so accruals reset correctly
  • One row per employee

Drafting tips

  • Lock the Balance and Total formula columns so only the Opening and Taken cells can be edited.
  • Set your leave year clearly (calendar or April to March). Earned leave carry-forward and encashment depend on it.
  • Add a Carry Forward column at year-end before you reset opening balances, so nothing is lost.

Leave Tracker Excel Template format

EMPLOYEE LEAVE TRACKER for leave year [YYYY]
Leave types: CL = Casual Leave  |  EL = Earned/Privilege Leave  |  SL = Sick Leave

Set each employee’s opening balance, then update the Taken columns as leave is approved.
The Balance columns subtract themselves, and the totals add across all leave types.

KEY FORMULAS (row 2 example)
CL Balance     = CL Opening - CL Taken       (D2 - E2)
EL Balance     = EL Opening - EL Taken       (G2 - H2)
SL Balance     = SL Opening - SL Taken       (J2 - K2)
Total Taken    = E2 + H2 + K2
Total Balance  = F2 + I2 + L2

FAQs

What is a leave tracker?

It is a sheet that records, for each employee, the leave they started with, the leave they have taken, and the balance left, usually split by casual, earned, and sick leave.

How do I calculate leave balance in Excel?

Subtract leave taken from the opening balance: Balance = Opening - Taken. This template does it for CL, EL, and SL, then totals the balances across all three.

What are CL, EL, and SL in Indian leave policy?

CL is casual leave for short personal needs, EL (or PL) is earned leave that accrues and can often be carried forward or encashed, and SL is sick leave. The exact entitlement is set by state Shops and Establishment rules and your policy.

How does leave carry-forward work?

Many states let unused earned leave carry into the next year up to a cap, and some require encashment beyond it. At year-end, record the carry-forward, then set it as the next year’s opening balance.

Can Excel handle leave for a whole company?

For a small team, yes. Past that, manual updates, approval emails, and accrual every month become error-prone. Self-service leave software keeps balances live and routes approvals automatically.

When should I move to leave management software?

When employees keep asking for their balance, when approvals get lost in email, or when accruals and encashment math gets complex. Indian HRM gives every employee a live balance and a one-tap apply-and-approve flow.