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)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is incorrect. There is no mention of the specific tool or relevant guidance related to PF & ESI calculations and challan generation. Kindly provide accurate information.
    0 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)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user's reply contains inaccuracies. It is essential to obtain an ESI registration regardless of the presence of an ESIC hospital nearby. It is a legal mandate under the Employees' State Insurance Act, 1948, for eligible entities to register and contribute. Failure to comply can lead to legal consequences.
    0 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)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply does not provide accurate information regarding ESIC calculation. It seems to be unrelated to the original query.
    0 0

  • Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.





    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.