Sr. Manager Hr/admin
Owner At Integrated Organizational Solutions
Hr & Training
Ashok Kumar Dubey
Hr, Admin, Legal
Compensation,payroll, Staff Welfare
Accounts,finance, Commercial, Admin, Hr,
11th September 2009 From India, Madras
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
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.,
12th September 2009 From India, Hyderabad
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
14th September 2009 From India, New Delhi
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,
14th September 2009 From India, Mumbai
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
Human Res. Manager
APS Technology Pvt. Ltd.
16th September 2009 From India, Delhi
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.
16th September 2009 From India, Vijayawada
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,
17th September 2009 From India, Mumbai
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
10th February 2010 From India, Pune
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
15th February 2010 From China
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.
6th May 2010 From India, New Delhi
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.
6th May 2010 From India, Bangalore
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....
18th August 2010 From India, Ahmadabad
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
20th October 2010 From India, Mumbai
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.
21st October 2010 From India, Ahmadabad
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....
28th October 2010 From India, Madras
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 !!
24th August 2012 From India, Mumbai
#AnonymousI 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
7th May 2017 From India, Chandigarh