How Do I Create an Employee Leave Tracker in Excel for a Small Team?

Dear All,

My manager has asked me to prepare an Excel sheet for all the employees to track the status of leaves taken, leave balances, reasons for leave, dates of leave, etc. Can anybody help me prepare the sheet? Our organization consists of 20 employees.

Regards,
Subhashini

Dear subhashinisankara,

Did you receive all the sheets while downloading? I inserted 4 sheets that include late, overtime, attendance, and leave balance.

Regards,
Shyam

Dear Shyam,

Thank you very much! It is really useful for me. I have a few doubts in entering data. I will get back to you with all my doubts by this evening.

Thank you.
Regards,
Subha

Hi Subha,

Before I can forward you the sheet for preparing leave records for 20 persons, please tell me the following details:
1) How many days are working?
2) Are Sat and Sun holidays?
3) Are any other types of leaves allowed to employees like EL / HPL? If yes, then how many?

If you already have software for handling the leave, please forward it to me.

Regards,
RK Sinha
[Login to view]

Hi Sinha,

We have a total of 20 employees engaged in software development. Saturday and Sunday are the holidays. Ours is a budding company; currently, we have 12 annual casual leaves and 30 sick leaves.

Regards,
Subha

Thank you for the information, sir.

I am working as an HR Executive in an Engineering Firm with a total of 38 employees. I am responsible for maintaining the annual leave records and need to submit them to my boss this month.

I would appreciate your assistance in creating the annual leave records.

Regards,
Anamika

Hi All,

Thank you for all your support. Can anyone also talk about the leaves lapsed?

In my organization, we have a leave system wherein everybody is entitled to 30 working days of leave. Out of 30, 10 leaves are compulsory to be taken (i.e. they get lapsed if unavailed), and the remaining 20 days are carried forward to the next year.

Please suggest.

Thanks,
Divanshi

Hi, your leave register is very helpful. Can you please clarify the terms W.Off, Paid Holiday, C.Off., Abst., and Susp.?

Thank you.