Attendance management is the crucial part for Human resource department. This is required for leave balance calculation and salary processing. In case of a small organization with few employees, this can be maintained in the excel template. This attendance sheet in excel with formula will help in leave and attendance management of employees with visualization dashboard.
Before using this template, please read following points:
This template can be used for monitoring the attendance and leave for one month. You have to create different sheet for each month.
You have to update year and moth in the sheet. Month days will be updated based on the month and year selected in the sheet.
Copy and paste the formula to add more employees in the template.
To update the attendance and leave in the sheet, select from the drop down list.
The company leave policy provides for different types of leaves for employees. This can be sick leave, Casual leave, Earned leave etc. the balance of these types of leaves can also be maintained in this attendance template. You can change the type of leaves if required as per the leave policy. The closing balance of the leaves will be calculated automatically based on the updating in the sheet.
From India, Bangalore
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.