{"id":6996,"date":"2012-08-17T04:31:26","date_gmt":"2012-08-17T04:31:26","guid":{"rendered":"http:\/\/www.yourhrworld.com\/formats\/?p=6996"},"modified":"2012-08-17T10:56:28","modified_gmt":"2012-08-17T10:56:28","slug":"new-pf-ecr-file-format-in-excel-sheet","status":"publish","type":"post","link":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/","title":{"rendered":"Electronic Challan cum Return Format (FOR EMPLOYERS)"},"content":{"rendered":"<p><strong>I have attached new PF ECR File Format in Excel Sheet and in PDF format.<br \/>\n<\/strong><\/p><div class=\"69eb924294c115e6505da44099e8df92\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"pub-0867779017855679\";\r\n\/* 300x250, created 4\/20\/11 *\/\r\ngoogle_ad_slot = \"1035864135\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n\n<p>&nbsp;<\/p>\n<h2>ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT<br \/>\n(FOR EMPLOYERS)<\/h2>\n<p>&nbsp;<\/p>\n<p><strong>The Electronic Challan cum Return (ECR) will be an electronic return in plain text format and will consist of DETAILED lines (one line for each member). The separator between fields should be #~# ( hash tilda hash).<\/strong><br \/>\nSl. No\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 Column Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column Width \u00a0 \u00a0 \u00a0 Whether\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Remarks<\/p>\n<p>mandatory<\/p>\n<p>1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Member ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (7)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Yes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Only account number(maximum<\/p>\n<p>7 digits)Value should be &gt;0<br \/>\n<strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Two lines with same member id will<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 not be accepted in a single ECR text <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 file<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Member Name\u00a0\u00a0\u00a0\u00a0\u00a0 Character (85)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Yes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No special characters other than \u2018.\u2019<\/p>\n<p>are allowed<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EPF Wages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals<\/p>\n<p>&nbsp;<\/p>\n<p>4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EPS Wages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character<\/p>\n<p>And not in decimals<\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Wages on which Pension contribution <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 is due. In case of the member over 58 <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 years age, the wages should be \u20180\u2019 <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 even in case there are PF wages. <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Also\u00a0 in case of employer contributing\u00a0 <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 over the wage ceiling, the pension <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 wages should be maximum 6500\/- if <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pension contribution is restricted to Rs <\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 541\/-.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EPF Contribution\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>(EE Share) due\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 not in decimals, should be equal to or<\/p>\n<p>more than EPF Contribution (EE Share)<\/p>\n<p>being remitted.Employee share deducted<\/p>\n<p>and due for remittance<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>6.\u00a0\u00a0\u00a0\u00a0\u00a0 EPF Contribution\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Numbers only, no special character, not in<\/p>\n<p>(EE Share)being\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 decimals:<br \/>\nEmployee share being remitted through<\/p>\n<p>this ECR<\/p>\n<p>&nbsp;<\/p>\n<p>7. EPS Contribution due\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals, should be equal to or<\/p>\n<p>more than EPS Contribution being remitted<\/p>\n<p>8.EPS Contribution being\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0 Numbers only, no special character, not in<\/p>\n<p>remitted\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 decimals<\/p>\n<p>9.Diff EPF and EPS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0 Numbers only, no special character and not<\/p>\n<p>Contribution (ER Share)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 in decimals, should be equal to or more due<\/p>\n<p>than Diff EPF and EPS Contribution (ER<\/p>\n<p>Share) being remitted<br \/>\n10.Diff EPF and EPS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character, not in<\/p>\n<p>Contribution (ER Share)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 decimals,<\/p>\n<p>being remitted<\/p>\n<p>&nbsp;<\/p>\n<p>11. NCP Days\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (2)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character, not in<\/p>\n<p>decimals.Number of days in the month for<\/p>\n<p>which wages are not due.<\/p>\n<p>&nbsp;<\/p>\n<p>12.Refund of Advances\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals<\/p>\n<p>13.Arrear EPF Wages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals<\/p>\n<p>14.Arrear EPF EE Share\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals<\/p>\n<p>15.Arrear EPF ER Share\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals<\/p>\n<p>16. Arrear EPS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0 Numbers only, no special character and<\/p>\n<p>not in decimals<\/p>\n<h2 style=\"text-align: center;\"><strong>ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT<\/strong><br \/>\n<strong>(FOR EMPLOYERS)<\/strong><\/h2>\n<p>Share<br \/>\n17.Father\u2019s\/Husband\u2019s \u00a0 \u00a0 \u00a0 Character (85) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0No \u00a0 \u00a0 \u00a0No special characters are allowed. Please<\/p>\n<p>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 provide only if the member has joined in<\/p>\n<p>the wage month. (for new member only)<br \/>\n18.Relationship with the\u00a0\u00a0\u00a0 Character (1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0 Relationship of the member with column<\/p>\n<p>Member\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17 above. Value should be F(for father) or<\/p>\n<p>S (for Husband). Please provide only if the<\/p>\n<p>member has joined in the wage month.<\/p>\n<p>(for new member only)<\/p>\n<p>19. Date of Birth\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Date (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Valid date in dd\/mm\/yyyy format. Please<\/p>\n<p>provide only if the member has joined in<\/p>\n<p>the wage month. (for new member only)<\/p>\n<p>20.\u00a0 Gender\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Character (1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 M(Male) , F(Female) or T (Transgender).<\/p>\n<p>Please provide only if the member has<\/p>\n<p>joined in the wage month. (for new<\/p>\n<p>member only)<\/p>\n<p>21.Date of Joining EPF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Date (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Valid date in dd\/mm\/yyyy format, not later<\/p>\n<p>than the month of ECR. Please provide<\/p>\n<p>only if the member has joined in the wage<\/p>\n<p>month. (for new member only)<\/p>\n<p>22.Date of Joining EPS\u00a0\u00a0\u00a0\u00a0\u00a0 Date (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Valid date in dd\/mm\/yyyy format, not later<\/p>\n<p>than the month of ECR. Please provide only<\/p>\n<p>if the member has joined in the wage<\/p>\n<p>month. (for new member only)<\/p>\n<p>23.Date of Exit from EPF\u00a0 Date (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0 Valid date in dd\/mm\/yyyy format, cannot be<\/p>\n<p>prior to date of joining. Please provide only<\/p>\n<p>if the member has left in the wage month.<\/p>\n<p>(for exiting member only)<\/p>\n<p>24.Date of Exit from EPS\u00a0 Date (10)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0\u00a0 Valid date in dd\/mm\/yyyy format, cannot be<\/p>\n<p>prior to date of joining. Please provide only<\/p>\n<p>if the member has left in the wage month.<\/p>\n<p>(for exiting member only)<br \/>\n25.Reason for leaving\u00a0\u00a0\u00a0 Character (1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 No\u00a0\u00a0\u00a0\u00a0 C (Cessation) , S (Superannuation) , R (<\/p>\n<p>Retirement), D (Death in Service), or P<\/p>\n<p>(Permanent Disablement).Please provide<\/p>\n<p>only if the member has left in the wage<\/p>\n<p>month. (for exiting member only).<\/p>\n<p>Mandatory, if \u201cDate of Exit from EPF\u201d is not<\/p>\n<p>blank.<br \/>\n<strong>Sample ECR text file with three members for the month of March 2012 paid in April 2012 for establishment id DLCPM0001234000 is as follows for reference:<\/strong><br \/>\n12#~#SANJAY#~#7000#~#6500#~#840#~#840#~#541#~#541#~#299#~#299#~#0#~#0#~#10000#~#1500#~#1000#~#500#~##~##~##~##~##~##~#20\/03\/2012#~#20\/03\/2012#~#S<br \/>\n13#~#BIRENDRA#~#6000#~#6000#~#720#~#720#~#500#~#500#~#220#~#220#~#8#~#0#~#0#~#0#~#0#~#0#~##~##~##~##~##~##~##~##~#<br \/>\n16#~#SHEELA#~#5000#~#5000#~#600#~#600#~#417#~#417#~#183#~#183#~#4#~#0#~#0#~#0#~#0#~#0#~#VINEET#~#F#~#05\/03\/1990#~#F#~#05\/03\/2012#~#05\/03\/2012#~##~##~#<br \/>\n<strong>How to Generate ECR Text file:<\/strong><br \/>\n<strong>Step 1:<\/strong> Use any Spreadsheet (OpenOffice, Excel, Lotus etc,) for creating the member details as per the prescribed format and save the file in CSV format.<br \/>\n<strong>Step 2:<\/strong> Open the CSV file in any text editor (notepad, editplus, etc.,) and replace all \u201c,\u201d with \u201c#~#\u201d . Save the file.<\/p>\n<p><strong><a href=\"https:\/\/www.yourhrworld.com\/formats\/wp-content\/uploads\/2012\/08\/New-PF-ECR-File-Format-in-Excel-Sheet.pdf\">Click Here To Download New PF ECR File Format in Excel Sheet<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a href=\"https:\/\/www.yourhrworld.com\/formats\/wp-content\/uploads\/2012\/08\/ECR-Format.xls\">Click Here To Download ECR Format<\/a><\/strong><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>I have attached new PF ECR File Format in Excel Sheet and in PDF format. &nbsp; ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT (FOR EMPLOYERS) &nbsp; The Electronic Challan cum Return (ECR) will be an electronic return in plain text format and will consist of DETAILED lines (one line for each member). The separator between fields should be #~# ( hash tilda hash). Sl. No\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 Column Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column Width \u00a0 \u00a0 \u00a0 Whether\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Remarks mandatory 1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Member ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (7)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Yes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Only account number(maximum 7 digits)Value should be &gt;0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Two lines with same member id will \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 not<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[1460,47,1461,1459],"class_list":["post-6996","post","type-post","status-publish","format-standard","hentry","category-hr","tag-ecr-file","tag-format","tag-in-excel-sheet","tag-new-pf"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Electronic Challan cum Return Format (FOR EMPLOYERS) - HR Letter Formats<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Electronic Challan cum Return Format (FOR EMPLOYERS) - HR Letter Formats\" \/>\n<meta property=\"og:description\" content=\"I have attached new PF ECR File Format in Excel Sheet and in PDF format. &nbsp; ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT (FOR EMPLOYERS) &nbsp; The Electronic Challan cum Return (ECR) will be an electronic return in plain text format and will consist of DETAILED lines (one line for each member). The separator between fields should be #~# ( hash tilda hash). Sl. No\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 Column Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column Width \u00a0 \u00a0 \u00a0 Whether\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Remarks mandatory 1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Member ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (7)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Yes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Only account number(maximum 7 digits)Value should be &gt;0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Two lines with same member id will \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 not\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"HR Letter Formats\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-17T04:31:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-08-17T10:56:28+00:00\" \/>\n<meta name=\"author\" content=\"Hrformats\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hrformats\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/\"},\"author\":{\"name\":\"Hrformats\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\"},\"headline\":\"Electronic Challan cum Return Format (FOR EMPLOYERS)\",\"datePublished\":\"2012-08-17T04:31:26+00:00\",\"dateModified\":\"2012-08-17T10:56:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/\"},\"wordCount\":874,\"commentCount\":1,\"keywords\":[\"ECR File\",\"Format\",\"in Excel Sheet\",\"New PF\"],\"articleSection\":[\"HR\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/\",\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/\",\"name\":\"Electronic Challan cum Return Format (FOR EMPLOYERS) - HR Letter Formats\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#website\"},\"datePublished\":\"2012-08-17T04:31:26+00:00\",\"dateModified\":\"2012-08-17T10:56:28+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/hr\\\/new-pf-ecr-file-format-in-excel-sheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Electronic Challan cum Return Format (FOR EMPLOYERS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#website\",\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/\",\"name\":\"HR Letter Formats\",\"description\":\"Free Human Resource Forms, Formats &amp; Questionnaires\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/#\\\/schema\\\/person\\\/12e40c15a77b1929a013a8c83de187ee\",\"name\":\"Hrformats\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g\",\"caption\":\"Hrformats\"},\"url\":\"https:\\\/\\\/www.yourhrworld.com\\\/formats\\\/author\\\/hrformats\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Electronic Challan cum Return Format (FOR EMPLOYERS) - HR Letter Formats","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/","og_locale":"en_US","og_type":"article","og_title":"Electronic Challan cum Return Format (FOR EMPLOYERS) - HR Letter Formats","og_description":"I have attached new PF ECR File Format in Excel Sheet and in PDF format. &nbsp; ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT (FOR EMPLOYERS) &nbsp; The Electronic Challan cum Return (ECR) will be an electronic return in plain text format and will consist of DETAILED lines (one line for each member). The separator between fields should be #~# ( hash tilda hash). Sl. No\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 Column Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column Width \u00a0 \u00a0 \u00a0 Whether\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Remarks mandatory 1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Member ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Number (7)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Yes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Only account number(maximum 7 digits)Value should be &gt;0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Two lines with same member id will \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 not","og_url":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/","og_site_name":"HR Letter Formats","article_published_time":"2012-08-17T04:31:26+00:00","article_modified_time":"2012-08-17T10:56:28+00:00","author":"Hrformats","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hrformats","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/#article","isPartOf":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/"},"author":{"name":"Hrformats","@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee"},"headline":"Electronic Challan cum Return Format (FOR EMPLOYERS)","datePublished":"2012-08-17T04:31:26+00:00","dateModified":"2012-08-17T10:56:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/"},"wordCount":874,"commentCount":1,"keywords":["ECR File","Format","in Excel Sheet","New PF"],"articleSection":["HR"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/","url":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/","name":"Electronic Challan cum Return Format (FOR EMPLOYERS) - HR Letter Formats","isPartOf":{"@id":"https:\/\/www.yourhrworld.com\/formats\/#website"},"datePublished":"2012-08-17T04:31:26+00:00","dateModified":"2012-08-17T10:56:28+00:00","author":{"@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee"},"breadcrumb":{"@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.yourhrworld.com\/formats\/hr\/new-pf-ecr-file-format-in-excel-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yourhrworld.com\/formats\/"},{"@type":"ListItem","position":2,"name":"Electronic Challan cum Return Format (FOR EMPLOYERS)"}]},{"@type":"WebSite","@id":"https:\/\/www.yourhrworld.com\/formats\/#website","url":"https:\/\/www.yourhrworld.com\/formats\/","name":"HR Letter Formats","description":"Free Human Resource Forms, Formats &amp; Questionnaires","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yourhrworld.com\/formats\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.yourhrworld.com\/formats\/#\/schema\/person\/12e40c15a77b1929a013a8c83de187ee","name":"Hrformats","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2ee0a9b5831e6c2a1d7162d4eb62c22eb1c468a34c4fdcac6e7b5df7fcde2302?s=96&d=mm&r=g","caption":"Hrformats"},"url":"https:\/\/www.yourhrworld.com\/formats\/author\/hrformats\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts\/6996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/comments?post=6996"}],"version-history":[{"count":0,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/posts\/6996\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/media?parent=6996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/categories?post=6996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yourhrworld.com\/formats\/wp-json\/wp\/v2\/tags?post=6996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}