EPF Challan Calculation Excel 2020

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.

But if you want to know how the details are calculated then download the below EPF challan calculation excel sheet 2020, which will simplify your PF challan calculation process.

EPF Challan Calculation 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 2020 Account Wise

A/C 1Employee & Employer PF Contribution12% & 3.67%
A/C 2Employer PensionContribution8.33%
A/C 10PF Admin Charges0.5%
A/C 21PF Admin Charges0.5%
A/C 22EDLI Admin ChargesNil

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 charges

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 charges.

How much EDLI admin charges in 2020

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.

Leave a Comment