Dear seniors how am prepares the ESI of employees in excel sheet send the excell sheet in which ESI prepare. THANKS ANJNA
From India, Chandigarh
Acknowledge(1)
Amend(0)
8From India, Chandigarh
Acknowledge(1)Amend(0)
Hi, hope this will clear how to prepare the ESIC calculation.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Anjana 179 is showing the employee contribtion part i.e 1.75% of Wages and 487 showing contri of employer i.e 4.75% when you press F2 in 179 and 479 it will clarify your doubts.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Pankaj, thank you. I understand, but both ESI contributions are deducted from employees' wages when I press F2. These two contributions are deducted from wages, but the total wage remains the same after the ESI contribution. Please tell me.
Thanks,
Anjna
From India, Chandigarh
Acknowledge(0)Amend(0)
Thanks,
Anjna
From India, Chandigarh
Acknowledge(0)Amend(0)
Dear Pankaj,
While appreciating your efforts, I want to educate you on two issues.
Exempted Employees and ESI Contributions
Firstly, employees whose average daily wages are less than Rs. 70 are known as exempted employees. For such employees, there is no need to pay 1.75%, but the employer's share of 4.75% should be deducted. This point was ignored while preparing your Excel sheet.
ESI Payment Process and System Updates
Secondly, due to recent computerization in ESI, paying the ESI through manual challans has been stopped. The calculation of the employees' share and employer's share will now be handled by the system. You only need to enter the number of days and wages paid to the employee to generate the challan, as payment through the system-generated challan is MANDATORY in ESI.
With regards,
From India, Hyderabad
Acknowledge(0)Amend(0)
While appreciating your efforts, I want to educate you on two issues.
Exempted Employees and ESI Contributions
Firstly, employees whose average daily wages are less than Rs. 70 are known as exempted employees. For such employees, there is no need to pay 1.75%, but the employer's share of 4.75% should be deducted. This point was ignored while preparing your Excel sheet.
ESI Payment Process and System Updates
Secondly, due to recent computerization in ESI, paying the ESI through manual challans has been stopped. The calculation of the employees' share and employer's share will now be handled by the system. You only need to enter the number of days and wages paid to the employee to generate the challan, as payment through the system-generated challan is MANDATORY in ESI.
With regards,
From India, Hyderabad
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.
Employee excel sheet.xls