Category Margin, Dead Stock, Supplier Power: Reporting for a Trading Business

Trading and retail look simple from the outside — buy, mark up, sell — and that simplicity is exactly why the reporting is so often inadequate. Margins are thin, volumes are high, and the difference between a good month and a bad one hides in places a statutory P&L never looks. A pack that reports revenue, gross profit, and net profit has told a retailer that money moved. It hasn’t told them which products made it, which stock is quietly dying, or how much cash is trapped on the shelves — and those are the questions that run the business.

The numbers that actually run a trading business

Category margin and mix. Blended gross margin is the most misleading number in retail. A business at 14.9% overall can be carrying a category that loses money on every sale, propped up by a high-margin category somewhere else — and the blended figure looks perfectly healthy. What a retailer needs is margin by category, plus an understanding of mix: when the low-margin category grows as a share of sales, blended margin falls even if nothing about any individual product changed. Reported only as a single percentage, that shift looks like a problem with the business; reported by category and mix, it’s a clear, actionable picture of where to push and where to pull back.

Stock health and the aged tail. Inventory is cash you’ve already spent and haven’t recovered yet, and in trading it piles up unevenly. The headline number — total stock, days of inventory, turns — matters, but the dangerous part is the aged tail: the stock that last moved months ago. A previous-generation model, an over-ordered SKU, a seasonal line that didn’t clear — ₹38,00,000 of it sitting past 180 days, slowly becoming worth less than its book value. A closing inventory figure shows none of this; it takes an aging view, by SKU, to surface the stock that needs a markdown or a provisioning decision before it becomes a write-off.

Supplier dependence and the honesty of schemes. Trading businesses often lean heavily on a few suppliers, and that concentration is a risk worth seeing — when one supplier is 40%+ of purchases, their terms are effectively your terms. Layered on top is the matter of scheme and rebate income: the back-margin suppliers pay for volume, which can be a meaningful slice of total profit. The trouble is that these are frequently estimated — accrued at a trailing rate while the confirmation letter is pending — and when an estimate hardens silently into the headline margin, a later true-up looks like a shock rather than the resolution of a known unknown. Good trading reporting shows supplier concentration plainly and flags which scheme income is still an estimate.

Cash tied up in inventory. All of the above converges on working capital. In a thin-margin business, the cash trapped in stock is often the single biggest call on the balance sheet, and inventory days creeping up — even for a “good” reason like a seasonal build — is cash leaving the current account. The link between what’s on the shelves and what’s in the bank is the relationship a trading business most needs to watch, and it’s nowhere on an income statement.

Why they don’t reach the pack

The reason is the same as in every specialised business: this view lives in data the accounting system doesn’t summarise. Category margin needs item-level sales and the landed cost behind each line. Stock aging needs the item ledger, not a closing balance. Supplier and scheme analysis needs purchase data plus the judgement to flag estimated accruals. Each is a reconciliation against detailed records, done by hand, every period — so the monthly pack quietly falls back to the statutory P&L, which the books produce for free, and the operationally vital layer gets built occasionally, if at all.

The cost of flying without it

A trading business running on its P&L alone makes predictable, expensive mistakes. The loss-making category keeps its shelf space because no one isolated it. Dead stock accumulates unprovisioned until it lands as a sudden write-off. Scheme income booked optimistically trues up downward and dents a quarter. Inventory days drift and cash tightens, with no line on the income statement to explain why. None of these are exotic — they’re the ordinary failures of a business reported one layer too high.

What to expect with Datavrn

Datavrn is built to produce the layer beneath the trading P&L. Category margin and mix, stock health and aging down to the slow-moving SKU, supplier concentration, and the working capital tied up in inventory come through as part of the monthly pack — and each figure drills to the invoice or stock-register row behind it, so a margin number opens into the sales and landed costs that made it. Estimated scheme income is flagged with its basis rather than buried in the headline, and a later true-up reads as a transparent restatement. You get the view that actually runs a trading floor, on the rhythm of the close, instead of rebuilding it against the item ledger by hand each month.