Retail Inventory Turnover: Connect Stock to Cash Flow

1. Start with a reliable stock and cost record

Use counted quantities and reviewed unit costs. Keep stock at cost separate from potential sales value. A shelf holding 100 units bought for $20 each represents $2,000 of recorded acquisition cost, even if the asking price is $35 per unit.

Show missing costs and stale counts. A high-level stock balance can conceal products that are not moving or goods that are no longer saleable. BDC identifies inventory as a less liquid current asset than cash and highlights how slow inventory can lengthen the working capital cycle.

2. Calculate turnover on a consistent basis

For a fictional full year with $180,000 of cost of goods sold and $45,000 of average inventory, turnover is four times. Using 365 days, estimated inventory days are 365 ÷ 4 = 91.25 days. This is an average holding measure, not the exact age of every item.

Monthly or weekly inventory snapshots can describe average stock better than only opening and closing balances when the business is seasonal. Do not divide selling-price revenue by cost-valued stock and label the result the same turnover measure. Return an unavailable result when average inventory or cost coverage is inadequate.

3. Review the products hidden by the average

Group units by product, variation and location. For each slow item, check its last movement, count date, outstanding purchase orders, expected demand and practical action. Consider a transfer, supplier return, focused promotion or purchasing pause before automatically ordering more.

BDC's inventory guidance supports monitoring stock to identify slow-moving items and manage the working capital tied up in inventory. It does not establish a universal ideal turnover rate for every retailer.

4. Model a sale's cash effect separately from profit

Assume all 100 units above sell for $25 each excluding sales tax. Revenue would be $2,500 and the difference from their $2,000 acquisition cost would be $500 before other relevant costs. That is a fictional outcome, not guaranteed demand at the lower price.

The cash forecast needs the actual collection or card settlement date, fees, refunds and any unpaid supplier balance. Inventory sold on credit does not become cash on the sale date. Repaying an inventory loan may also absorb part of the receipts. A fall in stock value alone does not establish cash released.

An operational clearance decision and an accounting inventory write-down are different events. Businesses using IFRS follow IAS 2's lower-of-cost-and-net-realisable-value measurement; applicable reporting and tax policies need their own review.

5. Put replenishment beside the cash forecast

A planning reorder point can combine expected daily demand, supplier lead time and a chosen safety buffer. Four units per day over a seven day lead time, plus eight safety units, produces a 36 unit planning point. These are assumptions to check against seasonality, stockouts, supplier reliability and committed or incoming stock.

Before placing the order, put its payment date in the cash forecast and compare it with expected receipts. Keep the inventory record, source invoices and purchasing decision linked. The related inventory and cash flow guides extend this routine in more detail.