EPF ECR file also known as the PF calculation sheet which 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 2019.
↓ Download ECR File Format in Excel Format
Fields present in EPF ECR File Format
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 if 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 gross wages of employees also.
Also Read
Download PF and ESI calculation in Excel format
Please provide ECR file format in excel
Dear sir,
Please provied ecr file format in excel
Regards
Shekhar
Very helpful