EPF Challan Calculation Excel 2021


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.

pf challan calculation in excel 2020

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 21 EDLI 0.5%
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.


Jaspreet Singh Ghuman

Jaspreet Singh Ghuman


Passionate Professional Blogger, Freelancer, WordPress Enthusiast, Digital Marketer, Web Developer, Server Operator, Networking Expert. Empowering online presence with diverse skills.

jassweb logo

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet, and extranet products.


Jassweb, Rai Chak, Punjab, India. 143518
Item added to cart.
0 items - 0.00