Once I have created this simple yet complete format of Daily Attendance Report for my staff to report me the daily attendance of all employees. This served my purpose very well. It is divided into two sections, at the top you can see summary view where you can see number of employees, absence, on leave and present. While the second section list each and every employee along with its attendance status. This section can be extended to next sheet to accommodate more and more employees. I am sure this will be helpful to many others so I am just sharing it with my visitors.
Here is preview of this Daily Attendance Report,