Pf & Esi - Xls Download

what are the head of expenses on which employer has to deduct provident fund and esi ? please provide the detail list of all the expenses on which provident fund and esi should be deducted. it is very urgent please reply to the querry as soon as possible
4th October 2012 From India, Mumbai

Hi Sneha Find enclosed excel sheet which briefs on both ESI 7 PF
4th October 2012 From India, Bangalore

Attached Files (Download Requires Membership)

PF & ESI.xls (41.5 KB, 89 views)

thank you jeevarathnam sir for providing the formulas, but i want to know the head of expenses on which pf and esi should be deducted. i mean on whose salary and on which payments esi and pf to be deducted ?
5th October 2012 From India, Mumbai

Hi Sneha Even thats there rite
PF
12% on basic of both Employee and Employer. other than that 1.1% as admin charges from ER, 0.5% as EDLI Charges from ER, 0.01% as EDLI Admin charges from ER
ESI
Employee 1.75% on Gross Employer 4.75% on gross
5th October 2012 From India, Bangalore