• Shopware Gold Partner & Shopify Partner

Chapter 16

Inventory turnover: How slow movers eat up liquidity

Table of contents

A profitable store can fail for lack of liquidity. The income statement looks good, revenue is growing. And yet at some point the bank calls because the credit line is maxed out. The cause often does not show up in the income statement but in the growing inventory on the balance sheet.

What inventory turnover measures

Annual cost of goods sold divided by average inventory. With €1.2 million cost of goods sold and €240,000 average inventory, inventory turnover is 5.

From this follows the average days in stock: 365 days divided by inventory turnover, in this example 73 days.

What better turnover is worth

If your inventory turnover rises from 5 to 6 with the same annual cost of goods sold, the required average inventory falls from €240,000 to €200,000. That frees up €40,000 of capital – without a single euro of additional revenue. Money that is available for bestsellers, advertising or as a buffer.

The cash conversion cycle

Average days in stock + average days until payment is received − average days until suppliers are paid. It shows how many days your money is tied up before it flows back. What matters are the actual times: when the payment provider really pays out and when you really pay your suppliers. Contractual payment terms are suitable for planning.

In the example: 73 days in stock plus 14 days until customers' money arrives, minus 30 days until suppliers are paid, gives 57 days. Calculated simply on the basis of cost of goods sold, around €187,000 is tied up. For the exact operating capital tied up, calculate: average inventory + receivables from sales − payables for goods supplied.

Benchmarks

Industry

Healthy turnover

Days in stock

Alarm

Beauty and supplements

6 to 12

30 to 60 days

below 4

Food

10 to 24

15 to 36 days

below 6

Fashion and seasonal goods

4 to 8

45 to 90 days

below 3

Sports and outdoor

4 to 7

52 to 90 days

below 3

Electronics and technology

5 to 9

40 to 73 days

below 4

Furniture and home

3 to 6

60 to 120 days

below 2

Luxury and jewelry

2 to 4

90 to 180 days

below 1.5

B2B stores

6 to 10

36 to 60 days

below 4

The slow mover trap

In many stores, an ABC analysis with a separate class for dead stock shows a similar pattern:

Product group

Share of assortment

Share of revenue

Turnover

A – bestsellers

10 to 20%

60 to 80%

10 to 20

B – solid sellers

20 to 30%

15 to 25%

4 to 8

C – slow movers

30 to 40%

3 to 10%

1 to 3

D – dead stock

20 to 30%

1 to 3%

below 1

Dead stock often ties up a double-digit percentage of inventory capital but brings in hardly any revenue. Every euro tied up there is missing for bestsellers, advertising or a buffer.

The counter-check always belongs to it: less inventory is only better if your bestsellers stay available. Anyone who reduces stock of the wrong items improves the metric and loses profitable orders at the same time.

Thinking about inventory and advertising together

Dead stock can justify a lower POAS during clearance than a regular product. The yardstick is then not the usual target but the alternative: further storage costs, financing and loss of value. Anyone who steers every product in the ad account by the same target leaves exactly these clearance sales on the table – another reason for steering by contribution margin as described in Chapter 13.

The levers

  • Regular ABC analysis and clear rules for clearance or delisting.

  • Optimizing order quantities: smaller, more frequent orders from suppliers, where terms allow.

  • Negotiating longer payment terms with suppliers.

  • Drop shipping for peripheral assortments.

  • Faster incoming payments: prefer payment methods with fast payouts, without creating purchase hurdles.

Where the numbers come from

Inventory turnover and the cash conversion cycle need cost prices, stock levels and payment terms. This data lives in inventory management and accounting, i.e. level 2 of the data source pyramid. A store system knows stock levels, but not necessarily the correct cost values and payment terms.

What you can check today

  1. Do you know your current inventory turnover and average days in stock?

  2. Do you know your cash conversion cycle?

  3. Do you know how much capital is currently tied up in inventory?

  4. Have you carried out an ABC analysis in the last twelve months?

  5. What share of your inventory value is dead stock?

  6. Are there clear rules for clearance and delisting?

Frequently asked questions

How often average inventory is sold and replaced per year. Calculated as annual cost of goods sold divided by average inventory.

365 days divided by inventory turnover. With a turnover of 5, goods spend an average of 73 days in stock.

A turnover below one per year is a strong warning sign. Also check demand, margin and the item's role in the assortment – some slow movers are indispensable as complements to bestsellers.

Days in stock plus days until payment is received minus days until suppliers are paid. It shows how long your money is tied up. Actual times are used for the calculation, contractual payment terms for planning.

Because profit and liquidity are two different things. Anyone who keeps putting profits into growing inventory can fail for lack of liquidity despite being in the black in the income statement.