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 sides by the Employee and the Employer. It is calculated based on the Gross salary per month, with a maximum ceiling of Rs. 10,000 per month. The contribution from both sides is as follows:
Employee Side - 1.75% of gross/month
If the gross salary of an employee is Rs. 8,000 per month, the ESI contribution would be 8,000 * 1.75% = Rs. 140.
Employer Side - 4.75% of gross/month
The ESI contribution would be 8,000 * 4.75% = Rs. 380.
On the other hand, PF is contributed at a rate of 12% of the basic salary only from both sides, the employee as well as the employer.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(4)
Amend(0)
ESI is contributed from both sides by the Employee and the Employer. It is calculated based on the Gross salary per month, with a maximum ceiling of Rs. 10,000 per month. The contribution from both sides is as follows:
Employee Side - 1.75% of gross/month
If the gross salary of an employee is Rs. 8,000 per month, the ESI contribution would be 8,000 * 1.75% = Rs. 140.
Employer Side - 4.75% of gross/month
The ESI contribution would be 8,000 * 4.75% = Rs. 380.
On the other hand, PF is contributed at a rate of 12% of the basic salary only from both sides, the employee as well as the 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)
From India, Hyderabad
Acknowledge(7)+2 more
Amend(0)
Dear Payal,
Regarding the Excel sheet provided by the HR team, please apply a condition that if Gross > 10000, ESI contribution is zero. This modification will enable the system to automatically assign a zero value for individuals with a salary exceeding Rs. 10000.
Truly Yours,
Kumar H. P
From Hong Kong
Acknowledge(1)
Amend(0)
Regarding the Excel sheet provided by the HR team, please apply a condition that if Gross > 10000, ESI contribution is zero. This modification will enable the system to automatically assign a zero value for individuals with a salary exceeding Rs. 10000.
Truly Yours,
Kumar H. P
From Hong Kong
Acknowledge(1)Amend(0)
Dear Amit,
I have a clarification about the below line as quoted by you. If I am not wrong, please confirm for me: is the Gross limit the maximum above which the employee can opt for PF? I mean, is it similar to the limit of the basic salary of Rs 6,500? Please clarify this for me.
PF is calculated based on the Gross salary per month, with a maximum ceiling of Rs 10,000 per month.
Regards,
Amith R.
From India, Bangalore
Acknowledge(1)
Amend(0)
I have a clarification about the below line as quoted by you. If I am not wrong, please confirm for me: is the Gross limit the maximum above which the employee can opt for PF? I mean, is it similar to the limit of the basic salary of Rs 6,500? Please clarify this for me.
PF is calculated based on the Gross salary per month, with a maximum ceiling of Rs 10,000 per month.
Regards,
Amith R.
From India, Bangalore
Acknowledge(1)Amend(0)
Dear Amith,
Please go through the mentioned line once again. ESI is contributed from both sides - employee as well as employer. It is calculated based on the gross salary per month, with a maximum ceiling of Rs. 10,000 per month. I hope it is clear now at your end.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Please go through the mentioned line once again. ESI is contributed from both sides - employee as well as employer. It is calculated based on the gross salary per month, with a maximum ceiling of Rs. 10,000 per month. I hope it is clear now at your end.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Dear Sir,
I have 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. However, I would like to know more about that 70.
Please clarify my doubt.
With Regards,
K. Ravi Kumar
E-mail: kasinaravikumar@gmail.com
Ph: 09989111149
From India, Hyderabad
Acknowledge(0)Amend(0)
0
0
I have 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. However, I would like to know more about that 70.
Please clarify my doubt.
With Regards,
K. Ravi Kumar
E-mail: kasinaravikumar@gmail.com
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 is up to 6500 only. Anything above 6500 should not be calculated for the rest of the basic salary. Basics PF contribution is 12% for both employee and employer.
- Basics PF 12% (Employee & Employer Contribution Equal Level)
- 5000 600
ESI:
Employee Contribution = 1.75%
Employer Contribution = 4.75%
Gross Salary ESI 1.75% (Employee) 4.75% (Employer)
- 10000 175 475
For salaries above 10000, they are not eligible for ESI.
Regards,
Vinoth.R 😄
From India, Madras
Acknowledge(0)Amend(0)
PF & ESI Calculation
PF: 12% of the Basics for Both (Employer & Employee). PF Calculation is up to 6500 only. Anything above 6500 should not be calculated for the rest of the basic salary. Basics PF contribution is 12% for both employee and employer.
- Basics PF 12% (Employee & Employer Contribution Equal Level)
- 5000 600
ESI:
Employee Contribution = 1.75%
Employer Contribution = 4.75%
Gross Salary ESI 1.75% (Employee) 4.75% (Employer)
- 10000 175 475
For salaries above 10000, they are not eligible for ESI.
Regards,
Vinoth.R 😄
From India, Madras
Acknowledge(0)Amend(0)
I have changed my job last year. I transferred my PF from my previous employer to the current employer's PF account. For the past few months, I have been trying to find out the status of the PF transfer. I finally got the details from my previous employer. I am doubtful that there has been a mistake, and the transferred amount is incorrect.
I worked with my previous employer from August 2003 till October 2006 and contributed x rupees towards the PF. As per my understanding, the employer should also contribute the same amount, and interest will be added to this total. However, the total amount transferred is much less. I have contacted my previous employer for details, but I doubt I will receive a proper response. Is there a way I can obtain this information from the PF office?
Thanks
Acknowledge(2)
Amend(0)
0
0
I worked with my previous employer from August 2003 till October 2006 and contributed x rupees towards the PF. As per my understanding, the employer should also contribute the same amount, and interest will be added to this total. However, the total amount transferred is much less. I have contacted my previous employer for details, but I doubt I will receive a proper response. Is there a way I can obtain this information from the 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
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
From India, Kota
Acknowledge(0)Amend(0)
From India, Kota
Acknowledge(0)Amend(0)
Thank you, Manoj.
Very helpful contribution. If you have any other labor law excel sheets, please share with me. I have good experience in soft skill activities, but I think in HR, I am lacking this exposure. So, I need your help to upgrade my knowledge. Please help.
Regards,
Vishal Trivedi
09825413635
From India, Kalol
Acknowledge(0)Amend(0)
Very helpful contribution. If you have any other labor law excel sheets, please share with me. I have good experience in soft skill activities, but I think in HR, I am lacking this exposure. So, I need your help to upgrade my knowledge. Please help.
Regards,
Vishal Trivedi
09825413635
From India, Kalol
Acknowledge(0)Amend(0)
During third party verification is there any chance that they can trace a company’s name and address details
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
During third party verification is there any chance that they can trace a company’s name and address details with PF Number provided
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hi Payal,
Please find enclosed attachment for deduction of PF and ESIC. For gratuity, this is the formula:
BASIC + DA [as applicable] * 15 * Number of years of service / 26 as per the applicable acts.
Best of luck,
Santosh
From India, Mumbai
Acknowledge(1)Amend(0)
Please find enclosed attachment for deduction of PF and ESIC. For gratuity, this is the formula:
BASIC + DA [as applicable] * 15 * Number of years of service / 26 as per the applicable acts.
Best of luck,
Santosh
From India, Mumbai
Acknowledge(1)Amend(0)
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.
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
1. LCI0001 1921 09/18/2007 Jitendra Prasad Maurya Carpenter Highly Skilled 07/24/1979 Ram Awadh Prasad 4300 36 36 16 20 6 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. CODE DOJ NAME DESIGNATION Grade DOB Father's Name Salary OT-01/07/08 to 31/07/08 OT-01/07/08 to 31/07/08 Total OT OT<=16 Hrs in a month Site Allowance(OT>16 hours) Days Jul' 08 Days Aug' 08 Earnings Deductions Net payable salary Net payable salary (Rounded) PF Wages Employee's Contribution Employer's contribution PF Admin Charges (1.10%) EDLI Wages EDLI Charges (.5%) EDLI Admin Charges (.01%) WD WD 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
Corrected and formatted the text for better readability.
From India, Mumbai
Acknowledge(1)
Amend(0)
Sl. No. EMP. CODE DOJ NAME DESIGNATION Grade DOB Father's Name Salary OT-01/07/08 to 31/07/08 OT-01/07/08 to 31/07/08 Total OT OT<=16 Hrs in a month Site Allowance(OT>16 hours) Days Jul' 08 Days Aug' 08 Earnings Deductions Net payable salary Net payable salary (Rounded) PF Wages Employee's Contribution Employer's contribution PF Admin Charges (1.10%) EDLI Wages EDLI Charges (.5%) EDLI Admin Charges (.01%) WD WD 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
Corrected and formatted the text for better readability.
From India, Mumbai
Acknowledge(1)Amend(0)
Hi I have to design a qustionnaire on Compensation for management trainee.if anyone has format,please provide,would be really helpful.
From United States, Plano
Acknowledge(0)Amend(0)
From United States, Plano
Acknowledge(0)Amend(0)
Dear friends,
Please help me with this issue. I joined a company called Elcome as a network engineer, and at that time, my PF number was MH-95817-A-187. However, after 6 months, I was transferred to another company called Elcosoft, where my probation period was extended, and my payroll details were changed. At this time, a new PF number, xxxxxxxxx-026, was assigned to me.
Now, the previous company, Elcome, is not part of Elcosoft anymore. They have provided me with a new PF number. Please guide me on how I can confirm that my PF is not being mishandled by the company.
Acknowledge(0)Amend(0)
Please help me with this issue. I joined a company called Elcome as a network engineer, and at that time, my PF number was MH-95817-A-187. However, after 6 months, I was transferred to another company called Elcosoft, where my probation period was extended, and my payroll details were changed. At this time, a new PF number, xxxxxxxxx-026, was assigned to me.
Now, the previous company, Elcome, is not part of Elcosoft anymore. They have provided me with a new PF number. Please guide me on how I can confirm that my PF is not being mishandled by the company.
Acknowledge(0)Amend(0)
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
From India
Acknowledge(0)Amend(0)
0
0
From India
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The percentage of contribution in PF from both the employer and employee sides is generally 12% each. The employer's contribution to the pension scheme is 8.33% of the wage subject to a maximum of Rs. 1,250 per month. These are standard rates as per the EPF Act, 1952. (1 Acknowledge point)
0
0
Pl let me differnt Forms in ESI & PF to submitted and also Various Act Like Bonurs Gratuity
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
Hii All I want the detail of the Employer contribution in PF including og administrative charges and all. Can anybody guide me on that :?:
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Amit,
I am working as HR and I want a different kind of performance evaluation system or process.
Kindly help me out on the same. It's very urgent; we have to present to our management in the next 2 days.
Awaiting your valuable feedback.
Regards,
Ravi
From India, Mumbai
Acknowledge(0)Amend(0)
I am working as HR and I want a different kind of performance evaluation system or process.
Kindly help me out on the same. It's very urgent; we have to present to our management in the next 2 days.
Awaiting your valuable feedback.
Regards,
Ravi
From India, Mumbai
Acknowledge(0)Amend(0)
Hi, my name is Archana. I have just joined this forum. Could someone help me understand what 8.33% is related to in PF calculation? If PF calculation involves both 12% from the employee and employer side, please assist me. 🤔
From India, New Delhi
Acknowledge(0)Amend(0)
0
0
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The 8.33% for PF calculation is specifically related to the employer's contribution towards the Employee Pension Scheme (EPS) and not the PF calculation itself. The PF calculation is indeed 12% from both the employee and employer sides. (1 Acknowledge point)
0
0
ESI is contributed from both sides, by the employee as well as the employer. It is calculated based on the gross salary per month; if it is 10,000 Rs./month or less, then ESIC is applicable.
The contribution from both sides is as follows:
Employee Side - 1.75% of gross per month. So, if an employee's gross salary is 10,000/month, the ESI contribution would be 10,000 * 1.75% = ### Rupees per employee.
Employer Side - 4.75% of gross per month. The ESI contribution would be 10,000 * 4.75% = ### Rupees per employee.
On the other hand, PF is contributed at a rate of 12% of the basic salary from both the employee and the employer.
The employer's PF breakdown is 3.67% for Provident Fund and 8.33% for the pension fund as of January 8, 2009.
Regards,
Gopal
From India, Madras
Acknowledge(0)Amend(0)
The contribution from both sides is as follows:
Employee Side - 1.75% of gross per month. So, if an employee's gross salary is 10,000/month, the ESI contribution would be 10,000 * 1.75% = ### Rupees per employee.
Employer Side - 4.75% of gross per month. The ESI contribution would be 10,000 * 4.75% = ### Rupees per employee.
On the other hand, PF is contributed at a rate of 12% of the basic salary from both the employee and the employer.
The employer's PF breakdown is 3.67% for Provident Fund and 8.33% for the pension fund as of January 8, 2009.
Regards,
Gopal
From India, Madras
Acknowledge(0)Amend(0)
Whereas PF is contributed at 12% of the basic salary from both the employee and the employer.
Employer PF breakdown is 3.67 for Provident Fund and 8.33 will be for the pension fund as of January 8, 2009.
This is okay, I think.
Regards,
Gopal
From India, Madras
Acknowledge(0)Amend(0)
0
0
Employer PF breakdown is 3.67 for Provident Fund and 8.33 will be for the pension fund as of January 8, 2009.
This is okay, I think.
Regards,
Gopal
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The information provided regarding PF contribution is accurate. It includes the breakdown of employer PF contribution into Provident Fund and Pension Fund correctly. Thank you for your contribution to the discussion. (1 Acknowledge point)
0
0
Dear All,
Can you please tell me whether the Overtime Allowance is to be included while calculating the ESI? For example, an employee is getting Rs. 8000/- as Gross Salary, and his Overtime Allowance is Rs. 1000/-. In this case, do we have to include the Overtime Allowance to calculate the ESI for both Employee's and Employer's contributions? Please clarify, and if you have any proof for this, please send it to my email ID mentioned below.
Regards, P.K. Sudarsan
From India, Madras
Acknowledge(0)Amend(0)
Can you please tell me whether the Overtime Allowance is to be included while calculating the ESI? For example, an employee is getting Rs. 8000/- as Gross Salary, and his Overtime Allowance is Rs. 1000/-. In this case, do we have to include the Overtime Allowance to calculate the ESI for both Employee's and Employer's contributions? Please clarify, and if you have any proof for this, please send it to my email ID mentioned below.
Regards, P.K. Sudarsan
From India, Madras
Acknowledge(0)Amend(0)
hi can anyone show me how the salary is calculated in the excel sheet.. i have doubt.. please can anyone show me in the excel sheet
From Kuwait
Acknowledge(0)Amend(0)
From Kuwait
Acknowledge(0)Amend(0)
Hi all, I m new member My name is pramod :-P pls find attached formulae sheet for your ref
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
Dear All, It would be Greate help for me if some one can provide me calculation procedure of service tax, payroll taxation and returns in Excel sheets. thanks, gururaju acharya
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi friends here iam attaching Pf calucltion format it is use full to know pf amount how much easily Regards Nageswararao
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
hi, It would be much helpfull for me if some one provide me calculation procedure of Gratuity, and its conditions. Regards, Salman
From India, Sholapur
Acknowledge(0)Amend(0)
From India, Sholapur
Acknowledge(0)Amend(0)
Hi Dear All,
Please give me clarification regarding whether PF is payable after deducting LOP or not. Because the law states to charge PF on the amount paid to the employees, i.e., Basic + DA + any allowance - LOP * 12%. Please clarify in this regard.
Regards,
Razik
Kerala
From India, Thiruvananthapuram
Acknowledge(0)Amend(0)
0
0
Please give me clarification regarding whether PF is payable after deducting LOP or not. Because the law states to charge PF on the amount paid to the employees, i.e., Basic + DA + any allowance - LOP * 12%. Please clarify in this regard.
Regards,
Razik
Kerala
From India, Thiruvananthapuram
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The PF is payable after deducting LOP as per the law, which calculates PF on Basic + DA + any allowance - LOP * 12%. This aligns with legal requirements. (1 Acknowledge point)
0
0
Hi all,
I am a new member. I would like to know the current balance of EPF accumulation along with the interest accrued. Is there any calculator to determine the above if I know the opening balance and the monthly contribution? Please help me.
From India, Madras
Acknowledge(0)Amend(0)
I am a new member. I would like to know the current balance of EPF accumulation along with the interest accrued. Is there any calculator to determine the above if I know the opening balance and the monthly contribution? Please help me.
From India, Madras
Acknowledge(0)Amend(0)
Hello Sir/Madam,
I have worked for 14 months at Gupta Equities Pvt Ltd, and my PF amount for one side is 780, and for the other side, I have my PF of 8 months. Could you please tell me how much amount I should get from the PF Office? I submitted the PF Form after 11 months. How much interest should I get? Kindly send me the amount and the formula sheet.
My email id: govindmundhra2050@gmail.com
From India, Madras
Acknowledge(0)Amend(0)
I have worked for 14 months at Gupta Equities Pvt Ltd, and my PF amount for one side is 780, and for the other side, I have my PF of 8 months. Could you please tell me how much amount I should get from the PF Office? I submitted the PF Form after 11 months. How much interest should I get? Kindly send me the amount and the formula sheet.
My email id: govindmundhra2050@gmail.com
From India, Madras
Acknowledge(0)Amend(0)
hello sir! i want to know about voluntairy provident fund, is there any fixed % of it. and how it is calculated.plz sir reply soon.
From India, New Delhi
Acknowledge(0)Amend(0)
0
0
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The voluntary provident fund does not have a fixed percentage; employees can choose to contribute more than the mandatory EPF amount. The calculation is similar to EPF but voluntary. Thank you for your query. (1 Acknowledge point)
0
0
Dear Friends,
Please let me know if the ESI ceiling amount has now changed from 10,000 to 15,000. What is the calculation percentage now?
One more question: If a person has a basic pay higher than 6,500 and wants to deduct their PF, what is the procedure?
From India, Ambala
Acknowledge(0)Amend(0)
Please let me know if the ESI ceiling amount has now changed from 10,000 to 15,000. What is the calculation percentage now?
One more question: If a person has a basic pay higher than 6,500 and wants to deduct their PF, what is the procedure?
From India, Ambala
Acknowledge(0)Amend(0)
Dear Sir’s, He it any confirmation from ESI to increase for wage limit from 10000/- to 15000/-. Regards Durga S Prasad
From India, Rajamahendri
Acknowledge(0)Amend(0)
From India, Rajamahendri
Acknowledge(0)Amend(0)
Hi,
Thanks for sharing valuable knowledge, but I have some doubts. Please clarify:
1. If any employee is paid a bonus on a half-yearly basis, in this case, is ESI deductible on the bonus or not?
2. If an employee is awarded a bonus quarterly, in this case, is ESI applicable on the bonus?
Please also send me the reply to amar188taksh@gmail.com.
Thanks with Regards,
Taksh
From India, Delhi
Acknowledge(0)Amend(0)
0
0
Thanks for sharing valuable knowledge, but I have some doubts. Please clarify:
1. If any employee is paid a bonus on a half-yearly basis, in this case, is ESI deductible on the bonus or not?
2. If an employee is awarded a bonus quarterly, in this case, is ESI applicable on the bonus?
Please also send me the reply to amar188taksh@gmail.com.
Thanks with Regards,
Taksh
From India, Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[B]Response[/B]: Your questions reflect a good understanding of ESI deductions on bonuses. ESI is not applicable on bonuses, whether paid half-yearly or quarterly. Thank you for your engagement. (1 Acknowledge point)
0
0
Hi, Can any ome help me in having one standard leave application form to avail pl cl and sl.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Subject: Bonus Received Letter Format
Dear All,
Could you please provide a sample format for a bonus letter that effectively emphasizes recognizing the contributions made by employees and rewarding them accordingly?
Thank you,
Durga
From India, Rajamahendri
Acknowledge(0)Amend(0)
Dear All,
Could you please provide a sample format for a bonus letter that effectively emphasizes recognizing the contributions made by employees and rewarding them accordingly?
Thank you,
Durga
From India, Rajamahendri
Acknowledge(0)Amend(0)
Hi Payal,
In my opinion, the EPF is calculated at 12% of Basic, and that amount is then matched by the employer. For example, if the EPF amount is "X," the total deposited into the employee's account would be "X+X." Every organization with more than 20 employees must be registered for EPF.
Regarding ESI, employees with salaries between 6500 and 10,000 fall under ESI. The deductions are as follows:
- Employees' contribution: 1.75% of Basic
- Employers' contribution: 4.75% of Basic
For employees with a Basic salary exceeding 10,000, PF is optional.
Regards,
Ashi
From India, Indore
Acknowledge(0)Amend(0)
In my opinion, the EPF is calculated at 12% of Basic, and that amount is then matched by the employer. For example, if the EPF amount is "X," the total deposited into the employee's account would be "X+X." Every organization with more than 20 employees must be registered for EPF.
Regarding ESI, employees with salaries between 6500 and 10,000 fall under ESI. The deductions are as follows:
- Employees' contribution: 1.75% of Basic
- Employers' contribution: 4.75% of Basic
For employees with a Basic salary exceeding 10,000, PF is optional.
Regards,
Ashi
From India, Indore
Acknowledge(0)Amend(0)
Dear Payal,
Now this limit has been changed to Rs. 15,000. Any employee whose gross is under Rs. 15,000 will be liable for ESI deductions.
In the Excel sheet provided by GRHRM, please apply a condition that if Gross > Rs. 10,000, ESI contribution is zero. This will ensure that it directly shows a zero value for people with a salary greater than Rs. 10,000.
Truly Yours,
Kumar H.P
From India, Delhi
Acknowledge(0)Amend(0)
Now this limit has been changed to Rs. 15,000. Any employee whose gross is under Rs. 15,000 will be liable for ESI deductions.
In the Excel sheet provided by GRHRM, please apply a condition that if Gross > Rs. 10,000, ESI contribution is zero. This will ensure that it directly shows a zero value for people with a salary greater than Rs. 10,000.
Truly Yours,
Kumar H.P
From India, Delhi
Acknowledge(0)Amend(0)
The excel sheet is wrong in because employers contribution to PF is not 12% . Along with 12% you need to add 1.61 as admin charges. PF ceiling is 6500 not 10, 000. and ESIC ceiling is 15000.
From India, Calcutta
Acknowledge(0)Amend(0)
0
0
From India, Calcutta
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The information provided in the user reply is correct regarding the PF and ESI contribution details. No corrections needed. (1 Acknowledge point)
0
0
Please provide information as follows for one day as per central government rules in Madhya Pradesh for B & C zones:
- Basic: 231 for B zone & 186 for C zone
- EPF employee contribution
- EPF Employer contribution
- ESIC employee contribution
- ESIC employer contribution
- Workman compensation for Zone 'C' for each employee
- January days are 31
- February days are 28
From India, Mumbai
Acknowledge(0)Amend(0)
- Basic: 231 for B zone & 186 for C zone
- EPF employee contribution
- EPF Employer contribution
- ESIC employee contribution
- ESIC employer contribution
- Workman compensation for Zone 'C' for each employee
- January days are 31
- February days are 28
From India, Mumbai
Acknowledge(0)Amend(0)
hi am working at 9 month in one company, my PF deduction 1217, PF forms send to office, please need to answer how much credit in my account .
From India, Bengaluru
Acknowledge(0)Amend(0)
0
0
From India, Bengaluru
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The PF credit in your account should be Rs. 10,953 (1217*9). Confirm with your employer for accurate details. (1 Acknowledge point)
0
0
required formula of pf calculation for salary register if Basic 15000 , less than 15000 and above 15000 one formula for all these rules.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
New unified epf portal says to mention gross salary and epf wages. Edli and administrative charges to calculate on gross or epf wages please confirm for employers
From India, Koraput
Acknowledge(0)Amend(0)
From India, Koraput
Acknowledge(0)Amend(0)
How to calaculate Salary arrears w.e.f April 2017. If it includes the cutting of ESIC , PF and LOP. If yes pls send me the excel calculator for that...if found...
From India, Thrissur
Acknowledge(0)Amend(0)
From India, Thrissur
Acknowledge(0)Amend(0)
Dear All, Need Monthly Salary Calculator with PF & ESI only. in Exl
From India, Port Blair
Acknowledge(0)Amend(0)
From India, Port Blair
Acknowledge(0)Amend(0)
simple and good information. this helped me understanding various accounts in pf challan to be filled and their percentages. thanks & Regards
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear sir, can you please explain me how to calculate PMPRY Workings.
From India, Thrissur
Acknowledge(0)Amend(0)
From India, Thrissur
Acknowledge(0)Amend(0)
am getting a salary of Rs:18000/- per month. and am paying my PF every month from 2014 to 2018. after completion of 10 years, how much pension am eligible for. plz calculate and give the information
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
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)