+7 Others
Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
kind send me the excel file containing formulas for calculation of EPF etc
From India, New Delhi
From India, New Delhi
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
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
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
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
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
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
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.
Add the url of this thread if you want to cite this discussion.
#Listed In: excel formulas Country-India provident fund employer contribution epf calculation pf calculation contract labour labour law consultant labour law basic salary family pension pension fund City-India-New-Delhi
Calcu. pf Emp.eps.epf sample sheet for HR site..xls
EPF registration Procedure.pdf
