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 1Employee & Employer PF Contribution12% & 3.67%
A/C 2PF Admin Charges0.5%
A/C 10Employer Pension Contribution8.33%
A/C 21EDLI 0.5%
A/C 22EDLI Admin ChargesNil

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.

4 thoughts on “EPF Challan Calculation Excel 2021”

  1. Sir if a person is not eligible for pension i.e if his epf wages is above 20000 then how to prepare the challan for him

    Reply
  2. Please correct the second table information, you have mentioned A/c 21 as PF admin charge again. That’s EDLI charges.

    Thanks & Regards,
    Manivannan R

    Reply

Leave a Comment