Read the following instructions carefully before proceeding to
Important Note
Steps to follow to fill details in the 'Investor De
Enable Macros
Enter the CIN
Add Investor Details
Save the Excel file
Upload the Excel file
Read the following instructions carefully before proceeding to enter the Investor Details:
(i)Install the pre-requisite softwares to proceed. The path for the same is as follows:
MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Prerequisite Software
(ii) Upload the excel file in the format xls only
(iii) Do not make any changes in the excel format/sheet name. Also do not delete any tab/sheet in the file
PLEASE NOTE:
1) Kindly ensure that Summation of amounts in the excel(s) should be equal to that in IEPF Form, else your excel shall get rejected
2) Kindly ensure that AGM Date in the excel(s) should be same as in IEPF Form, else your excel shall get rejected.
Steps to follow to fill details in the 'Investor Details' tab.
It is important that you Enable Macro using following instructions :
a) Excel 2000 and 2003: Tools-->Macro-->Security-->Select 'Low'-->OK
b) Excel 2007: Office Button-->Excel Options-->Trust Center-->Trust Center Settings--Macro Settings-->Enable all Macros-->OK
Pl Note : Close the Excel Sheet and re-open it after enabling Macro to start.
(i) Enter the CIN in the excel (cell B2)
(ii) Click on "Prefill" button
(iii) Company Name will be automatically filled on click of prefill button . User need not enter it.
(i) Fill in the required details in Columns A to P for Investor Details (row 15 onwards)
(ii) Follow the below mentioned validations for filling in the details.
First Name -> Mandatory if 'Last Name' is blank and Length should be less or equal to 35 characters.
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 Middle 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 Select value from the dropdown.
State -> Mandatory and Select value from the dropdown.
(1)If the Country is “INDIA”, the state should Indian state
(2)If the Country is other than INDIA state should be “NA”.
District -> Select value from the dropdown.
(1)If the Country is “INDIA”, the district should be Indian districts corresponding to the State selected in dropdown.
(2)If the Country is other than INDIA district will be “NA”
Pin code -> Alphanumeric and Length should be eithe 6 or 12 dight
Folio Number -> Mandatory and Length should be less than or equal to 20 characters.
Investment Type -> Select value from the dropdown.
Amount Due -> Mandatory and should be greater than zero.
Date of Event-> should be in DD-MON-YYYY format where 'MON' implies first three letters of Month.
(iii) Click on "Validate" button
(iii) Details of the Errors will be shown in "Error" Sheet.
*Make sure that Error sheet contains no errors.
If you have multiple excels for the same CIN and SRN; use the below nomenclature:
(ABC_1.xls, ABC_2.xls,ABC_3.xls ...) where ABC represents the CIN of the Company
Path to upload the excel file is HOME -> IEPF SERVICES -> Upload Investor details.
Note: This sheet is applicable for uploading the particulars related to the unclaimed and unpaid amount pending with co
Make sure that the details are in accordance with the information already provided in e-form IEPF-2
CIN/BCIN L65910MH1987PLC042961 Prefill
Sum of unpaid and unclaimed dividend 0.00
Sum of matured deposit 42000.00
Sum of matured debentures 0.00
Sum of application money due for refund 0.00
Sales proceed for fractional shares 0.00
Investor First Investor Middle Investor Last Father/Husband Father/Husband
Name Name Name First Name Middle Name
MADHAV KESHAV KHANDEKAR NA NA
PRADNYA ATUL KARMARKAR NA NA
SMITA KIRAN VADALKAR NA NA
GANESH WAMAN LELE NA NA
PRADIP CHACKO KURIAN NA NA
PRADIP CHACKO KURIAN NA NA
PRADIP CHACKO KURIAN NA NA
PRAMOD THOMAS KURIAN NA NA
PRAMOD THOMAS KURIAN NA NA
THANKAMMA KURIAN NA NA
THANKAMMA KURIAN NA NA
THANKAMMA KURIAN NA NA
GANESH WAMAN LELE NA NA
DIVAKAR DATTATRAYA MONE NA NA
DIVAKAR DATTATRAYA MONE NA NA
GANESH WAMAN LELE NA NA
PURECHA HARSHASUDAN HIRJI NA NA
PURECHA SMITA HARSHSUDAN NA NA
THANKAMMA KURIAN NA NA
HARSHA HIRALAL VORA NA NA
MADHURIKA PRAVIN HAKANI NA NA
MADHURIKA P HAKANI NA NA
MADHURIKA P HAKANI NA NA
MADHURIKA PRAVIN HAKANI NA NA
NEETA RAVINDRANATH PATANKAR NA NA
ANURADHA JAGDISH BHAT NA NA
ANURADHA JAGDISH BHAT NA NA
GANESH WAMAN LELE NA NA
PREETI RAGHUNATH SOWANI NA NA
ANUSAYA VASUDEO PATIL NA NA
SHIRIN NOSHIR SETHNA NA NA
VARSHA JYOTINDRA KAPADIA NA NA
VARSHA JYOTINDRA KAPADIA NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
ANJALI SURESHCHANDRABAPAT NA NA
INDRAVADAN AMRITLAL GANDHI NA NA
INDRAVADAN AMRITLAL GANDHI NA NA
INDRAVADAN AMRITLAL GANDHI NA NA
INDRAVADAN AMRITLAL GANDHI NA NA
INDRAVADAN AMRITLAL GANDHI NA NA
INDRAVADAN AMRITLAL GANDHI NA NA
RUKMINI KRISHNA GOGARKAR NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
NIEPCE COUTINHO NA NA
PRAMOD THOMAS KURIAN NA NA
ANAHITA MOTU MOTTABHOY NA NA
ANAHITA MOTU MOTTABHOY NA NA
ANAHITA MOTU MOTTABHOY NA NA
BINAIFER MOTU MOTTABHOY NA NA
BINAIFER MOTU MOTTABHOY NA NA
BINAIFER MOTU MOTTABHOY NA NA
BARBARA PIERRE NA NA
BARBARA PIERRE NA NA
BARBARA PIERRE NA NA
BARBARA PIERRE NA NA
BHAGWANDAS MORARJI THAKKAR NA NA
MADHAV KESHAV KHANDEKAR NA NA
PRADNYA ATUL KARMARKAR NA NA
d and unpaid amount pending with company.
d in e-form IEPF-2
Company/Bank Name BAJAJ FINANCE LIMITED
0.00 Sum of interest on matured debentures
42000.00 Sum of interest on matured deposit
0.00 Sum of interest on application money due for refund
0.00 Redemption amount of preference shares
0.00 Validate Clear
Father/Husband Last
Address Country State
Name
NA VAIBHAV B 3 GULMDHAR MARG CHU INDIA MAHARASHTRA
NA B-11 YOGISHWAR SOCIETY NEAR P INDIA GUJARAT
NA FLAT NO 2 SHREE CHAITANYA APARTINDIA MAHARASHTRA
NA 2-38 DATTA RAMANAND CHS,HANUMA INDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA 107/2 SHANKARA PRASAD,9TH CROINDIA MAHARASHTRA
NA 107/2 SHANKARA PRASAD,9TH CROINDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA 2-38 DATTA RAMANAND CHS,HANUMA INDIA MAHARASHTRA
NA 120 A-B 545/4 FLAT NO 501 YAMU INDIA MAHARASHTRA
NA 120 A-B 545/4 FLAT NO 501 YAMU INDIA MAHARASHTRA
NA 2-38 DATTA RAMANAND CHS,HANUMA INDIA MAHARASHTRA
NA A 45 SHASTRI NAGAR S V ROAD,S V INDIA MAHARASHTRA
NA A 45 SHASTRI NAGAR,81 MOHAMEDINDIA MAHARASHTRA
NA B 102 SHUBH SHANTI COMPLEX,M INDIA MAHARASHTRA
NA B 25 SNEH KUTIR CHS AMRUT NAG INDIA MAHARASHTRA
NA 25 MADHULAXMI RUNANUBANDH SOC INDIA MAHARASHTRA
NA 25 MADHULAXMI RUNANUBANDH SOC INDIA MAHARASHTRA
NA 25 MADHULAXMI RUNANUBANDH SOC INDIA MAHARASHTRA
NA 25 MADHULAXMI RUNANUBANDH SOC INDIA MAHARASHTRA
NA A 304 SWARALATA APT B/H DEODH INDIA MAHARASHTRA
NA 703 PUSHPAMANGAL COMPLEX BLDG INDIA MAHARASHTRA
NA 703 PUSHPAMANGAL COMPLEX BLDG INDIA MAHARASHTRA
NA 2-38 DATTA RAMANAND CHS,HANUMA INDIA MAHARASHTRA
NA C/O KUMUD A KHARE RAGHUKUL,38INDIA MAHARASHTRA
NA C/O J V PATIL DREAMS COMPLEX,4CINDIA MAHARASHTRA
NA C/O MRS P N SETHINA,SONA MAHALINDIA MAHARASHTRA
NA SHANTIKAMAL SOC FIRST FLOOR,VAINDIA MAHARASHTRA
NA SHANTIKAMAL SOC FIRST FLOOR,VAINDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA B 10 VRUDESHWAR C H S,BIBWEWAD INDIA MAHARASHTRA
NA MAJITHIA NAGAR BLOCK NO 4-B-11,INDIA MAHARASHTRA
NA MAJITHIA NAGAR BLOCK NO 4-B-11,INDIA MAHARASHTRA
NA MAJITHIA NAGAR BLOCK NO 4-B-11,INDIA MAHARASHTRA
NA MAJITHIA NAGAR BLOCK NO 4-B-11,INDIA MAHARASHTRA
NA MAJITHIA NAGAR BLOCK NO 4-B-11,INDIA MAHARASHTRA
NA MAJITHIA NAGAR BLOCK NO 4-B-11,INDIA MAHARASHTRA
NA KARMAYOG HOUSING SOCIETY RUPIINDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 1/B EDENA (1ST FLOOR),97 MAHA INDIA MAHARASHTRA
NA 107/2 SHANKARA PRASAD,9TH CROINDIA MAHARASHTRA
NA 10 MADHOOLI 2ND FLOOR CARTER RINDIA MAHARASHTRA
NA 10 MADHOOLI 2ND FLOOR CARTER RINDIA MAHARASHTRA
NA 10 MADHOOLI 2ND FLOOR CARTER RINDIA MAHARASHTRA
NA 10 MADHOOLI 2ND FLOOR CARTER RINDIA MAHARASHTRA
NA 10 MADHOOLI 2ND FLOOR CARTER RINDIA MAHARASHTRA
NA 10 MADHOOLI 2ND FLOOR CARTER RINDIA MAHARASHTRA
NA 102/B NANDANVAN APARTMENT,KAT INDIA MAHARASHTRA
NA 102/B NANDANVAN APARTMENT,KAT INDIA MAHARASHTRA
NA 102/B NANDANVAN APARTMENT,KAT INDIA MAHARASHTRA
NA 102/B NANDANVAN APARTMENT,KAT INDIA MAHARASHTRA
NA 22 DR WILSON STREET,V P ROAD,M INDIA MAHARASHTRA
NA 22 DR WILSON STREET,V P ROAD,M INDIA GUJARAT
NA VAIBHAV B 3 GULMDHAR MARG CHU INDIA MAHARASHTRA
Date Of AGM(DD-MON-YYYY) 19-JUL-2018
ures 0.00
41660.15
ey due for refund 0.00
shares 0.00
DP Id-Client Id-
District Pin Code Folio Number
Account Number
MUMBAI 400022 PBFL728341
VADODARA 390010 PBFL728342
PUNE 411009 PBFL728501
MUMBAI 400057 PBFL222911
MUMBAI 400067 PBFL222818
MUMBAI 400067 PBFL222818
MUMBAI 400067 PBFL222818
MUMBAI 400067 PBFL222819
MUMBAI 400067 PBFL222819
MUMBAI 400067 PBFL222820
MUMBAI 400067 PBFL222820
MUMBAI 400067 PBFL222820
MUMBAI 400057 PBFL222911
PUNE 411030 PBFL222831
PUNE 411030 PBFL222831
MUMBAI 400057 PBFL222911
MUMBAI 400092 PBFL222897
MUMBAI 400092 PBFL222898
MUMBAI 400067 PBFL222820
MUMBAI 400093 PBFL728322
PUNE 411007 PBFL728291
PUNE 411007 PBFL728292
PUNE 411007 PBFL728293
PUNE 411007 PBFL728294
THANE 400602 PBFL222882
THANE 400601 PBFL222862
THANE 400601 PBFL222862
MUMBAI 400057 PBFL222911
PUNE 411004 PBFL222864
MUMBAI 400078 PBFL728452
MUMBAI 400020 PBFL222891
MUMBAI 400054 PBFL222892
MUMBAI 400054 PBFL222892
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
PUNE 411037 PBFL509998
MUMBAI 400067 PBFL222900
MUMBAI 400067 PBFL222900
MUMBAI 400067 PBFL222900
MUMBAI 400067 PBFL222900
MUMBAI 400067 PBFL222900
MUMBAI 400067 PBFL222900
DEHU ROAD CANTT 412114 PBFL510003
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400004 PBFL222941
MUMBAI 400067 PBFL222944
PUNE 411001 PBFL222953
PUNE 411001 PBFL222953
PUNE 411001 PBFL222953
PUNE 411001 PBFL222952
PUNE 411001 PBFL222952
PUNE 411001 PBFL222952
MUMBAI 400012 PBFL222961
MUMBAI 400012 PBFL222961
MUMBAI 400012 PBFL222961
MUMBAI 400012 PBFL222961
MUMBAI 400004 PBFL727472
AHMEDABAD 380015 PBFL727844
MUMBAI 400022 PBFL728341
Proposed Date of
Amount
Investment Type transfer to IEPF
transferred
(DD-MON-YYYY)
Interest on matured deposits 1,165.00 01-APR-2019
Interest on matured deposits 1,398.00 01-APR-2019
Interest on matured deposits 1,904.00 30-SEP-2019
Interest on matured deposits 525.00 30-SEP-2018
Interest on matured deposits 437.50 01-OCT-2018
Interest on matured deposits 437.50 01-OCT-2018
Interest on matured deposits 437.50 01-OCT-2018
Interest on matured deposits 437.50 18-OCT-2018
Interest on matured deposits 437.50 18-OCT-2018
Interest on matured deposits 437.50 18-OCT-2018
Interest on matured deposits 437.50 18-OCT-2018
Interest on matured deposits 437.50 18-OCT-2018
Interest on matured deposits 525.00 31-DEC-2018
Interest on matured deposits 437.50 06-MAR-2019
Interest on matured deposits 437.50 06-MAR-2019
Interest on matured deposits 525.00 31-MAR-2019
Interest on matured deposits 437.50 31-MAR-2019
Interest on matured deposits 437.50 31-MAR-2019
Interest on matured deposits 437.50 18-OCT-2018
Interest on matured deposits 3,495.00 01-APR-2019
Interest on matured deposits 1,165.00 01-APR-2019
Interest on matured deposits 1,165.00 01-APR-2019
Interest on matured deposits 1,398.00 01-APR-2019
Interest on matured deposits 1,398.00 01-APR-2019
Interest on matured deposits 1.20 01-APR-2019
Interest on matured deposits 437.50 18-SEP-2019
Interest on matured deposits 371.58 18-SEP-2019
Interest on matured deposits 525.00 30-SEP-2019
Interest on matured deposits 437.50 09-OCT-2019
Interest on matured deposits 3,495.00 12-DEC-2019
Interest on matured deposits 1.92 01-APR-2020
Interest on matured deposits 700.00 01-APR-2020
Interest on matured deposits 1.92 01-APR-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 291.67 03-JUL-2020
Interest on matured deposits 8.00 03-JUL-2020
Interest on matured deposits 388.36 12-JUL-2020
Interest on matured deposits 437.50 12-JUL-2020
Interest on matured deposits 437.50 12-JUL-2020
Interest on matured deposits 437.50 12-JUL-2020
Interest on matured deposits 437.50 12-JUL-2020
Interest on matured deposits 49.14 12-JUL-2020
Interest on matured deposits 166.22 13-JUL-2020
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 700.00 05-SEP-2021
Interest on matured deposits 437.50 18-OCT-2021
Interest on matured deposits 525.00 01-APR-2022
Interest on matured deposits 523.56 01-APR-2022
Interest on matured deposits 525.00 01-APR-2022
Interest on matured deposits 525.00 01-APR-2022
Interest on matured deposits 523.56 01-APR-2022
Interest on matured deposits 525.00 01-APR-2022
Interest on matured deposits 437.50 26-JUL-2022
Interest on matured deposits 437.50 26-JUL-2022
Interest on matured deposits 437.50 26-JUL-2022
Interest on matured deposits 437.50 26-JUL-2022
Amount for matured deposits 31,000.00 02-MAR-2019
Amount for matured deposits 5,000.00 01-APR-2019
Amount for matured deposits 6,000.00 01-APR-2019
