TR NO.,TR PUNCH DATE,LI Receipt No/UNO Receipt No,Policy No/Certificate No,SFS TR Status,SFS TR Status Remarks,Certificate Status,Pending Requirements,Policy Issue Date,Maturity Date,Invested Interest Rate,Maturity Amount,TR PRODUCT,COMPANY NAME,TR Company.Ref Code,TR PLAN NAME,Tax Free Bond,Transaction Nature,Policy Term,Bank Name,Cheque Date,Cheque No.,Cheque Amount,Customer Name,House No. & Street Name,Building / Society Name,Area,City,state,Pincode,Phone Number,Mobile Number,E-Mail ID,Gender,Receipt Amount,Date Of Birth,PAN Number,Aadhaar Number,MIS MAIN TYPE,MIS SUB TYPE,MIS POLICY AMT.,MIS APE AMT.,MIS COMM. %,MIS COMM. AMT.,Gross Comm Amt,Comm ST Amt,COMM PAYMENT REMARKS,Comm Payment Ref No,Comm Pay Mode,Comm Pay Date,REASON FOR NON-PAYMENT,Chq/NEFT NO,PAYMENT REF. NO.,Comm Cycle Name,Paid Bank Name,Paid Account No,TR BA/CP CODE,TR BA/CP NAME,TR CHANNEL,TR Location Type,Reporting Code,Reporting Name,Type,INSTALMENT_NUMBER,Tenure
1611070304,7-Nov-2016,1611070009,50690132,Confirmed,,Live,,14-Nov-2016,14-Nov-2021,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50136514,7-Nov-2016,0,100000.00,RONALD RAPHAEL MANI,CHOTANI ROAD,C-7  PINK ROSE MIA MOHAMMED,MAHIM 9820504372,MUMBAI,MAHARASHTRA,400016,,9820504372,RRMANI@REDIFFMAIL.COM,M,100000.00,23-10-43,ADHPM6291R,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,0.00,0.00,1300.00,,Paid,2016111701,NEFT,7-Nov-2016, DEPOSIT COMMISSION HAS PROCESSED AS ON17 Nov 2016,611183056778,2016111701,DEP NOV 16 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1611090300,9-Nov-2016,1611090014,50691706,Confirmed,,Live,,20-Nov-2016,20-Nov-2021,,300000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50138316,9-Nov-2016,0,300000.00,RONALD RAPHAEL MANI,CHOTANI ROAD,C-7  PINK ROSE MIA MOHAMMED,MAHIM 9820504372,MUMBAI,MAHARASHTRA,400016,,9820504372,RRMANI@REDIFFMAIL.COM,M,300000.00,23-10-43,ADHPM6291R,,,FIXED DEPOSIT RECEIPT,300000.00,300000.00,0.00,0.00,3900.00,,Paid,2016120501,NEFT,9-Nov-2016, DEPOSIT COMMISSION HAS PROCESSED AS ON05 Dec 2016,612063124610,2016120501,DEPOSIT NOV 16 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1612150570,15-Dec-2016,1612150002,50700018,Confirmed,,CLOSED,,14-Dec-2016,14-Dec-2021,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,UNITED BANK OF INDIA,6-Dec-2016,644116,100000.00,MEENA VILAS FEDANE,7 BUNGALOWS ANDHERI,304 PRIDE RAHEJA COMPLEX,VESAVA,MUMBAI,MAHARASHTRA,400061,,9819006710,,F,100000.00,03-11-43,AAAPF3559R,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,0.00,0.00,1300.00,,Paid,2017010701,NEFT,6-Dec-2016, DEPOSIT COMMISSION HAS PROCESSED AS ON07 Jan 2017,701094222239,2017010701,DEPOSIT DEC-16 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1612150453,15-Dec-2016,1612150004,50700019,Confirmed,,Live,,13-Dec-2016,13-Dec-2020,,600000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,4,AXIS BANK LIMITED,7-Dec-2016,269716,600000.00,CAVAS F BILIMORIA,NEXT TO SIMLA HOUSE,S-24 GODREJ BAUG N P GODREJ MARG,NAPEAN SEA ROAD,MUMBAI,MAHARASHTRA,400036,,9930417501,,M,600000.00,25-07-41,ACFPB3135Q,,,FIXED DEPOSIT RECEIPT,600000.00,600000.00,0.00,0.00,7200.00,,Paid,2017010701,NEFT,7-Dec-2016, DEPOSIT COMMISSION HAS PROCESSED AS ON07 Jan 2017,701094222239,2017010701,DEPOSIT DEC-16 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,48
1701160360,16-Jan-2017,1701160001,50715667,Confirmed,,Live,,11-Jan-2017,11-Jan-2022,,75200.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,ICICI BANK LTD,10-Jan-2017,034145,50000.00,RITA SANDIP RAY,"OPP ST LOUIS HIGH SCHOOL, 4 BUNGLOWS","A/7, DASWANI CHS LTD, CONVENT AVENUE,",ANDHERI- WEST,MUMBAI,MAHARASHTRA,400053,,9323146883,,F,50000.00,18-08-55,ALUPR2188M,,,SPECIAL DEPOSIT RECEIPT,50000.00,50000.00,0.00,0.00,650.00,,Paid,2017020201,NEFT,10-Jan-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON02 Feb 2017,702094600036,2017020201,DEPOSIT JAN 2017 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1702060245,6-Feb-2017,1702060001,50722183,Confirmed,,Live,,30-Jan-2017,30-Jan-2022,,500000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50164246,6-Feb-2017,0,500000.00,CAVAS F BILIMORIA,NEXT TO SIMLA HOUSE,S-24 GODREJ BAUG N P GODREJ MARG,NAPEAN SEA ROAD,MUMBAI,MAHARASHTRA,400036,,9930417501,,M,500000.00,25-07-41,ACFPB3135Q,,,FIXED DEPOSIT RECEIPT,500000.00,500000.00,0.00,0.00,6500.00,,Paid,2017022101,NEFT,6-Feb-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON21 Feb 2017,702221270487,2017022101,DEPOSIT FEB-2017 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1703250766,25-Mar-2017,1703250001,50740348,Confirmed,,Live,,24-Mar-2017,24-Mar-2022,,200000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,ICICI BANK LTD,23-Mar-2017,292818,200000.00,UMESH B WAGLE,OFF LINK ROAD OSHIWARA MUMBAI,H 203 SERENITY COMPLEX,OSHIWARA,MUMBAI,MAHARASHTRA,400102,,9819015119,,M,200000.00,25-06-59,AAAPW3107C,,,FIXED DEPOSIT RECEIPT,200000.00,200000.00,0.00,0.00,2600.00,,Paid,2017040602,NEFT,23-Mar-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON06 Apr 2017,704107488363,2017040602,2017040602,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1703250564,25-Mar-2017,1703250002,50740349,Confirmed,,Live,,24-Mar-2017,24-Mar-2022,,50000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,PUNJAB AND MAHARASHTRA CO OPERATIVE BANK,23-Mar-2017,000005,50000.00,PRACHI U WAGLE,OFF LINK ROAD,H-203 SCRENITY COMPLEX,OSHIWARA,MUMBAI,MAHARASHTRA,400102,,9920162226,,F,50000.00,12-09-93,ACRPW9322N,,,FIXED DEPOSIT RECEIPT,50000.00,50000.00,0.00,0.00,650.00,,Paid,2017040602,NEFT,23-Mar-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON06 Apr 2017,704107488363,2017040602,2017040602,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1703250566,25-Mar-2017,1703250003,50740350,Confirmed,,Live,,24-Mar-2017,24-Mar-2022,,50000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,PUNJAB AND MAHARASHTRA CO OPERATIVE BANK,23-Mar-2017,721441,50000.00,ANURADHA U WAGLE,OSHIWARS,H 203 SERINTY COMPLEX  OPP LINK ROAD,,MUMBAI,MAHARASHTRA,400010,,,,F,50000.00,30-09-61,AAWPW5921A,,,FIXED DEPOSIT RECEIPT,50000.00,50000.00,0.00,0.00,650.00,,Paid,2017040602,NEFT,23-Mar-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON06 Apr 2017,704107488363,2017040602,2017040602,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1702260106,26-Feb-2017,1702260010,50730530,Confirmed,,Live,,4-Mar-2017,4-Mar-2022,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50176925,26-Feb-2017,0,100000.00,KAMAL NARAYAN VELANKAR,RAM MARUTI ROAD (EXT),"FLAT NO.10, VIDHATA",DADAR (W),MUMBAI,MAHARASHTRA,400028,24302698,,,F,100000.00,24-09-42,AANPV4005D,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,0.00,0.00,1300.00,,Paid,2017032101,NEFT,26-Feb-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON21 Mar 2017,703243284060,2017032101,DEPOSIT MAR-2017 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1702020147,2-Feb-2017,1702020006,50723730,Confirmed,,Live,,14-Feb-2017,14-Feb-2022,,100000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50168459,2-Feb-2017,0,100000.00,KAMAL NARAYAN VELANKAR,RAM MARUTI ROAD (EXT),"FLAT NO.10, VIDHATA",DADAR (W),MUMBAI,MAHARASHTRA,400028,24302698,,,F,100000.00,24-09-42,AANPV4005D,,,FIXED DEPOSIT RECEIPT,100000.00,100000.00,0.00,0.00,1300.00,,Paid,2017022101,NEFT,2-Feb-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON21 Feb 2017,702221270487,2017022101,DEPOSIT FEB-2017 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1702090309,9-Feb-2017,1702090010,50725634,Confirmed,,Live,,18-Feb-2017,18-Feb-2022,,37150.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50169941,9-Feb-2017,0,25000.00,SANDESHA M HALWAY,MANPADA ROAD INDRAPRASTHA,7 HIMNAGARI CHS DR RAGHUVIR NAGAR,DOMBIVALI,THANE,MAHARASHTRA,421201,,9820447948,,F,25000.00,15-07-85,AEXPH3968K,,,SPECIAL DEPOSIT RECEIPT,25000.00,25000.00,0.00,0.00,325.00,,Paid,2017030601,NEFT,9-Feb-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON06 Mar 2017,703093934696,2017030601,DEPOSIT FEB 17 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1612130295,13-Dec-2016,1612130003,50699685,Confirmed,,Live,,9-Dec-2016,9-Dec-2021,,300800.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,HDFC BANK,8-Dec-2016,000009,200000.00,JATIN SHROFF ,JUHU CHURCH ROAD,14 RADHA KUNJ NEAR CHAND SOC,JUHU,MUMBAI,MAHARASHTRA,400049,,9833465818,,M,200000.00,16-12-74,ADWPJ4908M,,,SPECIAL DEPOSIT RECEIPT,200000.00,200000.00,0.00,0.00,2600.00,,Paid,2016122101,NEFT,8-Dec-2016, DEPOSIT COMMISSION HAS PROCESSED AS ON21 Dec 2016,612232318739,2016122101,DEP DEC 16 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1702230428,23-Feb-2017,1702230003,50729146,Confirmed,,Live,,22-Feb-2017,22-Feb-2022,,50000.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,BANK OF BARODA,20-Feb-2017,000040,50000.00,SUREKHA  VELING,WELLING HOUSE,"PODDAR STREET ,",SANTACRUZ(WEST),MUMBAI,MAHARASHTRA,400054,,9768891380,,F,50000.00,19-01-48,AGPPV1364B,,,FIXED DEPOSIT RECEIPT,50000.00,50000.00,0.00,0.00,650.00,,Paid,2017030601,NEFT,20-Feb-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON06 Mar 2017,703093934696,2017030601,DEPOSIT FEB 17 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1701040157,4-Jan-2017,1701040002,50712088,Confirmed,,Live,,7-Jan-2017,7-Jan-2022,,50457.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,IDEPSTFC50154227,4-Jan-2017,0,33955.00,MILIND WORLIKAR ,4TH FLOOR DR A B ROAD,B-402 GOPCHAR SOCIETY,WORLI,MUMBAI,MAHARASHTRA,400018,,9820964640,,M,33955.00,10-07-59,AATPW4160C,,,SPECIAL DEPOSIT RECEIPT,33955.00,33955.00,0.00,0.00,441.00,,Paid,2017012002,NEFT,4-Jan-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON20 Jan 2017,701231835138,2017012002,DEPOSIT JAN-17 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1612170506,17-Dec-2016,1612170001,50700462,Confirmed,,CLOSED,,29-Oct-2016,29-Oct-2019,,73556.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,3,IDEPSTFC50133175,17-Dec-2016,0,58000.00,KANCHANA KANTI ARORA,FOUR BUNGLOWS,1/14 VERSOVA VIEW SOCIETY,ANDHERI (W),MUMBAI,MAHARASHTRA,400053,,,,F,58000.00,21-06-67,ADNPA6259M,,,SPECIAL DEPOSIT RECEIPT,58000.00,58000.00,0.00,0.00,638.00,,Paid,2017010701,NEFT,17-Dec-2016, DEPOSIT COMMISSION HAS PROCESSED AS ON07 Jan 2017,701094222239,2017010701,DEPOSIT DEC-16 II CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,36
1701030160,3-Jan-2017,1701030001,50713790,Confirmed,,Live,,2-Jan-2017,2-Jan-2022,,52640.00,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,5,ABHYUDAYA CO OP BANK LTD,2-Jan-2017,100046,35000.00,ZUBEDA EBRAHIM MUKRI,ROOM NO-484 S M ROAD ANTOP HILL,COSMOPOLETIN RANIWASI SANGHA,WADALA (E),MUMBAI,MAHARASHTRA,400037,65296487,0000000000,,F,35000.00,01-07-42,BRGPM7639M,,,SPECIAL DEPOSIT RECEIPT,35000.00,35000.00,0.00,0.00,455.00,,Paid,2017012002,NEFT,2-Jan-2017, DEPOSIT COMMISSION HAS PROCESSED AS ON20 Jan 2017,701231835138,2017012002,DEPOSIT JAN-17 I CYCLE,IDBI BANK,0162102000007047,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,60
1612300854,30-Dec-2016,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,,,,,,PRATEEKSHA PREMNATH CHUGANI,FLAT NO 1301/2 OSHIWARA ANDHERI WEST,INDIRA DARSHAN PHASE NO 2 BLDG NO 12,ANDHERI,MUMBAI,MAHARASHTRA,400053,,0000000000,,F,40000.00,18-11-92,APXPC3969C,,STFC DEPOSITS FIXED,FIXED DEPOSIT RECEIPT,40000.00,40000.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,12
1701050322,5-Jan-2017,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,,,,,,RUKHSAN DEBOO  ,JAMSHED RAOD,600 BACHAN MANOR JAME,MATUNGA,MUMBAI,MAHARASTRA,400019,,9820604349,,M,150000.00,04-07-60,AADPD0667M,,STFC DEPOSITS SPECIAL,SPECIAL DEPOSIT RECEIPT,150000.00,150000.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,48
1702030396,3-Feb-2017,,IDEP,Cancelled,,,,,,,,INVESTMENT,SHRIRAM TRANSPORT FINANCE COMPANY LIMITED,STFC,DEPOSIT,NO,,,,,,,PAWANDEEPSINGH RAMINDERPAL HUF,HILL TOP MAROL CHURCH ROAD,A/401 ECO ELEGANCE,ANDHERI (E),MUMBAI,MAHARASHTRA,400059,,9702012701,paulairol@gmail.com,M,100000.00,28-12-70,AAJHP1771Q,,STFC DEPOSITS SPECIAL,SPECIAL DEPOSIT RECEIPT,100000.00,100000.00,0,0,0,,,,,,,,,,,,195906,TULIP  INVESTMENTS,RETAIL,ASSISTANT MANAGER-CUSTOMER SERVICE,,,,,36
