Dear sirs/Madams,
Can anybody please send an Excel sheet for ECR, which was introduced by the EPF office just one week ago? The sheet should contain 11 columns instead of 26 columns. Additionally, in the old Excel sheet, all information such as Form 5, Form 10, father's name, date of birth, date of joining, and date of leaving are mentioned. Now, Form 5 and Form 10 need to be filed separately. We need to follow this new method starting this month.
Regards, V. Subbarao
From India, Madras
Acknowledge(0)
Amend(0)
38Can anybody please send an Excel sheet for ECR, which was introduced by the EPF office just one week ago? The sheet should contain 11 columns instead of 26 columns. Additionally, in the old Excel sheet, all information such as Form 5, Form 10, father's name, date of birth, date of joining, and date of leaving are mentioned. Now, Form 5 and Form 10 need to be filed separately. We need to follow this new method starting this month.
Regards, V. Subbarao
From India, Madras
Acknowledge(0)Amend(0)
I'm sorry, but I cannot access external URLs or web content. However, if you provide the text you would like me to review for spelling, grammar, or punctuation errors, I would be happy to assist. Just paste the text here, and I'll help you with the corrections.
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Dear All,
Hi,
1st Step: Complete the resignation formalities of the employee on the EPFO site. Go to the member section, then to the exit bulk option. For individual cases, go to the profile and mark the employee's exit based on their last working day.
2nd Step: Register your new employee on the EPFO portal. For bulk registrations, navigate to the EPFO site, go to the member section, and register individually or in bulk.
3rd Step: Download the UAN Base ECR Excel file for further processing. On the EPFO site, go to payment, ECR/return filing, ECR upload, select Nov-16, choose the type of "ECR," and download the Excel file. If the file does not open, please rename it to ecr.xls and remember not to forget the ".xls" extension.
4th Step: Fill out the UAN base ECR file, remove employees who have been processed for exit, and add new registered members' UAN and names to the file. Ensure it matches with the pay register.
5th Step: An example sheet is attached to this post for more information. Please contact me via email only; no calls, please.
6th Step: Refer to the contribution rate of PF and manually update accounts 22, 21, and 2 according to the contribution rate.
7th Step: Mention the total number of employees manually on the challan, along with their gross wages, and upload it finally.
8th Step: Approve the ECR file and download it.
9th Step: Verify and make the payment online through the same portal.
Thanks and regards,
Nailesh
Email: naileshpsurani@hotmail.com
Please note that I am not responsible for any mistakes or changes in the law.
From India, Rajkot
Acknowledge(0)Amend(0)
Hi,
1st Step: Complete the resignation formalities of the employee on the EPFO site. Go to the member section, then to the exit bulk option. For individual cases, go to the profile and mark the employee's exit based on their last working day.
2nd Step: Register your new employee on the EPFO portal. For bulk registrations, navigate to the EPFO site, go to the member section, and register individually or in bulk.
3rd Step: Download the UAN Base ECR Excel file for further processing. On the EPFO site, go to payment, ECR/return filing, ECR upload, select Nov-16, choose the type of "ECR," and download the Excel file. If the file does not open, please rename it to ecr.xls and remember not to forget the ".xls" extension.
4th Step: Fill out the UAN base ECR file, remove employees who have been processed for exit, and add new registered members' UAN and names to the file. Ensure it matches with the pay register.
5th Step: An example sheet is attached to this post for more information. Please contact me via email only; no calls, please.
6th Step: Refer to the contribution rate of PF and manually update accounts 22, 21, and 2 according to the contribution rate.
7th Step: Mention the total number of employees manually on the challan, along with their gross wages, and upload it finally.
8th Step: Approve the ECR file and download it.
9th Step: Verify and make the payment online through the same portal.
Thanks and regards,
Nailesh
Email: naileshpsurani@hotmail.com
Please note that I am not responsible for any mistakes or changes in the law.
From India, Rajkot
Acknowledge(0)Amend(0)
Dear All,
Hi,
1st Step: Complete resigned employee formalities in EPFO site. Then, under the member section, proceed to exit bulk or for individual cases, go to the profile and make the employee exit as per their last working day.
2nd Step: Register your new employee in the EPFO portal. For bulk joining, navigate to EPFO site, select member, register individual/bulk.
3rd Step: Download UAN Base ECR Excel file for further processing. (EPFO site -> Payment -> ECR/Return filling -> ECR upload -> select Nov-16 -> select type of "ECR" -> download excel file). If the file does not open, please rename ecr.xls to ".xls" and don't forget.
ECR UPLOADED WITH THIS POST. READ EARLIER POST FOR OTHER PROCESSES.
From India, Rajkot
Acknowledge(0)Amend(0)
Hi,
1st Step: Complete resigned employee formalities in EPFO site. Then, under the member section, proceed to exit bulk or for individual cases, go to the profile and make the employee exit as per their last working day.
2nd Step: Register your new employee in the EPFO portal. For bulk joining, navigate to EPFO site, select member, register individual/bulk.
3rd Step: Download UAN Base ECR Excel file for further processing. (EPFO site -> Payment -> ECR/Return filling -> ECR upload -> select Nov-16 -> select type of "ECR" -> download excel file). If the file does not open, please rename ecr.xls to ".xls" and don't forget.
ECR UPLOADED WITH THIS POST. READ EARLIER POST FOR OTHER PROCESSES.
From India, Rajkot
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.