Dear Friends I it very important version ECR 2.0 is mandatory read it & create the new ECR 2.0 file.
From India, Cuttack
Acknowledge(5)
Amend(0)
28From India, Cuttack
Acknowledge(5)Amend(0)
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
From India, Cuttack
Acknowledge(1)Amend(0)
---
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
From India, Cuttack
Acknowledge(1)Amend(0)
Dear sir, Any one pls send model ECR Xcell sheet pls help to how to upload ecr file to epf site we need practical Model excel sheet need sir
From India, Chennai
Acknowledge(1)Amend(0)
From India, Chennai
Acknowledge(1)Amend(0)
Ecr 2 consist of 11 fields which are separated by #~# how to make this file from excel please reply.
From India,
Acknowledge(0)Amend(0)
From India,
Acknowledge(0)Amend(0)
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
From India, Kolkata
Acknowledge(0)Amend(0)
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
From India, Kolkata
Acknowledge(0)Amend(0)
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
From India, Bengaluru
Acknowledge(2)
Amend(0)
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
From India, Bengaluru
Acknowledge(2)Amend(0)
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
From India, Bengaluru
Acknowledge(2)Amend(0)
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
From India, Bengaluru
Acknowledge(2)Amend(0)
Dear All Wish U Happy New Year All Frds download new ecr file version 2.0
From India, Cuttack
Acknowledge(2)Amend(0)
From India, Cuttack
Acknowledge(2)Amend(0)
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.
From India, Kanpur
Acknowledge(2)
Amend(0)
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.
From India, Kanpur
Acknowledge(2)Amend(0)
Hi Can anyone confirms, here in this new format " Gross Wages" means Basic component or Gross salary ? which includes all salary perks?? please do let me know. Thank you for your valuable time.
From India, undefined
Acknowledge(0)Amend(0)
From India, undefined
Acknowledge(0)Amend(0)
Can any one plz let me know how to prepare this(ECR File Version 2) in E-Return Tool 6.1?
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Dear friends, please suggest the meaning of gross wages in ECR 2.0.
From India, Suri
Acknowledge(0)Amend(0)
From India, Suri
Acknowledge(0)Amend(0)
Respected Seniors, please anyone can explain what does gross salary and EDLI wages means in ecr version 2. Thanks Regards Oshin Sharma
From India, Chandigarh
Acknowledge(0)Amend(0)
From India, Chandigarh
Acknowledge(0)Amend(0)
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
From India, Chennai
Acknowledge(0)Amend(0)
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
From India, Chennai
Acknowledge(0)Amend(0)
Kindly give information to show the exit employees and new employees in new uan based ecr. Also how to get the confirmation slip.
From India, Bhubaneswar
Acknowledge(0)Amend(0)
From India, Bhubaneswar
Acknowledge(0)Amend(0)
Dear sir, Any one pls send model ECR Xcell sheet pls help to how to upload ecr file to epf site we need practical Model excel sheet need sir i need Exempted category of company Like Trust and Company
From India, Chennai
Acknowledge(0)Amend(0)
From India, Chennai
Acknowledge(0)Amend(0)
while uploading ecr am getting this error Error Total Number of Fields: Invalid found on line numbers: Can you please guide me plsss
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
hi seniors, can any one help me to find out diff ee con & er con in new ecr salary enrty.. urgent
From India, Kochi
Acknowledge(0)Amend(0)
From India, Kochi
Acknowledge(0)Amend(0)
Dear Sir, How to validate excel file with new ecr tool version 2.0 or how can we upload in ecr main jar?. Thanks
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
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]
From India, Gurgaon
Acknowledge(0)Amend(0)
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]
From India, Gurgaon
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.
UAN BASED ECR EXCEL.xls
Mandatory seeding of Aadhaar to file ECR 1.6.2021.jpg