10 Inventory KPIs Every Retailer Should Track
If you run a retail or distribution business, your stock is almost certainly your single largest asset and your largest hidden liability at the same time. The difference between a healthy operation and one quietly bleeding cash often comes down to whether you measure the right things. That is where inventory KPIs come in. The right inventory KPIs tell you how fast products are selling, how much cash is tied up on shelves, how reliable your numbers are, and where margin is leaking. In this guide we walk through ten inventory KPIs every retailer should track, how to calculate each one, a worked example, common mistakes to avoid, and how to decide which metrics matter most for your business.
What inventory KPIs are and why they matter
Inventory KPIs (key performance indicators) are the measurable signals that describe how efficiently you buy, hold, and sell stock. They translate a messy reality of SKUs, warehouses and orders into a handful of numbers you can act on. Without them, decisions get made on gut feel: you over-order a slow line because it “feels popular”, or you run out of a bestseller because nobody was watching the reorder point.
Good inventory KPIs do three jobs. They protect cash flow by showing where money is stuck. They protect revenue by flagging stockouts before customers notice. And they protect margin by exposing shrinkage, dead stock and overspending on holding costs. The metrics below are deliberately a mix of speed, accuracy, cost and profitability so you see the whole picture rather than one flattering corner of it.
1. Inventory turnover
Inventory turnover measures how many times you sell through and replace your average stock over a period, usually a year. It is one of the most important inventory KPIs because it directly reflects how hard your working capital is working.
The formula is: Cost of goods sold ÷ average inventory value. A higher number generally means stock is moving quickly and cash is not sitting idle. A low number suggests over-ordering, weak demand or ageing lines. There is no universal “good” figure; a fashion retailer and a furniture distributor will sit in very different ranges, so compare yourself against your own history and your category, not an abstract benchmark.
2. Sell-through rate
Sell-through rate tells you what proportion of received stock you sold within a given window. It is calculated as units sold ÷ units received × 100 over the same period. If you bought 500 units of a product and sold 300 in the month, your sell-through is 60 per cent.
This metric is especially useful for seasonal or trend-driven lines, where buying decisions are made well in advance. A consistently low sell-through is an early warning that you are buying ahead of demand, while a very high rate quickly after launch may mean you under-ordered and left sales on the table.
3. Days of inventory on hand
Days of inventory on hand (DIO), sometimes called days sales of inventory, estimates how many days your current stock will last at the current rate of sale. Calculate it as (average inventory ÷ cost of goods sold) × number of days in the period. It is essentially turnover expressed in days, which many operators find more intuitive.
DIO is the metric to lean on when you are managing cash flow tightly. Fewer days means stock converts to cash faster; too few, though, and you risk stockouts. The aim is to optimise the balance for each product class rather than minimise it everywhere.
4. Stockout rate
A stockout is a missed sale you can often never recover, and frequently a customer you lose to a competitor. Stockout rate measures how often items are unavailable when demand exists. A simple version is number of out-of-stock SKUs ÷ total SKUs, but a more useful version weights by demand: out-of-stock events on your fastest movers hurt far more than on a dusty long-tail line.
Track this across every sales channel. A product can show “in stock” in your back office yet be unavailable on a marketplace because allocation was wrong, so visibility across Shopify, Lazada, Shopee, Amazon and TikTok Shop matters as much as the headline figure.
5. Inventory accuracy
Inventory accuracy compares what your system says you have against what is physically on the shelf. It is calculated as (verified accurate counts ÷ total counts) × 100, usually measured through cycle counting. Every other KPI on this list depends on this one: if your stock records are wrong, your turnover, fill rate and forecasting are all built on sand.
Most accuracy problems come from manual processes, untracked transfers between warehouses, and returns that never get logged. Barcode-driven receiving and picking, plus regular cycle counts, are the most reliable ways to keep accuracy high.
6. Carrying cost
Carrying cost (or holding cost) captures the total cost of keeping stock before it sells: storage and warehouse rent, insurance, handling, obsolescence, and the opportunity cost of cash tied up. It is usually expressed as a percentage of average inventory value.
Retailers consistently underestimate this figure because much of it is indirect. A line that “breaks even” on paper can be unprofitable once you account for the months it occupied a shelf. Tracking carrying cost forces those hidden expenses into the open and makes the case for clearing slow stock.
7. GMROI
Gross margin return on investment (GMROI) answers a deceptively simple question: for every unit of currency invested in inventory, how much gross profit did you get back? Calculate it as gross margin ÷ average inventory cost. A GMROI above 1 means the inventory is generating more gross profit than it costs to hold; below 1 means it is destroying value.
GMROI is powerful because it blends margin and turnover into a single profitability lens. A low-margin product that sells incredibly fast can outperform a high-margin product that lingers. Use it to compare categories and to decide where to put your buying budget next season.
Worked example: reading the numbers together
Imagine a homeware retailer reviewing two products over a year, with figures in Singapore dollars.
| Metric | Product A (ceramic mugs) | Product B (designer lamps) |
|---|---|---|
| Average inventory value | S$10,000 | S$20,000 |
| Annual cost of goods sold | S$60,000 | S$24,000 |
| Gross margin | S$15,000 | S$16,000 |
| Inventory turnover | 6.0 | 1.2 |
| Days of inventory on hand | ~61 days | ~304 days |
| GMROI | 1.5 | 0.8 |
At first glance the lamps look attractive because their gross margin is higher. But the KPIs tell a different story. The mugs turn over six times a year and return S$1.50 of gross profit per dollar invested, while the lamps sit for roughly ten months and return only S$0.80 per dollar, destroying value once carrying cost is included. The lesson: never judge a product on margin alone. Reading turnover, DIO and GMROI together reveals where your cash is genuinely working.
8. Fill rate
Fill rate measures how well you meet demand from stock on hand. Order fill rate is orders shipped complete ÷ total orders × 100, while line or unit fill rate looks at individual items or quantities. It is the customer-facing flip side of the stockout rate: a high fill rate means people get what they ordered, complete and on time.
For retailers selling across multiple channels, fill rate is a direct driver of seller ratings and repeat purchases. Partial shipments and back-orders erode trust quickly, so this is a KPI worth watching at the channel level, not just in aggregate.
9. Shrinkage
Shrinkage is the gap between the inventory you should have and what you actually have, caused by theft, damage, supplier shortages, miscounts and administrative error. Calculate it as (recorded inventory value − actual counted value) ÷ recorded inventory value × 100.
Some shrinkage is unavoidable, but a rising trend is a red flag worth investigating. Because shrinkage comes straight off your bottom line, even a modest percentage can wipe out the profit on thin-margin categories. Regular cycle counting and tight receiving controls keep it visible and contained.
10. How to choose which inventory KPIs to track
You do not need all ten on a daily dashboard. Trying to watch everything usually means watching nothing well. Choose based on your biggest current constraint:
- Cash-flow pressure: prioritise inventory turnover, days of inventory on hand and GMROI.
- Lost sales and complaints: focus on stockout rate and fill rate.
- Numbers you cannot trust: start with inventory accuracy and shrinkage before anything else.
- Margin erosion: watch carrying cost and GMROI together.
Pick three to five KPIs, set a baseline from your own history, review them on a regular cadence, and only add more once those are under control.
Common mistakes when tracking inventory KPIs
- Measuring without acting. A dashboard nobody uses to change a buying or reorder decision is just decoration.
- Aggregating away the detail. Healthy averages can hide a handful of dead SKUs and chronic stockouts. Always be able to drill down to product and channel level.
- Trusting dirty data. Calculating turnover or GMROI on inaccurate stock records produces confident but wrong conclusions.
- Chasing a single benchmark. Copying another retailer’s “ideal” turnover ignores your category, margins and lead times.
- Ignoring multi-channel reality. Stock looks fine in the back office but is unavailable on a marketplace because allocation was never synced.
- Optimising one metric in isolation. Slashing days on hand to the bone improves one number while quietly raising your stockout rate.
How WhiteBox helps
Tracking these inventory KPIs by hand across spreadsheets is slow and error-prone, and it falls apart the moment you sell on more than one channel. WhiteBox keeps stock synced in real time across Shopify, Lazada, Shopee, Amazon and TikTok Shop, manages multi-warehouse stock and transfers, and uses barcode picking and packing to keep inventory accuracy high. Its forecasting and reporting turn raw movements into the turnover, sell-through, fill rate and GMROI figures you actually need, so the numbers stay clean without manual reconciliation. Plans start from S$49 per month with unlimited users, a 14-day free trial, and you can be live within an afternoon. Explore our pricing or get in touch to see how it fits your operation.
Frequently asked questions
How often should I review my inventory KPIs? It depends on the metric and the pace of your business. Fast-moving signals like stockout rate and fill rate are worth a weekly look, while turnover, GMROI and carrying cost are usually reviewed monthly or quarterly to spot trends rather than noise.
What is the single most important inventory KPI? There is no universal answer, but inventory accuracy underpins everything else. If your stock records are wrong, every other KPI you calculate will be unreliable, so it is the sensible place to start.
Are these KPIs different for online versus physical stores? The core metrics are the same, but channel visibility matters more online. A multi-channel seller needs accuracy and stockout figures broken down per marketplace, because stock can be available in one place and sold out in another.
Can I track inventory KPIs in a spreadsheet? You can start that way, and it is fine for a single channel with few SKUs. As you add products, warehouses and sales channels, manual updates introduce errors and lag, which is exactly when inventory management software earns its keep.
What is the difference between stockout rate and fill rate? Stockout rate measures how often items are unavailable, while fill rate measures how completely you satisfy the orders that do come in. They are closely related but viewed from opposite ends: one looks at availability, the other at fulfilment.
Related reading: Inventory management guide, Retail metrics, Inventory and cash flow.