payal80 Started The Discussion:
Dear All, It would be Greate help for me if some one can provide me calculation procedure of Pf,ESI& gratuity in Excel sheets. Thanks Payal
Posted 3rd November 2007 From India, Calcutta
Hi Payal,

ESI is contributed from both the sides Employee as well as Employer.
It is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.
The contribution from both the sides is as below-

Employee Side- 1.75% of gross/month
So if gross of an employee is 8000/month then
ESI contribution would be 8000*1.75% = 140 Rupees

Employer side- 4.75% of gross/month
ESI contribution would be 8000* 4.75% = 380 Rupees.

Where as PF is contributed @12% of basic salary only from both sides employee as well as employer..

Regards,

Amit Seth.
Hi friend, I am enclosing here with an Excell sheet with formulas and examples. It will helpe u to make a clear idea and also for ur work. Thanks GrHrm
Posted 3rd November 2007 From India, Hyderabad
Attached Files
 Shared By Cite.Community Member "grhrm" For Public Download esi__pf_calculation_191.xls (16.0 KB, 37437 views)
Dear Payal,

To the excell sheet provided by grhrm, please apply a condition that If Gross > 10000, ESI contribution is Zero. So that it can directly read Zero value for people having salary greater than Rs.10000

Truly Yours,
Kumar.H.P
Posted 5th November 2007 From Hong Kong
Dear Amit,

I have a clarification about the below line as quoted by you, if i am not wrong wrong confirm me is this the Gross limit the maximum above which the employee can opt for PF i mean is it similar to the limit of basic salary of Rs 6500. Clarify me on the same.

PF is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.

Regards
Amith R.
Posted 5th November 2007 From India, Bangalore
Dear Amith,

Please go through with the mention line once again..

ESI is contributed from both the sides Employee as well as Employer.
It is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.

Hope now it must be clear at your end..

Regards,

Amit Seth.
hi esic challan and calcul.for u
Posted 6th November 2007 From India, Gurgaon
Attached Files
 Shared By Cite.Community Member "manojkumar01" For Public Download pf___esi_challan_and_calcu_299.xls (155.0 KB, 7405 views)
Dear Sir,

I've one doubt regarding pension. According to the formula the pension is calculated in this manner.

last drawn wages x no. of years of service / 70

But i would like to know about that 70.

With Regards,

K. Ravi Kumar.
E-mail:
Ph: 09989111149
Posted 6th November 2007 From India, Hyderabad
Its ok Amith.. No issues.. wish you Happy Diwali.. :D Thank you Milan.. Regards, Amit Seth.
Hi,

PF & ESI Calculation

PF 12% of the Basics for BOth (Employer & Employee)
PF Calculation upto 6500 Only above 6500 should not calulate for rest of the BASIC SALARY.
Basics PF 12% (Employee & Employer Contribution Equal Level)
5000 600

ESI
Empoyee Contribution= 1.75%
Employer Contribution= 4.75%

Gross Salary ESI 1.75%(Employee) 4.75% (Employer)
10000 175 475

Above 10000 Gross Salary
They are not eligible for ESI

Regards,
Vinoth.R :lol:
Posted 10th November 2007 From India, Madras
I have changes my job last year. I have transferred my PF from my last employeer to the currently employeer pf account. For past few months I was trying to find out the status of PF transfer. I finally got the details from my prev. employeer. I am having a doubt that there has been some mistake and the amount transferred is not correct.

I have been in working with my prev. employeer from Aug 2003 till oct 2006. I have contributed x rupees toward the PF. As per my understanding the employeer will also contribute the same amount. Also the interest will be added to this amount. But the total amount transferred is much less. I have contacted my prev. employeer for details but i doubt i will get a proper response. Is there a way that I can find this information from PF office.

Thanks
Posted 17th November 2007
Hi Amith How are you? Wish you a very happy diwali. You have lots of good information that will help me lots. Thanks & Regards Akhil Asst.Mgr — HR & Admin
Posted 17th November 2007 From India, Kota
Thank you Manoj,

Very helpful contribution. If you have any other labour law's excel sheets please share with me.

I have good experience in the softskill activities but I think in HR I am lacking all these exposure, so i need your help to upgrade my knowledge.

pl help.

Regards,
Vishal Trivedi
09825413635
Posted 19th November 2007 From India, Kalol
During third party verification is there any chance that they can trace a company’s name and address details
Posted 13th July 2008 From India, Madras
During third party verification is there any chance that they can trace a company’s name and address details with PF Number provided
Posted 13th July 2008 From India, Madras
Dear Sir, Please confirm one thing...Is the PF employer contribution 12 % or 13.61 %..?? Regards, Vivek Keshri vivek.keshri@yahoo.co.in
Posted 15th August 2008 From India, Vadodara
Hi payal

Please find enclosed attachment for deduction of PF and ESIC

For gratuity this is the formula

BASIC + DA [as applicable] *15*NO of year of service
____________________________________________

26

as per the acts applicable

best of luck

Santosh

Posted 22nd August 2008 From India, Mumbai
Attached Files
 Shared By Cite.Community Member "santosh_shrimal" For Public Download PF ESIC.xls (15.0 KB, 1519 views)
Dear All, Please Check the Calculation for P.F, I think we need to calculate by using the upper value of Basic & DA. Please check this and then move forward.
Posted 16th September 2008 From India, Madras
1LCI0001192109/18/2007Jitendra prasad MauryaCarpenterHighly Skilled07/24/1979Ram Awadh prasad4300363616206 397 198 198 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04 1LCI0001192109/18/2007Jitendra prasad MauryaCarpenterHighly Skilled07/24/1979Ram Awadh prasad4300363616206 397 198 198 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04

Sl. No.EMP. CODEDOJNAMEDESIGNATIONGradeDOBFather's Name Salary OT-01/07/08 to 31/07/08OT-01/07/08 to 31/07/08Total OTOT<=16 Hrs in a monthSite Allowance(OT>16 hours)Days Jul' 08Days Aug' 08 Earnings Deductions Net payable salary Net payable salary (Rounded) PF Wages Employee's Contribution Employer's contribution PF Admn Charges (1.10%) EDLI Wages EDLI Charges (.5%) EDLI Admin Charges (.01%) WDWD Basic ( Conv All Site All. HRA OT Project All. Total Earning PF (12%) Reg. amt Recv. Total Deduction EPF (12%) Total EPF (3.67%) EPS (8.33%) Total 1 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04
Posted 16th September 2008 From India, Mumbai
Hi I have to design a qustionnaire on Compensation for management trainee.if anyone has format,please provide,would be really helpful.
Posted 18th September 2008 From United States, Plano
Dear friends,

I was joined one company call elcome as network engineer at that time my Pf no. was MH-95817-A-187 . But after 6 mounth I was tranfered to another company called elcosoft and my probation increased and payrolled also changed. At this time new pf no. was given as xxxxxxxxx-026.
now perivious company elcome is not a part of elcosoft now. So they provied me new PF no.

Please guide me how can I confirm that my pf is not digest by company.

Posted 6th October 2008
Posted 22nd November 2008 From India
Dear grhrmThanks for excel Sheet of PF /ESI, and also I would like to know the returns to be submitted in the form to PF/ESIRegardsMaria Pradeep
Posted 22nd November 2008 From India
Pl let me the percentage of contribution in PF either from Employer side and employee side and % of employers contribution in pension scheme and so on
Posted 22nd November 2008 From India
Pl let me differnt Forms in ESI & PF to submitted and also Various Act Like Bonurs Gratuity
Posted 24th November 2008 From India
Hii All I want the detail of the Employer contribution in PF including og administrative charges and all. Can anybody guide me on that :?:
Posted 12th December 2008 From India, Delhi
Dear Amit
i am working as hr and i want some diffrent kind of performance evlution system or process .

kindly help me up on the same its ver urgent ,we have to represent in next 2 days to our management :confused:

Regards
:-PRavi

Posted 15th December 2008 From India, Mumbai
hi,
My name is archana. i have just joined this forum ,could some help me what is all about 8.33% related to PF calculation ..if PF calculation is both 12% from employee or employer side plz help me:confused:
Posted 6th January 2009 From India, New Delhi
ESI is contributed from both the sides Employee as well as Employer.
It is been calculated on the basis of Gross salary per month is 10000 Rs./Month less than only then ESIC is applicable.

The contribution from both the sides is as below-

Employee Side- 1.75% of gross/month
So if gross of an employee is 10000/month then
ESI contribution would be 10000*1.75% = ### Rupees per employee

Employer side- 4.75% of gross/month
ESI contribution would be 10000* 4.75% = ### Rupees per employee

Where as PF is contributed @12% of basic salary only from both sides employee as well as employer..

Employer PF break-up is 3.67--Provident Fund and 8.33 will be for pension fund as on date 8-Jan-2009.

regards
Gopal
Posted 8th January 2009 From India, Madras
Where as PF is contributed @12% of basic salary only from both sides employee as well as employer..

Employer PF break-up is 3.67--Provident Fund and 8.33 will be for pension fund as on date 8-Jan-2009.

This is ok i think

regards
Gopal
Posted 8th January 2009 From India, Madras

Found This Useful? +Vote Up This Via Google.

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.