At a glance
Top 20 SKUs by inventory value on hand. The concentration view: which products own most of the working capital.
| What it counts | Item.QuantityOnHand × AverageCost per SKU, sorted desc, top 20. |
| Tax treatment | n/a. |
| Currency | OneWorld: reporting currency. |
| Subsidiary scope | Respects dashboard filter. |
| Time window | RT |
| Alert trigger | None at headline; pair with Dead Stock for risk view |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your NetSuite data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US wholesale apparel distributor on NetSuite. Snapshot 14 Apr 26.| Rank | SKU | Description | Units OH | Avg cost | Inventory value |
|---|---|---|---|---|---|
| 1 | BR-A-001 | Brand A Premium Tee Black M | 24,800 | $11.20 | $277,760 |
| 2 | BR-A-014 | Brand A Premium Polo Navy L | 18,400 | $14.50 | $266,800 |
| 3 | BR-B-022 | Brand B Mid-Tier Hoodie Grey | 12,600 | $19.80 | $249,480 |
| 4 | BR-A-002 | Brand A Premium Tee Black L | 22,100 | $11.20 | $247,520 |
| 5 | BR-D-008 | Brand D Kids Tee Bundle | 38,000 | $5.80 | $220,400 |
| 6-20 | (mid-tier) | various | various | various | $2,140,000 |
| Top 20 total | $3,402,000 |
- Top 20 SKUs = 28.6M total (12% concentration). Healthy distribution; not over-concentrated.
- Top 5 are all Brand A or Brand B core products. These are the must-have SKUs; never let stock outs happen.
- Pair with sales velocity. A top-by-value SKU that’s slow-moving is dead-stock candidate. Top-by-value + fast-moving = critical reorder priority.
- Brand D Kids Tee at $5.80/unit but 38,000 OH is high-volume low-cost. Concentration by units, not by dollar.
- Use the table to focus reorder discipline. The top 20 deserve daily attention; the long tail (>10,000 SKUs) deserves periodic.
Sibling cards merchants should reference together
| Card | Why pair it with Top SKUs Value |
|---|---|
| Total Inventory Value | The total. |
| Margin by SKU | Profitability of these SKUs. |
| Inventory Aging | Age of these SKUs. |
| Low Stock Alerts | Don’t run out of these. |
| Dead Stock Value | Top by value but slow-moving = bad. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite:Reports → Inventory → Inventory Valuation Detail sorted desc by value Lists → Items with value columnWhy our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Costing method | Either | Average vs FIFO valuation differs slightly. |
| In-transit inclusion | Either | Card includes; some saved searches exclude. |
| Subsidiary scope | Either | Card defaults to all subs. |
| Card | Relationship | Why |
|---|---|---|
| shopify.top_products | Sales-side parallel | Top products by sales (commerce side); compare to top by inventory value (NetSuite side). Mismatch = inventory misalignment. |