Pf Calculatoin Sheet - Xls Download

Hi
Need PF calculation sheet as per new UAN rule (Ceiling Limit 15,000/- and Pension wage 1,000/-).

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)

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

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.

Dear Mr. Sharma,
Very good work. Thanks for the clarifications and xl lsheet.
Regards
NK

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