Inventory Value

The Inventory Value report shows how much capital is sitting in stock, broken down by supplier, with sales velocity beside the value so you can spot money that isn't moving.

Columns

• Supplier — name and code.
• SKUs — distinct active products from this supplier.
• Units — total on-hand quantity.
• Value at cost — landed cost × on-hand units, in your base currency.
• Sales 3 / 6 / 12 mo — trailing-window sales value at cost. The basis for stock turns.
• Turns — trailing-12-month sales ÷ value at cost. Higher = faster turning.
• Excess — value above what target cover months would justify. Capital that should arguably not be there.
• Dead / slow — combined value of dead and slow SKUs from this supplier, with counts.

Reading the table

Sort by Value for the biggest stockholdings, by Turns ascending to find suppliers your money is stuck with, or by Dead / slow to find clean-up candidates.

Money formatting

Money columns are shown in thousands with a k suffix — so the whole grid reads in one unit. Hover any cell to see the full value.

Drilling in

Click a supplier row to open the per-supplier inventory view — item-level breakdown, charts, and a locations breakdown showing where each supplier's stock actually sits.

Click any item in that drill-down to see its history chart. The chart opens in chain-wide viewby default (Show all locations is on) — useful for the supplier-report question of “is this SKU dying everywhere?” Switch the location dropdown or untoggle Show all locations to drill into a single location's sales / stock / forecast.

Viewing every SKU at once

The View all SKUs across suppliers link above the supplier table opens a single grid of every active SKU — same valuation columns as the per-supplier drill-down, with a Supplier column added. Sort or filter to scan the whole catalogue without bouncing through suppliers.

The list can be 10k+ rows, so the page renders empty and fetches on Load items. Click a supplier name in any row to jump back to that supplier's drill-down.

Export to CSV or Excel

The Export dropdown on the grid toolbar downloads the currently visible rows. Pick CSV (.csv) for a portable plain-text file, or Excel (.xlsx) for a typed workbook where numbers behave as numbers and dates as dates — sums, sorts, and date filters work straight away without any post-import cleanup. The frozen header row stays visible as you scroll.

The export reflects the active chip filter — pick Dead, Slow, Overstock, or New first if you only want those rows. The file includes the full column set (status, sku, description, on-hand, value, months of supply, excess, trailing 1/3/6/12-month sales and value, last sale date, cost, landed cost, retail) so you can pivot or sort in your spreadsheet without losing context.