If you are working as a human resource staff or manager, you might looking for excel spreadsheets that you can use to manage and monitor your employee’s attendance. This is the case if you want to evaluate your employee’s performances and you think the attendance management software, usually provided together with attendance machine, cannot accommodate your needs. These three spreadsheets, Employee Attendance Calendar, Employee Timesheet Manager and Employee Shift Schedule Planner, are best spreadsheets you can use to manage your employee’s attendance. They can be opened in excel version 2007 and above and can be moved between computers without problems. And there is no macros inside so you won’t get any macros warning while opening these files which usually pop up because of windows or antivirus security system protection.
1. Employee Attendance Calendar
This is a spreadsheet to manage and record your employee’s attendance. You can use it to record their attendance for one full year. There are 12 attendance worksheets where you can easily mark their absences by typing related absence code in related dates. And there are marking colors that you can specify in setup worksheet to help you differentiate absence codes as well as holiday dates in the calendar.
There are reports that will summarize your company’s employee attendance. You can see the report in two kind of forms, total employee and single employee report. And there is a calendar dashboard that will show you the performance of your employee’s attendance. Since it is created in Microsoft Excel, you can easily pull the data and evaluate it to follow your company’s policy.
The lite version will always start from January. You can change the year period only. The Medium version will allow you to start from any month. It will be useful if your financial year is not starting from January, while the Pro version will allow you to record and monitor your employee’s attendance for 3 years, but the Pro version can’t start from specific month.
2. Employee Timesheet Manager
This excel spreadsheet is suitable for company that record their employee’s attendance based on hour instead of day. Usually it is applied in manufacturing or construction companies where they also pay their wages on weekly bases.
To start using this template, you have to set your company’s attendance year period and set your working days per week. There are other parameters like absence codes and holiday dates that you can type to mark those days in employee’s timesheets. Then you can put your employee’s name in respective worksheets as well as add several detail information related to those employees, for example their hourly wages. You can start to fill your employee’s working hours based on their time card. In this spreadsheet, you can also generate and print a blank timesheet you can use to record your employee’s attendance manually before record it into this file.
And there is a report worksheets you can use to evaluate and analyze your employee’s attendance and also you can use to calculate the total wages based on their attendance. You can try and do several simulation using the lite version. And if you need more features, you can purchase the Pro version.
3. Shift Schedule Planner
Creating a shift schedule could be time consuming, especially if you have to manage a large number of employees and you have to be precisely divide them into several groups with proportional working hour. Also, you must calculate their resting time carefully to make sure that they are healthy enough when their shift time come.
Fortunately, there are many shift schedule samples available in several internet sites where you can copy and implement it to your employees. Still, you need some knowledge of Microsoft Excel, the most suitable spreadsheet creator to implement those samples into a real shift schedule. Or, you will fall on purchasing a built-in shift schedule software to manage it well. There are plenty of them, but if it come to a shift schedule created in Excel, there is only a few of them.
This one below is a well designed shift schedule generator in Excel. It is good enough for you to cut your time needed to arrange your employee’s shift schedule. And it is not as complicated as other software you might have used. Of course there are some limitation, but if your need is only to create a decent shift schedule, you should use this one.
The free version will allow you to create the standard schedule where you can choose from 26 pre-designed shift plans. You can select from 2 until 4 shift period that cover 10/5 until 24/7 working days per week. Some values are adjustable, so you don’t have to create custom plan if you have different number of working time per day/working time per shift. And you can change the start time of each shift period to follow your company’s policy. If you can’t find the suitable one for your company, you can try to create your own shift schedule also by putting your own patterns in custom table in setup worksheet. This spreadsheet is easy to use. Just follow the 3 steps written inside the spreadsheet and you’re done. This spreadsheet also works well in Macintosh/Apple OS. You can save the file in Excel for Mac OS and open it in Excel for Windows OS and vice versa.
If you think this one is useful and you need additional features as well as other pre-designed plans, you can purchase it.
If you’d rather like to manage and monitor your employees using Microsoft Excel, where you can integrate and play around with your other Excel report easily, those spreadsheets above should fit your needs. But, if you need more integrated and sophisticated software, you might skip above spreadsheets.