Attendance sheet in excel - income tax Xls Download.. CiteHR

Irfan_shaikh Started The Discussion:

how to create employee attendance sheet in excel

mba_suneetha -  Member Since: Dec 2008
Hi Irfan,

May be you can try Payroll Champion from and it costs Rs5000/-.

You can maintain employee profile's and daily attendance and you can generate Payslips in PDF format.


Dixitkumar P Shah -  Member Since: Feb 2009
Attendance Register From 25

Attached FilesProvided by community member Dixitkumar P Shah. Join us to learn and grow with your peers.
File Type: xls Attendance Register From 25.xls (409.0 KB, 13496 views) -  Member Since: Apr 2009
Dear Dixit, Could you please provide me Attendance Register as per Karnataka Factory Act in Form-22. Regards, Ivan

tanuku -  Member Since: Jun 2009
Dear Shah, attendance sheet excellent but protested by a password. If it is unprotected, very useful for all. Regards, BVR

ramukumar -  Member Since: Dec 2008
Hi Dear !!!! Plz find enclosed format for attendance sheet.

Attached FilesProvided by community member ramukumar. Join us to learn and grow with your peers.
File Type: xls Format for Attendance sheet.xls (31.5 KB, 5930 views)
carora -  Member Since: Dec 2008 you go for unprotected version of the file. Cheers!

Attached FilesProvided by community member carora. Join us to learn and grow with your peers.
File Type: xls Attendance%20Register%20From%2025(1).xls (415.5 KB, 3766 views)
rabiya.anjum -  Member Since: Dec 2009

I need a help we follow a server data which then we need to convert it into an excel format wherein we put some formulas,but i need a simple format where i can maintain it with out putting any formulas.

jiguparmar -  Member Since: Dec 2008
Please find Following link for Excel base Payroll Sheet and Attendance Program(Up to 200 Employees)


1-Attendance Register
2-Payroll Register
3-Generate Salary Slip
4-ESI/PF/TDS Calculation
4-Track Employees' Leave history
5-Track Income Tax of All Employee
6-Print out Leave History of Employee
7-Overtime Monitor
8-Master Data sheet of All Employees
9-Leave Calculation sheet

For more Free Excel Cration For Home/Office and Free Books visit
Free Excel Programs-Softwares-Books-Novels

jiguparmar -  Member Since: Dec 2008
Please find new version of Salary Master with new Feactures..

Totally Usefriendly program.
You can enter your Company name,Address,Department,Designations
You can set Categoeries of Fixed earning-Other Earning-Fixed deduction-Other deduction in Salary Slip.
You can set limit of ESI,P.F,Income Tax Slab for Man and Woman,Surchage setting,Professional Tax.

Program is Designed on Two mode
(1) In Auto mode salary slip will be generated as per Your predefined data given in "Company Detail Sheet"
(2) In Manual mode Salary Slip will be generated as per Manual detail given by You.It will not concern with the data given by you in "Company detail sheet"
Ex: We need to generate salary for Regular Employee as per company Policy for that You may put this employees on Auto mode and it will generate Salary slip as per your predefined data (If Basic is 25% of Gross than auto calculate it)But Some Employees are Temperaroy or We don't Follow Rules as per Regular employee so that This Type of Employee Put on Manual mode and enter your Data manually(here You have manually enter Basic and other details).

Software Contains:

1-Attendance Register.
2-Payroll Register.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
6-Print out Leave History of Employee.
7-Overtime Monitor.
8-Master Data sheet of All Employees.
9-Leave Calculation sheet.
10-ESI Calculation(Set Your Requirements)
11-P.F Calculation
(Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%
Second is 12% of Basic)
12-Pension Scheme (not more than 541 rs submission)
13-TDS Calculation
14-Annual Salary statement of Employee and Employer
15-Employer Monthly Salary statement
16-Income Tax Calculations
17-Generation of Form No-6 (For ESIC)
18-Generation of Form no-3A (PF)
19-Generation of Form no-6A(PF)

Limitation: You have monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.
Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.

If You find this is useful for You than Don't miss to deop Thanks...


  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • 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.

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Share This Discussion:

    3M Users, 100K+ Documents & 450K+ Discussions
    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network