EPF Challan Calculation Excel 2021
Every employer has to make EPF payments on or before the 15th of every month for the previous month’s wages. For that, they need to generate a challan in the EPF employer portal.
There is no need to calculate the amount on challan separately, after uploading the ECR statement the challan details will be calculated automatically.
EPF Challan Calculation Excel Sheet Format 2021
Download the below EPF challan calculation excel sheet 2021, which will simplify your PF challan calculation process.
What is EPF Challan
EPF challan is required to make the PF contributions payments of the employee and employer. Every challan consists a unique TRRN number, which will help you to track the challan details.
EPF challan consists of total wages of employees and account numbers like A/C 1. A/C 2, A/C 10, A/C 21, and A/C 22.
PF Contribution Rate 2021 Account Wise
|A/C 1||Employee & Employer PF Contribution||12% & 3.67%|
|A/C 2||PF Admin Charges||0.5%|
|A/C 10||Employer Pension Contribution||8.33%|
|A/C 22||EDLI Admin Charges||Nil|
Calculate PF Admin Charges Online
How EPF Challan Looks
The actual EPF challan generated automatically by EPFO system will look like this.
FAQs about PF Challan
How to download PF Challan for previous years
To download PF challan login in employer PF portal → Go to payments → ECR Return Filing → Search Challan → Select Wage Month & Challan Type → Click on Search
( You can download all types of PF challans here, payment confirmed, payment failed, payment awaiting challans, rejected challans, and draft challans also.).
What is PF admin charges
PF admin charges are paid by the employer. Every employer will pay 0.5% of employees’ basic wage + DA as PF admin charges.
What is EDLI contribution
Every EPF member who is contributing to PF will become a member of EDLI. It means the Employee Deposit Linked Insurance Scheme. Employers will pay 0.5% of employee basic wage + DA as EDLI contribution.
How much EDLI admin charges in 2021
EDLI admin charges are waived off by the employer W.E.F 1 April 2017, now there is no need to pay EDLI admin charges, it is Nill.