Hi Need PF calculation sheet as per new UAN rule (Ceiling Limit 15,000/- and Pension wage 1,000/-).
From India, Chennai
24From India, Chennai
pl.find as required by you.
EPF wages = Rs. 15000/-
Calculation details- ( Total Contribution = 24% )
Employee Contribution to EPF= 12%
Employer Contribution to EPF= 3.67% and rest 8.33% is contribution for Employee pension fund
Now Calculation for Monthly Challan.
A/C No.01 =Employee Provident Fund = (3.67% + 12%)
A/C No.02 = Admin Charge of Employee Provident Fund = 1.1%
A/C No.10 = Employee Pension Fund = 8.33%
A/C No.21 = EDLI Contribution = 0.5% of Pensionable Salary i.e 0.5% of Rs. 15000 ( from Sept-14 otherwise it was 6500)
A/C No.22 = Admin Charges of EDLI Contribution= 0.01% of Pensionable Salary i.e 0.01% of Rs. 15000 ( from Sept-14 otherwise it was 6500)
From India, Rudarpur
EPF wages = Rs. 15000/-
Calculation details- ( Total Contribution = 24% )
Employee Contribution to EPF= 12%
Employer Contribution to EPF= 3.67% and rest 8.33% is contribution for Employee pension fund
Now Calculation for Monthly Challan.
A/C No.01 =Employee Provident Fund = (3.67% + 12%)
A/C No.02 = Admin Charge of Employee Provident Fund = 1.1%
A/C No.10 = Employee Pension Fund = 8.33%
A/C No.21 = EDLI Contribution = 0.5% of Pensionable Salary i.e 0.5% of Rs. 15000 ( from Sept-14 otherwise it was 6500)
A/C No.22 = Admin Charges of EDLI Contribution= 0.01% of Pensionable Salary i.e 0.01% of Rs. 15000 ( from Sept-14 otherwise it was 6500)
From India, Rudarpur
Dear Ms.Sharma,
I shall insert an Excel sheet for calculation of EPS. Calculation will be done automatically if the salary w.e.f 01.09.2014 is Rs.15000 or above. If it is below 15000, arrive the pensionable salary by taking average of last drawn 60 months and enter to the corresponding column (D28).
Abbas.P.S
From India, Bangalore
I shall insert an Excel sheet for calculation of EPS. Calculation will be done automatically if the salary w.e.f 01.09.2014 is Rs.15000 or above. If it is below 15000, arrive the pensionable salary by taking average of last drawn 60 months and enter to the corresponding column (D28).
Abbas.P.S
From India, Bangalore
Dear Seniors, Kindly find attached salary sheet and pls check and confirm PF calculation is correct or not. If not correct pls provide corrections or guide me.
From India, Chennai
From India, Chennai
Dear Mr. Sharma, Very good work. Thanks for the clarifications and xl lsheet. Regards NK
From India, Chennai
From India, Chennai
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 and one more correction is 0.01% of administrative charges for EDLI scheme under A/c.No.22 have been totally waived. This is for your information.
N.LOKANADHA BABU
MANAGER
From India, Guntur
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 and one more correction is 0.01% of administrative charges for EDLI scheme under A/c.No.22 have been totally waived. This is for your information.
N.LOKANADHA BABU
MANAGER
From India, Guntur
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls