Learn about the differences in these courses: Excel 2010 and Excel 2007. While this is the same process, some things are different in the 20 version than the 2013 version.
From the File type drop down box select CSV (comma delimited) and then hit Save. The new format is based on UAN(Universal Account Number).In this blog I have demonstrate the preparation of new uan based ecr format in excel sheet and then how to make text file of. December 2016 paid in January 2017)onward. UAN based ECR format in excel EPFO has changed the format of ECR file using UAN for filing return from January 2017(i.e. Excel Import Data: Text File, CSV File, Access, Excel File. Create Text file in new EPF format for ECR uploading. How to prepare Text file for UAN based NEW ECR format. In ECR version 2 all arrear related fields are part of new arrear file and employee’s informative fields are captured at the time of UAN generation. In ECR version 2 member id, EE share due, EPS contribution due, ER share due, all of the arrear field and employee informative fields will be omitted while UAN number, Gross Wages will be added. For a new employee, the company has to generate UAN number before filing ECR online. Electronic Challan Cum Return (ECR) (version 2.0) Electronic Challan cum Return (ECR) Version 2 will be completely UAN base format so only UAN allowed employees contribution can be uploaded through new ECR filing. The new portal will combine existing ECR filling portal, existing claim status portal and challan payment portal. New ECR file format will be of just 11 fields and called Electronic Challan Cum Return (ECR) (version 2.0).ĮCR portal will replace existing fragmented and multiple portals for filing and payment process with unified one place ECR filing and payment process. To reduce the complexity of existing portal and simplify overwhelmed 25 field Electronic Challan cum Return (ECR) file EPFO is planning to revise existing ECR file format and ECR filing portal.Ecr File Format In Excel Sheet Download.
0 kommentar(er)
