kind send me the excel file containing formulas for calculation of EPF etc
From India, New Delhi
Acknowledge(0)
Amend(0)

Dear Madhvai,
thanks for the reply. What i exactly need is some formula by which we can caculate how much amount will be accumulated at the year's end at a fixed epf rate (say 8.5%) on the combined monthly EPF shares of Employee and Employer (i.e 12% + 3.67% of {basic+DA})
i have sent the scenario in excel file (sheet2) at your email id.
thanks again

From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls pf_calculation_686.xls (35.0 KB, 17820 views)

Acknowledge(1)
SU
Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The response provided contained incorrect information regarding the EPF calculation formulas. Please ensure accuracy in calculations for EPF contributions.
    0 0

  • Dear Sir,
    Thanks for the formula sheet, but i suggest that the formula sheet provided by you have to be changed such as if an employees basic salary is more than 6500 then the maximum deduction to the pension should be Rs. 541 but as per you formula it is diffeerent .
    Sir just change the formulla and get your statement revised.
    Regards
    Chandrakant V.
    9820592842
    (PF, ESI, COntract Labour and other labour law Consultant)

    From India, New+Delhi
    Acknowledge(1)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The information provided regarding EPF calculation is incorrect. The maximum deduction for pension is not fixed at Rs. 541 for employees with a basic salary above 6500. The EPF contribution calculation should follow the prescribed legal guidelines.
    0 0

  • hi dear chandrakanth i forgot to mention about the wage limit i
    if the wages is less than 6500 then the formula will be calculated as (basic+da)*12% and if it is greater than 6500 it will be fixed as 780 apart from that employer provident fund wii be 780*3.67/12 and family pension fund is 780*8.33/12
    madhavi

    From India, Hyderabad
    Acknowledge(1)
    AM
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply contains inaccuracies regarding the calculation of EPF. The correct formula is (basic + DA) * 12% regardless of the wage amount. The employer provident fund and family pension fund calculations are accurate. Please refer to the EPF rules for confirmation.
    0 0

  • hi, please find enclosed the excel sheet for the reference Regards,
    From India, Pune
    Attached Files (Download Requires Membership)
    File Type: xls epf_1__123.xls (13.5 KB, 8019 views)

    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is missing the attachment of the Excel file for EPF calculation. Please ensure to attach the file for reference.
    0 0

  • Thanks for the calculations. Can u please help me to know the excel formulas to generate the 3A/6A reports through the said sheet regards kumar 9885576600
    From India, Hyderabad
    Acknowledge(1)
    SG
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The 3A/6A reports cannot be generated through EPF calculations in Excel. You need to extract this data from the EPF organization's portal. Thank you for your inquiry.
    0 0

  • Thanks a lot
    I am in the process of calcualating the PF amoutn for our employees I know the %s but I don't have the format. I was planning toprepare the formula format for PF but You made my work easy.
    It helped me a lot.
    Thanks
    usha

    From India, Hyderabad
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-Your response is partially correct. It is advisable to ensure accurate PF calculations using the latest EPF rates and formulas. Double-check for precision.
    0 0

  • please give a revised excel calculation sheet for pf with salary more than Rs.6500/- per month.
    From India, Calcutta
    Acknowledge(1)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The reply is incorrect. As per the latest laws, EPF is applicable on salary up to Rs. 15,000 per month. A revised excel sheet can be provided accordingly.
    0 0

  • hi Im new to this site really very useful site. Im looking for Design Engineers who have experience in Manufacturing firm especially ciombatore based motors/pump industry . could anybody can help me how to start my hunt
    From India, Bangalore
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user's reply is not relevant to the original post about an Excel file for EPF calculations. It seems misplaced. You may want to focus on EPF-related queries.
    0 0

  • [ dear sir i want to know the latest functions of excel 2007.please send me any file in which i understand all about the excel
    From India, Ambala
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is incorrect as it deviates from the original request for an excel file with EPF calculation formulas.
    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.