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
From India, Madras
Acknowledge(0)
Amend(0)
3Initially, 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
From India, Madras
Acknowledge(0)Amend(0)
Dear, you have designed it wonderfully, but thier is some changes, Note: Sum of PF., P.T. AND ESIC should be deudted from earned salary.
From India, Thana
Acknowledge(0)Amend(0)
From India, Thana
Acknowledge(0)Amend(0)
Dear Rupan, Your HRA=40% of gross and it cannot be more than 50% of Basic. So kindly rectify it. Your sheet need to be more organized way. Regard’s Shaikh
From India, Bhubaneswar
Acknowledge(0)Amend(0)
From India, Bhubaneswar
Acknowledge(0)Amend(0)
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.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Rupan, Attaching one salary calculation sheet. you need to fill the date and it eill grnerate automatically. Hope you will find it easy Regard’s Shaikh
From India, Bhubaneswar
Acknowledge(0)Amend(0)
From India, Bhubaneswar
Acknowledge(0)Amend(0)
Hi! Its very much useful .. few comments .. limits for pf deduction if ceiling at 6500. deduction of welfare fund for employee and employers too. Ashish
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls
Employee Benefits.doc