EPF ECR file also known as the PF calculation sheet is used to create EPF contributions text file and it is further used to create monthly EPF challans. Here you can find the EPF ECR calculation sheet with formulas for the year 2023.
↓ Download ECR File Format in Excel Format
Fields present in EPF ECR File Format
| S No |
Field Name |
Details |
| 1 |
UAN |
Here we have to put the UAN number of the employee |
| 2 |
Member Name |
Here we have to write the member name |
| 3 |
Gross Wages |
This is also new in the ECR file, here we have to add the gross wages of employees |
| 4 |
EPF Wages |
Basic wage of employee has to be entered |
| 5 |
EPS Wages |
Basic wage of employee has to be entered |
| 6 |
EDLI Wages |
Basic wage of employee has to be entered |
| 7 |
EPF Contribution Remitted |
12% of employee contribution |
| 8 |
EPS Contribution Remitted |
8.33% of employer contribution |
| 9 |
EPF EPS Difference Remitted |
Generally it 3.67% of employer contribution towards PF, when the basic wage of an employee is greater than 15000 then it will automatically calculate the PF contribution of employer |
| 10 |
NCP Days |
Noncontribution period days of employee i.e absenteeism days. |
| 11 |
Refund Of Advances |
If is there any advance taken by the employee from the PF account, then he can repay that amount here. |
The latest ECR text file contains 11 fields, you can find the below to the table to know what details you need to enter in each field of ECR version 2.0 Excel.
The major differences in Old ECR format and the new UAN-based format are Universal Account Number, in the ECR text file 2 version UAN is mandatory in the old format we don’t need to add a UAN number. Another main difference is the gross wages entry, in the old ECR format there is no need to add gross wages but in the new ECR file, we employer has to show the gross wages of employees also.
Recommended:
Download PF and ESI calculations in Excel format
please send formate epf challan formate
Kindly share a video how to prepare ECR file and upload the same on site
EPF Wages wrongly entered at the time employee registration in epfo portal please sir provide any suggestion for re correction of wages
Hi Dear Team,
Please share the pf & esi template in excel.
Thanks
sir,
Our salary structure is as following
Basic + VDA = 35000
HRA & conv= 10000
gross 45000
Epf collected for 35000
eps for 15000
So what amount i should fill in the coloum of gross wages in the excel format
15000 only
Dear sir,
Please provied ecr file format in excel
Regards
Pradeep lakhara
Sir,pl share excel format for arrears
IF A EMPLOYEE GIVE RESIGNATION THEN , WHAT WE HAVE TO DO IN ECR FILING
please guide us
deposit pf for working days only. rest days as absenteism and mark left in EPF
u dont have to remove name from ecr file
Dear sir,
We need your help ,Please provide ECR file format in excel
Thanks & Regards
Rajesh Upadhyay
Dear Sir,
Kindly send EPF ECR Arrear File format in excel.
Regards,
Prasath
Please provide ECR file format in excel
Dear sir,
Please provied ecr file format in excel
Regards
Shekhar
Dear sir,
Please provied ecr file format in excel
Regards
Pradeep lakhara
Very helpful