Dear All,

I am very glad to post my first assignment on CiteHR. I have use this site more than 4 months and I am very happy with this site which give me large information on Admin, HR, Accounts and Management. Specially I like management, personality development and motivating presentations.

Now it is my turn, So I am attaching this excel sheet. I am confident that you good people will really admire my work.

I have made this excel sheet using Vlookup command and other commands and I assure that these commands will definately help you how to use Vlookup command in excel and its benefits.

I have highlighted some cells in yellow, you just put necessary information in that cell.

You just put attendance in Attadance sheet and it will create Salary Sheet, Pay slip, Bank List, PF ESIC Deduction List and PT summary.

I am eagerly waiting for your response and suggestions. Also I am waiting for new assignments from you.

I will update this excel file time to time and post it on this site.


:)Thanks & Regards,
(My email ID is )
10th September 2009 From India, Mumbai
Attached Files
Registration required. Create all access/no charge Cite.Co account first.
File Type: xls SALARY.xls (155.5 KB, 22080 views)

India, Bangalore
Sr. Manager Hr/admin
India, Jaipur
Asif Danwad
India, Bangalore
Management, Structures
India, Ahmadabad
Owner At Integrated Organizational Solutions
India, Delhi
Hr & Training
Ashok Kumar Dubey
India, Gurgaon
Hr, Admin, Legal
India, Delhi
India, Mumbai
India, New Delhi
Accounts Manager
Shashi Sharma
Compensation,payroll, Staff Welfare
India, Hyderabad
Accounts,finance, Commercial, Admin, Hr,
India, Pune
+28 Others

Dear Sandeep, the product seems to be good. keep up the good work. Kind regards, ASIF DANWAD
10th September 2009 From India, Bangalore
dear sandeep i downloaded the excel file but it says excel sheet is protected and asks password , pl help me rgds voichal
11th September 2009 From India, Madras
This is very nice data & valuable for everyone, you should be appricated for this by everyone, but plz. take care you are sharing valuable salary data which is confedential, plz. take care.
12th September 2009 From India, Pune
Hi Sandeep I will really appriciate your great work.Its really helpful for processing of salary and the statutory also. Keep in touch..... Regards Manjunath Human Resources PSK Engg.Pvt.Ltd Bangalore
12th September 2009 From India, Kochi
Started with Excellent,Fabulous,Awesome work Sandeep! no more words to express Get going Cheerz Jeeva
12th September 2009 From India, Bangalore
salary sheet is protect pls give password
12th September 2009 From India, Delhi
Attached Files
Registration required. Create all access/no charge Cite.Co account first.
File Type: doc registration for esi and pf.doc (20.5 KB, 2177 views)
HI, Sandeep
This is really good work and thank you very much to you for this work. I think it need some improvement such IF any employee salary attendance is not a full month then we need to calculated his salary manually and enter in sheet. It will be extremely good if when we enter no. of days in attendance sheet it calculated automatically.
But all is very very good work.
12th September 2009 From India, Gurgaon
The posting is very usefull. In fact I was looking sor something like this. It would be great help if you prepare form-16 as well as full and final satement in this excel sheet (its just a suggestion).
12th September 2009 From United Arab Emirates, Dubai
please tell me that the TDS is decucted everymonth from the emp salary or is deducted ones in a year. Please also describe the process of calculating TDS form employee salary in industrial company.
Vishal Harjani
12th September 2009 From India, New Delhi


Discuss problems openly with your peers around the world without getting into company specifics. Access to years of such problem discussion data and business material is at your finger tips.
All resources created by our members are available to everyone at no cost.

Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction. 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+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network