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
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..
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.
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)
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
Found This Useful? +Vote Up This Page 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.
Explore Topical Knowledge Areas
Topic Categories >> pf transfer pf number gratuity calculation pf and esi pf account esi & pf excel sheets basic salary esi form esi esi and pf employers contribution basic pay Location-India-Calcutta happy diwali central government site allowance payroll tax Complete List Of Categories
Interesting Relevant Discussions