ptiwari2ki@gmail.com
9

kind send me the excel file containing formulas for calculation of EPF etc
From India, New Delhi
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Chandrakant
Provident Fund, Esic, Professional Tax, Contract
Baishya.hrishikesh@ibibo.com
Hr Consultants At Gvk Emri - 108
Abbasiti
Assistant Engineer, Indian Telephone Industries,
Madhavi47
Hr Professional
Deepak.acb
Admn.executive
Rasheedcoorg
Hr And Accounts Exc
Saumen12@gmail.com
Senior Officer- Accounts
+7 Others

ptiwari2ki@gmail.com
9

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

Attached Files (Download Requires Membership)
File Type: xls pf_calculation_686.xls (35.0 KB, 17730 views)

chandrakant
3

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
madhavi47
2

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
narayanrao.mp
3

hi, please find enclosed the excel sheet for the reference Regards,
From India, Pune

Attached Files (Download Requires Membership)
File Type: xls epf_1__123.xls (13.5 KB, 7965 views)

kumar0510
1

Thanks for the calculations. Can u please help me to know the excel formulas to generate the 3A/6A reports through the said sheet regards kumar 9885576600
From India, Hyderabad
usha HR
2

Thanks a lot
I am in the process of calcualating the PF amoutn for our employees I know the %s but I don't have the format. I was planning toprepare the formula format for PF but You made my work easy.
It helped me a lot.
Thanks
usha

From India, Hyderabad
ghosal
1

please give a revised excel calculation sheet for pf with salary more than Rs.6500/- per month.
From India, Calcutta
sepl
1

hi Im new to this site really very useful site. Im looking for Design Engineers who have experience in Manufacturing firm especially ciombatore based motors/pump industry . could anybody can help me how to start my hunt
From India, Bangalore
deepak.acb
1

[ dear sir i want to know the latest functions of excel 2007.please send me any file in which i understand all about the excel
From India, Ambala
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHR

All Copyright And Trademarks in Posts Held By Respective Owners.