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. 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. 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. If is there any advance taken by the employee from the PF account, then he can repay that amount here.

Noncontribution period days of employee i.e absenteeism days. 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 TDS Details In Excel Format On : 18 January 2023 Download. Excel sheet upload will lead to successful transaction only when all the Employees (who are currently. new ecr 2. Downloaded: 715 times File size: 145 KB Rating: Download Other files in Others category. 20, Instructions to fill in the excel file. This is also new in the ECR file, here we have to add the gross wages of employees epf sep 17 xls Submitted By: RAJESH SOMIDI. Step 1: Use any Spreadsheet (OpenOffice, Excel, Lotus etc,) for creating the member details as per the prescribed format and save the file in CSV format. The ECR format has been revised and it will be UAN based without the erstwhile member ID. ECR Validation Tool And New Revised EPF Process Ex. Here we have to put the UAN number of the employee Follow the included instructions carefully and create your ECR Returns with bare minimum Excel knowledge.To download click on the Download Now Link.

Epf ecr file format in excel download