Struggling with PF Challan Calculations: Can Anyone Guide Me on A/C Codes?

Hello,

Can anyone help me with how to work on A/C 1, A/C 10, A/C 2, A/C 21, and A/C 22 in the PF Challan sheet? How are they calculated or created? I would really appreciate it if anyone could help me with a formulated sheet for the same.

Regards,
Shalini

Dear Sschristian,

As per your post requirement, I have attached the Excel sheet. Hope it will help you!

Regards,

RAHUL JAT.

Please find the calculation below for the basic salary, which is Rs. 20,000/-:

Employees' Contribution A/c. No. 1: 12.00% = 2400
Employers' Contribution A/c. No. 1: 3.67% = 1150
Employers' Contribution A/c. No. 10: 8.33% = 1250
Admin. Charges A/c. No. 2: 0.85% = 170
Admin. Charges A/c. No. 21: 0.50% = 100
Admin Charges A/c. No. 22: 0.01% = 2

TOTAL: 25.36% = 5072

If the basic salary is less than 15000/-, for example, 14000/-:

Employees' Contribution A/c. No. 1: 12.00% = 1680
Employers' Contribution A/c. No. 1: 3.67% = 514
Employers' Contribution A/c. No. 10: 8.33% = 1166
Admin. Charges A/c. No. 2: 0.85% = 119
Admin Charges A/c. No. 21: 0.50% = 70
Admin Charges A/c. No. 22: 0.01% = 1

TOTAL: 25.36% = 3550

Thank you.