1.0HR Letter Formatshttps://www.yourhrworld.com/formatsrich600338<blockquote class="wp-embedded-content" data-secret="Yt0Z7a1LaY"><a href="https://www.yourhrworld.com/formats/hr/attendance-report-2011/">Attendance Report Format</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.yourhrworld.com/formats/hr/attendance-report-2011/embed/#?secret=Yt0Z7a1LaY" width="600" height="338" title="“Attendance Report Format” — HR Letter Formats" data-secret="Yt0Z7a1LaY" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.yourhrworld.com/formats/wp-includes/js/wp-embed.min.js </script> Download the “Attendance Report Format” and just update the Employee Name, Emp ID, Designation, Department and Team Name in the “Jan Sheet” only and the rest will be automatically updated, it’s a yearly attendance report which will help you in tacking the Daily, Monthly & yearly Attendance, and will also tack the attrition percentage as well. And if you have few or many teams, then in the department Column you can put your Team Names and it will help you in tracking Team wise attendance and attrition as well. Also check the below link to download the automated attendance format