Synplex Logo
Synplex
Inventory questionhow much cash is tied up in my inventory

How much cash is tied up in my inventory?

Cash tied up in inventory equals your on-hand units multiplied by unit cost, plus the ongoing carrying cost of holding that stock. To make the number useful, split it by fast movers, slow movers, and dead stock, then compare it to your turnover target and annual carrying cost benchmark of 20–30%.

20–30% annual carrying costStandard operations benchmark

Overview

Inventory is usually the biggest pile of silent working capital on a merchant balance sheet. The issue is not only how much stock you own, but how much of that cash is moving quickly versus sitting in slow SKUs, excess buffers, and forgotten purchase orders. Once you quantify inventory value and carrying cost by SKU, it becomes easier to decide what to reorder, transfer, markdown, or discontinue.

Calculate inventory value first

Start with the simple formula Inventory value = On-hand units × Unit cost, using quantities from Admin → Products → Inventory and your cost records. This tells you how much cash is physically sitting in stock before you even factor in turnover, dead stock, or carrying cost.

Add the cost of holding that cash

Apply the annual carrying cost benchmark of 20–30% to your total inventory value so you can see the real cost of keeping slow stock on hand. If inventory value is 100,000 in currency terms, the carrying cost alone is typically 20,000–30,000 per year before markdowns or write-offs.

Separate healthy stock from trapped cash

Use Shopify Analytics → Reports → Inventory to split inventory between fast movers, slow movers, and items trending toward dead stock. SKUs materially below the common 6–8× turnover target usually hold cash for too long and deserve review with /calculators/inventory-turnover-calculator and /questions/what-is-dead-stock.

Look at inbound inventory too

Cash is also tied up in open purchase orders, not just on-hand stock, so review Admin → Purchase orders alongside current inventory. A large inbound PO can increase working capital exposure long before the units appear in Admin → Products → Inventory.

Formula

Inventory value and annual carrying cost

Inventory value = On-hand units * Unit cost; Annual carrying cost = Inventory value * Carrying cost rate

  • On-hand units — On-hand units: Units currently in stock
  • Unit cost — Unit cost: Per-unit landed or inventory cost
  • Carrying cost rate — Carrying cost rate: Annual percentage cost of holding inventory

Worked examples

Electronics brand checking how much cash is trapped in one core SKU

  • On-hand units: 1,200 units
  • Unit cost: 18
  • Annual carrying cost rate: 24%
  1. 1. Multiply 1,200 units by 18 to get inventory value of 21,600.
  2. 2. Multiply 21,600 by 24% to get annual carrying cost of 5,184.
  3. 3. Divide 5,184 by 12 to estimate a monthly carrying cost of 432.

Result: This single SKU ties up 21,600 of cash and costs about 5,184 per year to hold if it does not turn quickly.

Once you can see carrying cost in absolute terms, it becomes easier to justify markdowns, smaller POs, or SKU rationalization.

How to apply this in Shopify

  • Use Admin → Products → Inventory to export current on-hand quantities by SKU and location before valuing inventory.

  • Review Shopify Analytics → Reports → Inventory to identify which SKUs have unusually high stock relative to recent demand.

  • Check Admin → Purchase orders for inbound inventory that will soon add to your working capital exposure.

  • Use Inventory adjustments after cycle counts so your cash-tied-up calculation is based on accurate quantities, not stale numbers.

  • Turn on Product variant → Track quantity for all stocked SKUs so Shopify reflects real inventory positions when you measure value.

Common mistakes

Looking only at total inventory value

A single top-line stock value hides whether the cash sits in healthy bestsellers or in slow and aging SKUs.

Fix: Break inventory value down by SKU, category, and location using Shopify Analytics → Reports → Inventory so you can target the real problem areas.

Ignoring carrying cost

Merchants often value stock at cost but forget that holding it typically adds 20–30% of unit cost per year in ongoing expense.

Fix: Add annual carrying cost to every inventory value review so slow stock is measured as a cash-flow problem, not just a storage problem.

Forgetting open purchase orders

Cash committed to open POs is still working capital at risk even if the units have not been received yet.

Fix: Review Admin → Purchase orders together with on-hand stock whenever you assess total capital tied up in inventory.

Treating dead stock like productive inventory

Old inventory that is unlikely to sell at full price inflates asset value and hides true cash recovery risk.

Fix: Use /questions/what-is-dead-stock to classify stale SKUs and decide whether to markdown, bundle, or discontinue them.

Frequently asked questions

Related resources

Related questions

Related guides

Related calculators