Dear Cite HR Members,
Good evening.
Could anyone help me with payroll calculations including all components such as basic, DA, HRA, CCA, PF, ESIC, and PT?
Please send me an Excel sheet so that I can review it.
Thank you in advance.
Regards,
Alekhya
From India, Bengaluru
Acknowledge(2)
Amend(0)
3Good evening.
Could anyone help me with payroll calculations including all components such as basic, DA, HRA, CCA, PF, ESIC, and PT?
Please send me an Excel sheet so that I can review it.
Thank you in advance.
Regards,
Alekhya
From India, Bengaluru
Acknowledge(2)Amend(0)
Hello Jeevarathnam Sir,
I found a few salary structure calculations, but I reside in Hyderabad and I am not aware of the PT tax slab. If I have any further questions related, I will contact you on your mobile number.
Thank you,
Alekhya
From India, Bengaluru
Acknowledge(0)Amend(0)
I found a few salary structure calculations, but I reside in Hyderabad and I am not aware of the PT tax slab. If I have any further questions related, I will contact you on your mobile number.
Thank you,
Alekhya
From India, Bengaluru
Acknowledge(0)Amend(0)
PT slab for Hyderabad is 15,000 - 19,999 is Rs 150 20000 & Above is Rs 200
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Employees' Provident Fund
Employees' Provident Fund is a small savings scheme offered to Indian workers as well as international workers through the EPFO of India. The scheme allows the accumulation of funds as well as the accrual of interest on the accumulated funds. The funds thus collected are made up of contributions partly from employees and partly from their employers.
Contributions from employees as well as employers add to the EPF. However, contrary to common belief, the entire portion of the contribution from an employer doesn’t go exclusively towards the Employees' Provident Fund.
Provident Fund Calculator
Basic Pay: ₹25,000/Month
PF Contribution:
- Employee: 12% of ₹15,000: ₹1,800.00
- Employer: 13% of ₹15,000: ₹1,950.00
- Total: ₹3,750.00
Minimum salary limits: Employees with monthly salaries less than or equal to INR 15,000 now have to contribute mandatorily towards EPF. The PF amount is calculated on the basic amount. PF will be calculated as 12% of the basic.
Employees' State Insurance Act, 1948 (ESI Act)
The Employees' State Insurance Act, 1948 (ESI Act) is social security legislation aimed at providing benefits to employees in case of sickness, maternity, employment injury, and certain other related matters. Under this self-financing health insurance scheme, funds are primarily built out of contributions from employers and employees. The ESI fund, maintained by ESIC, is applicable to employees earning ₹21,000 or less per month to provide cash and medical benefits to them and their families. This fund is a contributory fund in which both the employer and employee contribute 4.75% and 1.75% respectively, making a total of 6.5%. For ESI calculation, the salary comprises all the monthly payable amounts such as basic pay, dearness allowance, city compensatory allowance, HRA, incentive allowance, and meal allowance. However, the salary does not include the annual bonus, retrenchment compensation, encashment of leave, and gratuity. ESI will be calculated for the total gross salary of the employee.
Employee Contribution: 0.75%
Employer Contribution: 3.25%
From India
Acknowledge(1)
Amend(0)
Employees' Provident Fund is a small savings scheme offered to Indian workers as well as international workers through the EPFO of India. The scheme allows the accumulation of funds as well as the accrual of interest on the accumulated funds. The funds thus collected are made up of contributions partly from employees and partly from their employers.
Contributions from employees as well as employers add to the EPF. However, contrary to common belief, the entire portion of the contribution from an employer doesn’t go exclusively towards the Employees' Provident Fund.
Provident Fund Calculator
Basic Pay: ₹25,000/Month
PF Contribution:
- Employee: 12% of ₹15,000: ₹1,800.00
- Employer: 13% of ₹15,000: ₹1,950.00
- Total: ₹3,750.00
Minimum salary limits: Employees with monthly salaries less than or equal to INR 15,000 now have to contribute mandatorily towards EPF. The PF amount is calculated on the basic amount. PF will be calculated as 12% of the basic.
Employees' State Insurance Act, 1948 (ESI Act)
The Employees' State Insurance Act, 1948 (ESI Act) is social security legislation aimed at providing benefits to employees in case of sickness, maternity, employment injury, and certain other related matters. Under this self-financing health insurance scheme, funds are primarily built out of contributions from employers and employees. The ESI fund, maintained by ESIC, is applicable to employees earning ₹21,000 or less per month to provide cash and medical benefits to them and their families. This fund is a contributory fund in which both the employer and employee contribute 4.75% and 1.75% respectively, making a total of 6.5%. For ESI calculation, the salary comprises all the monthly payable amounts such as basic pay, dearness allowance, city compensatory allowance, HRA, incentive allowance, and meal allowance. However, the salary does not include the annual bonus, retrenchment compensation, encashment of leave, and gratuity. ESI will be calculated for the total gross salary of the employee.
Employee Contribution: 0.75%
Employer Contribution: 3.25%
From India
Acknowledge(1)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.
Challans for EPF ESIC.zip
Epf calculations.xl s
EPF n ESIC -common challan.pdf