Can someone tell me how to generate an ECR file for more than one thousand employees to submit the PF challan? Is there any shortcut method instead of doing data entry for the wages of each employee? Please help me regarding this as there are only a few days remaining for the challan submission.
Regards,
CHG
From India, Nagpur
Acknowledge(0)
Amend(0)
12Regards,
CHG
From India, Nagpur
Acknowledge(0)Amend(0)
Yes, you can generate an ECR file in a very simple and easy way through eReturn. You can import data from your Excel CSV file (import data structure given in eReturn). Additionally, you can create your own Excel file and convert it to a text file for ECR upload without using eReturn.
Regards,
Chirag Shah
From India, Surat
Acknowledge(0)Amend(0)
Regards,
Chirag Shah
From India, Surat
Acknowledge(0)Amend(0)
It is very easy to generate an ECR file if you have the following details:
1. PF number of the member
2. Name of the member
3. PF salary
4. Working days/NCP days
In addition to the above, for new members, Father/Husband Name, Date of Birth, and Date of Joining are required. For the left members, Date of Leaving is required.
Regards,
S. Ganapathy
[Email Removed For Privacy Reasons]
From India, Coimbatore
Acknowledge(0)Amend(0)
1. PF number of the member
2. Name of the member
3. PF salary
4. Working days/NCP days
In addition to the above, for new members, Father/Husband Name, Date of Birth, and Date of Joining are required. For the left members, Date of Leaving is required.
Regards,
S. Ganapathy
[Email Removed For Privacy Reasons]
From India, Coimbatore
Acknowledge(0)Amend(0)
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.
From India, Bengaluru
Acknowledge(0)Amend(0)
From India, Bengaluru
Acknowledge(0)Amend(0)
First of all, you may register in Employer E-Sewa. If already registered, log in to E-Sewa. There is an option to download on the homepage. You can download the ECR instructions from there. That would help you generate the ECR file.
Regards,
Starlet
From India, Madras
Acknowledge(0)Amend(0)
Regards,
Starlet
From India, Madras
Acknowledge(0)Amend(0)
I am familiar with the entire procedure; the only difference is that in my previous company, I had to do it for approximately 50 employees. Now, in my new workplace, the employee strength is in thousands. Thanks for your response.
Regards,
CHG
From India, Nagpur
Acknowledge(0)Amend(0)
Regards,
CHG
From India, Nagpur
Acknowledge(0)Amend(0)
Use VLOOKUP formula. by using VLOOKUP formula we need not to enter wages per each person.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
herewith attaching a model of CSV file and guidelines . Let me know if u require any more support regarding this. Regards, Starlet
From India, Madras
Acknowledge(1)Amend(0)
From India, Madras
Acknowledge(1)Amend(0)
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 12A. I am also not clear on the concept of 12A. Previous month's members, new members joined, and members left are not tallying.
Please help.
Regards, Ronnie
From India, Nagpur
Acknowledge(0)Amend(0)
Please help.
Regards, Ronnie
From India, Nagpur
Acknowledge(0)Amend(0)
Please follow the steps as given by Mr. Starlet and upload the text file. After uploading, a challan will be generated with a TRN number. You can take a printout and make the payment. The details of contributions, new members' details, and existing members' details can be downloaded. You need not prepare Form 12A, 5, & 10.
Regards,
S. Ganapathy
From India, Coimbatore
Acknowledge(0)Amend(0)
Regards,
S. Ganapathy
From India, Coimbatore
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.
Employee Data - Format.xls