Here is an Excel file attached, in which you can calculate your Provident Fund interest. Just input your contribution for any year and the interest rate for that year, and the calculation will be done by the file itself.
Thanks & Regards,
Nitesh Barman
From India, Jaipur
Acknowledge(4)
Amend(0)
83Thanks & Regards,
Nitesh Barman
From India, Jaipur
Acknowledge(4)Amend(0)
Hi Nitesh Barman, Is this the correct format? It seems to be wrong when I calculate my PF+EPF by adding it and putting interest (9.50%) on the whole figure, I am getting a very small amount as interest. As per my knowledge, PF is calculated only once a year (after April). But in this format, it is being calculated every month. How is this possible?
Regards,
Vinay Kumar
From India, Hyderabad
Acknowledge(0)Amend(0)
Regards,
Vinay Kumar
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi, maybe you are right that interest is credited to your account in the month of April, but the calculation is made each month of contribution. It's called compound calculation of interest; I think you have heard about it.
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
Hi, please find the file attached to this post. I have attached my PF contribution, where I do not have an opening balance in my account because this is a new account. In the attachment, you can find my estimated amount, which will be the output at the year-end (April).
I joined Zenara Pharma on 13th May, and at that time, my basic was 5818, and my PF was 698. Please verify if this information is correct.
Also, please provide me with the calculation for each month. What percentage are we going to add each month?
Regards,
Vinay Kumar
From India, Hyderabad
Acknowledge(0)Amend(0)
I joined Zenara Pharma on 13th May, and at that time, my basic was 5818, and my PF was 698. Please verify if this information is correct.
Also, please provide me with the calculation for each month. What percentage are we going to add each month?
Regards,
Vinay Kumar
From India, Hyderabad
Acknowledge(0)Amend(0)
I have attached file, in my view it should be like this. if me wrong suggest me.
From India, Jaipur
Acknowledge(1)Amend(0)
From India, Jaipur
Acknowledge(1)Amend(0)
The Excel sheet you prepared is excellent. However, there is one drawback that I would like to bring to your attention. When calculating PF accumulation and interest with an opening balance, it works excellently. But when attempting the same with a new account, it fails to calculate the accurate interest. You can either edit it yourself or provide me with the password or an unprotected file, and I can do it. Nevertheless, I genuinely appreciate your efforts in creating it.
With lots of compliments,
Abhijit.
From India, Hyderabad
Acknowledge(0)Amend(0)
With lots of compliments,
Abhijit.
From India, Hyderabad
Acknowledge(0)Amend(0)
My name is Arpan Srivastava. My PF EE amount is Rs. 32,377, and the ER amount is Rs. 9,889. I left my previous organization on 30th October 2011, and now I want to withdraw my PF. I have also generated a PF E-Passbook which shows Employee Contribution as Rs. 32,377 and Employer Contribution as Rs. 9,889 under the Deposit Column, with Rs. 16,724 diverted to the Pension Fund Column as of 31st March 2013. I would like to know the amount that will be transferred to my account.
Regards,
Arpan Srivastava
[Phone Number Removed For Privacy Reasons]
From India, Lucknow
Acknowledge(0)Amend(0)
Regards,
Arpan Srivastava
[Phone Number Removed For Privacy Reasons]
From India, Lucknow
Acknowledge(0)Amend(0)
My name is Arpan Srivastava. My PF EE amount is Rs. 32,377, and the ER amount is Rs. 9,889. I left my previous organization on 30th October 2011. Now, I want to withdraw my PF. I have also generated a PF E-Passbook, which shows Employee Contribution as Rs. 32,377 and Employer Contribution as Rs. 9,889 under the Deposit column, with Rs. 16,724 diverted to the Pension Fund column as of 31st March 2013. I just want to know the amount that will be transferred to my account.
Regards,
Arpan Srivastava
Mobile: [Phone Number Removed For Privacy Reasons]
Email: [Email Removed For Privacy Reasons]
From India, Lucknow
Acknowledge(0)Amend(0)
Regards,
Arpan Srivastava
Mobile: [Phone Number Removed For Privacy Reasons]
Email: [Email Removed For Privacy Reasons]
From India, Lucknow
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
PF Calculation Sheet To The Subscribers At the Time Of Provident Fund Withdrawal.pdf
Provident Fund interest Calculation Tool -97-03.xls