Jeevarathnam
Sr. Manager Hr/admin
Asif Danwad
Management, Structures
Radg25@yahoo.com
Sr.accountant
Sagarjivani
Owner At Integrated Organizational Solutions
Shilpi.kakkar
Hr & Training
Ashok Kumar Dubey
Hr, Admin, Legal
YKKALIA
Advocate
Ilayahkumar
Accounts Manager
Shashi Sharma
Compensation,payroll, Staff Welfare
NSreedhar
Accounts,finance, Commercial, Admin, Hr,
+28 Others

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 )
From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls SALARY.xls (155.5 KB, 23558 views)


Dear Sandeep, the product seems to be good. keep up the good work. Kind regards, ASIF DANWAD
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
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.
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
From India, Kochi
Started with Excellent,Fabulous,Awesome work Sandeep! no more words to express Get going Cheerz Jeeva
From India, Bangalore
salary sheet is protect pls give password
From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: doc registration for esi and pf.doc (20.5 KB, 2384 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.
From India, Gurgaon
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).
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
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
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


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
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.
From India, Delhi
Sir, I think when we put attendance days to attendance sheet it gives effect in salary sheet. Regards, Sandeep
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
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
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.
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.
From India, Bangalore
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
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

From India, Mumbai
Dear Sanjeev, Thanks for your appreciation. Please find attached herewith formal memo for Later coming. Regards, Sandeep
From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: doc Formal Memo for Late coming.doc (29.0 KB, 2720 views)

Dear Girish,
Thanks for your appreciation.
I am always here to tell / discuss problem which you have faced to understand some vlookup formulas.
Please reply with your problems.
Thanks and Regards,
Sandeep
From India, Mumbai
can anyone tell me the meanings of GLS in salary slip? and GLS is receive every months/? What is the criteria for FMCG in GLS? Can anyone Explain me in brief?
From India, Mumbai
Dear Sandeep
Excellent job and I don't have words share with you. It is really helpful for every one who is into Payroll. You have really worked hard for this more important is that you have shared this sheet with every one.
My mail id is :
If you have any new stuff plz share it... thank u
Regards,
Purushottam
From India, Pune
Hi Sandeep,
I am Haroon and I am from Mumbai, I Like your hard and good job, I am A building contractor and i have many registers e.g Cement Register, sand,Metal I & II, Steel and etc, for stocking material, another register for Payment of material (Suppliers) and attendance of labour and staff and etc. So I have to manage many registers. So can you help me in preparing all register in one place. my id is
From China
Hi Sandeep, I will have this used for our attendance timesheets at work. Thanks, I will advise in due course if I need any ammendments. Keep on being innovative. Rgds, Alex
From Papua New Guinea, Port Moresby
Hai iam suresh kumar i am working in pharmacy company so please i want salary sheet formet and muster formet and pay slip formet and all salary information
From India, Hyderabad
Sir,
this to inform you that there is so much problem to open the attachments of any answers.
Pehle jab maine citiHR join kiya tha us waqt very uptodate chal raha tha but aajkal koi bhi attachment kholne mein problem face kar rahi hoon jab ki mai registered hoon.aisa kyu hai plz.....plz....plz....pata kariye aur ye problem solve kijiye.
attachment kholne mein waiting ka caption laga kar bhi khulta nahi hai.chahe 60sec ke baad ho ya phir 100 sec ke baad.Khulta hi nahi.
Thanks
Divya Shukla

From India, New Delhi
Hi Sandeep,
Mind blowing, too good yar, thanks a lot giving such a nice thing.
You are very good at excel i believe.
Thanks for the same.
As you have given the password to it can we save it for our use, Pls yar can we change the password in our excel sheet. Pls let me know the things Sandeep.
from Sapbru
From India, Bangalore
Dear Sandeep Jee,
Excellent ............... It is really so good helpful for every one . Please provide us the same idea
in Accounts (trading, PL a/c, Balance Sheet, TDS, TCS, PF , ESI etc)
With regards
Rajan Mishra
From India
yes exellent work.... i want to use it....but problem is ... am not so good with excel sheet ...n dont know how make formulas.... any one suggest me how to learn excel sheet ... any book or sumthing
From India
Sandeep The sheet is fabulous. I am actually a starter in General HR and hope it will support me a lot. I believe it is one among the best structures. Regards Soujanya Hegde
From India, Bangalore
Dear Sandeep this post is really helpful to people like me who are freshers regards rajani
From India, Mumbai
Hi Sandeep,
i really appreciate your work. i am also using it and prepared my sheet first time for company employees keeping ur base.
can u explain me the rules for HRA and LTC. Actually employees are demanding to include those heads which are exempted in incometax so that they can have benefit of investing less and pay less tax.
I have already taken meal vouchers upto 15000p.a,medical reimbursement-15000 p.a, 9600 conveyance and 2400 chidren allowance.
can u pls help me to provide hra and LTC....
From India, Ahmadabad
hi!! Really Sandeep you have done a very good job. It is really very easy for freshers to understand. But it will be more good if you update the same as almost all the provisions are changed...
From India, Delhi
Dear Sandeep The information u have posted is really important but u have given password to excel sheet. Plz post it again without password. regards Asmita
From India, Mumbai
Hi Pratima,
following is the information regarding HRA and LTA
HRA exemption = minimum of (40% (50% for metros) of Basic+DA or HRA or rent paid - 10% of Basic+DA)
LTA is exempt to the tune of ecomony class airfare for the family to any destination in India, by the shortest route.
LTA can be claimed twice in a block of 4 calendar years. The current block is from Jan 2010 to Dec 2013
Regards,

From India, Mumbai
Dear all,
Herewith i am attaching the copy of Gujarat professional tax form 5 which we have to submit with professional tax challan.
I have made this form with a lot of searching and hard work.
I think it will be useful not only for gujarati HR professionals but also it will guide to all other state professionals to make such descriptive and ready to use for freshers' form.
From India, Ahmadabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls PT FORM FEB 10.xls (33.0 KB, 268 views)

[QUOTE=Bulla Kranthi Kumar;868331]Dear Sandeep
Its a great job it will be helpful for everyone who are new to this payroll process and im a MBA(fresher) and i started my HR career in the hotel industry it will surely helpful to continue my HR career in the payroll process and i have no words to express my views....may god bless u....
Regards,
jagadeesh.v
From India, Madras
Sound become music, Movement becomes dance, S mile becomes laughter Life becomes celebratio n.When old friend keep in touch.H.DIWALI MOHD RAFI password - 090909
From India, Indore
Its godd but please check that esi has been deducting to those employees who are drawing 10000 and below but as per the ammendent it was raised to 15000 please check, but the work quiet appreciable..
From India, Anantapur
[QUOTE=sandeepmore_finance;865804]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,

The sheet posted by you is really very useful.. great work !!
From India, Mumbai
Good job done keep it up. Good job done keep it up. Good job done keep it up. Good job done keep it up. Good job done keep it up. Good job done keep it up.
From India, Pune
Dear Sandeep , Appreciate your work but i was looking for a sheet in excel so i can see the whole year salary of all employee in one sheet. Thanks Gaurav
From India, Jaipur
Hi, Sandeep, Appreciate your efforts. salary sheet is protect pls give password. .Regards RAJENDRAN
From India, Pune
#Anonymous
I want atleast 5 salary sheets in excel
1 in which all calculations are done like pf esi on monthly basis
2 in which calculations are done on per day wages act
3 in which ctc is defined and all calculations done
4 calculations done on the basis of lop days and total no of paid days
please send me these formats as soon as possible
thank you
From India, Chandigarh
good evening
sir plz help ERP Format
Thanks
Bhim singh
From India, Ghaziabad
Reply (Add What You Know) Start New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™