Bank & Loan Reconciliation
Reported bank and loan positions, credit limits and reconciliation status.
Total loans
₹177.12 Cr₹1,77,11,69,095
(25) facilities
Outstanding
₹53.14 Cr₹53,13,50,729
30% of total limit
Available
₹123.98 Cr₹1,23,98,18,367
Unused credit
Total channel finance
₹134.40 Cr₹1,34,40,00,000
(15) facilities
Average ROI · total loan
8.00%
All facilities
Average ROI · vehicle loan
8.00%
(40) vehicle loans
Total EMI in month
₹51.04 L₹51,03,642
Term + vehicle loans
Bank balance
₹47.04 L₹47,04,093
(5) accounts · 2 pending reconciliation
Credit limit utilisation
30% of total limit used Sanctioned Utilised
Loans & credit facilities
| Bank | Facility type | Brand / distributor | Sanction date | Limit | Outstanding | Available | Utilisation | ROI | Loan tenure (days) | Renewal date | Credit period (days) | Tenure | EMI |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Axis Bank | Channel Finance | Ingram | 1 Apr 2026 | ₹3,00,00,000 | ₹90,00,000 | ₹2,10,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 45 | — | — |
| Axis Bank | Channel Finance | Redington | 1 Apr 2026 | ₹3,00,00,000 | ₹90,00,000 | ₹2,10,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 45 | — | — |
| Axis Bank | Channel Finance | Samsung | 1 Apr 2026 | ₹28,80,00,000 | ₹8,64,00,000 | ₹20,16,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 45 | — | — |
| Axis Bank | Vehicle Loan | — | 1 Apr 2026 | ₹3,75,60,000 | ₹1,12,68,000 | ₹2,62,92,000 | 30% | — | 365 | 1 Apr 2027 | — | — | — |
| ICICI Bank | Channel Finance | Redington | 1 Apr 2026 | ₹6,00,00,000 | ₹1,80,00,000 | ₹4,20,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 90 | — | — |
| ICICI Bank | Term Loan | — | 1 Apr 2026 | ₹9,00,00,000 | ₹2,70,00,000 | ₹6,30,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | — | 36 Months | ₹8,33,333 |
| ICICI Bank | Vehicle Loan | — | 1 Apr 2026 | ₹12,00,000 | ₹3,60,000 | ₹8,40,000 | 30% | — | 365 | 1 Apr 2027 | — | — | — |
| ICICI Bank | WCDL | — | 1 Apr 2026 | ₹9,00,00,000 | ₹2,70,00,000 | ₹6,30,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | — | — | — |
| HDFC Bank | OD against FD | — | 1 Apr 2026 | ₹3,30,00,000 | ₹99,00,000 | ₹2,31,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | — | — | — |
| HDFC Bank | Vehicle Loan | — | 1 Apr 2026 | ₹3,88,07,095 | ₹1,16,42,129 | ₹2,71,64,967 | 30% | — | 365 | 1 Apr 2027 | — | — | — |
| HSBC | Channel Finance | Ingram | 1 Apr 2026 | ₹12,00,00,000 | ₹3,60,00,000 | ₹8,40,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 90 | — | — |
| HSBC | Channel Finance | Redington | 1 Apr 2026 | ₹12,00,00,000 | ₹3,60,00,000 | ₹8,40,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 90 | — | — |
| State Bank of India | Channel Finance | LG | 1 Apr 2026 | ₹30,00,00,000 | ₹9,00,00,000 | ₹21,00,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 60 | — | — |
| State Bank of India | Channel Finance | Godrej | 1 Apr 2026 | ₹12,00,00,000 | ₹3,60,00,000 | ₹8,40,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 60 | — | — |
| State Bank of India | Channel Finance | Haier | 1 Apr 2026 | ₹6,00,00,000 | ₹1,80,00,000 | ₹4,20,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 60 | — | — |
| State Bank of India | Channel Finance | Whirlpool | 1 Apr 2026 | ₹4,20,00,000 | ₹1,26,00,000 | ₹2,94,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 60 | — | — |
| State Bank of India | Channel Finance | Bluestar | 1 Apr 2026 | ₹3,00,00,000 | ₹90,00,000 | ₹2,10,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 60 | — | — |
| State Bank of India | Channel Finance | Sony | 1 Apr 2026 | ₹3,00,00,000 | ₹90,00,000 | ₹2,10,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 30 | — | — |
| State Bank of India | Channel Finance | Voltas | 1 Apr 2026 | ₹2,40,00,000 | ₹72,00,000 | ₹1,68,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 90 | — | — |
| South Indian Bank | Overdraft | — | 1 Apr 2026 | ₹7,20,00,000 | ₹2,16,00,000 | ₹5,04,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | — | — | — |
| South Indian Bank | Vehicle Loan | — | 1 Apr 2026 | ₹1,38,88,200 | ₹41,66,460 | ₹97,21,740 | 30% | — | 365 | 1 Apr 2027 | — | — | — |
| South Indian Bank | Term Loan - 699 | — | 1 Apr 2026 | ₹2,21,42,400 | ₹66,42,720 | ₹1,54,99,680 | 30% | 8.00% | 365 | 1 Apr 2027 | — | 62 Months | ₹1,95,250 |
| South Indian Bank | Term Loan - 698 | — | 1 Apr 2026 | ₹2,85,71,400 | ₹85,71,420 | ₹1,99,99,980 | 30% | 8.00% | 365 | 1 Apr 2027 | — | 79 Months | ₹1,95,250 |
| Federal Bank | Channel Finance | Impex | 1 Apr 2026 | ₹6,00,00,000 | ₹1,80,00,000 | ₹4,20,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 75 | — | — |
| Ujjivan Finance | Channel Finance | IFB | 1 Apr 2026 | ₹3,00,00,000 | ₹90,00,000 | ₹2,10,00,000 | 30% | 8.00% | 365 | 1 Apr 2027 | 120 | — | — |
Vehicle loans
40 loans · EMI ₹38,79,809| Bank | Vehicle make | Vehicle | Sanction date | Limit | Outstanding | ROI | Tenure (months) | EMI |
|---|---|---|---|---|---|---|---|---|
| ICICI Bank | Toyota | Hyrider | 1 Apr 2026 | ₹12,00,000 | ₹5,47,575 | 8.00% | 39 | ₹58,772 |
| Axis Bank | Volkswagen | Golf GTI | 1 Apr 2026 | ₹40,20,000 | ₹13,91,786 | 8.00% | 39 | ₹1,95,974 |
| Axis Bank | Lexus | Lexus LM 350 | 1 Apr 2026 | ₹1,44,00,000 | ₹45,66,785 | 8.00% | 39 | ₹7,00,885 |
| Axis Bank | Eicher | EICHER PRO 2075 E | 1 Apr 2026 | ₹8,40,000 | ₹3,16,244 | 8.00% | 39 | ₹42,919 |
| Axis Bank | Mahindra | MAHINDRA VEERO V2-5927 | 1 Apr 2026 | ₹4,20,000 | ₹1,58,123 | 8.00% | 39 | ₹21,459 |
| Axis Bank | Mahindra | MAHINDRA VEERO V2-6043 | 1 Apr 2026 | ₹4,20,000 | ₹1,58,123 | 8.00% | 39 | ₹21,459 |
| Axis Bank | Mahindra | BOLERO CAMPER GOLD-5995 | 1 Apr 2026 | ₹5,10,000 | ₹1,92,005 | 8.00% | 39 | ₹26,058 |
| Axis Bank | Mahindra | BOLERO CAMPER GOLD-6007 | 1 Apr 2026 | ₹5,10,000 | ₹1,92,005 | 8.00% | 39 | ₹26,058 |
| Axis Bank | Land Rover | Rangerover - Autobiography | 1 Apr 2026 | ₹1,64,40,000 | ₹76,03,088 | 8.00% | 39 | ₹5,50,343 |
| HDFC Bank | Mercedes | Mercedes Maybach | 1 Apr 2026 | ₹2,39,96,155 | ₹85,49,588 | 8.00% | 39 | ₹8,20,661 |
| HDFC Bank | Land Rover | Defender | 1 Apr 2026 | ₹84,86,400 | ₹23,21,505 | 8.00% | 39 | ₹4,16,338 |
| HDFC Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹5,70,000 | ₹1,64,066 | 8.00% | 39 | ₹29,614 |
| HDFC Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹5,70,000 | ₹1,64,066 | 8.00% | 39 | ₹29,614 |
| HDFC Bank | Toyota | HYCROSS | 1 Apr 2026 | ₹20,69,340 | ₹9,77,779 | 8.00% | 39 | ₹69,931 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹4,14,000 | ₹2,02,029 | 8.00% | 39 | ₹21,025 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹4,14,000 | ₹2,02,029 | 8.00% | 39 | ₹21,025 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹4,14,000 | ₹2,02,029 | 8.00% | 39 | ₹21,025 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹4,14,000 | ₹2,02,029 | 8.00% | 39 | ₹21,025 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹4,14,000 | ₹2,02,029 | 8.00% | 39 | ₹21,025 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹4,14,000 | ₹2,02,029 | 8.00% | 39 | ₹21,025 |
| HDFC Bank | Tata | ULTRA LIGHT COMMERCIAL VE | 1 Apr 2026 | ₹6,31,200 | ₹3,08,021 | 8.00% | 39 | ₹32,056 |
| South Indian Bank | Toyota | Toyota Hilux | 1 Apr 2026 | ₹11,22,000 | ₹2,22,881 | 8.00% | 39 | ₹55,481 |
| South Indian Bank | Bharath Benz | Bharath Benz | 1 Apr 2026 | ₹11,10,000 | ₹2,18,109 | 8.00% | 39 | ₹54,888 |
| South Indian Bank | Ashok Leyland | Ashok Leyland Ecomet | 1 Apr 2026 | ₹10,12,200 | ₹2,25,720 | 8.00% | 39 | ₹50,052 |
| South Indian Bank | Mahindra | Mahindra Vero V2 | 1 Apr 2026 | ₹3,90,000 | ₹1,31,190 | 8.00% | 39 | ₹19,164 |
| South Indian Bank | Eicher | Eicher Pro 2075 | 1 Apr 2026 | ₹8,94,000 | ₹3,00,730 | 8.00% | 39 | ₹43,929 |
| South Indian Bank | Mahindra | Mahindra Vero V2 | 1 Apr 2026 | ₹3,90,000 | ₹1,30,701 | 8.00% | 39 | ₹19,164 |
| South Indian Bank | Mahindra | Mahindra Vero V2 | 1 Apr 2026 | ₹3,90,000 | ₹1,30,701 | 8.00% | 39 | ₹19,164 |
| South Indian Bank | Mahindra | Mahindra Vero V2 | 1 Apr 2026 | ₹3,90,000 | ₹1,30,701 | 8.00% | 39 | ₹19,164 |
| South Indian Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹4,08,000 | ₹1,41,757 | 8.00% | 39 | ₹20,048 |
| South Indian Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹4,08,000 | ₹1,41,757 | 8.00% | 39 | ₹20,048 |
| South Indian Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹4,08,000 | ₹1,41,757 | 8.00% | 39 | ₹20,048 |
| South Indian Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹4,08,000 | ₹1,41,757 | 8.00% | 39 | ₹20,048 |
| South Indian Bank | Tata | Tata Intra V30 | 1 Apr 2026 | ₹4,08,000 | ₹1,41,757 | 8.00% | 39 | ₹20,048 |
| South Indian Bank | Toyota | Toyota Glanza | 1 Apr 2026 | ₹5,49,600 | ₹1,29,364 | 8.00% | 39 | ₹27,070 |
| South Indian Bank | Toyota | Toyota Glanza | 1 Apr 2026 | ₹5,49,600 | ₹1,29,364 | 8.00% | 39 | ₹27,070 |
| South Indian Bank | Toyota | Toyota Glanza | 1 Apr 2026 | ₹4,00,200 | ₹94,195 | 8.00% | 39 | ₹19,712 |
| South Indian Bank | Toyota | Toyota Hycross | 1 Apr 2026 | ₹13,49,400 | ₹3,13,249 | 8.00% | 39 | ₹74,402 |
| South Indian Bank | Toyota | Toyota Hycross | 1 Apr 2026 | ₹13,49,400 | ₹3,13,249 | 8.00% | 39 | ₹74,402 |
| South Indian Bank | Toyota | Toyota Hycross | 1 Apr 2026 | ₹19,51,800 | ₹4,53,093 | 8.00% | 39 | ₹1,07,616 |
Bank reconciliation
| Bank | Account | Book balance | Statement balance | Difference | Last reconciled | Assigned to | Status | Action |
|---|---|---|---|---|---|---|---|---|
| South Indian Bank | 234567 | ₹5,49,600 | ₹5,49,600 | 0 | 31 Oct 2026 | Niya | Reconciled | |
| ICICI Bank | 4567 | ₹4,01,200 | ₹4,00,200 | ₹1,000 | 30 Oct 2026 | Ragesh | Reconciled | |
| Axis Bank | 9876 | ₹4,53,093 | ₹4,53,093 | 0 | 29 Oct 2026 | Thomas | Pending | |
| Axis Bank | 12345 | ₹13,49,400 | ₹13,49,400 | 0 | 28 Oct 2026 | Niya | Pending | |
| HDFC Bank | 9876 | ₹19,51,800 | ₹19,51,800 | 0 | 31 Oct 2026 | Ragesh | Reconciled |
Reconciliation history
3 entries31 Oct 2026
- NiyaReconciledSouth Indian BankA/c 234567
Marked as reconciled.
- RageshReconciledHDFC BankA/c 9876
Marked as reconciled.
30 Oct 2026
- RageshReconciledICICI BankA/c 4567
Marked as reconciled.