New to Payroll? Seeking Simple Excel Format for Salary Calculations in Small Companies

Hi Masters,

I am Ramesh, working for a small company with an employee strength of around 30. I am new to payroll. Could you please send me the Excel format for calculating salary?

Thanks & Regards,
Ramesh

Dear Ramesh,

Please find the payroll attachment as I maintain for our company. It may be useful to you. It contains formulas, so please don't change the sheet; copy it and create a new payroll.

Regards,
Sonia

Hi, Ms. Sonia!

Thanks for the information. However, in your payroll sheet, there is no Professional Tax column. Why is that? As far as my knowledge goes, the professional tax deduction is a must.

Thanks & Regards,
Sujatha

Dear Sonia,

Thank you for your valuable information. The sheet that you have provided is to be taken as a base. We can modify it to some extent, taking into consideration the statutory compliance and other regulations.

Thanks and regards,

Hi Sonia,

I've checked the format; it's really well done. However, in the Ahmedabad region, associates have noticed that ESI has been deducted even when they are not in the band (the limit being Gross 10,000/-), as their gross was 18,000/-.

Please check this issue.

Regards,
Hari Krishna

Hi Sonia,

I have checked your Excel sheet. I am new to this field, and I want to confirm a few things. What will happen if your company is deducting PF and Gratuity as well?

Regards,
Nidhi

Hi, masters,

I am Julie Ann, working in a small company, and I don't have knowledge yet about salary payroll. Can you please send me a sample so that I can do it quickly? Thank you.

I am P. Vyas. I am working in a small industries company in different departments. I want payroll with different departments, some with PF and some without PF, and daily wages. Please send an Excel sheet for that.

Dear Sonia,

I came across the payroll Excel sheet posted by you; it was an excellent job. Since I am new to this, I wonder if you could send me a sheet with the formulas used for calculating Basic, HRA, and Conveyance.

Regards, Trupti

Hi Sonia,

Good work. However, the Management's contribution for PF is restricted to Rs. 6,500, which you have not considered.

Regards,
Ramanan K L V

Hi Sonia,

I have been primarily involved in recruitment for the past 2 years and have no knowledge about payrolls. Could you please advise me on how to use the Excel sheet you shared?

Regards,
Kalyan

Hi everybody,

Actually, I am a fresher recently joined a small company with 25 employees. Could anyone provide us with a payroll Excel sheet that would be helpful for calculating payroll?

Thanks and regards,
Keshav Bats.

Dear All,

I am Anisha Multani. Please help me with the PF process. I have a doubt regarding how to calculate the PF Challan and Form No. 12A based on the total amount of all the employee PF contributions as well as the employer's. How do I calculate this? Please help me, all.

Regards,
Anisha

Hi Sonia,

I am Ramesh Perumal, a new member on the citehr platform. Could you please provide me with an Excel format for calculating salaries? Additionally, I am interested in learning more about completing HR tasks.

I am eagerly awaiting your valuable information.

Thank you,
Ramesh Perumal

Dear Sonia,

Thank you for providing me with valuable information. Please also send me any details regarding payroll and HR. I also want to express my gratitude once again.

Thanks,
Ramesh

I am new to payroll. Our manpower consists of only 5 people. Please send me a simple Excel sheet for calculating payroll. The staff is still on contract, so they receive a fixed pay. The only deduction is for unpaid leave. Thank you.