Hi Everyone, I have joined as an HR Executive in a Logistic Company. They have asked me to frame a salary structure of the employees in Excel which should include:
- Basic
- HRA
- Conveyance
- Total Gross
- Overtime
- Total False
- PF-Employer (13.61%) and Employee share (12%)
- ESI-Employer (4.75%) and Employee share (1.75%)
- PT
- Bonus
- Gratuity
- Net Pay
Kindly help me out with these calculations.
Thanks in advance.
Regards,
Suman
From India, Bangalore
Acknowledge(1)
Amend(0)
2- Basic
- HRA
- Conveyance
- Total Gross
- Overtime
- Total False
- PF-Employer (13.61%) and Employee share (12%)
- ESI-Employer (4.75%) and Employee share (1.75%)
- PT
- Bonus
- Gratuity
- Net Pay
Kindly help me out with these calculations.
Thanks in advance.
Regards,
Suman
From India, Bangalore
Acknowledge(1)Amend(0)
Hi Everyone, I have joined as an HR Executive in a Logistic Company. They have asked me to frame a salary structure of the employees in Excel which should include:
- Basic
- HRA
- Conveyance
- Total Gross
- Overtime
- Total False
- PF-Employer (13.61%) and Employee share (12%)
- ESI-Employer (4.75%) and Employee share (1.75%)
- PT
- Bonus
- Gratuity
- Net Pay
Kindly help me out to do these calculations.
Thanks in advance.
Regards, Suman
From India, Bangalore
Acknowledge(0)Amend(0)
- Basic
- HRA
- Conveyance
- Total Gross
- Overtime
- Total False
- PF-Employer (13.61%) and Employee share (12%)
- ESI-Employer (4.75%) and Employee share (1.75%)
- PT
- Bonus
- Gratuity
- Net Pay
Kindly help me out to do these calculations.
Thanks in advance.
Regards, Suman
From India, Bangalore
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.
A NEW HR EXECUTIVE HAND BOOK.pdf
SALARY EXCEL.zip
Creating a Competitive Salary Structure.doc