Daily Attendance Recorder Pro is a ready Microsoft Excel Spreadsheet for maintain daily attendance up to 100 employees.
It has 12 Excel tab sheets for every months from January to December. And another one sheet is for yearly summary report.
Every sheets for all months, it has individual columns for record employee ID, name of employees, designations etc.
And every date cells have dropdown menu of Present, Late-In, absent, different types of Leave, Holidays, Offsite Duty, and Roster Duty.
Every monthly sheets also have features of automatically calculate and show monthly summary.
Monthly Summary shows totals of Sick Leave, Casual Leave, Earned Leave, Total Leave, Late, Holidays, Leave without Pay for absent and another one column for add Notes or Remarks.
And yearly Summaries Report automatically calculate yearly totals from every months.
It also shows individual Monthly summary from every Monthly sheets.
For re-use Attendance Recorder Pro for next year, just save as the document and change the year in 1st January cell. Just this change, it will automatically update all the dates, months and also year.