Need Help with New EPF ECR Format: Can Anyone Share the Updated Excel Sheet?

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

Steps for Managing Employee Resignation and Registration on the EPFO Site

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.

Regards, Nailesh

[Email Removed For Privacy Reasons]

Please note that I am not responsible for any mistakes or changes in the law.

Steps for Managing EPFO Formalities

1st Step: Complete the resigned employee formalities on the EPFO site. 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 the EPFO site, select member, and register individual/bulk.

3rd Step: Download the UAN Base ECR Excel file for further processing. (EPFO site -> Payment -> ECR/Return filing -> 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.

Regards