New ECR 2.0 Version: Why It's Crucial to Read and Update Your Files

Dear Friends,

It is very important that version ECR 2.0 is mandatory to read. Please ensure to read it and create the new ECR 2.0 file.

New Version: ECR 2.0 and UAN-Based Flow Chart

Hi,

Please find below the updated flow chart for the new version of the ECR, which is ECR 2.0. This version is based on the UAN system for efficient processing.

Thank you.

URL: [https://unifiedportal-emp.epfindia.gov.in](https://unifiedportal-emp.epfindia.gov.in)

---

Hi,

Thank you for sharing the link. I have reviewed it, and it seems to be correct. If you have any questions or need further assistance, feel free to ask.

Best regards

Dear sir,

Could anyone please send a model ECR Excel sheet? I need help on how to upload the ECR file to the EPF site. We require a practical model Excel sheet. Thank you.

Ecr 2 consists of 11 fields that are separated by #~#. How can I create this file from Excel? Please reply.

Dear Senior,

Please help me handle the following situations in the new UAN-based ECR:

1. How should an employee be exited in the new UAN-based ECR 2.0? Is it before uploading the current month's ECR or after?
2. How can an employee be rehired in the new ECR after being marked as left?

Regards,
Prasenjit

Steps to Generate a New ECR

To generate a new ECR, follow these steps:

1. First, open a new Excel sheet. In the first row, set up the following headers:
1. UAN NO
2. NAME
3. GROSS SAL
4. EPF SAL
5. EPS SAL
6. EDLI SAL (SAME SAL EPF)
7. EE CON 12% OR 10%
8. ER CON 8.33%
9. DIFF EE CON & ER CON
10. NCP DAY
11. ADVANCES/REFUND

Fill in the details in the Excel sheet and save it as a CSV file. Open the CSV file in Notepad and save it as a TXT file. Your TXT file should look like this:

100132409491#~#DEEPAK M KMALLESAPPA#~#2400#~#2000#~#2000#~#2000#~#240#~#16 7#~#73#~#11#~#0
100236604905#~#MUDAKAPPA B NARGUND#~#1550#~#1300#~#1300#~#1300#~#156#~#108#~# 48#~#18#~#0
100226790766#~#MEHABOLI M MMOULASAB#~#1950#~#1500#~#1500#~#1500#~#180#~#125# ~#55#~#16#~#0

Delete the header line in Notepad. Your ECR file is now ready to upload to the ECRUPLOAD portal at https://unifiedportal-emp.epfindia.gov.in.

Please find the attached CSV file for your reference.

Regards,
R S PAGAD

Steps to Generate a New ECR

Here are the steps on how to generate a new ECR:

First, open a new Excel sheet. In the first row, set up the headers as follows:
1. UAN NO
2. NAME
3. GROSS SAL
4. EPF SAL
5. EPS SAL
6. EDLI SAL (SAME SAL EPF)
7. EE CON 12% OR 10%
8. ER CON 8.33%
9. DIFF EE CON & ER CON
10. NCP DAY
11. ADVANCES / REFUND

Fill in the details in the Excel sheet and save it as a CSV file. Open the CSV file in Notepad and save it as a .txt file. Replace commas with #~#.

Your ECR file should now look like this:
100132409491#~#DEEPAK M KMALLESAPPA#~#2400#~#2000#~#2000#~#2000#~#240#~#16 7#~#73#~#11#~#0
100236604905#~#MUDAKAPPA B NARGUND#~#1550#~#1300#~#1300#~#1300#~#156#~#108#~# 48#~#18#~#0
100226790766#~#MEHABOLI M MMOULASAB#~#1950#~#1500#~#1500#~#1500#~#180#~#125# ~#55#~#16#~#0

Remember to delete the header line in Notepad. Your ECR file is now ready to be uploaded to the ECR upload portal at https://unifiedportal-emp.epfindia.gov.in.

Please find the attached CSV file for your reference.

Regards,
R S PAGAD

Dear all,

Wishing you a Happy New Year! All friends, please download the new ECR file version 2.0.

Thank you.

Dear All,

Is there any way to generate a new ECR 2 in the E-return Tool? I have tried it in version 6.1, but it always shows an error message stating, "Error Total Number of Fields: Invalid found on line numbers." Should we generate it manually until the new E-return tool is available? Please guide.

Thank you.

Hi, can anyone confirm if in this new format, "Gross Wages" means the basic component or the gross salary, which includes all salary perks? Please do let me know. Thank you for your valuable time.

Can anyone please let me know how to prepare the ECR File Version 2 in E-Return Tool 6.1?

Dear friends, please suggest the meaning of gross wages in ECR 2.0.

Respected seniors,

Could anyone please explain what gross salary and EDLI wages mean in ECR version 2?

Thanks,

Regards,
Oshin Sharma

How to Generate a New ECR

I apologize for forgetting a few steps in the last post. Here is how you can generate a new ECR:

First, open a new Excel sheet. In the first row, label the columns as follows:
1. UAN NO
2. NAME
3. GROSS SAL
4. EPF SAL
5. EPS SAL
6. EDLI SAL (Same as EPF SAL)
7. EE CON 12% OR 10%
8. ER CON 8.33%
9. DIFF EE CON & ER CON
10. NCP DAY
11. ADVANCES / REFUND

Fill in the details in the Excel sheet and save it as a CSV file. Open the CSV file in Notepad and save it as a .txt file. Replace "," with "#~#" in the text file to format the ECR file correctly, like this:

100132409491#~#DEEPAK M KMALLESAPPA#~#2400#~#2000#~#2000#~#2000#~#240#~#16 7#~#73#~#11#~#0
100236604905#~#MUDAKAPPA B NARGUND#~#1550#~#1300#~#1300#~#1300#~#156#~#108#~# 48#~#18#~#0
100226790766#~#MEHABOLI M MMOULASAB#~#1950#~#1500#~#1500#~#1500#~#180#~#125# ~#55#~#16#~#0

Delete the header line in Notepad. Your ECR file is now ready to be uploaded to the ECR upload portal at https://unifiedportal-emp.epfindia.gov.in.

Please find the attached CSV file for your reference.

Regards

Certainly! Here is the corrected and formatted text:

Kindly provide information on how to process the exit of employees and onboard new employees using the new UAN-based ECR. Additionally, please explain the procedure for obtaining the confirmation slip.

Thank you.

This file is to be uploaded on the ECR portal. This is a text file.

Dear sir,

Could anyone please send a model ECR Excel sheet? I need help with uploading the ECR file to the EPF site. We require a practical model Excel sheet. I also need information on exempted categories of companies, such as Trusts and Companies.

Thank you.

While uploading ECR, I am getting this error: "Error Total Number of Fields: Invalid found on line numbers: [1-68]. Can you please guide me? Thank you.

Hey friends, here is the solution for your new ECR format.

---
Hey friends, here is the solution for your new ECR format.

Hi seniors,

Can anyone help me to find out the difference between E-con and ER-con in the new ECR salary entry? This is urgent.

Dear Sir,

How do I validate an Excel file with the new ECR Tool version 2.0, or how can we upload it in the ECR main jar?

Thanks

Dear Colleagues, Hope you are doing well! Please help me with your valuable advice on the matter below:

Q1. PF Dues Based on Rs. 15,000 Limit

The query is for those employers who treat the PF dues based on the Rs. 15,000 limit on EPF wages and not the entire amount. In the case of such an employer, if an employee has PF wages defined as, for example, Rs. 50,000 per month and is on Loss of Pay for 15 days out of 30 in April, what is the PF deduction and contribution?
- Is it based on the fact that since the employee is paid Rs. 25,000 for that month (15/30 x 50,000), the PF should be 12% of Rs. 15,000 (lower of Rs. 15,000 and Rs. 25,000), i.e., Rs. 1,800, OR
- Should it be computed as PF wages being Rs. 15,000 (lower of Rs. 50,000 and Rs. 15,000) and PF wages pro-rated as per LOP days, which is 15/30 of Rs. 1,800, i.e., Rs. 900?

Q2. PF Dues Based on Entire Amount

The query is for those employers who treat the PF dues based on the entire amount. In the case of such an employer, if an employee has PF wages defined as, for example, Rs. 50,000 per month and is on Loss of Pay for 15 days out of 30 in April, what should be the EPF wages? Rs. 50,000, Rs. 25,000, or Rs. 15,000?

Thank you for your assistance.

Best regards, [Your Name]