Pf - Xls Download - Provident Fund

augustin joseph

how to calculate provident fund for employer and employee?
how to calculate the pension for the same persons?
whats the formula for calculating gratuity?

augustin joseph

i need to know about the calculations being made in every companies.. as a hr person i should know these conditions and the benefits..

pankajmishra1

how to calculate provident fund for employer and employee?
how to calculate the pension for the same persons?
whats the formula for calculating gratuity?

krithishanky

Hi All,
I attach an excel sheet. I hope it clarifies your doubt.

1 Attachment(s) [Login To View]

BrIjLAl Arora

Hello,
Asper my knowledge PF is calculated on PF Base Salary (Basic + DA), But as per ur attach sheet u have calculated on Basic + DA + Food Concession Value.
Can U Explain this.
Regars,
BrijLal Arora

krithishanky

I have attached the definitions of PF Act from Net, The Definition for Contribution inthe sixth point includes Cash Value of Food Concession

1 Attachment(s) [Login To View]

krithishanky

Sir,
Like u said there are always controversial opinions on this particular point.. Its debatable..

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute