Launch Offer: Extra 20% Off Everything With Code LAUNCH20 · Instant DownloadExtra 20% off with code LAUNCH20
Draftstack
Leave Policy & Leave Balance Calculator (Excel) – Excel template preview
Excel & SheetsNew

Leave Policy & Leave Balance Calculator (Excel)

Set your leave policy and holiday list once, log every leave, and get each employee's earned, casual and sick leave balance with monthly accrual, carry-forward checks and leave encashment value.

₹299₹699Save ₹400 (57%)
Inclusive of all taxes · One-time payment · Instant download
1 offer for you
LAUNCH20 20% off · save ₹60
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
HR teams in small and mid-size companiesFounders who approve leavePayroll teams preparing full and final settlements
What you get2 × .xlsx (blank + sample)
Works withMicrosoft Excel · Google Sheets · WPS Office
DeliveryInstant download
LicencePersonal & own-business use

Frequently bought together

Leave Policy & Leave Balance Calculator (Excel) – Excel template previewThis item: Leave Policy & Leave Balance Calculator (Excel)₹299Payroll & Salary Slip Maker (Excel) with PF, ESI & PT – Excel template previewPayroll & Salary Slip Maker (Excel) with PF, ESI & PT₹249New Labour Code Salary Kit: 50% Wage Rule, PF & Gratuity (Excel) – Excel template previewNew Labour Code Salary Kit: 50% Wage Rule, PF & Gratuity (Excel)₹299
All three: ₹762₹847Extra 10% off

Leave records on paper registers and email threads lead to the same arguments every year: 'I had 12 days left', 'HR says 8'. A clear policy and a log everyone can see end that.

What it does

  • Policy: leave types with days per year, carry-forward limit and whether they're encashable
  • Holidays and weekly off: leave days exclude Sundays (or any weekly off pattern) and holidays automatically
  • Employees: joining date, monthly basic and opening balances carried from last year
  • Leave Log: employee, type, from and to dates, half days and reason, with working days counted
  • Balances: EL earned with monthly accrual, EL taken and balance, CL and SL balances, encashment value and warnings for negative balances or EL above the carry-forward limit
  • Summary: leave taken by type, total encashment liability and holiday count

Fair and transparent

Share balances with employees each month. Fewer disputes, fewer surprises at full and final settlement.

What's inside

Everything you get

01

Policy and holidays

Your own rules and calendar

02

Leave Log

800 entries with working days counted

03

Balances

EL, CL, SL and encashment for 60 people

04

Blank + sample

Sample with six employees

Files in your download

  • XLSXLeave_Balance_Calculator_Policy.xlsx72 KB
  • XLSXLeave_Balance_Calculator_Policy_SAMPLE.xlsx73 KB
How to use

Start in 5 simple steps

A step-by-step guide is also included inside your download.

  1. 1

    Set the policy

    Days, carry-forward, encashment

  2. 2

    Add holidays

    And weekly off

  3. 3

    Add opening balances

    From last year

  4. 4

    Log every leave

    As approved

  5. 5

    Share balances

    Every month

FAQ

Questions about this product

Does it skip Sundays and holidays?

Yes. Leave days are counted with your weekly off pattern and holiday list, so a Saturday-to-Monday leave over a Sunday counts as two days if Sunday is off.

Can earned leave be credited all at once?

Yes. Set 'Accrue earned leave monthly' to No on Settings and the full yearly quota is available from the start.

How is encashment worked out?

EL balance × monthly basic ÷ 26, a common method. Change it if your policy uses a different formula.

Does it follow the labour codes?

It follows the policy you enter. Check minimum leave rules under your state's law and the new labour codes when you set the policy.

How many employees can it handle?

Balances are set up for 60 employees and the log for 800 entries; copy rows for more.

How do I get the files after payment?

A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.

Can I use it on my phone?

Yes. It works with Microsoft Excel, Google Sheets, WPS Office. Free mobile apps are enough.

What if something does not work?

Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.

Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
Complete the set

Goes well with this

See all
₹299₹699