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

From India, New+Delhi
Acknowledge(0)
Amend(0)

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.

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls Monthly Salary Statement - CTC and TDS Calculator.xls (78.5 KB, 2816 views)

Acknowledge(1)
NC
Amend(0)

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.

From India, Kolkata
Acknowledge(0)
Amend(0)

Formula not available esic calculation 1.75% 1 paisa is greater tahn=1 rupees, 1 paisa less than=0
From Australia
Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.