The income statement shows a profit, yet the bank account is empty: in retail this puzzle nearly always has the same answer. The profit is on the shelves, disguised as stock that was supposed to sell. This guide turns the warehouse into a cash account: how much money is frozen, how old that ice is, which products are dead and how to recover cash before the stock ages to zero.
Opening calculation
Calculate frozen value: stock times purchase cost
Working definition
Frozen value is the sum of each product’s stock level multiplied by its purchase cost. It is cash that has already left the business and will only return once the stock is sold.
This figure surprises almost every owner (mobile accessories shop, illustrative data):
29% of this amount sits in stock older than 90 days in sales terms, meaning products that, at the current pace, will not return the cash for a quarter or longer. The total itself is not the problem; the problem is its age.
Prerequisite for the calculation: purchase prices per product in the data (how to enter them and how margin differs from markup: the guide to margin in e-commerce).
Age of the ice
Turnover and stock age: where cash got stuck
Two measures say the same thing from two sides: days of stock (stock / average daily sales, covered in more detail in the guide to stock levels) and turnover (annual cost of goods sold / average stock value). For decisions, the most useful view splits stock value into three age zones, per category:
Cash in stock by sales pace · at purchase costmobile accessories shop · illustrative data
Reading: cables turn over healthily (one sixth in the frozen zone), whereas phone cases and holders keep ~40% of their value in stock older than a quarter. That is where most of the €16k of frozen cash lives; the average for the whole warehouse would never show it.
Diagnosis
Dead SKUs: a list with the cost of freezing
A practical definition of a dead SKU: stock above zero and not a single sale over a set period (a sensible starting point is 90 days, shorter in fashion and technology categories). The holding cost is frozen cash plus space, plus product ageing, plus opportunity cost: the same money could be tied up in stock that actually sells. The top of the list usually looks like this (illustrative data):
| Product | Frozen cash | Days since last sale | Ageing risk | First move |
|---|---|---|---|---|
| Screen protectors for an older phone model | €1,175 | 210 | high: the model is disappearing from the market | clearance to recover cash |
| Cases for a discontinued series | €2,100 | 140 | high | bundle with a bestseller or clearance |
| Car charger (excess reorder) | €1,475 | 96 | low: universal product | pause reorders, reduce stock with a promotion |
Recovery
Unfreezing stock: four ways to recover cash
The order matters: from cheap moves to painful ones. The goal for dead stock is set in cash terms (getting the money back) rather than margin terms, and this is a different game from discounts on fast-moving products (for that calculation, see the guide to discount codes):
Bundle with a bestseller
A dead product added to a fast-moving one (a threshold freebie or a set). Cash comes back alongside a sale that would have happened anyway; products frequently bought together point to the candidates.
Clearance channel
A separate outlet section in the shop or a listing on a marketplace (for the fee calculation, see the guide to marketplace profitability). The price drops where it does not spoil the main shelf.
Return or exchange with the supplier
For recent purchasing mistakes: some suppliers will accept a return or exchange it for a fast-moving item at the cost of logistics. The cheapest route, and the easiest to forget.
Clearance sale to recover cash
For stock that is genuinely ageing: recovering part of the cost today can be better than a full valuation the market will never pay. This is the owner’s financial decision, made per SKU, with a cut-off date.
Root cause
Unfreezing stock without changing reorder rules is like bailing water out of a boat without patching the hole. Reorders are managed against target days of stock per product (more for fast movers, zero for the frozen zone), with the seasonal pace adjustment described in the guide to Q4 planning.
DataOrganizer
How DataOrganizer calculates cash tied up in stock
The whole calculation rests on three datasets that DataOrganizer keeps together: stock levels, purchase prices and sales history per product. Frozen value, age zones, dead SKUs and bundle candidates (products bought together) all fit into a single conversation:
Cash in stock: €54,500, of which €16,000 (29%) is in the frozen zone (no sales coverage for over 90 days).
| Product | Frozen | Days since sale | Suggestion |
|---|---|---|---|
| Cases for a discontinued series | €2,100 | 140 | bundle: bought together with the bestselling screen protector |
| Car charger | €1,475 | 96 | pause reorders; threshold promotion |
| Screen protectors for older model | €1,175 | 210 | clearance to recover cash: model disappearing from the market |
The frozen zone is concentrated in cases and holders (about 40% of category value each). Releasing half of the €16k would fund reorders of cables, where stock covers less than a month of sales. For the owner’s decision: a list of 14 SKUs with a clearance cut-off date.
Methodological note: the figures in the examples are illustrative. Age zone thresholds (30/90 days) are set per category: fashion and electronics age faster than universal products. Value calculated at purchase cost deliberately excludes storage and capital costs; it is the lower bound of the true cost of frozen stock.
Key takeaway
Read your warehouse in money at purchase cost. Total frozen value, age zones, a list of dead SKUs and four recovery routes: this set turns the annual stocktake shock into a monthly, routine financial decision.
FAQ
Frequently asked questions about cash in stock
How much cash is frozen in the warehouse?
The total: stock × purchase cost per product; in many shops the amount is comparable to annual profit. More important than the total is its split into age zones: bestseller stock is working, while goods with no sales for a quarter are just sitting there.
How do you calculate stock turnover and days of stock?
Days of stock = stock / average daily sales; annual turnover = cost of goods sold / average stock value. Both measures are calculated per product and category, because the warehouse average hides the places where cash is stuck.
What is a dead SKU?
Stock above zero and zero sales over a set period (start with 90 days, shorter in fast-ageing categories). Holding cost = frozen cash + space + ageing + opportunity cost. The list is reviewed regularly, with an amount next to each item.
Should you sell below purchase cost?
It is the owner’s financial decision, per SKU: for genuinely ageing stock, recovering part of the cost today can be better than a full valuation the market will not pay. Cheaper routes come first: a bundle with a bestseller, a clearance channel, a return to the supplier.
How does DataOrganizer calculate frozen cash?
From stock levels, purchase prices and sales history: value at cost, age zones, days of stock, dead SKUs with amounts and bundle candidates from products bought together. The answer to “how much and where” arrives in a table from a single chat question.
Cheat sheet for the whole guide
Cash in stock: the calculation in three steps
1. Calculate frozen value at cost. Stock × purchase cost, per product and category, split into age zones. The total alone is impressive; age drives the decisions.
2. Keep a list of dead SKUs with amounts. Zero sales over the day threshold with stock above zero; each item with its frozen value and first move.
3. Unfreeze starting with the cheapest route and fix reorders. Bundle, clearance channel, return to supplier, and finally a clearance sale to recover cash; in parallel, reorder rules based on target days of stock. DataOrganizer keeps stock, costs and sales together, so the whole calculation refreshes with a single question.
DataOrganizer · inventory converted into cash
Connect your shop system: stock levels are matched with purchase prices and sales velocity, and dead SKUs get amounts and first actions. Demo account available instantly; you only pay for connected sources.