need formula/procedure for EPF / PF calculation excel file

ptiwari2ki · #1 (**permalink**) 27-12-2007, 11:27 PM

kind send me the excel file containing formulas for calculation of EPF etc

madhavi47 · #2 (**permalink**) 28-12-2007, 12:01 AM

DEAR TIWARI IAM SENDING U THE FORMAT OF EPF CALCULATION IF U DONT UNDERSTAND THAT BE IN TOUCH WITH

ptiwari2ki · #3 (**permalink**) 30-12-2007, 11:01 AM

Quote:

Originally Posted by madhavi47

DEAR TIWARI IAM SENDING U THE FORMAT OF EPF CALCULATION IF U DONT UNDERSTAND THAT BE IN TOUCH WITH

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

chandrakant · #4 (**permalink**) 30-12-2007, 11:35 AM

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)

madhavi47 · #5 (**permalink**) 30-12-2007, 01:53 PM

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

narayanrao.mp · #6 (**permalink**) 30-12-2007, 01:56 PM

hi,

please find enclosed the excel sheet for the reference

Regards,

vasanthapriya · #7 (**permalink**) 31-12-2007, 11:29 AM

i cant download it dude send it to mu mail id

kusumanaregal · #8 (**permalink**) 27-05-2008, 04:16 PM

Thank You very much

dev.delhirock · #9 (**permalink**) 27-05-2008, 05:01 PM

tnx all of u 4 this very good calculation

rantu · #10 (**permalink**) 09-07-2008, 12:44 PM

can i have manual for pf/esi working? pl suggest

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode