EPF Calculation In Excel Sheet

I prepared one Excel sheet in Excel to calculate Gratuity. Kindly let me know if any corrections are needed.

Dear Gautam,There is a correction in your reply. Account No. 2 Administrative charges are not 1.1%. It is 0.65% w.e.f. 01/04/2017\. Additionally, 0.01% of administrative charges for the EDLI scheme under A/c. No. 22 have been totally waived. This is for your inf...

Dear Seniors,Kindly find attached the salary sheet. Please check and confirm if the PF calculation is correct. If it is not correct, please provide corrections or guide me.Thank you.

Dear Mr. Sharma,Very good work. Thanks for the clarifications and Excel sheet.Regards,NK

Please find the required details as per your request.EPF wages = Rs. 15,000/-Calculation details - (Total Contribution = 24%)- Employee Contribution to EPF = 12%- Employer Contribution to EPF = 3.67%, and the remaining 8.33% is contributed to the Employee Pensio...

Dear Ms. Sharma,I shall insert an Excel sheet for the calculation of EPS. The calculation will be done automatically if the salary effective from 01.09.2014 is Rs. 15,000 or above. If it is below Rs. 15,000, determine the pensionable salary by averaging the last...

Hello Aniket Agrawal,The calculation of EPF (Employee Provident Fund) and ESI (Employee State Insurance) in Maharashtra follows the same general principles as in the rest of India. Let's break down each.1\. EPF Calculation: EPF is calculated as 12% of the basic ...