Managing Leave Records on Your Computer: What Columns Should You Include?

I would like to know how to manage leave records on the computer and what columns I should include in the leave register.

Hi Samarsing,

This is with reference to your query. I am attaching the Excel sheet for attendance to be maintained on the computer. If you have any doubts or queries, please revert back to me.

Hope this will provide you with the information you are looking for.

Cheers,
Nidhi (HR Executive)

Hi Samar,

You may maintain the attendance in a simple Excel sheet only. Start with E-Code and Name of the employee, then put the column for Designation and Date of Joining. Then onwards, date and month. Below them, mark Present, Absent, Leave, or Holiday. By this way only, you may maintain it in a very simple way. Moreover, at the end, put the formula and calculate all the Absent and leaves taken in that month.

Hope it will help you to do the same.

Regards,
Amit Seth.