Dear frnds, will anyone tell me how to fill the new ecr format of pf. And what about the form 5 and 10 how will we fill it online regards, asmita hr exec.
From India, Mumbai
Acknowledge(3)
Amend(0)
36From India, Mumbai
Acknowledge(3)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
- 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
From India, Bangalore
Acknowledge(0)Amend(0)
Dear friends, go through the below file for understand epfo ANUMITA(HR) COCACOLA
From India, Bareilly
Acknowledge(3)
Amend(0)
From India, Bareilly
Acknowledge(3)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
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
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The errors you are encountering in filling the EPF form are likely due to incorrect input of dates and reasons for leaving. Please ensure the dates are in the correct format (dd/mm/yy) and reasons are accurately indicated to resolve the errors. (1 Acknowledge point)
0
0
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
From India, Delhi
Acknowledge(0)Amend(0)
Regards,
Kusum
From India, Delhi
Acknowledge(0)Amend(0)
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.
From India, Bangalore
Acknowledge(1)Amend(0)
From India, Bangalore
Acknowledge(1)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
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
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply contains accurate information and helpful insights into the mistakes made while filling the new ECR format of PF. Great attention to detail and improvements noted. (1 Acknowledge point)
0
0
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
From India, Nellore
Acknowledge(0)Amend(0)
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
From India, Nellore
Acknowledge(0)Amend(0)
DEAR Mr. Jeeva There is still a problem i am attaching a .txt file u try to upload it on epfo ecr upload it will show error kindly tell me what is the problem with th file. regards, Asmita
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
sir, sorry sir uploaded wrong file. Here is the excel file. Regards, Asmita
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Mr. Jeeva, But if the employee had not worked a single day then what should i mention in last two rows instead of zero. and the problem is also occuring row no. 2 and 9 regards, Asmita
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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,
From India, Madras
Acknowledge(1)Amend(0)
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,
From India, Madras
Acknowledge(1)Amend(0)
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
From India, Calcutta
Acknowledge(0)Amend(0)
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
From India, Calcutta
Acknowledge(0)Amend(0)
Hi for the month of march you should have filed in the month of April itself. If not you can give 1st April & give NCP of 1 day and try to upload
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
can you kindly check what mistake i am making, its showing error everytime i upload navin rout
From India, Bhopal
Acknowledge(0)Amend(0)
0
0
From India, Bhopal
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The error you are encountering may be due to incorrect data entry or missing fields. Double-check your entries and ensure all required information is provided. Thank you for seeking clarification. (1 Acknowledge point)
0
0
Dear asmtia their is no need to submit the form 5,10 after upload Ecr.in ecr you mention already new joining & exit employees With warm regards Vikas yadav
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
0
0
- (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
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The errors mentioned in the user reply are related to incorrect date formats in various fields. It's important to ensure the dates are in the correct format to avoid issues. (1 Acknowledge point)
0
0
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.
From India, Bangalore
Acknowledge(1)Amend(0)
From India, Bangalore
Acknowledge(1)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
Regards,
Poornima
From India, Bangalore
Acknowledge(0)Amend(0)
Here is ECR Format, attached, as you were searching for it.
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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.
From India
Acknowledge(0)Amend(0)
Thank you.
From India
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SBudget Format HR.xls
CiteHR.AI
(Fact Checked)-The user's reply provides relevant links to understand the new ecr format of PF. Encouraging self-learning and offering further help is positive. (1 Acknowledge point)