Pf Balance Xls Download
CiteHRCiteHR
 
HOME RISE NEW TEAM →|

chandan_bhola Started The Discussion:
Hi, My PF balance says EE amount 83271, ER amt: 48363 as on 01-09-11(account updated uptp 31-03-2010. Can some one please tell me the approx updated balance which i would receive including the interest??
awaiting response
I want to share some more information which I have regarding PF balance SMS getting from EPFO and PF interest calculation tool (Excel file).

Information on SMS getting from EPFO
Sl.No Massage Meaning/ interpretation
1 Account Details Office and Account no ext,
2 EE Amt.: Employee’s Contribution (12% on Basic +DA or Max. 780/- per month)
3 ER Amt.: Employer’s Contribution (3.67% on Basic +DA) or Max. 239/- per month)
4 ER Pension Remaining balance of Employer’s Contribution (8.33% on Basic +DA “or” Max. 541/- per month). is goes to pension fund account. (it does not reflect the PF Account)
5 As on date– dd-mm-yyyy Your monthly contributions updated as on dd-mm-yyyy
6 (Accounts updated up to 31-03-2010) Interest added to your account balance up to 31-03-2010((interest is Compounded annually)
7 Interest rates 16.11.95 to 31.3.2000 - 12%
1.4.2000 to 31.3.2001 - 11%
1.4.2001 to 31.3.2005 - 9.5%
1.4.2005 to 31.3.2010 - 8.5%
2010-2011 is 9.5%
2011-2012 not yet declared



All the best

KVJ Raghunath
Thanks Mr Raghunath/Mr Dhingra, is it possible to calculate the approx. balance that i am entitled to receive?
I have filled PF withdrawal form 3 months ago..
On website status showing as Under Process. When we call at PF office, nobody pick-up call.

I also sent mail multiple time on given email ID of respecting PF office but nobody respond.

I also put grievance on website but nobody responded yet. Let me know what to do ?

Who can be authority believe in responding me.

Regards,
Sourabh
Dear Chandan,

Definitely you can. You can even calculate exact balance along with interest on your pf account, as follows:

Take the closing balance (CB) of the last year, say 2008-09 and treat that as your opening balance (OB) for the year 2009-10.

You can cast OB & CB of each month as follows:

April 2010: OB (+) total subscription of the month (-) withdrawal (if any) = CB
May 2010: OB, i.e., CB of April (+) subscription of the month (-) withdrawal = CB

AND SO ON for every month up to March 2011

ADD all CBs of 12 months and DIVIDE by 12 = Average yearly CB at the end of March 2011

To this CB, multiply with the approved rate of interest/100.

Last CB + interest will be your balance for 2010-11.

Similarly, you can calculate for 2011-12 and onwards every year.

Quote:
Originally Posted by chandan_bhola View Post
Thanks Mr Raghunath/Mr Dhingra, is it possible to calculate the approx. balance that i am entitled to receive?
Mr. Chandhan, Yes You can calculate. Find the Calculation tool All the best ( KVJ Raghunath) at http://www.kvjraghunath.com ( KVJ Raghunath) at http://www.kvjraghunath.com
Attached FilesProvided by community member kvjraghunath. Register to join your network of peers.
File Type: xls Provident Fund interest Calculation Tool -97-03.xls (74.5 KB, 2435 views)
Hey Guys,

i submitted a query on the EPF claims and received a msg that the application has been received on 1-10-11 and is under process. Can anyone tell me the estimated time for the PF amount to be credited in the bank account.


Thanks,
Chandan Bhola
Hello Mr.KVJ Raghunath,

Your Provident Fund interest Calculation Tool is very easy and helpful.

It will be grateful if you will send updated file (upto 2013-14) as a attachment.

Thanks in advance


Regards

Jatin
Hi friends, pls tell me the full form of 'fpr' in epfo. Thanks,
asmi_2 
Dear Mr KVJ Raghunath

"Good Evening"

My query is that my employer calculate the EPF accumulation from March to February.Where as there is two different ROI.Is my employer making any mistake? The PF amount is deposited in a Trust managed by the Employer.
As per your formula it is difficult to calculate interest.Please do the needful.
Regards
Jagannath Pandit



 
 
 
 





Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Share This Discussion:


3M Users, 100K+ Documents & 450K+ Discussions
About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network