Struggling with the New ECR Format for PF? Need Help with Forms 5 and 10 Online?

y123-56
Could someone please advise me on how to fill out the new ECR format for PF? Also, I have queries regarding Form 5 and Form 10 - how can we complete these forms online?

Regards,
Asmita
HR Executive
jeevarathnam
Go through the below links:

- https://www.citehr.com/401123-regarding-e-sewa-epf.html
- https://www.citehr.com/401161-e-sewa.html
- https://www.citehr.com/401322-epfo-e...uidelines.html

I believe these links will help you understand better. If you need more clarification, do contact me.

Cheers
Regards
anumitasingh745@gmail.com
Please go through the attached file to understand EPFO.

Regards,
Anumita
HR, Coca-Cola
1 Attachment(s) [Login To View]

y123-56
Error Messages in ECR Format

The following errors are occurring:

- (Err 29) DOE EPF is incorrect on data line 2
- (Err 31) DOE EPS is incorrect on data line 2
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving has some value on data line 2
- (Err 29) DOE EPF is incorrect on data line 9
- (Err 31) DOE EPS is incorrect on data line 9
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving has some value on data line 9
- (Err 29) DOE EPF is incorrect on data line 15
- (Err 31) DOE EPS is incorrect on data line 15
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving has some value on data line 15
- (Err 29) DOE EPF is incorrect on data line 16
- (Err 31) DOE EPS is incorrect on data line 16
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving has some value on data line 16

I have entered the dates in columns 15 and 16 in dd/mm/yy format, and in the reason column, I have written "c". However, the errors persist.

Regards,
Asmita
kusumrawat1985
Thank you for sharing this report. Could you please tell me what value needs to be put in arrear EPF wages, arrear EPF EE share, arrear EPF ER share, and arrear EPS share? Please help me, dear, with an example.

Regards,
Kusum
jeevarathnam
Hi Kusum, if there are any arrears of EPF wages either from the employee (EE) or employer (ER) from previous months, you should mention them. In normal cases, there will be none. However, in certain cases, if there are any arrears, you should mention them. 
y123-56
Following are the mistakes committed by me:

1. I didn't remove the first line which contains the headings, for example, member ID.
2. The dates I entered were in the dd-mm-yy format.
3. The member IDs I wrote included the establishment ID, for example, 2451601, but it should be 1.
4. I converted a .csv file directly into a .txt file instead of copying the same data to a new .txt file and saving it.

Regards,
Asmita
harishkchowdary
I don't know how to file Form 5 and 10, but if you want to know about the ECR upload, don't hesitate to call me between 6:00 PM to 9:00 PM. My number is [Phone Number Removed For Privacy Reasons].

Filling the New ECR Format of PF

Will anyone tell me how to fill the new ECR format of PF? Also, how can we fill Form 5 and 10 online?

Regards,
Asmita
HR Executive
y123-56
Dear Mr. Jeeva, there is still a problem. I am attaching a .txt file. Could you please try to upload it on EPFO ECR? It is showing an error. Kindly let me know what the issue is with the file.

Regards,
Asmita
1 Attachment(s) [Login To View]

y123-56
Sorry, I uploaded the wrong file. Here is the Excel file.

Regards,
Asmita
1 Attachment(s) [Login To View]

y123-56
If the employee had not worked a single day, what should I mention in the last two rows instead of zero? Additionally, there is an issue occurring in row numbers 2 and 9.

Regards,
Asmita
krsrajesh
Instructions for Editing ECR File

Please review my ECR .xls file and make any necessary changes to the contributions:

1. Open the .xls file, then save it as a .csv (in MS-DOS mode).
2. Right-click on the .csv file, open with Notepad, and save it with the file extension name as .txt.
3. Open the text file, go to the edit option, and replace "find what" with "," and replace it with "#~#", then remove the header row before uploading.

Thank you.

Regards,
1 Attachment(s) [Login To View]

paulscc
I am getting an error as follows:

Error Codes and Descriptions

- (Error Code 021) DOB 1/1/1972 (Field 19) is in the incorrect date format on line number 1.
- (Error Code 025) DOJ EPF 1/7/2011 (Field 21) - incorrect date format on line number 1.
- (Error Code 027) DOJ EPS 1/7/2011 (Field 22) - incorrect date format on line number 1.
- (Error Code 029) DOE EPF 0 (Field 23) - incorrect date format on line number 1.
- (Error Code 031) DOE EPS 0 (Field 24) - incorrect date format on line number 1.
- (Error Code 025) DOJ EPF 1/7/2011 (Field 21) - incorrect date format on line number 2.
- (Error Code 027) DOJ EPS 1/7/2011 (Field 22) - incorrect date format on line number 2.
- (Error Code 029) DOE EPF 0 (Field 23) - incorrect date format on line number 2.
- (Error Code 031) DOE EPS 0 (Field 24) - incorrect date format on line number 2.
- (Error Code 025) DOJ EPF 1/7/2011 (Field 21) - incorrect date format on line number 3.
- (Error Code 027) DOJ EPS 1/7/2011 (Field 22) - incorrect date format on line number 3.
- (Error Code 029) DOE EPF 0 (Field 23) - incorrect date format on line number 3.
- (Error Code 031) DOE EPS 0 (Field 24) - incorrect date format on line number 3.
- (Error Code 025) DOJ EPF 1/7/2011 (Field 21) - incorrect date format on line number 4.
- (Error Code 027) DOJ EPS 1/7/2011 (Field 22) - incorrect date format on line number 4.
- (Error Code 029) DOE EPF 0 (Field 23) - incorrect date format on line number 4.
- (Error Code 031) DOE EPS 0 (Field 24) - incorrect date format on line number 4.
- (Error Code 025) DOJ EPF 1/7/2011 (Field 21) - incorrect date format on line number 5.
- (Error Code 027) DOJ EPS 1/7/2011 (Field 22) - incorrect date format on line number 5.
- (Error Code 029) DOE EPF 0 (Field 23) - incorrect date format on line number 5.

Please advise.

Regards,
Paul
jeevarathnam
Hi, for the month of March, you should have filed in the month of April itself. If not, you can give 1st April and give NCP of 1 day and try to upload.
navin_rout
Can you kindly check what mistake I am making? It's showing an error every time I upload.

Regards,
Navin Rout
1 Attachment(s) [Login To View]

raovikas123@gmail.com
There is no need to submit Form 5 or Form 10 after uploading the ECR. In the ECR, you have already mentioned the new joining and exiting employees.

With warm regards,
Vikas Yadav
anitha dhayakaran
Dear Mr. Paul, please help as I am getting the following errors:

- (Error Code 025) DOJ EPF 1/8/2012 (Field 21) - incorrect date format on line number 54
- (Error Code 027) DOJ EPS 1/8/2012 (Field 22) - incorrect date format on line number 54
- (Error Code 021) DOB 10/4/1987 (Field 19) is an incorrect date format on line number 55
- (Error Code 025) DOJ EPF 1/8/2012 (Field 21) - incorrect date format on line number 55
- (Error Code 027) DOJ EPS 1/8/2012 (Field 22) - incorrect date format on line number 55
- (Error Code 021) DOB 1/6/1984 (Field 19) is an incorrect date format on line number 56
- (Error Code 025) DOJ EPF 1/8/2012 (Field 21) - incorrect date format on line number 56
- (Error Code 027) DOJ EPS 1/8/2012 (Field 22) - incorrect date format on line number 56
- (Error Code 021) DOB 1/6/1985 (Field 19) is an incorrect date format on line number 57
- (Error Code 025) DOJ EPF 1/8/2012 (Field 21) - incorrect date format on line number 57
- (Error Code 027) DOJ EPS 1/8/2012 (Field 22) - incorrect date format on line number 57
- (Error Code 025) DOJ EPF 13/8/2012 (Field 21) - incorrect date format on line number 58
- (Error Code 027) DOJ EPS 13/8/2012 (Field 22) - incorrect date format on line number 58

jeevarathnam
All the date formats should be in DD/MM/YYYY format. For example, Error Code 025) DOJ EPF 1/8/2012 (Field 21) - incorrect date format on line number 54. The date should be written as 01/08/2012, not 1/8/2012.
Prompt Services Inc
Since March, I have been submitting the EPF contributions using the Excel format only. However, my system got corrupted, and I lost all the files. I was using an old version which was good and easy. I am unable to find that format now; the current one is completely different.

Regards,
Poornima
jeevarathnam
Hi Poornima, find enclosed the Excel format for filing ECR.
1 Attachment(s) [Login To View]

nitesh_barman
Here is the ECR format attached, as you were searching for it.
1 Attachment(s) [Login To View]

Prompt Services Inc
I was using the Excel file format since March 2012, but I downloaded a new one in May 2012.

1. The first sheet is an introduction where we can edit anything.
2. The second sheet is where we need to fill in all the names, wages, contributions, etc.
3. We should update the month and year; the sheet will automatically calculate all the figures like 2%, and we are not able to edit anything else.

All the calculations filled in the challan are used while submitting online after uploading the ECR Excel file. This process is straightforward. Please let me know if you can assist with this and send me the file.

Regards,
Poornima
ramu-ch
The attachment in your ECR format is okay, but some columns remain blank. In the future, it is compulsory to fill in details such as the nominee and date of birth. During the preparation of my ECR file, I completed all the columns and uploaded it. However, an error occurred regarding the date of birth format (DD/MM/YY).

Thank you.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute