When a bank reviews a working-capital limit or a CA prepares your MIS, they're not asking for your dashboards — they're asking for a small set of consistent, defensible numbers with the workings behind them. Scrambling to assemble those from spreadsheets the night before is how good businesses get worse terms. Here's what they actually want and how to have it ready in one pack.
A lender extending a working-capital limit is underwriting one question: will you convert receivables to cash reliably enough to service the facility? So they look at revenue trend, gross margin stability, DSO and ageing, and customer concentration. A fleet with ₹3 Cr revenue but 55-day DSO and 60% revenue from one customer is riskier than its topline suggests — and they'll price that risk into your rate.
A monthly MIS pack is about consistency and traceability: the same metrics defined the same way every month, each one traceable to source records if questioned. The fastest way to lose an auditor's confidence is a number this month that was computed differently from last month.
Both audiences are served by the same monthly board-ready pack — a single PDF, generated on demand and scoped to your business:
A pack you assemble by hand each month drifts — definitions change, someone copies last quarter's number by mistake, and the lender notices. A pack generated from the same underlying model every month is consistent by construction, and every figure still drills to the rows behind it if the CA or the bank asks 'show me'.
From cost/km to value-at-risk — the numbers that actually decide whether a fleet makes money, and how to read them.
A practical walk through empty running, unbilled trips, detention and sub-margin lanes — where the money hides and how to get it back.