Few Days back we have registered ourselves to EPFO e-sewa and prepare challan after reading instruction one by one .Its takes three and Half hour to prepare one challan for just 7- 8 person .We have to read all the instruction and do every thing by Hit & trail method .Next day we have searched free software for challan preparation for ECR (EPF challan cum return) but not found any thing concrete. But few Days Back Mr Datha3 shared a free software to prepare EPFO esewa challan Text file through use of Microsoft excel Macro's .We have tried it and its working fine.
- Go through the "ReadMe1st" sheet
- Do not leave blank cells between Cells "A" to "J". 2. Do not use special characters in the Member & Father/Husband's Names field.
- Fill details of Date of Joining and Date of Leaving of those members who have joined and left during the month for which data is being entered.
- For exempted establishments, col. "E", "F", "I" and "J" are to be filled with 0.
- EPS wages in Col."D" is to be changed to 0 for those who have attained the age of more than 58 yrs.
- Voluntary Contribution, if any, may be added to Col."E" and "F".
- Further you have to enable Macro before using this software in Microsoft excel.
Update :New Version 1.21 (date 03/06/2012)
In case MS Excel 2007,Following Message will be shown
"Excel found unreadable content in "ecr file template version 1.21 xslmDo you want to remove the content of this workbook?if you trust the source of this workbook,click yes."please press Yes.
Some more options have been included for exempted establishments and updated the Help file.
Help file Download from here
Dathathri M., SS, SRO, Mysore Road, Bangalore-560098
Contact info: Mobile: +919480797570
Update :04/05/2012 File has been updated due to error pointed out by Sh Prasad Gupta VVN ,BILT Graphic Paper Products Limited ,Unit: Kamalapuram regarding arrears wages, EPF and EPS is not catching in text file .The same has been corrected now .Download updated version now.
2 .Prepare a ECR file in txt through excel complete trick can be downloaded from here.
Download challan software as given above and prepare challan cum return file in Text format.
Download Procedure (instructions)
3. Upload the ECR file generated at 2 above at EPFO employer sewa and download challan (process is given below )
4. Deposit challan in authorised Branch of SBI.
Read FAQ about E SEWA