MRajesh Started The Discussion:
Hi All,

Attached is the attendance sheet in excel. This is not my own work. I have just done some essential changes in this sheet which was posted earlier in Cite HR. I hope this attendance sheet will fulfill your requirement. Not only you can calculate the attendance for each month but also track leave record for each employee. You can modify it according to your organization policy.


Posted 22nd February 2008 From India, Bhopal
Attached Files
Shared By Cite.Community Member "MRajesh" For Public Download
File Type: xls attendance_sheet-jan_08_850.xls (150.5 KB, 19398 views)
thanks a lot i just joined a new company in HR Dept. There is not any good format of Leave record so i hope it will help me out. THANKS ONCE AGAIN
Posted 5th June 2009 From Nepal, Kathmandu
Dear all, find attached an excel attendance format developed by me for our organization. Pls post your views. bye, Philip
Posted 14th July 2009 From India, Tiruppur
Attached Files
Shared By Cite.Community Member "aphilipshannon5480" For Public Download
File Type: zip (447.9 KB, 2817 views)
How to manage office administration. Could you provide me some tips which can help me to manage my office administration. Thanks
Posted 25th July 2009 From United Arab Emirates, Dubai
Dear Mr. Philip, I have downloaded your file. Let me check and will comment. I will try to make more effective. Thanks, BARUN (
Posted 25th July 2009 From United Arab Emirates, Dubai
dear mrajesh,
can u please help me for sending some sample of memos or letters regarding rules and regulations of the company i.e leave, dress, attendance etc. etc. i am facing a probelm with my seniors becoz they will take a month to give their opinion. so i wanted to send them memo instead of visit them. i hope u can understand my problems

thanks rgds,
Posted 26th July 2009 From Nepal, Kathmandu
can any one help me how to edit the month column in sheet 2 i.e. 1 st jan 2008 to 31 jan 2008, please do help me
Posted 2nd October 2009 From India, Delhi
Attached Files
Shared By Cite.Community Member "neeraj240" For Public Download
File Type: xls attendance_sheet-jan_08_850.xls (150.5 KB, 1996 views)
Thanks if u add Time Record in that it would be better thanks 43213214
Posted 1st April 2010 From India, Delhi
Hi Rajesh, Thanks very much for a great work.... very very helpful...actually fast nd efficient enough to capture required data... Thanks again, kavitha
Posted 23rd August 2010 From India, Madras
Hi Thanks for the attendance sheet. There are four entries under CTC - Basic, HRA, Con. and Total. Could you please let me know what does Co. stand for? Regards Pooja
Posted 14th September 2010 From India, Faridabad
Dear Rajesh, this is an excellent format and very useful. Thanks for providing this format. In the current organization where I am working, the leave balance record were not properly maintained by the previous HRs. The attendance entries are made in Tally but there is no proper system for attendance. This will help me streamline things.
Posted 9th September 2012 From India, Mumbai
Thanks Vijaya. Soon I will post a sheet from which you can calculate department wise/category wise cost. Regards. Rajesh
Posted 23rd September 2012 From India, Bhopal
hi! Please help me and send me some sample how to make attendance sheet for 4 diferent cite office and corporate office
Posted 11th December 2015 From India, Pune
hello rajesh, its a great work....if you have add In time and out time column in that sheet it will be very easy while calculate...plz provide those types of formats... Thank you
Posted 13th April 2016 From India, undefined
That is a wonderful effort to capture leaves. However, I think manual updating of sheets while the company grows will be a challenge. You can try 'Clockit' - ClockIt - ClockIt

This is a platform which will end all your woes and will save you the trouble to compute attendance data across multiple office locations. Sharing this info cause I was benefitted from the platform. I now can concentrate on improving the happiness quotient of my employees.

Hope it helps you too.. the best part of this software is that it integrates with your current time monitoring hardware and has a trial period of 30 days! I found it useful in the first week itself!
Posted 18th April 2016 From India, Bengaluru


Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network