Free Monthly Attendance Templates in MS Excel. Use these attendance tracker spreadsheets to record, analyse and plot your student attendance records each month. Simply enter the Month and Year required at the top of the attendance sheet, together with your class details. Use the following name format to ensure consistency; [SURNAME]. The following pages contain multiple templates that you can customize using Excel. There are also some printable PDFs such as blank attendance and sign-in forms. These attendance sheet templates are designed specifically for school class attendance where you need to track student attendance daily.
Employee Attendance Sheet is a document that records the presence, absence, sick leave etc of employees for payroll or salary purpose.
It consists of records of payroll heads used to calculate the salary. to present, absent, late comings, holidays, on job training and all other kinds of leaves.
There are many kinds of leaves like Paid Leave, Sick Leave, Maternity Leave, Casual Leave etc.
Office Administrators working in HR departments need to keep records of employees attendance in detail.
In olden times, attendance sheets were physically made on books. As time passed and the usage of computers increased, people started maintaining records on computer.
With further advancement now we can see the fingerprint machines at most companies.
Attendance Sheet for Employees: If you are running a company then you need to maintain the attendance sheet of your employees so that we are sharing here Employees Attendance Sheet 2018, Templates, Tracker in Excel, PDF & Word. The attendance sheet is available in excel format for the year 2018. For this purpose an employee attendance sheet or the office attendance sheet is used, it is a useful document that marks the presence, absence, and leaves, etc. Of all the employees and is used later on for the purpose of payroll or salary calculation. The attendance sheet is available in excel format for the year 2018. To maintain the attendance of any company, we need attendance sheet. Also Check: July 2018 Calendar Printable. Attendance and punctuality are necessary to rate an employee on if you have the accurate timekeeping records.
Currently, in India there about 40% – 50% of small and medium companies still maintain their record on excel.
An Attendance sheet helps to keep an eye on the employee and further increase the performance of the company.
Employee Attendance Sheet Excel Template
We have created an easy to use Employee Attendance Sheet Excel Template with predefined formulas.
You can maintain up to 50 employees record in this template. You just need to enter some employee details and select from the drop-down menu.
This template can be helpful to accountants for calculating salary and also office admins/ HR Assistants for HR/Employee benefit related records.
Click here to Download All HR & Payroll Excel Templates for Rs 199.
Create Attendance Sheet In Excel
You can download the same in Numbers from the link below:
Additionally, you can download other accounting templates like Petty Cash Book, Simple Cash Book, and Accounts Payable Excel Templates from here.
Let us discuss the components of this template in detail.
Contents of Employee Attendance Sheet Template
This template consists of 4 sections:
1. Header Section 2. Employee Details Section 3. Attendance Record Section 4. Summary Section 1. Header Section
Header section consists of the company name, heading of the sheet and the month for which the attendance is maintained.
2. Employee Details Section
This section consists of the employee details like name of the employee, employee id, his department and his designation.
3. Attendance Record Section
Attendance record section consists of the heading of the month, days of the month (28,30 or 31).
In the dates section you need to enter only the first date and it will automatically update all the rest dates according to the formula.
The formula applied here is =F3+1 and so on. For days you need to enter them manually.
Now for updating the present, absence record, we have created a drop down list with data validation.
Details of the drop-down list are as follows:
P = Present. (Turns the cell green with conditional formatting).
A = Absent. (Turns the cell red with conditional formatting).
Hid Compliant Touch Screen Driver for Windows 7 32 bit, Windows 7 64 bit, Windows 10, 8, XP. Uploaded on 3/13/2019, downloaded 3360 times, receiving a 80/100 rating by 1932 users. Hid Compliant Touch Screen Driver Version: 876mDL4F. Microsoft Microsoft SideWinder X3 Mouse (IntelliPoint) Up To Date. Hid Compliant Mouse Driver for Windows 7 32 bit, Windows 7 64 bit, Windows 10, 8, XP. Uploaded on 3/4/2019, downloaded 6769 times, receiving a 78/100 rating by 3985 users.
OT = Over Time.
L = Late.
SL = Sick Leave.
EL = Earned Leave.
PL = Paid Leave.
CL = Casual Leave.
ML = Maternity Leave.
NH = National Holiday.
Excel Employee Attendance Sheet Template
FH = Festive Holiday.
H = Other Holiday.
TR = Training.
Click on the link below to know how to create a drop-down list in 3 easy steps.
At the end, you can find the total of employees present each day.
Attendance Sheet Format In Excel With Formula
The formula applied here is =COUNTIF(F4:F53,”P”).
Best Attendance Sheet Format In Excel
Every Sunday is marked blue. If you want to update with “H” you can or else leave blank.
4.Summary Section
Summary Section consists of the individual total of each employee for the following heads:
Present.
Absent. Over Time. Late. Sick Leave. Earned Leave. Paid Leave. Casual Leave. Maternity Leave. National Holiday. Festive Holiday. Other Holiday. Training.
We thank our readers for liking, sharing and following us on different social media platforms.
Monthly Attendance Sheet Template Excel
If you have any queries please share in the comment section below. I will be more than happy to assist you.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |