Salary Calculation Excel Sheet for Up to 20 Employees: Download and Simplify Payroll Tasks

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

Here is the Excel sheet. Download here.

Hi Manoj,

Could you please share the password to unlock the protected Excel file? I noticed that all the cells are currently protected, and I would appreciate your guidance on how to proceed.

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 appreciated, but I also need the calculation of PT in this worksheet. I also need calculations according to states as each state has different PT slabs.

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

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.

For my employee, I have read that the basic is gross salary percentage deduction. Can you please help?

Hi Manoj,

Fantastic sheet there. Can you please modify this sheet and create a simple one for my store, with no PF or ESIC and only WD, CL, etc.? Not too complex.

Regards

Hello friends, I need some help. I need a salary calculation and tax calculation sheet, and I also found one. However, there is one doubt in these sheets - we have only deductions for transport and PF, or 80C, 80CC, and 80D. But there are lots of other deductions like medical, meal cards, LTA, etc. Please, if you can help me and share a sheet that includes all these deductions. Thank you.

Request for Salary Slip Template Customization

I work as an Accounts Assistant in a small startup company. There are ten employees working in my company, and the company has been functioning since June 2018. Coming from a Computer Science background, I do not have detailed knowledge of accounts. The company has asked me to create a template for the salary slip.

I searched the web and came across your file (Salary Calculation Sheet_Revised.xls). Based on my company's salary data, I need to customize some fields in the salary sheet related to gross salary and deductions. Therefore, I kindly request you to email me the password for that file. I have attached the same file for your reference. My email ID is [Email Removed For Privacy Reasons].

Thank you for your assistance.

Best Regards,
Venkatesan.N

Hi Manoj,

The ESIC rates have changed. Could you modify the sheet accordingly and send? It's a fantastic piece of work you have created.

Respected Sirs, I need some help. I need a salary calculation and tax calculation sheet, and I also found one. However, there is one doubt in these sheets. We only have deductions for transport and PF or 80C, 80CC, and 80D. Other Deductions There are many other deductions like medical, meal cards, LTA, etc. Please, if you can help me, share a sheet that includes all these deductions as well.