How to use ECR EXCEL Skeleton file to create ECR file

  1. Download ECR Excel skeleton file
  2. Open it and Enter the Details
  3. Save the file as CSV (coma separated values) file using 'SAVE AS' option.
  4. Rename the file to change the file extension from '.csv' to '.txt' (If you can not see the file extension like '.csv', '.txt' etc., Click ControlPanel->Folder Options->View->UnTick 'Hide extensions for Known file types -> OK )
  5. Open the renamed text file in NOTEPAD and by using the 'EDIT' option, replace all coma (,) with #~#
  6. You should remove the Heading line and consequent Blank line from the text file.
  7. The file contents will look like:
    12#~#SANJAY#~#7000#~#6500#~#840#~#840#~#541#~#541#~#299#~#299#~#0#~#0#~#10000#~#1500#~#1000#~#500#~##~##~##~##~##~##~#20/03/2012#~#20/03/2012#~#S
    13#~#BIRENDRA#~#6000#~#6000#~#720#~#720#~#500#~#500#~#220#~#220#~#8#~#0#~#0#~#0#~#0#~#0#~##~##~##~##~##~##~##~##~#
    16#~#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#~##~##~#
  8. Save the file and Upload this ECR file at E-SEWA website to get challan
    Known Problems Error Codes
  1. Challan printed/prepared by any method other than the E-SEWA site (http://esewa.epfoservices.in/) will not be accepted at the bank, as other source challan will not have TRRN number in the challan. When SBI enters the TRRN number at their computer system, all the details you entered at E-Sewa site will come automatically in their computer.
  2. Use Internet Explorer 7 or above (or use Chrome,Firefox etc). Otherwise Options/Menu will not displayed when you click on ECR at E-Sewa site
  3. While entering the Password, enter carefully the Upper case and lower case letters
  4. Write down the User name and mobile number and keep it safely. In case you forgot the password, UserId and mobile number are required to be entered by You at E-Sewa site to generate a letter which should be submitted at EPFO for Password reset. The same username can not be used again.
  5. You can not Enter the Challan for current month at the E-SEWA site - First you have to upload ECR
  6. Challan for prior to 2012-2013 can be ENTERED and Printed at E-Sewa site
  7. Those establishment covered by EPFO but having no EPF contributing employees, need not upload the ECR. They have to Enter the Admn. Charges in the Challan Entry facility at E-Sewa and Print the challan to remit the amount.
  8. Each line in the ECR file should contain 24 numbers of #~# so as to have 25 fields (else 001 Error).
  9. First character in the Name should be an alphabet, else error 004 will occur
  10. There should not be Coma (,) in the Name. This may lead to Error 001 as the number fields will become more than 25.
  11. If a new employee joins in that particular month, then only you need to enter Father Name, Gender, Dt of Birth, Dt. of Join etc. Else leave those columns blank. If the month in Dt. of Join differs that of ECR month, you can not upload the ECR
  12. If an employee leaves the EPF in that particular month, then only you need to enter Dt. of Exit, Reason of Exit etc. Else leave those columns blank. If the month in Dt. of Exit differs that of ECR month, you can not upload the ECR

  13. 24-04-2012
  14. SBI says they are not getting Entry Provision for VDR for 2011, Earlier it was possible. Ans:EPFO has not changed anything. It is the problem of SBI/ their software development. They have to sort out with their head office.
  15. Employer says, Exit date is not available instantly. Hence not able to enter it in proper month. Ans: Submit Form-10 separately as previously.
  16. Manual/old type challan used by many estts. to remit the dues of Mar 2012 without uploading ECR. Eventhough ECR uploaded, it will become invalid after 15 days. Then how to file the Returns? Ans: to be decided at HQ
  17. For EPFO, what is the userid and Password to remit amounts? Ans: No provision. In the application s/w, generate VDR which will have VDR ref no and remit. SBI will enter as VDR.