How Do I Prepare Employee ESI in Excel? Seeking Guidance and Sample Sheet from Seniors

Dear seniors, how do I prepare the ESI of employees in an Excel sheet? Could you please send the Excel sheet in which ESI is prepared?

Thank you,

ANJNA

I hope this will clarify how to prepare the ESIC calculation.

---

I have corrected the spelling and grammar errors in your text. I also added a line break to separate the paragraphs for better readability. If you have any further questions or need clarification, feel free to ask.

Regards

Hi Anjana, at 179, it shows the employee contribution part, i.e., 1.75% of wages, and at 487, it shows the contribution of the employer, i.e., 4.75%. When you press F2 in 179 and 479, it will clarify your doubts.

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

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,

Dear Rohan, Form 37 is not available in Excel. I am busy these days. Please install a PDF to Word converter. After converting, you can copy and paste it into an Excel format. I am sending all the ESIC forms.