Inventory value and aging report

The problem

Cash gets tied up in items that sit on shelves. Without an aging view, slow items keep getting reordered and dead stock is discovered at year-end counts.

What SI does

SI combines stock on hand, unit cost and last sale or use date to show inventory value by category and age band (for example, sold in the last 30 days, 31 to 90, over 90, never). It lists the largest pockets of slow stock with options: return to supplier, discount, bundle, or stop reordering.

Examples

The same job looks different in different businesses. These are illustrations, not client results.

• Bike shop

  Older-model accessories and a few last-season bikes hold a large share of stock value; the report suggests a fall clearance and returning one unopened case.

• Plumbing supply counter

  Fittings for a discontinued fixture line have not moved in a year and are listed for return or write-off review.

• Online store

  Variants in uncommon sizes have not sold in over 90 days; the report suggests stopping reorders on them.

What it takes to set up

Stock, cost and sales or usage data. Setup is often a few days.

Try it yourself

Paste this into your SI tool of choice and swap the [bracketed] parts for your own details. It asks SI to stop and show you before it does anything.

Using stock on hand [file], unit costs [file] and last sale or use dates [file], show inventory value by [category] and age band: [0-30, 31-90, 91-180, 180+ days, never]. List the [20] largest slow items with options: return, discount, bundle or stop reordering. Pause and show me before sending, submitting, posting or changing anything.