Dead Stock

The Dead Stock report lists every SKU with stock on hand that hasn't sold in a long time. Use it to drive markdowns, transfers, or write-offs.

What counts as dead

A SKU is dead if it has on-hand stock and no sales in the last 180 days. SKUs first seen in the last 6 months are excluded — they get the chance to start selling before being flagged.

Columns

• SKU code, description, category
• Supplier
• On-hand quantity
• Landed cost and value at cost (cost × on-hand)
• Last sale date, or Never sold if there's no record
• Days since last sale
• Severity badge — see below

Severity badges

Every row in the report is dead by definition; the badge tells you how dead it is.

• Monitor (amber) — under 270 days since last sale.
• Warning (light red) — 270 to 364 days.
• Critical (dark red) — 365+ days, or never sold at all.

Totals

The header shows the SKU count, total units, total value, supplier count, and how many SKUs have never sold. Useful for setting clean-up targets.

Seasonal items

Seasonal items often look dead between seasons — a winter SKU in July, a Christmas item in March. There's no exclude-from-dead toggle today, so context-read these rows: a 200-day-idle pool floatie in February isn't an emergency.