Thread Started by #curious_hr_guy

Dear All,
Can Someone tell me how to generate ECR file for more than one thousand employees to submit the PF challan is there any shortcut method instead of doing data entry for wages of each employee?.
Plz help me regarding this as there are few days remaining for the challan submission.
11th November 2012 From India, Nagpur
It is not easy to educate about the generation of ECR file for EPF. You have to consult an consultant or nearby PF office for guidance. There is no short cut method.
J Vaikunth
Vaipav Consultants
12th November 2012 From India, Chennai
yes u can generate ecr file in very simple & easy way through e return u can import data from ur excel csv file(import data structure given in e return)
& u also make ur own excel file file & convert in text file for ecr upload without use of e return
chirag shah

12th November 2012 From India, Surat
There are methods, but at least you have to enter basic wages of each employee in that too.
12th November 2012 From India, Jaipur
if you are using a payroll software than it is ver easy to generate .csv excel file which can be uploaded in e return software..
For more details feel free to contact me at
12th November 2012 From India, Ahmadabad
Dear sir,
It is very easy to generate ECR file if you have the following details.
1. Pf No. of the member
2. Name of the member
3. Pf Salary
4. Working days/ncp days
in addtion to the above for new members
Father/Husband Name, Date of Birth, Date of joing required and for the left members Date of Leaving is required.
Thank U,

13th November 2012 From India, Coimbatore
if more than 100 you may use the XL sheet for submitting the p.f. challan creation. xl sheet is also provided by the epfo . no problem to creat the p.f. challan.
13th November 2012 From India, Bhilai
First of all You may register in Employer E sewa. If already registered, do login into e sewa. There is an option download in the home page. You can download the ECR instrustions from there.
That would help you to generate ECR file.
14th November 2012 From India, Madras
Dear Starlet,
I know the entire procedure only thing is that in my previous company I had to do it for approximate 50 employees, but now in my new workplace the employee strength is in thusands.
Thanks for your response
14th November 2012 From India, Nagpur
Hi, The procedure is same even if the employess strength is high.. You can follow the same procedure. Regards, Starlet
15th November 2012 From India, Madras
Dear, You can go for a payroll software like which can generate PF ECR automatically. Also it contains ITNS challan 281 and online ESIC file generation utility. Regards Sunil
16th November 2012 From India, Pune
Use VLOOKUP formula. by using VLOOKUP formula we need not to enter wages per each person.
17th November 2012 From India, Hyderabad
herewith attaching a model of CSV file and guidelines . Let me know if u require any more support regarding this. Regards, Starlet
21st November 2012 From India, Madras

Attached Files
Membership is required for download. Create An Account First
File Type: pdf EPF Guidelines.pdf (173.8 KB, 280 views)
File Type: csv EPF upload Format.csv (551 Bytes, 465 views)

Guys thank you so much for your response, I have uploaded the entire data in CSV Format. now the problem is that I am not able to make form 12 A. I am also not clear with the concept of 12 A , Previous months members new Members joined and Members left is not getting tallied.
Plz help
27th November 2012 From India, Nagpur
Dear Mr.Ronnie Please follow the steps as given by mr.Starlet and upload the text file. After uploading a challan will be generated with trn no.You can take printout and make payment. The details of contribution, new members detail and exiting members details can be download. You need not prepare Form 12A, 5 & 10.
27th November 2012 From India, Coimbatore
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™