Form IEPF-2 is required to be filed by the company/Corresponding New Bank which shall contain investor wise details of unclaimed and unpaid amounts in respect of dividends, debentures, deposits, etc. The details of unclaimed and unpaid amounts shall need to be provided as on the Annual General Meeting (AGM) date. This form is to be filed annually within 90 days from the date of AGM. The form can be downloaded from the IEPF portal of the Ministry (http://www.iepf.gov.in/)

After the Form IEPF-2 is filled and uploaded on the IEPF portal, you are required to provide the investor wise details of unclaimed and unpaid amount.
Following are the steps which need to be followed to upload the investor wise details of unclaimed and unpaid amounts:
1. Install the Pre-requisite Software's to proceed. To know and install the same click on 'Prerequisite Software' link
2. Download the Excel toolkit
3. Download the excel template from the IEPF portal in the zip format
4. Unzip the zip file and save the template in xls (97-2003) and .xlsm(2007) format only
5. Fill the required details in the excel file

• The excel template is having three worksheets

ReadMe – Worksheet having instructions to fill the investor details. The users should go through these instructions before filling the investor details so that minimal errors are occurred.

Investor Details – Worksheet in which users have to enter the details of unclaimed and unpaid amounts.

Error – Worksheet in which errors shall be displayed upon click of Validate button in Investor Details,

• In Investor Details worksheet,

• The user is required to enable the Macros in downloaded excel template so that offline validations can be performed through the Validate button.

It is important that you Enable Macro using following instructions:

• Excel 2003: Tools-->Macro-->Security-->Select 'Low'-->OK
• Excel 2007: Office Button-->Excel Options-->Trust Center-->Trust Center Settings-->Macro Settings-->Enable all Macros-->OK

Please Note: Close the Excel Sheet and re-open it after enabling Macro to start.

For all other excel types please use the help functionality of the Excel.

• The users is required to enter the valid CIN against CIN text field
• On click of the Prefill button, the company name against company name field or Corresponding New Bank name shall be filled automatically.
• The user is required to enter the required details Columns A to O for Investor Details (row 15 onwards) like First Name, Middle Name, Last Name, Address, Country, State etc
• The user is required to select the Country, State, District and Investment Type.
• The date should be in DD-Mon-YYYYformat.
• The user can also copy the entire set of columns from other sources and paste into investor details Columns A to O for Investor Details (row 15 onwards) in downloaded excel template.
• Once the entire investor details are entered or copied, the user is required to press the Validate button for the below mentioned offline validations:
• Investor First Name -> Mandatory if Last Name is blank and Length should be less or equal to 35 characters.
• Investor Middle Name -> Length should be less or equal to 35 characters.
• Investor Last Name -> Mandatory if First Name is blank and Length should be less or equal to 35 characters.
• Father/Husband First Name -> Mandatory if Father/Husband Last Name is blank and Length should be less or equal to 35 characters.
• Father/Husband Second Name -> Length should be less or equal to 35 characters.
• Father/Husband Last Name -> Mandatory if Father/Husband First Name is blank and Length should be less or equal to 35 characters
• Address -> Mandatory and Length should be less or equal to 300 characters
• Country -> Mandatory and List of all countries shall be there.

If the Country is other than INDIA state will be “NA”.

• State -> Mandatory and If the Country is “INDIA”, the state should Indian state
• District -> If the Country is “INDIA”, the district should be Indian districts corresponding to the state selected in dropdown.
• Pincode -> Mandatory and Length should be less or equal to 35 characters.
• Folio Number -> Mandatory and Length should be equal to 20 characters.
• Investment Type -> Mandatory and Length should be less or equal to 35 characters.

• The errors identified shall be displayed in the ‘Error’ worksheet.
• Once all the listed errors are removed, the user shall save the updated excel sheet.

• Filled in excel file needs to be uploaded on the IEPF portal within 14 days of upload of eForm IEPF-2.
• For Uploading the excel file on IEPF portal:

• Click on the link ‘ Upload investor-wise details of unclaimed and unpaid amounts’ on the IEPF sub-site. The path for the same is as follows:

MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Upload Investor Details

• Enter the User ID, Password (provided at the time of upload of eForm IEPF-2) along with SRN of Form IEPF-2 and CIN. Please ensure that the details entered are correct.
• Click on validate button. After the details are validated, upload the excel file containing investor-wise details of unclaimed and unpaid amounts .
• Multiple excel files can be uploaded in respect of a particular Form IEPF-2, if required. All the excel files should be uploaded within the aforesaid time period.
• Ensure that the correct details are uploaded on the IEPF portal as an excel file once uploaded cannot be deleted. To modify the details, the excel file with the same file name shall have to be uploaded which shall replace the earlier file.
• In case no excel file is uploaded within the prescribed time limit, the filing of Form IEPF-2 shall be treated as Defective and the form shall be rejected.

• To confirm the upload of the investor-wise details, following steps are to be followed:
• Click on “Confirm Upload of unclaimed and unpaid amount details”. Path for the same is as follows:
• MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Confirm Uploaded Files
• Enter the CIN and SRN details and clicks on “Confirm” button.
• On successful confirmation, the details shall be processed and thereafter the Form IEPF-2 shall be marked as ‘Approved’.
• In case uploaded excel files are not confirmed within the aforesaid time period, then the same will be automatically confirmed by the system.

Please note that the filing of Form IEPF-2 shall be treated as complete only after the excel file(s) are uploaded and confirmed.

Ensure that the correct details are uploaded on the IEPF portal as excel file once uploaded cannot be deleted.

To modify the details, an excel file with the same file name (as of the original file) shall have to be uploaded which shall replace the original file.

Please note that no excel file can be modified after the upload has been confirmed. After confirmation, the details shall be processed and shall not be allowed to be modified.

In case no excel file is uploaded within the prescribed time limit, the filing of Form IEPF-2 shall be treated as Defective and the form shall be rejected.

The upload of excel file needs to be confirmed within 15 days of upload of eForm IEPF-2.

In case uploaded excel file(s) are not confirmed within the prescribed time period, the same will be automatically confirmed by the system.

No, there shall not be any fee required to be paid for Form IEPF-5.

In case the form has been marked as defective, its filing shall be cancelled and shall stand rejected. You will have to file it again on the IEPF portal. Thereafter you shall be required to upload the excel files again and confirm the same.

In case the Form IEPF-2 is marked as defective, the status of the SRN is changed to Rejected. Following are the scenarios in which Form IEPF-2 will be marked as defective:
a. In case there is a mismatch in the CIN/CNBIN, company/ Bank name entered in the excel file (Investor-wise details of unclaimed and unpaid amount) vis-à-vis the information filed in the eForm IEPF-2;
b. On non-fulfillment of mandatory validations, ,
c. In case there is a mismatch between the sum of amount due in respect of all investors as entered in the excel file(s) (Investor-wise details of unclaimed and unpaid amount) vis-à-vis the total unclaimed and unpaid amount as entered in the eForm IEPF-2.
d. In case no excel file is uploaded within 14 days of upload of eForm IEPF-2.

• MS Office (97 and above)
• Microsoft Office XP Web Services Toolkit 2.0

• MS Office (97 and above) needs to be purchased by the user from market
• Microsoft Office XP Web Services Toolkit 2.0. Click here to download

A search facility is provided for the investors to search for unclaimed and unpaid amount standing to the investor’s credit. The following are the steps to be followed for searching the amount:

a. Click on the link ‘ Search for unclaimed and unpaid amounts of investors ’ on the IEPF sub-site. The path for the same is as follows:

MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Search Unclaimed/Unpaid

Amount

c. Search can be done using following combinations:

• Investor Name (in full or part) and Father/Husband Name (in full or part)
• Investor Name (in full) and Company name (in full or part)
• Folio Number (should be same as per certificate)

d. The investor-wise details using the criteria specified shall be displayed.

In case you have not downloaded the Excel toolkit this error gets displayed. It is mandatory to download the Excel Toolkit before filling the investor-wise details in the Excel. Please click the following link to download the Excel Toolkit. Click here to download

As per the Investor Education and Protection Fund (Uploading of information regarding unpaid and unclaimed amounts lying with companies) Rules, 2012, Form IEPF-2 is required to be filed only in case there are unclaimed and unpaid amounts as referred to in sub-section (2) of section 205C of the Act.

In case the company does not have any unclaimed and unpaid amounts as on the date of AGM, then in such case, it is not required to file Form IEPF-2.

One form IEPF-2 is to be filed containing details of unclaimed and unpaid amounts for all the previous seven years. Refer circular number 17/ 2012 and 20/2012 for more details in this regard.

Yes, you may either prepare a consolidated excel for all the years or use separate Excel sheets for each year.

In case the investor is a non-individual, in the first name column- name of the investor should be entered. In the columns for Last Name and Father's name- 'Not Applicable' may be entered.

Details of small shareholders is to be provided as per the provisions of the Companies Act, 2013.

Yes, the companies are required to file one Form IEPF-2 each year containing details of unclaimed and unpaid amounts of previous seven years pending as on date of AGM of that year. The form is to be filed every year within a period of 90 days after the holding of Annual General Meeting or the date on which the AGM should have been held. Refer circular number 17/ 2012 and 20/2012 for more information in this regard.

The details are required to be submitted in the excel template only. You can prepare multiple excel files for uploading on the IEPF website. You may use MS -Excel 2007(.xlsm) format to reduce the size of the excel files.