The overstock cash trap: how to quantify it from your data

Excess inventory feels vague until you attach a number to it. Once every SKU has a cover target, the gap between what you hold and what you need becomes a euro figure per line. At that point clearing overstock stops being a buyer's side project and becomes a finance-approved program with a weekly scoreboard.

Why excess inventory hides in plain sight

Most distributors track inventory as a total: stock days at company level, turnover per category, a valuation line on the balance sheet. All of those are averages. A category turning 6 times a year can contain forty SKUs turning twice, funded by twenty turning twelve times. The forty lines quietly hold working capital that could fund fast movers or pay down a credit line.

The second hiding place is time. Annual turnover is a rear-view mirror: a line that sold strongly in January and stalled in June still shows a healthy twelve-month ratio. Today's decision depends on current velocity, not last year's total.

Step 1: Set a cover target per SKU class

A cover target is the number of days of demand you are willing to fund on the shelf. It is not a minimum; it is the band above which stock is excess. Targets vary by class because the cost of a stockout and the cost of holding differ.

Tune the bands to your working capital policy and supplier cadence; a 21-day target on a line the supplier ships every six weeks only generates noise.

Step 2: Quantify excess inventory per line

With a target in place the arithmetic is simple and repeatable:

Excess units = max(0, on-hand − daily run rate × target cover days)
Excess cash = excess units × unit cost

Worked example

Run this on every SKU and sort by excess cash; the first twenty rows usually explain most of the problem. Rank by cash, not unit count: a low-volume expensive line outranks a pallet of cheap fittings.

Step 3: Look forward, not just backward

Excess on the shelf is half the picture; the other half is stock already committed to arrive. A line at 131 days of cover with two open purchase orders in transit will be at 200 days by month end.

Forward cover answers that question directly: take the net stock you will build over the next eight weeks (purchases plus returns minus expected sales) and divide by trailing weekly demand. The result is expressed in weeks and tiers cleanly:

The point is timing. Cancelling a purchase order before it ships costs nothing. Discounting the same stock four months later costs margin.

Step 4: Price the trap with carrying cost

Finance rarely reacts to units. They react to an annual cost. Carrying cost bundles capital cost, warehouse space, insurance, handling, shrinkage and obsolescence. For distributors the all-in rate typically lands between 20 and 30 percent of inventory value per year.

Applied to the example above: €7,936 of excess at a 25 percent rate is roughly €1,984 a year, on one B line. Across the top hundred overstocked SKUs, that number justifies a clearance budget and a weekly update to leadership.

Step 5: Release cash in the right order

1. Stop-buy. Freeze reorders on every line above target. This is free and immediate. Review open purchase orders for cancellation or deferral.
2. Transfer. If another branch or warehouse is below target on the same SKU, move stock before you discount it company-wide.
3. Bundle. Pair excess lines with fast movers that sales already asks for. Attach rates from co-movement data tell you which pairings are natural.
4. Liquidate. Only where recovery beats the carrying cost of waiting. A line costing €1,984 a year to hold can absorb a real discount and still come out ahead.

Report cash released weekly, by line, alongside the remaining excess. When the number moves every Monday, the program keeps its sponsor.

How Flowra handles this

Flowra reconstructs each product's stock trajectory from net transaction flow, so you do not need a clean opening balance to start measuring excess inventory. Every product gets a forward-cover reading over the next eight weeks, tiered low to critical, alongside its risk score and velocity trend. When a holding-cost rate is configured, the annual carrying cost appears next to the excess figure so finance sees the leak in euros per year.

Recommendations arrive as drafts, not orders. Flowra is read-only by default: a stop-buy or clearance proposal shows the fact, the forecast, the hypotheses it rests on and a confidence badge, and nothing changes in the ERP until a buyer approves. When the data is stale or a forecast cannot stabilise, Flowra withholds the recommendation and says what is missing. The weekly Monday digest lists cash released and remaining excess by line, which is the scoreboard the program needs. You can read more about the evidence structure on the evidence-backed AI section or see how it plays out in distribution use cases.