Seeking Feedback: How Can I Improve My Payroll Process Draft for HR Studies?

Hello seniors,

I am Ruban, pursuing MSW (HR) at Mar Gregorios College. I have prepared a payroll process and have attached a file. Please go through it and give me suggestions to improve myself. Seniors, I am eagerly awaiting your replies.

Initially, I posted the process on Cite HR and have since revised it based on the received suggestions. I would appreciate your feedback and corrections.

Thanks and regards,
Ruban Kumar R

You have designed it wonderfully, but there are some changes.

Note: The sum of PF, P.T., and ESIC should be deducted from the earned salary.

Regards,

Dear Rupan,
Your HRA is 40% of the gross and it cannot exceed 50% of the Basic. Please make the necessary corrections.

Your sheet needs to be organized in a better way.

Regards,
Shaikh

In your sheet, you have calculated the ESI contribution of the employee & employer based on the Gross per month, but it should be based on the actual salary. Additionally, you have calculated the employer's P.F. contributions based on Gross per month, but it should be based on the earned Basic. Yes, the checking of PF applicability may be based on the actual basis.

Dear Rupan, I am attaching a salary calculation sheet. You need to fill in the date, and it will generate automatically. I hope you will find it easy.

Regards, Shaikh

Hi! It's very much useful. A few comments:

- Limits for PF deduction if the ceiling is at 6500.
- Deduction of welfare fund for employees and employers too.

Ashish

If we read the definition of an employee in the Shops and Establishment Act of Punjab, an employee works on a piece-rate basis. This means one is free to work whether it is on a daily wage basis. Thus, employees are working on a piece-rate basis, and I want to develop a standard piece-rate salary sheet where I can calculate his deductions for PF, ESI, W.F., etc. I also need his individual job cards, detailing the pieces made on specific days. For reference, please see the attachment.

Thank you all!
Ashish

It appears to be the basic information sheet. Also, while going through the sheet, you have given 12% PF on the total basic itself. Is it not the basic reduced for the leave period? Check this one.

Dear Mr. Dipak,

You cannot input anything into the payslip sheet as it is connected to the master sheet through VLOOKUP. One thing you need to do is on the payslip sheet, you will find the numbers 1, 2, 3 on the adjacent left side. There, you need to change the number. For example, if you input 5, it will generate the payslip of the employee whose serial number is 5 in the master sheet.

I hope this explanation helps you.

Regards,
Shaikh