Employee attendance sheet in excel with formula - XLS Download - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.

Attached Files
Membership is required for download. Create An Account First
File Type: zip Attendance recording template_13012019.zip (17.8 KB, 1310 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™