y123-56
33

KINDLY HELP ME CITEHR MEMBERS. PF HAS SAID TO ALL EMPLOYERS TO SUBMIT ANNEXURE-II FOR MISSING DETAIL IN SAME WAY AS WE FILL ECR FORMAT FOR MONTHLY CHALLAN FOR PF BUT THERE IS SINGLE ERROR THAT IS CREATING PROBLEM IN UPLOADING THAT LINE NUMBER 18 IS BLANK.
From India, Mumbai
y123-56
33

Hey Diti, I got the solution.The solution is after creating the text file open it and press backspace button and again save it. Then you will be able to upload it successfully. Regards, Asmita
From India, Mumbai
sweta_mona
hey, thanks Ashmita ...!! all were facing the same problem of blank line...
The solution is after creating the text file open it and press backspace button and again save it. Then you will be able to upload it successfully.
Regards,
Sweta

From India, Mumbai
sweta_mona
Dear Mr. V. Bhosale, Please find the attached instruction.... hope this will help you..!
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: pdf ECR_Annexure-II_15042013.pdf (96.9 KB, 796 views)

A.S.Senthil kumar
25

Dear All,

While searching in google, i came across a video for UPLOADING THE EPFO ANNEXURE-II MISSING MEMBER DETAILS.

The URL:

EPFO Annexure-II (Missing member details updation instruction) - YouTube

Hope it will be useful for all HR's.

Regards,

Senthil

From India, Madras
Pradnya Sushil
1

KINDLY HELP ME CITEHR MEMBERS. PF HAS SAID TO ALL EMPLOYERS TO SUBMIT ANNEXURE-II FOR MISSING DETAIL I WANT .txt FILE FORMAT TO UPLOAD THIS DATA
From India, Mumbai
JAYALAKSHMI BHASKAR
Thanks Asmita!
I was also facing the same problem since y'day. I contacted the concerned PF Office and they were also not able to guide me properly. My colleague happened to check the problems thro this site and we uploaded it successfully.

From India, Bangalore
elfinprincy
How to generate “Annexure-II Text file”?

Ans: “Annexure-II Text file” is plain text file with missing details of Form 5/10 in text format and consist of one line for each member. The separator between fields should be #~# (hash tilde hash). The delimition is like ECR text file but contains information for members’ data in 14 columns.

The Annexure II text file generation menu is available with “E-RETURN TOOL VERSION 5” (next to “generation of ECR menu”), Please upgrade E-return tool software for generating the text file from the software, the Employees’ master should be updated within software.

The text file can also be generated using Excel. Please follow the steps below:

1. Download the .xls file with missing members’ details.

2. Remove rows where all details of members are already available.

3. Fill in the mandatory and optional details in excel.

4. Save the file as “CSV (Comma delimited *.csv).

5. Close Excel.

6. Rename the generated file from .CSV to .TXT (e.g. if the name of csv file is GJAHD0012345.csv then rename to GJAHD0012345.txt).

7. Open the file in any text editor (notepad / wordpad).

8. Remove the header rows. (First three lines)

9. Replace all the , (Comma) with #~# (Hash Tilde Hash).

10. Save the file.

11. Upload the text file.

12. Download the generated pdf file.

13. Verify the pdf and press approve if in order.

From India, Chennai
elfinprincy
Please review the error codes PDF file first along with error log text file.

Few common precautions before uploading the annexure text file are given below:

• Do not modify the structure of given excel file, It should have 14 columns.

• Date format for all the dates should be dd/mm/yyyy (Not dd-mm-yyyy or others).

• Do not change details in Column 1 (Member id) and Column 2 (Member’s name).

• International Worker Field (Column 3) is compulsory and should be either Y or N (single character).

• If Mobile No. (Column 4) and E-mail id (Column 5) are not available they should be kept blank (It is seen that the Annexure II Generated from E-return tool Version 5 may contain 91 in Mobile No. field where mobile number is not available, Please use text editor to remove 91 in mobile no. field where mobile No. is not available).

• Special characters should not be given in father\'s/husband\'s name (Column 6).

• Relationship should be F for father or S for husband (column 7).

• Gender should be M or F or T (Column 9).

• Date of exit (Column 13) cannot be prior to date of joining (Column 11).

• If date of exit (Column 12,13) is given then reason of exit (column 14) is compulsory and should only be Only be any of these : C (Cessation), S (Superannuation), R(Retirement), D (Death in Service), or P (Permanent Disablement).

• Please make sure that no blank line is available in text file (generally last line of the text file is blank while conversion from excel, press backspace on last line to remove blank line). (Error code 021).

• Members’ whose data is already updated or uploaded and approved once is not accepted again; remove the lines of such member ID. (Error code 019).

• Members’ whose details are asked in excel file should only be given; any other member’s details (which is not shown in downloaded excel file) should not be given (Error code 018).

Apart from the questions given above if you have any queries please contact the EDP Section of Office.

Missing details are to be submitted at ESEWA portal only.

From India, Chennai
prabhuloyola@gmail.com
10

How to generate “Annexure-II Text file”?

Ans: “Annexure-II Text file” is plain text file with missing details of Form 5/10 in text format and consist of one line for each member. The separator between fields should be #~# (hash tilde hash). The delimition is like ECR text file but contains information for members’ data in 14 columns.

The Annexure II text file generation menu is available with “E-RETURN TOOL VERSION 5” (next to “generation of ECR menu”), Please upgrade E-return tool software for generating the text file from the software, the Employees’ master should be updated within software.

The text file can also be generated using Excel. Please follow the steps below:

1. Download the .xls file with missing members’ details.

2. Remove rows where all details of members are already available.

3. Fill in the mandatory and optional details in excel.

4. Save the file as “CSV (Comma delimited *.csv).

5. Close Excel.

6. Rename the generated file from .CSV to .TXT (e.g. if the name of csv file is GJAHD0012345.csv then rename to GJAHD0012345.txt).

7. Open the file in any text editor (notepad / wordpad).

8. Remove the header rows. (First three lines)

9. Replace all the , (Comma) with #~# (Hash Tilde Hash).

10. Save the file.

11. Upload the text file.

12. Download the generated pdf file.

13. Verify the pdf and press approve if in order.

Please review the error codes PDF file first along with error log text file.

Few common precautions before uploading the annexure text file are given below:

• Do not modify the structure of given excel file, It should have 14 columns.

• Date format for all the dates should be dd/mm/yyyy (Not dd-mm-yyyy or others).

• Do not change details in Column 1 (Member id) and Column 2 (Member’s name).

• International Worker Field (Column 3) is compulsory and should be either Y or N (single character).

• If Mobile No. (Column 4) and E-mail id (Column 5) are not available they should be kept blank (It is seen that the Annexure II Generated from E-return tool Version 5 may contain 91 in Mobile No. field where mobile number is not available, Please use text editor to remove 91 in mobile no. field where mobile No. is not available).

• Special characters should not be given in father\'s/husband\'s name (Column 6).

• Relationship should be F for father or S for husband (column 7).

• Gender should be M or F or T (Column 9).

• Date of exit (Column 13) cannot be prior to date of joining (Column 11).

• If date of exit (Column 12,13) is given then reason of exit (column 14) is compulsory and should only be Only be any of these : C (Cessation), S (Superannuation), R(Retirement), D (Death in Service), or P (Permanent Disablement).

• Please make sure that no blank line is available in text file (generally last line of the text file is blank while conversion from excel, press backspace on last line to remove blank line). (Error code 021).

• Members’ whose data is already updated or uploaded and approved once is not accepted again; remove the lines of such member ID. (Error code 019).

• Members’ whose details are asked in excel file should only be given; any other member’s details (which is not shown in downloaded excel file) should not be given (Error code 018).

Apart from the questions given above if you have any queries please contact the EDP Section of Office.

Missing details are to be submitted at ESEWA portal only.

From India, Chennai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.