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
From India, Calcutta
Acknowledge(0)
Amend(0)
15From India, Calcutta
Acknowledge(0)Amend(0)
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.
From India, Ahmadabad
Acknowledge(4)
Amend(0)
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.
From India, Ahmadabad
Acknowledge(4)Amend(0)
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
From India, Hyderabad
Acknowledge(7)
Amend(0)
0
0
From India, Hyderabad
Acknowledge(7)+2 more
Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply lacks accuracy and correct spelling. Please ensure precise information and proper spelling for better understanding. Thank you for sharing your input.
0
0
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
From Hong Kong
Acknowledge(1)
Amend(0)
0
0
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
From Hong Kong
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Checked)-The suggestion to apply a condition for ESI contribution based on Gross salary in Excel is correct and can streamline calculations efficiently. (1 Acknowledge point)
0
0
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.
From India, Bangalore
Acknowledge(1)
Amend(0)
0
0
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.
From India, Bangalore
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is incorrect. The PF is not calculated on the basis of Gross salary per month, but on the basis of Basic salary. The maximum ceiling for PF contribution is Rs. 15,000 per month, not Rs. 10,000.
0
0
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.
From India, Ahmadabad
Acknowledge(0)Amend(0)
0
0
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.
From India, Ahmadabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The Employee State Insurance (ESI) contribution is solely deducted from the employee's side, not the employer's. The contribution is based on the employee's salary, with a ceiling of INR 21,000. Please refer to the ESI Act for details.
0
0
hi esic challan and calcul.for u
From India, Gurgaon
Acknowledge(1)
Amend(0)
0
0
From India, Gurgaon
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is not accurate as it lacks detailed information on ESIC, PF, and gratuity calculations in Excel. Please provide more comprehensive guidance. Thank you for your input!
0
0
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.
Please clarify my doubt.
With Regards,
K. Ravi Kumar.
E-mail:
Ph: 09989111149
From India, Hyderabad
Acknowledge(0)Amend(0)
0
0
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.
Please clarify my doubt.
With Regards,
K. Ravi Kumar.
E-mail:
Ph: 09989111149
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The formula for pension calculation is correct. The number 70 is used as a divisor in the formula. It is based on the assumption of a 3% interest rate as per the Employees' Pension Scheme, 1995. (1 Acknowledge point)
0
0
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:
From India, Madras
Acknowledge(0)Amend(0)
0
0
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:
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply contains inaccuracies regarding the calculation of PF and ESI. The correct calculations should follow specific guidelines. Please refer to the latest PF and ESI rules for accurate computation.
0
0
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
Acknowledge(2)
Amend(0)
0
0
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
Acknowledge(2)Amend(0)CiteHR.AI
(Fact Checked)-The process of PF transfer involves the full amount transferred, not just contributions. You can file a grievance with the PF office for resolution. Thank you. (1 Acknowledge point)
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is mostly accurate. However, there is a slight error in the calculation of the ESI contribution on the employer's side. The correct percentage for the employer's contribution to ESI is 3.25% of the gross salary, not 4.75% as mentioned.