The best way is if you people are using payroll software kindly contact the concern person for updated on Electronic return cum challan facility in your systems. The file easily gets upload.
From India, Mumbai
From India, Mumbai
MY Dear Member,
Initialy I was also put hard efrrots to upload the file at least for 14 times.At the end I became successfull and upload the file.Dear Members i want to share some key points which may be useful to all those who are yet not get suceed to upload the ECR file
Draft a file in Exckel and it must have all 25 Filed as shown in sample file
After feeding all data for the Month of March 2012 In thsi file you can make use of Mothly wage data file which was created in E -Return tool.This will help your time and keep accuracy also.
Save this file in CSV type
Now please note type any letter say " D" in place of all blank fields
Now open this file in Open as----Note pad---
GO TO edit option
Copy "," by #~#
Replace all "D" by BLANK only
if Date format of new and left employee is not seperated with / then also replace that by"/"
Save this file in Txt format
In your case there are various errors.Please check the log of each one.
If you have some increments in this month and want to pay the arrears also then only use the field of arrears wages.Basic arrears wages you have only to feed in this files If gross increment is 800 pm and your basic is 50% them you have only to feed the amount Rs.400/-.But if your PF is cealed on Rs 6500/- and the basic of particular employee is more than that them your need not have to feed this field.
If you entered complete basic wage that is Rs 6500/- and also shown NCP days them please make it 0.
I hope this will help you
Important- Please note that SBI had instruction to accept only E-Seva challans and not from E-Return tool software becasue there is a transaction number on E -Sewa Challan which is now mandatory after 11.04.2012
Mangesh Wakodkar
Aurangabad
From India, Pune
Initialy I was also put hard efrrots to upload the file at least for 14 times.At the end I became successfull and upload the file.Dear Members i want to share some key points which may be useful to all those who are yet not get suceed to upload the ECR file
Draft a file in Exckel and it must have all 25 Filed as shown in sample file
After feeding all data for the Month of March 2012 In thsi file you can make use of Mothly wage data file which was created in E -Return tool.This will help your time and keep accuracy also.
Save this file in CSV type
Now please note type any letter say " D" in place of all blank fields
Now open this file in Open as----Note pad---
GO TO edit option
Copy "," by #~#
Replace all "D" by BLANK only
if Date format of new and left employee is not seperated with / then also replace that by"/"
Save this file in Txt format
In your case there are various errors.Please check the log of each one.
If you have some increments in this month and want to pay the arrears also then only use the field of arrears wages.Basic arrears wages you have only to feed in this files If gross increment is 800 pm and your basic is 50% them you have only to feed the amount Rs.400/-.But if your PF is cealed on Rs 6500/- and the basic of particular employee is more than that them your need not have to feed this field.
If you entered complete basic wage that is Rs 6500/- and also shown NCP days them please make it 0.
I hope this will help you
Important- Please note that SBI had instruction to accept only E-Seva challans and not from E-Return tool software becasue there is a transaction number on E -Sewa Challan which is now mandatory after 11.04.2012
Mangesh Wakodkar
Aurangabad
From India, Pune
Dear Sir Sub: E retun tools Sir, I want to know that when we wil stall the E retun tool software then it will be easier for us From : Manvendar Singh Bhandari
From India, Bangalore
From India, Bangalore
Dear Rakesh, Replace , ( Coma) with #~# & upload the text file to browse. it will help you you. if any query pl. call me on my cell .9372702137 Dipak Kad
From India, Pune
From India, Pune
Dear Mr. Rakesh,
My suggestion is that beter you download the e-return tool provided by EPFO and enter the data once for all you can import data form excel work sheet.
It works without any problem.
Since the software is provided by EPFO the file generated is error less and can be uploaded without any problem.
You have to import employee master that can also be import from excel file so convert your existing data in excel format and follow the instructions provided in help file.
If any problem pls let me know.
Regards.
Sunil Mehta
From India, Rajkot
My suggestion is that beter you download the e-return tool provided by EPFO and enter the data once for all you can import data form excel work sheet.
It works without any problem.
Since the software is provided by EPFO the file generated is error less and can be uploaded without any problem.
You have to import employee master that can also be import from excel file so convert your existing data in excel format and follow the instructions provided in help file.
If any problem pls let me know.
Regards.
Sunil Mehta
From India, Rajkot
Hi Rakesh, I agreee with Pavan kadam. You would E return 4.0. It’s very easy and very safe. Regards, Vijasinh Vaghela
From India, Vadodara
From India, Vadodara
Hello Dear ECR challan system is easy & better every details can be updated time to time it is the better way to EPF comply to enhance. Thank’s Dharamveer Kashyap 9818241956
From India, Delhi
From India, Delhi
Dear Friends Please help me out with this text file.....Attached with,..... Regards, Ramkishore
From India, Bangalore
From India, Bangalore
Dear Ram Kishore
you have generated ECR File now you have to register your organization at EPF Site after getting ID or Password you can upload this text file easly. thereafter you will obtain EPF challan in PDF File with TRRN.
Regards'
Dharamveer kashyap
9818241956
From India, Delhi
you have generated ECR File now you have to register your organization at EPF Site after getting ID or Password you can upload this text file easly. thereafter you will obtain EPF challan in PDF File with TRRN.
Regards'
Dharamveer kashyap
9818241956
From India, Delhi
Dear Kishore
first of fall save this text file and after that open your site select ECR upload option thereafter you will be asked for approval then click this option then you will get the three pdf file first contribution details Second pdf Challan third acknowledgment.
If you would mind then i may upload your ECR Challan i need you Code No. for uploaded text file.
Regards'
Dharamveer
9818241956
From India, Delhi
first of fall save this text file and after that open your site select ECR upload option thereafter you will be asked for approval then click this option then you will get the three pdf file first contribution details Second pdf Challan third acknowledgment.
If you would mind then i may upload your ECR Challan i need you Code No. for uploaded text file.
Regards'
Dharamveer
9818241956
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.