How Do I Calculate PF & ESI and Generate Challans Without External Help?

Dear Senior,

In my company, we used to work with a consultancy for PF & ESI calculation and challan generation. However, they have now terminated their services, and I am now responsible for handling both PF & ESI. I need assistance on how to calculate PF & ESI and generate challans in a spreadsheet. I am aware that there is a tool on the PF site for these tasks, but I am having trouble locating it. Kindly guide me on how to address this.

Regards,
Sharda

Hi Ms. Sharda,

I hope the enclosed tool will help you prepare salary statements, ESI, and PF calculations. Regarding the ECR tool using Excel, there have already been many discussions. If you are unable to find it, I can share the link. If you need any assistance, you can reach out to me.

Sir,

In a private company, we have a PF code and timely deposit it with 50 employees. However, we have not obtained an ESI number until today because there is no ESIC hospital where our work is located. We are concerned about potential problems that may arise in the future.

Thank you.