Can I get calculator for EPF in excel ?

POSTED BY Umashankar ON January 21, 2014 11:53 am COMMENTS (3)

1. Can you please provide a calculator for EPF in excel so that one can track and verify wrt company calculation ?

2. I tried to see my EPF balance through the official web site of EPF. I could not succeed. I heard that since my company EPF is handled by a private trustee board, it is not available in the net. Is it true ? My company is a Public Limited company (although majority of the shares are hold by the promoters) and listed in BSE/NSE.


3 replies on this article “Can I get calculator for EPF in excel ?”

  1. Bunker says:

    The Tax Calc I suggested before may not do correct calculation in the excel for a PF Trust as generally PF trusts do not have EPS (Pension) option wherein Rs 541/- every month from employer’s PF contribution goes for Pension.
    It does work correctly for those who have PF in the EPFO (I had confirmed with the author).


  2. Bunker says:

    Go to

    Download the annual Tax Calculator that the website provides for each financial year.
    Enter your salary details in each month as per your salary slip, bonus, incentive, TDS, etc. Set the PF interest rate that your PF trust offers each financial year.

    The excel does all the necessary calculations for PF deduction, interest etc.

    In the April column, it allows you to write the OB(Opening Balance) of PF amount which is nothing but the Closing balance of your PF for previous financial year.

  3. ashalanshu says:

    Dear Usctty, as your PF is a recognised PF trust, you should get your PF slip from your employer every year. The details of your PF should also be there in your salary system.



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Download Our FREE Ebook!

Available only for first 100 people today

Download Our FREE Ebook!

Available only for first 100 people today