Q&A
Home Top New Follow Journal Login
Hi,
while uploading file follwoing error is comining.
ECR File upload- Validation Error Log
Sr.No ECR File Upload Date Time Uploaded ECR File Error Log File List of Error Codes
1 2012-04-14 14:40:21 _1334394574.txt
1334394574_err.txt
2 2012-04-14 14:26:04 1334393717.txt
_1334393717_err.txt
3 2012-04-14 11:06:31 _1334381745.txt
_1334381745_err.txt
4 2012-04-14 11:01:48 _1334381461.txt
1334381461_err.txt
Please help me in this regards.
Rakesh Sharma
From India, Chandigarh
Error mentioned below:-

(Error Code 013) NCP days data is incorrect on line number 1

(Error Code 014) Refund advance data is incorrect on line number 1

(Error Code 015) Arrear EPF wages data is incorrect on line number 1

(Error Code 016) Arrear EPF (EE share) data is incorrect on line number 1

(Error Code 017) Arrear EPF (ER share) data is incorrect on line number 1

(Error Code 018) Arrear EPS share data is incorrect on line number 1

(Error Code 013) NCP days data is incorrect on line number 2

(Error Code 014) Refund advance data is incorrect on line number 2

(Error Code 015) Arrear EPF wages data is incorrect on line number 2

(Error Code 016) Arrear EPF (EE share) data is incorrect on line number 2

(Error Code 017) Arrear EPF (ER share) data is incorrect on line number 2

(Error Code 018) Arrear EPS share data is incorrect on line number 2

(Error Code 013) NCP days data is incorrect on line number 3

(Error Code 014) Refund advance data is incorrect on line number 3

(Error Code 015) Arrear EPF wages data is incorrect on line number 3

(Error Code 016) Arrear EPF (EE share) data is incorrect on line number 3

(Error Code 017) Arrear EPF (ER share) data is incorrect on line number 3

(Error Code 018) Arrear EPS share data is incorrect on line number 3

(Error Code 013) NCP days data is incorrect on line number 4

(Error Code 014) Refund advance data is incorrect on line number 4
From India, Chandigarh
check the mentioned lines in .txt file.. There must be some error.. It should be in correct format.. There must not be any "," in any field..
From India, New Delhi
Dear Mr.Rakesh,
Mention the data in the specified fields. If data is not there put 0 in the specified fields.
Example If NCP days is there mention the days as well if arrears is there mention the arrears amt in the respective field. If nothing is there mention 0[ZERO], then upload it well get.
Thanks
Chikkegowda.N
From India, Ahmadabad
I would suggest u to use E-return tools.. its very easy n safe.. No errors at all if u use E-return tools..
From India, New Delhi
U need not remove that, once u upload a correct file, this error log files will go automatically..
From India, New Delhi
Go thru the attached file and follow the instructions given at the botom of the last page. Regards
From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: pdf ECR Help.pdf (221.6 KB, 2119 views)

Hi, Please find attached the sample of text file. Rakesh
From India, Chandigarh

Attached Files
Membership is required for download. Create An Account First
File Type: txt EPFOuploaded - Copy.txt (1.5 KB, 1332 views)

Your text file is correct. I uploaded this text file and checked.. Its correct.. Check the attachment.. It is a ECR file which i have created using the text file provided by you..
From India, New Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: pdf 2421204000337.pdf (23.9 KB, 959 views)

yup its 09590021885... u can call me on this i am number. i am from karnataka.. or u can connect with me on facebook . search for pavankadam, belgaum.
From India, New Delhi
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
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
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
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
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
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
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
Dear Friends Please help me out with this text file.....Attached with,..... Regards, Ramkishore
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
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
Mr. Rakesh, Go through the instructions in the portal. for any mistake the exact error code generate, rectify the particular line. be cautious while making the data sheet. Jaydev
From India, Ranchi
Respected Seniors,
I already download E Return Tool version 4.0 & Validation For E Return and add my establishment on E Return Tool version 4.0.
But the problem is that how and where can I upload employee data for monthly return and challan.
plz help me out in the same or can any one given me the complete procedure for monthly return and challan.
Thanx
Rahul Rana

From India, Faridabad
Dear Rahul Rana Read my above mail in spite of if you may not understand then you can call me i will tell you. Thank’s Dharmaveer kashyap 9818241956
From India, Delhi
Dear Members, Please go through the E Return Tool and upload the text file (generated by E Return tool) to Online ECR form. Its a very simple process. Regards Dev
From India
Sir,
I have uploaded ECR Return file. But What is the procedure for Filing Form 5, Form 10, Form 12.
Is there any different formats. to be uploaded separately.
Need Ur valuable advice Sir. my mail address:
Regards,
JRK Prasad
From India, Hyderabad
Hi, I think attached User Manual can help you all to fill e-return RC
From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: pdf USER%20MANUAL%20FOR%20EMPLOYERS.pdf (1.05 MB, 198 views)

Dear All,
(Err 001) Data is not as per ECR format (25 Fields separated by #~#) on line number 20
this is the error I am getting while ecr uploading kindly suggest what is this error.
Thanks & Regards
Vinay.D
From India, Mumbai
Dear Seniors, Can you tell me, how to identify error code for "1334564822err.txt" for this....
From India, Bangalore
i got the advice of mrpavankadam to go for ereturn tool for generation of pf challan.it was really easy. i suggest others also..i remitted the challan on 16th of this month..would i receive penalty for that? please inform me members
D.BALAVINAYAGAM
From India, Madras
can anyone help me with this regard how can i replace in .txt file with blank space to #~#. i have earlier sent the mail in this regard.
From India, New Delhi
(Err 001) Data is not as per ECR format – on line number 1

(Err 001) Data is not as per ECR format – on line number 2

(Err 001) Data is not as per ECR format – on line number 3

(Err 001) Data is not as per ECR format – on line number 4

(Err 001) Data is not as per ECR format – on line number 5

(Err 001) Data is not as per ECR format – on line number 6

(Err 001) Data is not as per ECR format – on line number 7

(Err 001) Data is not as per ECR format – on line number 8

(Err 001) Data is not as per ECR format – on line number 9

(Err 001) Data is not as per ECR format – on line number 10

(Err 001) Data is not as per ECR format – on line number 11

(Err 001) Data is not as per ECR format – on line number 12

(Err 001) Data is not as per ECR format – on line number 13

(Err 001) Data is not as per ECR format – on line number 14

(Err 001) Data is not as per ECR format – on line number 15

(Err 001) Data is not as per ECR format – on line number 16

(Err 001) Data is not as per ECR format – on line number 17

(Err 001) Data is not as per ECR format – on line number 18

(Err 001) Data is not as per ECR format – on line number 19

(Err 001) Data is not as per ECR format – on line number 20

kINDLY PROVIDE THE ABOVE ERROR SOLUTION
From India, Nasik
Dear Rakesh, can u sent me the excel or csv file then only i can help you out. regards, VINOD
From India, Vadodara
Dear All, Pleasefind the error log file for your reference
From India, Jamnagar

Attached Files
Membership is required for download. Create An Account First
File Type: pdf ECR_ErrorCodesList_15042012.pdf (317.7 KB, 269 views)

You download the Etool which is available in the PF Website, it is very easy to upload the data to the E Sawa. Regards Vivek
From India, Madras
Dear All, i need the help regarding the Can i save a excel file in .dbf format in office 2007????? please help
From India, New Delhi
Dear Rahul,

E Return toll and E-Sewa are two different concepat for time being now.There is no direct interlink for now.But you can use the monthly wage data which you have created in E-Retrun tool for generaing challan from E-Return tool.

Please open EPFO web site

Click on the E-Sewa link

You can see ECR FILE Format,Instruction manual etc.

Regsiter your establishmente for E-Sewa.Please note that registraion for E-Retrun tool and E-Sewa are different .

Aftrer registration you will get pin no.from PF by sms

Use this nos to get open the option for password

Create passoword and username

User name should contain atlese one numeric character i.e 1,2...

Password also should contain alphabetic,special and numeric character for eg

munnabhai&123

Now for the month of March please create ECR FILE and I HAVE ALREADEY POSTED HOW TO CREATE IT.

In the web site go to menu ECR then cleack upload ECR File option

AFTER SUCCESSFULL UPLOADING of the file your challan will be genrerated as instructed.

Hopes this will help you

Mangesh Wakodkar

Aurangabad


From India, Pune
Dear Mangesh Sir,
Thanks for reply, I already register my organization in EPFO portal E-Sewa as well as in E Return Tool version 4.0 and successfully generate challan for the month of March-12 from E-Sewa portal.
But my concerns are to all my R/Seniors:-
1. What is use of Validation For E Return software?
2. What is use of E Return Tool version 4.0 software?
3. Can we submit system generated hard copy of monthly returns (Form 5, 10 & 12A) in excel format?
4. If no, so what exactly we have to do?
5. For annual return of PF, can we prepare details (Form 3A & 6) in excel format then convert into txt file manually?
hope you all help me out in the above matters........
Thanks & Regards,
Rahul Rana
07838861690

From India, Faridabad
Hi to everyone,
ECR file should be completely as per the format of EPFo to be submitted without any error.
To create the ECR file with the help of software you can use following package -
www.nextechss.com/EPF40Installer.exe
Best Regards
From India, Nagpur
hi if we are paying our pf & esic contribution on time, so there is any dis-allowances in f or in esic.
From India, Faridabad
(Error Code 029) DOE EPF 31-03-2012 (Field 23) - incorrect date format on line number 1
(Error Code 031) DOE EPS 31-03-2012 (Field 24) - incorrect date format on line number 1
(Error Code 029) DOE EPF 31-03-2012 (Field 23) - incorrect date format on line number 4
(Error Code 031) DOE EPS 31-03-2012 (Field 24) - incorrect date format on line number 4
how to put date format my date format in excel sheet is 31/03/2012
From India, Delhi
Hi Chavi,
Please go to the format cells and then custom and select the data as per requirments.If now hapen then do the changing in not pad as per requirments and then load the ECR file.
Regards,
Rakesh Sharma
From India, Chandigarh
Your problem is=== The date of leaving person will old date first you set the date according form 10 in this file only give the leaving date of previous month. kamal
From India, Pilani
Anonymous
Use this file to create ecr and read carefully instructions dabaskar varshney
From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls PF ECR CREATOR.xls (253.0 KB, 374 views)

We are generating the challan in ECR.But ECR donot have individual full details.whether filling of PF details (Challan,3A/6A,Form-2)in E-Return tool version-4.0 is it Mandatory .?
Please suggest me on regards.
With Regards
santhosh
From India, Bangalore
Just fill the info in e-return tools and preserve it. Once the services for online submission of 3A/6a, form 2 , etc starts than we can submit these returns through tools.. Filing of various returns online will be started very soon. and this is to be filed with the help of tools only..
From India, New Delhi
to all the members
i suggest everyone to use e-return tools v4 for ecr generation and filing of other returns. Please don't follow the process of converting excel to text, this method contains some or the other error may be visible or hidden.. So use only and only e-return tools..
From India, New Delhi
Hi Rakeshbhai,
I have good idea for you. I have one EPF software. you can make the files in it and easily uopload it in to the ECR File directely. there will not be any type of error occurs thats the guranttee. just try this.
i have faced the same problem thats why i m giving u this suggestion and that is also the right process . even i got that software from the EPF office only. u can give me your mail Id to me. iwill send it in to it.
Chaitali.
From India, Vadodara
u can send me the flle so that i will rectify and will send back to u with no cost Lakshminarayana 9866917232
From India, Hyderabad
HI Rakesh,
While uploading ECR file:
1) No special character are symbol allowed in Members names.
2) NCP days Should contain Numeric values.
3) DOB/DOJ/DOR - format should in "30/04/2012" - Control Panel - Regional & Language option - Select ( English United Kingdom) - Select Customize - Select Date - Select Date Separator "/ " and apply.
4) Save file in CSV (Comma Delimited).Make CSV second Copy.
5) Open with Notepad, replace "," with "#~#" and save in text format and upload.
6) Check the errors in which line occuring.
Regards,
K Sukumar
From India, Jalandhar
Hi all,

I too had the same problems whileuploading the ecr files for the months march and april 2012. Its quite simple to upload the file.... There are certain things to notice while uploading the file.

1) While you open the csv file in note pad,just cross check whether there are 24 commas in each line..

2)After replacing the "," with "#~#", delete the headings ie, emp id, name n all.....

3)All fields except amt and date columns should be blank, if you dont have any values to add in it.

4) Even if you dont have any arrears, u should put 0 in the column. NCP column should also have values..

5)The most important thing is that IF YOU HAVE APPLIED FORMULA or DECIMALS IN EXCEL, it will not get uploaded

Now about errors:-

Lets take an example from the error log of MR. Rakesh Sharma,

(Error Code 013) NCP days data is incorrect on line number 1, means the NCP days column might be blank or more than the total days of the month.... if there are 31 days in a month and the ncp is shown as 31 and if contribution is also shown for that month, it is shown as error.

Regards,

Manasi

AM- HR
From India, Kochi




To ask a question or write a reply on this discussion you will need to create an account and login.



About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2017 Cite.Co™