Friday, 13 April 2012

Generating ECR using Excel and Notepad

To generated ECR with Excel and Notepad there is a very good screencast made available on EPFO India website, which neatly explains how to generated ECR file for upload to E-sewa. Please go through with it.

A few things to keep in mind while preparing ECR text files are:
  • The text file should strictly have 25 Fields.
  • This is a delimited file not a fixed width file, which means all the fields(columns) are separated by some delimiter which in this case is #~# and you don't need to fill spaces or zeros.
  • The text file should not have header row, only data is required in text file.
  • Only if the member  has joined in current month (of which you are generating ECR file), fill details of Form-5 (Father's/Husband name,Date of Birth, Gender, Date of joining)  else leave it blank. The Relationship should be any one of following character ( F / S) [Father / Spouse].
  • Only if the member has left the service in current month (of which you are generating ECR file), fill details of Form-10 (Date of leaving, Reason of leaving) else leave blank. The reason should be any one of following character ( C / S / R / D / P ).
  • Date should be of format dd/mm/yyyy strictly.
  • Check if member is leaving withing same month of joining then the date of leaving should be greater than or equal to date of joining.
  • Column 1 (Employee No) is numeric only and should not contain Establishment code i.e. for member with code GJ/AHD/12345/123 Emp no will be 123.
  • Column 4 (EPS Wages) will be maximum 6500, if member is not member of Pension Scheme or has crossed 58 Yrs EPS Wages should be 0 (Zero).
  • Decimals are not used.
  • Special characters (*-/!@#$%^&*()_-) should not be used (period is allowed in name only).
Feel free to ask.

Wednesday, 11 April 2012

Using E-sewa (screenshots and process flow)

To use E-sewa please read the following documents thoroughly:
The above are official documents available on

Broadly to use E-sewa you first need to register at Employer portal (E-sewa) then download latest E-return Tool and feed monthly contribution details and generated ECR text file from the tool and finally upload the text file at E-sewa website and generate online Challan with TRRN Number and submit the same to SBI.

Monday, 9 April 2012

Generating Challans (EPFO Esewa)

Go through the following steps to generate challans.

  • Register your establishment with Employer Esewa.
  • Download E-return Tool ver 4.0.
  • Feed in contribution details of the month of which you are going to generate return/challan.
  • Generate ECR (Electronic Challan cum Return) text file from e-return tool.
  • Log into the E-sewa Employer Portal.
  • Upload the ECR text file under "ECR Upload" page and approve the same.
  • Generate challan and remit to SBI Branch. You may check which SBI Branch will accept your Challan through EPFO India website.

Wednesday, 4 April 2012

EPFO E-return tool version 4.0 released

The awaited e-return tool version 4.0 has been released on EPFO India website on 04-04-2012.
Please download the same from here.
The addition is generation of ECR (electronic challan cum return) and backup/restore data along with other improvements.