Salary sheet, Payslip, Bank List, Master data - professional tax

sandeepmore_finance Started The Discussion:

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 )

Attached FilesProvided by community member sandeepmore_finance. Join us to learn and grow with your peers.
File Type: xls SALARY.xls (155.5 KB, 14920 views)
Asif Danwad -  Member Since: Mar 2009
Dear Sandeep, the product seems to be good. keep up the good work. Kind regards, ASIF DANWAD

Voichal -  Member Since: Sep 2009
dear sandeep i downloaded the excel file but it says excel sheet is protected and asks password , pl help me rgds voichal

Bulla Kranthi Kumar -  Member Since: May 2009
Dear Sandeep Excellent job and I don’t have words share with you. It is really helpful for every one who is into Payroll. Regards, Kranthi

ayush_shraddha -  Member Since: Sep 2009
Hi Sandeep! Its just amezing! I have done really a great job. Keep it up . From: Umang Shah

Jaycop Noh -  Member Since: Sep 2009
please help me I need to sign a contract agreement to my new applicant. please give a sample about that. thank you very much...

Ashutosh Panse -  Member Since: May 2008
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.

Manjunath.HR -  Member Since: Mar 2009
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

jeevarathnam -  Member Since: Aug 2007
Started with Excellent,Fabulous,Awesome work Sandeep! no more words to express Get going Cheerz Jeeva

mky15 -  Member Since: Dec 2008
salary sheet is protect pls give password

Attached FilesProvided by community member mky15. Join us to learn and grow with your peers.
File Type: doc registration for esi and pf.doc (20.5 KB, 1202 views)


  • 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