Personnel Officer
Hr Executive
Million Services
+1 Other

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Here is the Excel Sheet, Download Here

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

Hi Manoj, Can you share the Excel Protected passworrd? In Excel it shows all the cells are protected, kindly guide. Regards Gnanaprakasam P
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.
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
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

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Calculation Sheet_Revised.xls (334.0 KB, 5986 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 .
for my employee. I have read that the basic is gross salary percentage deduction. can u pls help
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
Hi Manoj
thanks for the format
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™