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)
3I 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)
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 & 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.
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)
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
From India, Delhi
Acknowledge(0)Amend(0)
Thank you all!
Ashish
From India, Delhi
Acknowledge(0)Amend(0)
Hi, It appears the basic Information Sheet. Also while going thro' the Sheet U have given 12%PF on the Total Baisc itself. Is is not the Basic reduced for leave Period. Check this one
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Bhubaneswar
Acknowledge(0)Amend(0)
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
From India, Bhubaneswar
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