Q&A
Home Top New Follow Journal Login
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
Hi Asmita
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 to understand better. If need more clarification do contact me
Cheerz
From India, Bangalore
Dear friends, go through the below file for understand epfo ANUMITA(HR) COCACOLA
From India, Bareilly

Attached Files
Membership is required for download. Create An Account First
File Type: pdf ProcessFlowECR.pdf (1.73 MB, 3040 views)

Dear all, I have done as the instruction being provided by you still it is giving error. and how to convert txt file into zip file becoz the text file is exceeding 2mb limit . regards, Asmita
From India, Mumbai
Hi Asmita I hope you would have made some mistakes. Please recheck whether is there any mistakes in validation part. If any clarfication do call me Cheerz
From India, Bangalore
Dear sir,
Following error is coming
(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 have some value 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 have some value 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 have some value 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 have some value data line 16
i have mentioned date in coloumn 15 16 in dd/mm/yy format and in reason i have written c then also following error is coming
asmita
From India, Mumbai
Dear Jeeva, Can you please share your Excel Format without Data for the benefit of all? regards
From India, Mumbai
Dear Raj As requested find enclosed of the Excel Sheet I have Prepared, CSV File and TXT File. I uploaded the same format with out any Error
From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls RCDT ECR Mar 2012.xls (24.5 KB, 2272 views)
File Type: txt RCDT ECR Mar 12.txt (1.9 KB, 1055 views)

You are welcome Atleast now did you find the mistake what you did? Can you brief the mistakes. So that it will help others to avoid the same mistakes.
From India, Bangalore
dear sir, ihave face the problem of date format plz tell me how can i writ the date1/4/2012
From India, Delhi
Hi dear all , plz convert the all the value into number format,then it will not creat any type of error regards, anumita(hr) cocacola
From India, Bareilly
hi raj
thank for sharing this report.
can you please tell me what value needs to put in arrear EPF wages, arrar epf ee share, arrear epf er share and arrear eps share.
please help me dear with example.
regards
kusum
From India, Delhi
HI Kusum.
If there is any arrears of EPF wages either from EE or ER from previous months you should mention. In normal cases there will be nil. But in certain cases if there is any arrears you should mention.
:)
From India, Bangalore
Dear Mr. jeevanathan
Following are the mistakes committed by me:
1. i didn't removed the first line which contains the headings ex- member id
2. the dates i entered in dd-mm-yy format
3. the member id 's i wrote them with establishment id ex- 2451601
but it should be 1
4. i converted .csv file directly into .txt file instead of copying the same matter to new .txt file and saving it.
regards,
asmita
From India, Mumbai
Hi Asmita
Thats good. Finally everything is fine. So no problems from next time onwards..
Regarding ESI I feel no need to file half yearly returns. I you feel to file returns then you shall file just online. Coz few places they are not accepting manual returns.
From India, Bangalore
Dear asmita i dont know how to file the form 5 and 10, but if u want to know about the ECR uplaod don't hesitate to call me between 6.00PM to 9.00PM
my number is 9494505581
Harish k chowdary
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.[/QUOTE]
From India, Nellore
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

Attached Files
Membership is required for download. Create An Account First
File Type: txt ECR.txt (1.6 KB, 141 views)

Hi Asmita
I am sorry. I was not in station for 2 days. I couldn't reply for your queries.
Try to upload the enclosed TXT File.
There are few doubts on your Statement. If you can call me then I could clarify on that. If need you shall even chat with me on my gmail or yahoo both IDs are pjeevarathnam
:)
From India, Bangalore
dear asmita, can u attach the excel file then i will definetly help u warm regards Rao vikas 09882133609
From India, Delhi
HI Rao There is some problems with that Excel Sheet Can you find all the number are 0 in last 2 rows. Y this 0? If resigned then what is the date of resignation?
From India, Bangalore
sir, sorry sir uploaded wrong file. Here is the excel file. Regards, Asmita
From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls book.xls (20.5 KB, 194 views)

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
Dear All
you see my ecr .xls file and any changes of contribution
1. Open .xls file please save as .csv (ms dos mode)
2. and then you go to the csv right click open with notepad and save the file extension name in .txt file
3. and open that text file go to edit option and replace find what "," and replace with "#~#", and remove header row then upload
From India, Madras

Attached Files
Membership is required for download. Create An Account First
File Type: zip ECR Format.zip (1.05 MB, 144 views)

Dear Asmita You can contact me on 9891620801 & I’LL tell you about ecr. regards Amit Sharma
From India, Delhi
HI IT PAUL

I AM GETTING AN ERROR GIVEN BELOW

(Error Code 021) DOB 1/1/1972(Field 19) is 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 SUGGEST ME

REGARDS

PAUL
From India, Calcutta
Dear paul
if the employees have joined in the month of july 2011 why are u mentioning them now.you should mention DOB AND DOJ of those employee who have joined in the month of march 2012.
Regards,
Asmita
From India, Mumbai
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
Hi I have a good solution for creating ECR text file for PF Pls contact me: renjithalp at gmail regards renjith
From India, Ernakulam
can you kindly check what mistake i am making, its showing error everytime i upload navin rout
From India, Bhopal

Attached Files
Membership is required for download. Create An Account First
File Type: zip ECR.zip (1.6 KB, 87 views)

Hello Asmita,
I have one recommendations. I am using IntelliPayroll Software a Payroll Software by Prodigy Technologies. Hope it will solve your problems.
to know more about software visit
Payroll Software Online - Prodigy Technologies
regards,
Manoj
From India, Bangalore
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
Dear Mr.Paul pls help am getting this 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 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 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 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
Hi Anitha
All the date formats should be in DD/MM/YYYY for example .
Error Code 025) DOJ EPF 1/8/2012 (Field 21) - incorrect date format on line number 54
there date should be as 01/08/2012 not 1/8/2012
From India, Bangalore
Hi,
From March i was submitting the EPF contribution through the excel format only but my system got corrupted & lost all the files.
i was using old version it was good & easy
please let me get that format, by searching i am not getting that format its totally different.
Regards,
Poornima
From India, Bangalore
Hi Poornima find enclosed excel format for filing ECR
From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls April 12.xls (29.5 KB, 109 views)

Here is ECR Format, attached, as you were searching for it.
From India, Jaipur

Attached Files
Membership is required for download. Create An Account First
File Type: xls ECR.xls (38.0 KB, 109 views)

Hi Jeevarathnam, I was getting all the calculations in the 2 sheet of my file. i need that excel file pls can u send me regards, poornima
From India, Bangalore
Sir i was using the excel file format from March-2012, but i downloaded in May-2012,
1. 1st sheet was introduction we can edit anything in 1st sheet.
2. 2nd sheet was we have to fill all the names, wages, contribution etc..
3. we should update month & year, it will calculate all the calculations automatically for Eg:2% etc & we are not able to edit anything else.
All the calculation which we fill in the challan while submitting online after uploading ecr excel file.
This is very easy to do, pls let me know whether u can do this find & send me that file pls....
regards,
poornima
From India, Bangalore
1st sheet background was purpal or blue.
2nd sheet was in white as u send me & header was in gray colour.
3rd sheet was in fully gray but edit cells was in white, only 2 or 3 cells can be edited
after updating everything i use to save as some option command was there...
it was very easy for working
From India, Bangalore
I am not sure, what you are asking for. But here is a link of my one of contribution in citehr.
This is automated pf ledger.
https://www.citehr.com/397716-revise...pf-ledger.html
From India, Jaipur
You have to enable macros.. after opening it.
security warning Some active content has been disable
Click on OPTIONS
Then Enable this content.
this is the file i am looking for macros enabling. pls send me the excel file.
I know how to work on this.
regards
poornima
From India, Bangalore
Dear sir ,

The above attachment in your ecr format is ok but some remaining columns blank in future it is compusary required like nominee and dat birth.in my ecr file preparation i fill all the columns and uploaded but it showing some error in date of birth dd/mm/yy
From India
Member ID Member Name EPF Wages EPS Wages EPF Contribution (EE Share) due EPF Contribution (EE Share) being remitted EPS Contribution due EPS Contribution being remitted Diff EPF and EPS Contribution (ER Share) due Diff EPF and EPS Contribution (ER Share) being remitted NCP Days Refund of Advances Arrear EPF Wages Arrear EPF EE Share Arrear EPF ER Share Arrear EPS Father’s/Husband’s Name Relationship with the Member Date of Birth Gender Date of Joining EPF Date of Joining EPS Date of Exit from EPF Date of Exit from EPS Reason for leaving

1 AAA 4400 4400 528 528 367 367 161 161 0 0 0 0 0 0

2 BBB 22500 6500 2700 2700 541 541 239 239 0 0 0 0 0 0

5 CCC 43750 6500 5250 5250 541 541 239 239 0 0 0 0 0 0

7 DDD 42750 6500 5130 5130 541 541 239 239 0 0 0 0 0 0

8 EEE 22000 6500 2640 2640 541 541 239 239 0 0 0 0 0 0

19 FFF 11000 6500 1320 1320 541 541 239 239 0 0 0 0 0 0

27 GG 16500 6500 1980 1980 541 541 239 239 0 0 0 0 0 0

28 HH 11000 6500 1320 1320 541 541 239 239 0 0 0 0 0 0

44 III 7750 6500 930 930 541 541 239 239 0 0 0 0 0 0

45 JJ 7650 6500 918 918 541 541 239 239 0 0 0 0 0 0

47 ABC 7750 6500 930 930 541 541 239 239 0 0 0 0 0 0

48 XYZ 7750 6500 930 930 541 541 239 239 0 0 0 0 0 0

53 ASD 7750 6500 930 930 541 541 239 239 0 0 0 0 0 0

55 ZXC 6250 6250 750 750 521 521 229 229 0 0 0 0 0 0

58 QWE 6134 6134 736 736 511 511 225 225 0 0 0 0 0 0

60 WER 21650 6500 2598 2598 541 541 239 239 0 0 0 0 0 0
From India, Pune



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™