Hi everyone,
Just sharing a 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.
Regards,
Manoj Kumar
From India, Delhi
Acknowledge(0)
Amend(0)
36Just sharing a 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.
Regards,
Manoj Kumar
From India, Delhi
Acknowledge(0)Amend(0)
Hi Manoj, Can you share the Excel Protected passworrd? In Excel it shows all the cells are protected, kindly guide. Regards Gnanaprakasam P
From India, Chennai
Acknowledge(3)
Amend(0)
From India, Chennai
Acknowledge(3)Amend(0)
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.
From Australia, Melbourne
Acknowledge(0)Amend(0)
From Australia, Melbourne
Acknowledge(0)Amend(0)
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
From India, Nagpur
Acknowledge(0)Amend(0)
0
0
From India, Nagpur
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply is correct. Different states have varying Professional Tax (PT) slabs, so including PT calculations in the worksheet would be beneficial. (1 Acknowledge point)
0
0
Hi,
I have modified the sheet according to some suggestions received:
- Enabled Selection in the protected sheets.
- PF Rate input
- OT Rate input
Many have asked to increase the employee capacity. My suggestion is to copy the sheet and add the remaining employees to that one. I have also added a bank letter and a gratuity & EL encasement calculator.
Regards,
Manoj Kumar
From India, Delhi
Acknowledge(7)
Amend(0)
0
0
I have modified the sheet according to some suggestions received:
- Enabled Selection in the protected sheets.
- PF Rate input
- OT Rate input
Many have asked to increase the employee capacity. My suggestion is to copy the sheet and add the remaining employees to that one. I have also added a bank letter and a gratuity & EL encasement calculator.
Regards,
Manoj Kumar
From India, Delhi
Acknowledge(7)+2 more
Amend(0)CiteHR.AI
(Fact Checked)-The suggestion to increase employee capacity by copying sheets is practical. Including PF and OT rate inputs enhances functionality. Well done! (1 Acknowledge point)
0
0
Hi,
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, along with all the compliance guidelines.
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
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, along with all the compliance guidelines.
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user reply does not provide accurate information related to the original post about a Salary Calculation Excel Sheet. No correction needed. (1 Acknowledge point)
0
0
for my employee. I have read that the basic is gross salary percentage deduction. can u pls help
From India, Thrissur
Acknowledge(0)Amend(0)
From India, Thrissur
Acknowledge(0)Amend(0)
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 rgds
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Employee excel sheet.xls
CiteHR.AI
(Fact Checked)-The Excel sheet likely has password protection to ensure data integrity. You can unlock it by requesting the password from Manoj Kumar. Thank you for your query. (1 Acknowledge point)