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.

PASSWORD FOR FILE IS - 090909

:)Thanks & Regards,
(My email ID is )
Posted 10th September 2009 From India, Mumbai
Attached Files
Shared By Cite.Community Member "sandeepmore_finance" For Public Download
File Type: xls SALARY.xls (155.5 KB, 19938 views)
Dear Sandeep, the product seems to be good. keep up the good work. Kind regards, ASIF DANWAD
Posted 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
Posted 11th September 2009 From India, Madras
Hi Sandeep! Its just amezing! I have done really a great job. Keep it up . From: Umang Shah
Posted 12th September 2009 From China
please help me I need to sign a contract agreement to my new applicant. please give a sample about that. thank you very much...
Posted 12th September 2009
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.
Posted 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
Posted 12th September 2009 From India, Kochi
Started with Excellent,Fabulous,Awesome work Sandeep! no more words to express Get going Cheerz Jeeva
Posted 12th September 2009 From India, Bangalore
mky15 
salary sheet is protect pls give password
Posted 12th September 2009 From India, Delhi
Attached Files
Shared By Cite.Community Member "mky15" For Public Download
File Type: doc registration for esi and pf.doc (20.5 KB, 1871 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.
Posted 12th September 2009 From India, Gurgaon
thanks, it is very useful for salary calculation to the establishments. I have downloaded the file regards antara
Posted 12th September 2009 From India, Mumbai
Hi,

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).
Posted 12th September 2009 From United Arab Emirates, Dubai
Sir,

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.

Regards
Vishal Harjani
Posted 12th September 2009 From India, New Delhi
Hi Sandeep,

Really it is a good work. I appreciate your hard work. Keep it up. Please clarify,
1. In the yellow colour marked area, can we create any rows or columns?
2. Professional Tax is having more slabs in Andhra Pradesh but your files says only 3, can we meet this requirement?
3. Give some insert options like adding some more column in salary break up, deduction area etc.,

Regards
Sreedhar
Posted 12th September 2009 From India, Hyderabad
Master,
thanks for your things, and it will appreciate by all, well done.
if i want to increase the list of employee, how i can do, can copy the rows in all sheets, it will works.,
if you have time pls reply me
thanks
Ilayahkumar/nigeria



Posted 12th September 2009
Hi,

This is bhavin lashakari - officer HR at Wockhardt Hospital, could you please send password of this salary excel sheet on my e-mail address (bhavin.lashkari@wockhardthospitals.com for my reference.

Regards,

Bhavin Lashkari
Officer - HR
Posted 12th September 2009 From India, Anklesvar
Hi Sandeep, Your posting is not only amazing, but is really innovative. God bless you for this effort. Y. K. Kalia, Advocate.
Posted 12th September 2009 From India, Delhi
Sorry to say something about the salary sheet because it is protected by password. Md. Mahfuz Hossain. Milan.
Posted 13th September 2009 From Bangladesh, Dhaka
Dear Mr.Sandeep, You have done a very good job.It is helpful for all those are not working system (ERP System).Keep it up. Thanks & Regards, Prakash
Posted 13th September 2009 From India, Calcutta
Sir, I think when we put attendance days to attendance sheet it gives effect in salary sheet. Regards, Sandeep
Posted 13th September 2009 From India, Mumbai
hi nice works its very gud could you pls kindly help me with some topics of finance for my thesis
Posted 13th September 2009 From India, Bhopal
Dear Sandip The idea is nice. Why don’t you linkup form No. 16 & its details along with salary file. It will be more useful.
Posted 14th September 2009 From India, Mumbai
Tremendous amount of labour and effort must have been put. Really a good one.

My Question to you:

We give colour to a particular cell. If we want that the colour should change when we feed in the data to enable us to identify which cells are left where we need to feed the data. Can you explore and let me know.

Thanks & Regards
Posted 14th September 2009 From India, New Delhi
Hi Sandeep,

Amazing, very nicely prepared. :( I am surprise, we both are in the same office and you are siting next to my table but i was not aware that you are posting woderful stuff.

It will be help full to not only those who are handling payroll but help full to understand Excel comands.

Keep it up and please keep on posing more.

Thanks & Regards,
Rajesh Auchare
Posted 14th September 2009 From India, Mumbai
Thanks for your suggestions, keep following this thread I will post updated version very soon. Regards, Sandeep
Posted 14th September 2009 From India, Mumbai
Dear Sandeep,

Must appreciate, good job
Let me just make your salary sheet more attractive just like a payroll software appears.
I will back with this by the end of Sept 16th, 2009

Regards,
Shilpi Kakkar
Human Res. Manager
APS Technology Pvt. Ltd.
Posted 16th September 2009 From India, Delhi
Dear Mr. Sandeep, I am very much impressed by your excel sheet wherein we can get various formats such as pay slips, ESI, PF etc.
Posted 16th September 2009 From India, Bangalore
Hi Sandeep, Appreciate your efforts.Thanks for sharing with us. Keep posting!! Thanks, Regards, schavva
Posted 16th September 2009 From India, Hyderabad
Hi Sandeep,

This is great master sheet, u have really prepared a multipurpose sheet but one thing is can you have some option like automatic change in months and year so the calculation will be easy, otherwise you have to do the same exercise every month which is time consuming.

One more thing is in attendance you can add leaves, cl, sl, el, holidays for monthly calculation.

Hope what i am righting will be right and hope you will understand the same.

Thank You
Posted 16th September 2009 From India, Vijayawada
Hi,

Thanks for your appreciation and valuable suggestions. I am updating this excel sheet as per you good people suggestions. One day we will get all the information regarding salary and various reports generated from it.

I really wants suggestions from you to update this excel sheet.

Plus you good people can also make changes as per requirement.

Please keep following this thread. I will be post updated excel sheet on this thread very soon.

Thanks & Regards,

Sandeep




Posted 17th September 2009 From India, Mumbai






 
 
 
 







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