Employee Leave Tracker (Excel)
Record every leave with its dates and type; the tracker counts the working days (skipping Sundays and your holiday list) and shows each employee's leave taken and balance for every leave type for the year.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
Balance
| Employee | Casual | Sick | Earned | Unpaid | ||||
| Taken | Left | Taken | Left | Taken | Left | Taken | Left | |
| Rahul Mehra | 2.5 | 9.5 | 0 | 12 | 0 | 15 | 0 | 0 |
| Pooja Rani | 0 | 12 | 3 | 9 | 0 | 15 | 0 | 0 |
| Arjun Nair | 0 | 12 | 0 | 12 | 0 | 15 | 0 | 0 |
What's inside
- Settings: year start, leave types with yearly quota (Casual 12, Sick 12, Earned 15 to start with)
- Holidays list for the year
- Leaves sheet: employee, type, from, to, half day, reason; days counted automatically
- Balance sheet: taken and remaining for every employee and type, negative balances in red
How to use it
- On the Settings sheet check the leave types and quotas and the year start date.
- Type your holiday list on the Holidays sheet.
- List your employees on the Employees sheet.
- For each leave, add a row on the Leaves sheet: employee, type, from date and to date (tick half day if it is half a day).
- Open the Balance sheet to see leave taken and left.
Tips
- Only Sundays and listed holidays are skipped. If Saturday is also off, change the weekend code on the Settings sheet from 0000001 to 0000011.
- Unpaid leave can be a separate type with a quota of 0.
Questions and answers
Does it carry forward leave?
Not automatically. At the year end, add the carried-forward days to the next year's quota for that employee type, or note it on the Employees sheet.
Can it handle half days?
Yes. Put Yes in the Half day column and the leave counts as 0.5 day.
More in the Office, HR & Freelancers toolkit
Salary Sheet & Payslip (Excel)Free Excel salary sheet for small offices: earned salary by days paid, PF and ESI deductions, professional tax, TDS, adv…Excel templateOffer Letter & Experience Letter (Word)Free editable offer letter and experience certificate formats for Word: company letterhead, joining details, salary, ter…Word templateOnline Salary Slip MakerMake a salary slip online: earnings, deductions, PF, ESI, net pay and amount in words. Print, save as PDF or download as…Online tool
Also useful
GST Invoice Template (Excel)Free GST tax invoice template for Excel. Pick a customer and items; it fills HSN, rates, CGST+SGST or IGST and the amoun…Excel templateGST Monthly Summary (Excel)Free Excel workbook that totals a month's sales and purchases by GST rate: taxable value, IGST, CGST, SGST, B2B and B2C,…Excel templateClient Dues & Ageing (Excel)Free Excel receivables tracker: list bills and receipts, see each client's balance by age (not due, 1-30, 31-60, 61-90, …Excel template