Treasury Dashboard
Outstanding by lender
Fund-based + Non-fund + Term outstanding vs. sanctioned limit (dashed track)
Fund-based
Non-fund (LC/BG)
TL / NCD / FITL
Decision intelligence
deterministic rules · computed from live data · no AI model in the loopForecasts, anomaly detection, and recommendations — every item shows the exact rule and inputs behind it
Lender attention scores
Facility mix — outstanding
Debt service
By due date
Interest outlook
Monthly interest — entered vs projected
Utilisation watchlist
Facility heads closest to fully drawn
Fiscal year — interest & principal by month
Every month of the year with its calculation basis. Click a month row to open its full bank × facility drill-down, or a bank chip to open that bank's page.
Facilities
ROI, outstanding on record, and latest daily balance
Limits & heads
Sanctioned vs. outstanding by head (₹ Cr)
Interest & principal by month
Entered figures from workbooks · click a month to jump to that projection
Upcoming repayments
From the repayment schedule — next 8 instalments for this lender
Daily balance history
Last 90 days — one compact chart per facility, latest balance and day-on-day change shown top right
Borrowing Profile
Bank-wise limits & outstanding · ₹ in Crores · edit in Admin
Utilisation heatmap
Outstanding as % of sanctioned limit — darker = closer to fully drawn. Click any cell to open that bank.
Summary — FB / NFB / Term
Non-fund based — LC / BG
Term — FITL / NCD-ECB2
Interest Due Projection
Entered figures entered from the monthly workbook · projected computed from balances × ROI · figures editable in Admin
"As per bank" saves to the database once advices arrive — difference computes against the entered/projected figure
Daily Balances / Bank Statements
Upload day-wise outstanding from bank statements — projections and date-wise calculations run off these
Upload bank statement PDF auto-extract
Drop a PDF from the bank's portal — the parser detects the bank, extracts day-wise closing balances and interest debit lines (Int.Coll / Debit of Interest etc.), and shows a preview before saving. Balances go to daily history; ticked interest debits sum into the "As per bank" column of the Interest Due matrix for the chosen month. Penal charges are unticked by default.
Drop PDF here or click to choose
Upload statement CSV
Columns: Bank, Facility, Date, Amount(₹) · dates DD-MM-YYYY or YYYY-MM-DD · one row per day per facility
Drop CSV here or click to choose
e.g. SBI, CC, 05-07-2026, 1979822844.53
e.g. SBI, CC, 05-07-2026, 1979822844.53
No file loaded.
Add a balance manually
Single day-end balance for one facility
Coverage & latest balances
Days loaded in the selected projection month, and the most recent balance on record per facility
Interest Calculation
Workbook-style date-wise calculation from daily balances, plus a quick what-if calculator
Date-wise calculation
Balance carried forward day to day; days without an uploaded balance use the last known figure
Quick what-if
Daily interest
—
Interest for period
—
In ₹ Crores
—
Repayment Schedule
Term-loan, NCD, FITL, ECB and other principal repayments — seeded from the TL master (Mar-26), fully editable by admins
Repayments by month
Scheduled principal outflow (₹ Cr) — next 24 months
Add a repayment
Schedule
Rate of Interest Chart
Rates by lender × facility · edit in Admin
UCO Bank CC: MCLR (8.75%) + 3.30% spread. IFC/PROPARCO/FMO/DEG tranches at 7.90194%; ECB-2 tranches at 0.01%.
Audit Logs
Every change made in the portal — who did it, what changed, and when. Records are written by the database itself and cannot be edited from the app.
Change history
Admin
Add, edit or remove banks, limits, facilities, ROIs and monthly interest entries
Admin PIN
Convenience lock only — change the PIN under Settings.