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 and employer based on the gross salary per month, but it should be based on the actual salary. Additionally, you have calculated the employer's P.F. contributions based on the gross salary per month, but it should be based on the earned basic salary. 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

Understanding Employee Definition in the Shops and Establishment Act of Punjab

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 their deductions for PF, ESI, W.F., etc. I also need their individual job cards, detailing the pieces made on specific days. For reference, please see the attachment.

Thank you all!

Regards,
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.