Inventory Aging Report: Find Dead Stock Fast

The uncomfortable question that saves you money

If you don't measure how long items sit, you'll keep buying more while cash is trapped in boxes.

Most small-batch card sellers track what they own, maybe even what they paid — but they don't track the one metric that changes decisions fast:

Days in inventory.

An inventory aging report is a simple view that tells you:

• what's moving

• what's stuck

• what's quietly draining cashflow

• what needs a pricing change, better listing, or a different channel

This isn't about selling everything quickly. It's about protecting margin and freeing cash so you can buy smarter.

What is an inventory aging report?

It's a list of your inventory with:

• acquisition date (or "date added to inventory")

• cost basis

• current list price

• days in inventory

• an "aging bucket" (0–7 days, 8–30, 31–60, etc.)

• next action

You can build it in a spreadsheet in under an hour.

Why aging matters more than "inventory value"

Inventory value can look great while your business feels broke.

Aging fixes that because it forces reality:

• A card sitting 120 days is not "inventory," it's cash you can't use

• A card sitting 120 days with lots of watchers might be priced slightly wrong

• A card sitting 120 days with no views might be listed poorly (title/photos/category)

• A card sitting 120 days with low demand might need a channel change or bundling

Aging turns "I think" into "I know."

Step 1: Choose your aging buckets

Keep it simple. Example buckets:

• 0–7 days (new)

• 8–30 days (normal)

• 31–60 days (watchlist)

• 61–90 days (action needed)

• 91–180 days (stale)

• 180+ days (dead stock / liquidation candidates)

Your buckets should match your selling cadence. If you list weekly, these ranges work well.

Step 2: Build the report (copy/paste columns)

Create a sheet with these columns:

• Item ID / SKU

• Card description (generic)

• Acquisition date

• Cost basis

• Fees estimate (%)

• Current list price

• Net at list price

• Days in inventory

• Aging bucket

• Channel (marketplace / consignment / show / other)

• Views / watchers (if you track them)

• Next action (reprice / relist / bundle / move channel / hold)

Days in inventory formula

If your acquisition date is in cell C2:

Days in inventory = TODAY() − C2

(Your spreadsheet will handle the date math.)

Step 3: Define "next actions" that protect margin

Aging only helps if it triggers decisions. Use a simple rule set:

0–30 days: Don't touch it

Let the market respond. Focus on listing quality.

31–60 days: Improve discoverability

• Rewrite the title for search clarity

• Add better photos

• Fix category/attributes

• Add condition notes consistently

61–90 days: Make a pricing decision

Pick one:

• reduce price by a small, controlled amount

• offer free shipping (if it makes sense)

• add a small promotion

• test a different channel

91–180 days: Bundle or reposition

Bundles move slow inventory without nuking your entire pricing strategy.

• create themed bundles (by set/era/type/condition)

• bundle lower-demand items with one stronger item

• track sell-through for 7 days

180+ days: Liquidation rules (pre-decide)

Dead stock is where sellers get emotional and lose money.

Pre-decide:

• minimum acceptable net

• whether you'll accept offers

• whether you'll move it to a bulk channel

• when you'll donate/trade (if that's your model)

Step 4: Add one "cash trapped" metric

Add a summary box at the top:

• Total cost basis in 91+ day inventory

• Total potential net if sold at current prices

• Count of items in 91+ day buckets

This tells you, instantly, where cash is stuck.

Step 5: Run a weekly 20-minute aging review

Once per week:

• Sort by Days in inventory (descending)

• Filter to 61+ days

• Pick the top 10 items

• Apply one action per item

• Record the action date (so you don't thrash pricing daily)

Consistency beats intensity.

Common mistakes to avoid

Mistake 1: Constant repricing

If you change prices too often, you can't learn what worked.

Mistake 2: Treating all stale items the same

Some are stale because demand is low; others are stale because the listing is weak.

Mistake 3: Ignoring fees

Aging decisions must be based on net, not gross.

Mistake 4: No SKU/ID discipline

If you can't locate an item fast, you can't run a clean aging process.

---

Build your inventory aging report this week and run it every Friday:

• identify your 10 oldest items

• take one action per item

• track results for 7 days

That's how you turn boxes into cashflow without panic-selling.

Disclaimer

This article is for educational and informational purposes only and does not constitute financial, investment, or business advice. All examples, frameworks, and templates are provided as general guidance for trading card sellers. Always do your own research and consult a qualified professional before making business or financial decisions. BlueVioletPoke LLC and its authors are not liable for any losses or damages resulting from the use of this content.