S.NO DATE BILL NO BL\PL\LAP\HL COSTOMER NAME BANK NAME DISBURSMENT AMOUNT PAY OUT AMOUNT CGST @ 9 % SGST @ 9% TOTAL %AGE tds total amount 1 23-Apr-2024 AND/0001 BL HAMIDULLAH HASMATULLAH HH GARMENTS FULLERTON INDIA 768986 23069 2076 2076 27221 3.00 1153.45 21916 2 23-Apr-2024 AND/0002 BL HAMIDULLAH HASMATULLAH HH GARMENTS INCRED 764372 22931 2064 2064 27059 3.00 1146.55 21784 3 29-Apr-2024 AND/0003 BL HAMIDULLAH HASMATULLAH HH GARMENTS HERO FINCORP 1020000 24400 2196 2196 28792 2.39 1220 23180 4 8-May-2024 AND/0004 BL HAMIDULLAH HASMATULLAH HH GARMENTS POONAWALA 1536272 40237 3621 3621 47480 2.62 2011.85 38225 5 15-May-2024 AND/0005 PL SABUJ ROY INCRED FINANCIAL 103860 2532 228 228 2988 2.44 126.6 2405 6 30-Jul-2024 AND/0006 LAP PRADEEP BANERJEE PNB HOUSING 5190000 57765 5199 5199 68163 1.11 2888.25 54877 7 2-Aug-2024 AND/0008 BL DHEERAJ NATHANI/ISHWARDASS GOURISHANKAR LENDINGKART 1379000 36956 3326 3326 43608 2.68 1847.8 35108 8 2-Aug-2024 AND/0010 BL DEEPAK CHAND NATHANI LENDINGKART 2088000 55958 5036 5036 66030 2.68 2797.9 53160 9 2-Aug-2024 AND/0008 BL DEEPAK CHAND NATHANI POONAWALLA 1027463 28768 2589 2589 33946 2.80 1438.4 27330 10 2-Aug-2024 AND/0007 PL SAMI MANSOOR VOHRA HDFC BANK 2918263 70620 6356 6356 83332 2.42 3531 67089 11 2-Aug-2024 AND/0008 PL SAMI MANSOOR VOHRA IDFC BANK 2539544 66028 5943 5943 77913 2.60 3301.4 62727 12 2-Aug-2024 AND/0008 PL SAMI MANSOOR VOHRA TATA CAPITAL 1517541 33385 3005 3005 39394 2.20 1669.25 31716 13 2-Aug-2024 AND/0008 PL SAMI MANSOOR VOHRA CHOLA 1519098 33420 3008 3008 39436 2.20 1671 31749 14 2-Aug-2024 AND/0011 PL SAMI MANSOOR VOHRA BAJAJ FINANCE 2280000 53443 4810 4810 63063 2.34 2672.15 50771 15 2-Aug-2024 AND/0009 PL SAMI MANSOOR VOHRA L&T FINANCE 2575700 70059 6305 6305 82670 2.72 3502.95 66556 16 1-Sep-2024 AND/0018 BL KALIMUDDIN / K ELEVEN ENTERPRISE AXIS FINANCE 1519036 40596 3654 3654 47903 2.67 2029.8 38566 17 2-Sep-2024 AND/0015 BL KALIMUDDIN / K ELEVEN ENTERPRISE HERO 2020800 53198 4788 4788 62773 2.63 2659.878 50538 18 3-Sep-2024 AND/0014 BL KALIMUDDIN / K ELEVEN ENTERPRISE POONAWALA 1521399 49293 4436 4436 58166 3.24 2464.66638 46829 19 4-Sep-2024 AND/0014 BL KALIMUDDIN / K ELEVEN ENTERPRISE IIFL 1800000 51030 4593 4593 60215 2.84 2551.5 48479 20 5-Sep-2024 AND/0012 BL KALIMUDDIN / K ELEVEN ENTERPRISE BAJAJ FINANCE 3000000 71685 6452 6452 84588 2.39 3584.25 68101 21 6-Sep-2024 AND/0012 BL DEEPAK CHAND NATHANI / MS. DEEPAK CHAND NATHANI BAJAJ FINANCE 1000000 23895 2151 2151 28196 2.39 1194.75 22700 22 7-Sep-2024 AND/0014 BL DEEPAK CHAND NATHANI / MS. DEEPAK CHAND NATHANI ADITYA BIRLA 950000 26933 2424 2424 31780 2.84 1346.625 25586 23 26-Sep-2024 AND/0019 BL PANARESH BISHWAS TATA CAPITAL 1035704 29362 2643 2643 34647 2.83 1468.1 27894 24 1-Oct-2024 AND/0020 BL KALIMUDDIN / K ELEVEN ENTERPRISE AXIS BANK 1000000 27350 2462 2462 32273 2.74
S.NO DATE BILL NO BL\PL\LAP\HL COSTOMER NAME BANK NAME DISBURSMENT AMOUNT PAY OUT AMOUNT CGST @ 9 % SGST @ 9% TOTAL %AGE tds total amount 1 23-Apr-2024 AND/0001 BL HAMIDULLAH HASMATULLAH HH GARMENTS FULLERTON INDIA 768986 23069 2076 2076 27221 3.00 1153.45 21916 2 23-Apr-2024 AND/0002 BL HAMIDULLAH HASMATULLAH HH GARMENTS INCRED 764372 22931 2064 2064 27059 3.00 1146.55 21784 3 29-Apr-2024 AND/0003 BL HAMIDULLAH HASMATULLAH HH GARMENTS HERO FINCORP 1020000 24400 2196 2196 28792 2.39 1220 23180 4 8-May-2024 AND/0004 BL HAMIDULLAH HASMATULLAH HH GARMENTS POONAWALA 1536272 40237 3621 3621 47480 2.62 2011.85 38225 5 15-May-2024 AND/0005 PL SABUJ ROY INCRED FINANCIAL 103860 2532 228 228 2988 2.44 126.6 2405 6 30-Jul-2024 AND/0006 LAP PRADEEP BANERJEE PNB HOUSING 5190000 57765 5199 5199 68163 1.11 2888.25 54877 7 2-Aug-2024 AND/0008 BL DHEERAJ NATHANI/ISHWARDASS GOURISHANKAR LENDINGKART 1379000 36956 3326 3326 43608 2.68 1847.8 35108 8 2-Aug-2024 AND/0010 BL DEEPAK CHAND NATHANI LENDINGKART 2088000 55958 5036 5036 66030 2.68 2797.9 53160 9 2-Aug-2024 AND/0008 BL DEEPAK CHAND NATHANI POONAWALLA 1027463 28768 2589 2589 33946 2.80 1438.4 27330 10 2-Aug-2024 AND/0007 PL SAMI MANSOOR VOHRA HDFC BANK 2918263 70620 6356 6356 83332 2.42 3531 67089 11 2-Aug-2024 AND/0008 PL SAMI MANSOOR VOHRA IDFC BANK 2539544 66028 5943 5943 77913 2.60 3301.4 62727 12 2-Aug-2024 AND/0008 PL SAMI MANSOOR VOHRA TATA CAPITAL 1517541 33385 3005 3005 39394 2.20 1669.25 31716 13 2-Aug-2024 AND/0008 PL SAMI MANSOOR VOHRA CHOLA 1519098 33420 3008 3008 39436 2.20 1671 31749 14 2-Aug-2024 AND/0011 PL SAMI MANSOOR VOHRA BAJAJ FINANCE 2280000 53443 4810 4810 63063 2.34 2672.15 50771 15 2-Aug-2024 AND/0009 PL SAMI MANSOOR VOHRA L&T FINANCE 2575700 70059 6305 6305 82670 2.72 3502.95 66556 16 1-Sep-2024 AND/0018 BL KALIMUDDIN / K ELEVEN ENTERPRISE AXIS FINANCE 1519036 40596 3654 3654 47903 2.67 2029.8 38566 17 2-Sep-2024 AND/0015 BL KALIMUDDIN / K ELEVEN ENTERPRISE HERO 2020800 53198 4788 4788 62773 2.63 2659.878 50538 18 3-Sep-2024 AND/0014 BL KALIMUDDIN / K ELEVEN ENTERPRISE POONAWALA 1521399 49293 4436 4436 58166 3.24 2464.66638 46829 19 4-Sep-2024 AND/0014 BL KALIMUDDIN / K ELEVEN ENTERPRISE IIFL 1800000 51030 4593 4593 60215 2.84 2551.5 48479 20 5-Sep-2024 AND/0012 BL KALIMUDDIN / K ELEVEN ENTERPRISE BAJAJ FINANCE 3000000 71685 6452 6452 84588 2.39 3584.25 68101 21 6-Sep-2024 AND/0012 BL DEEPAK CHAND NATHANI / MS. DEEPAK CHAND NATHANI BAJAJ FINANCE 1000000 23895 2151 2151 28196 2.39 1194.75 22700 22 7-Sep-2024 AND/0014 BL DEEPAK CHAND NATHANI / MS. DEEPAK CHAND NATHANI ADITYA BIRLA 950000 26933 2424 2424 31780 2.84 1346.625 25586 23 26-Sep-2024 AND/0019 BL PANARESH BISHWAS TATA CAPITAL 1035704 29362 2643 2643 34647 2.83 1468.1 27894 24 1-Oct-2024 AND/0020 BL KALIMUDDIN / K ELEVEN ENTERPRISE AXIS BANK 1000000 27350 2462 2462 32273 2.74
Created using ChatSlide
The Loan Portfolio Dashboard provides an overview of 83 loan records from April 2024 to July 2026, enabling tracking of disbursements, payouts, taxes, and net receipts. It emphasizes the need to standardize fields for accurate reporting. The data architecture includes three sheets: active loan leads, trend summaries, and a financial ledger. Additionally, the portfolio scale and financial snapshot allow for comparisons of disbursements and payouts, distinguishing gross totals from net amounts...