← Datavrn Notes
Industry

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

13 Jun 20264 min readUpdated 7 Nov 2026

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 — 3,800,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 rebates. 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 promotion 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 rebate 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 rebate 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. Rebate 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.

From insight to action

See Datavrn in action.

Explore enterprise performance management with deterministic engines, preserved working and pricing built around the outcomes your finance team needs.