Personnel Officer
Hr Executive
Million Services
+2 Others

Thread Started by #needcom

HI everyone, just sharing Salary Calculation Excel Sheet for easy salary calculations. It is limited to 20 Employees :
01. Salary Sheet.
02. Challans - ESIC and PF.
03. Salary Slips.
Manoj Kumar
24th May 2016 From India, Delhi
Here is the Excel Sheet, Download Here
24th May 2016 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Calculation Sheet.xls (240.5 KB, 6700 views)

Hi Manoj, Can you share the Excel Protected passworrd? In Excel it shows all the cells are protected, kindly guide. Regards Gnanaprakasam P
24th May 2016 From India, Chennai
Before asking people for passwords etc, you might need to brush up on your Excel skills.
There is no problem with the spreadsheet. I have just downloaded it and had a play with it.
All the data entry is done on Sheet 1 and that is NOT protected.
The remaining sheets take the data that you enter on Sheet 1 and create the reports and salary slips.
So replace the data on Sheet 1 with your data, and your problem is solved.
25th May 2016 From Australia, Melbourne
very great work appriciated, but i also need calculation of PT in this worksheet also need calculation according to states as each state is having different PT slabs
25th May 2016 From India
I have modified the sheet according to some suggestion received.
  • Enabled Selection in the protected sheets.
  • PF Rate input
  • OT Rate input
Many asked to increase the emp capacity, my suggestion to copy sheet and add remaining emps to that one. Also added bank letter and gratuity & EL encasement calculator.
Manoj Kumar
26th May 2016 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Calculation Sheet_Revised.xls (334.0 KB, 5621 views)

You can refer to this salary calculator in the article - What should you consider for the perfect performance appraisal?
It also explains the ideal structure as well with all the complaince guidelines .
27th May 2016 From India, Mumbai
for my employee. I have read that the basic is gross salary percentage deduction. can u pls help
28th May 2017 From India, Thrissur
Hi manoj
fantastic sheet there
can you please modify this sheet and create a simple sheet for my store ,with no pf or esic and only wd,cl,ect not to complex
22nd July 2017 From India, Mumbai
Hi Manoj
thanks for the format
17th November 2017 From India, Chennai
Hi Thank You , The first employee the medical leave is hard coded to 2 always and how do i get this editable sheet for more employees ?
The process to pay
24th March 2018 From India
hello frnds i need some help... i need a salary calculation & tax calculation sheet and i also found that but their is one doubt in these sheets we have only deduction of transport and PF or 80C, 80CC and 80D but their are lots of other deductions like medical, meal cards, Lta, etc please if you can help me and shared a sheet which includes all the these deductions also
26th May 2018 From India, Noida
GREAT HELP THANK YOU SO MUCH. this tool is really helping me in generating salary details and salary slips. thank u so much.
3rd November 2018 From India, Bhopal
Hello MANOJ sir,
I working as Accounts Assistant in a small startup Company. Ten employees are working in my company, company functioning from June 2018. I am coming from Computer Science background so don't know accounts in details. Company asked me to create a template for Salary slip.
I searched in the web and found your file(Salary Calculation Sheet_Revised.xls) in it. According to my company salary data, I want to customize some fields in Salary sheet in Gross salary and deductions. So kindly request you to mail the password for that file. I attached the same file in the attachment. My E-mail id :
Thanking you,
Best Regards,
31st December 2018 From India, Chennai

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Calculation Sheet_Revised.xls (334.0 KB, 199 views)

Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™