Excess inventory is stock a retailer holds beyond what its own sales rate will clear inside a useful window. It ties up cash the owner already spent, and it costs money every month it sits. Recovery runs in four moves: measure the inventory, classify eligible SKUs while holding new or incomplete items as Data Incomplete, rank the supported recovery candidates by dollars recoverable, and exit through markdown, bundling, or liquidation.
Key Takeaways
- Excess inventory is stock beyond what a store's own trailing sales rate will clear inside a useful window. The measurement runs per SKU, never per category.
- Overstock and dead stock are both forms of excess inventory. Overstock still sells but was bought too deep, and dead stock has no verified sales history.
- U.S. retailers held $832.4 billion in inventories at the end of May 2026, an inventories-to-sales ratio of 1.25 months, per the U.S. Census Bureau.
- Clothing and clothing accessory stores carried a 2.11 inventories-to-sales ratio in May 2026, per Census data published by FRED. That runs about 69 percent above the all-retail figure.
- The cost of excess inventory is built from five line items an owner already pays. Those are interest on the money tied up, occupancy, shrink and damage, handling labor, and insurance.
- Excess inventory shows up in the bank account before it shows up on the profit and loss statement. Inventory sits on the balance sheet at cost until it sells.
- The recovery sequence that returns the most cash runs measure, classify, rank, then exit. The ranking step is where most independent retailers lose money.
What This Guide Covers
- What excess inventory is, in one definition
- Why excess inventory hits your cash position first
- The nine causes of excess inventory in independent retail
- The cost of excess inventory, built from your own bills
- How to recover cash from excess inventory, in ranked order
- A worked example: one boutique, 2,940 SKUs, $186,000 at cost
- Benchmarks: what good looks like
- Comparing the recovery approaches side by side
- Excess inventory management: the rhythm that prevents the next pile
- Start here: five moves this week
- Frequently asked questions
What Excess Inventory Is, in One Definition
Excess inventory is stock a retailer holds beyond what its own trailing sales rate will clear inside a useful window. The definition is store-specific by design, because the same six units mean two different things in two different stores.
Six units of a candle that sells one a month is a two-month supply, and healthy. Six units of a candle that sells one a year is a five-year supply, and excess inventory.
Category never settles the question. The sell-through rate does, where sell-through is the share of units received that sold in a period.
I've walked stockrooms where the owner could name every problem SKU on sight. I've walked others where the owner was wrong about nine out of ten.
Both owners were working hard. The difference was whether anyone had joined the sales export to the on-hand list.
The Four Recovery States to Review
This guide uses four recovery states because each maps to a cash action. The live Cash Margin Partners workspace also separates stockout risk and data incomplete, protecting those items from recovery actions.
Dead stock is inventory with no verified sales history over the measured window, typically six months or more. It has failed at full price and at whatever promotional price the store already tried.
Slow-moving inventory is inventory still selling, but below the rate that justifies the shelf space and the cash it holds. A demand signal exists, which changes the exit.
Overstock inventory is inventory selling at a normal rate where the original buy went too deep. The product works; the quantity was the mistake.
Healthy is everything else, and the correct action on healthy stock is to leave it alone and protect the reorder. The trapped cash breakdown on the CMP site shows the four recovery states side by side with a sample dollar split.
Excess Inventory, Overstock, and Dead Stock Are Not Interchangeable Words
Excess inventory is the umbrella term. Overstock and dead stock are two species inside it, and they require different exits.
Overstock responds to price and placement, because customers still buy the item. Dead stock has already refused both, so another 10 percent off usually buys nothing except another month of storage.
Treating the two the same way is the most common recovery mistake I see. Owners run a storewide 25 percent sale and clear the overstock they'd have sold anyway at full price. The dead stock stays exactly where it was.
Excess inventory value, measured properly, is the sum of the at-cost dollars sitting in the first three states. That number is the one worth knowing before any pricing decision gets made.
Cash Margin Partners is an inventory cash-recovery practice for independent, owner-operated retailers. CMP shows you how much cash is trapped in unsold inventory, then gives you a prioritized plan to get it back.
Your own six-state workspace classification can be available after a successful supported import with sufficient history and cost evidence. Create a free workspace through the trapped-cash diagnostic, then use an eligible production connection or compatible item-level upload. There is no credit card and no trial clock.
Your Balance Sheet Calls It an Asset. Your Landlord Charges Rent on It.
Excess inventory hits your bank account long before it hits your profit and loss statement. Inventory sits on the balance sheet as an asset at cost. Nothing about it touches the income statement until the item sells.
That accounting treatment is correct. It's also why a store posts a profitable year and still struggles to make February rent.
The profit is real. Cash left the building at the purchase order and has been sitting in the back room ever since.
The back room is where cash goes to sit down and stop moving. It's a physical place with a rent number attached. Everything in this guide covers what enters that room, what it costs per month, and what gets it out.
Rent, Payroll, and Next Season's Buy Come Out of the Same Account
An independent retailer funds rent, payroll, and next season's buy from one operating account. Every dollar converted into inventory is a dollar unavailable for the other three until a customer converts it back.
Chains solve this with an inventory planning department. A single owner solves it between a delivery and a payroll run.
Small firms are already absorbing cost pressure from other directions. The Federal Reserve's 2026 Report on Employer Firms found 77 percent naming rising costs as a financial challenge. Those costs covered goods, services, and wages.
That survey drew 6,525 responses from firms with 1 to 499 employees, fielded between September and November 2025. It also found that for the second consecutive year, more firms reported revenue declines than increases.
Why Gross Margin Hides the Problem
Gross margin measures what happened to the items you sold. Excess inventory is defined entirely by items you didn't sell, so a strong margin percentage tells you nothing about it.
Two stores can both report a 52 percent gross margin. One turns its inventory four times a year and the other turns it twice. The second store has roughly double the cash locked up to produce the same margin rate.
Margin is a rate. Cash is a level. A store dies from the level.
Key Data Point: The National Inventory Position, May 2026
U.S. retailers held $832.4 billion in inventories at the end of May 2026, per the U.S. Census Bureau. The inventories-to-sales ratio stood at 1.25, meaning the sector held roughly 1.25 months of sales in stock.
Clothing and clothing accessory stores ran at 2.11 months over the same period, per Census data published by the St. Louis Fed.
What Trapped Cash Looks Like in a Real Week
Take a 1,400-square-foot apparel and home goods boutique running Shopify, with $186,000 of inventory at cost. The owner has a $40,000 line of credit drawn to $31,000 and a spring order due in nine days.
She has three options: draw further on the line, delay the order, or convert some of the $186,000 back into cash. Only the third option costs her nothing in interest.
The third option requires knowing which SKUs to touch. That's the whole job.
The Nine Causes of Excess Inventory in Independent Retail
Excess inventory in independent retail comes from nine repeatable causes. Eight of them happen at the purchase order rather than on the sales floor. Naming the cause matters, because the fix for a case-pack problem looks nothing like the fix for a reorder-default problem.
1. Buying to a Vendor Minimum Instead of to a Sell-Through Rate
Vendor minimums set the order quantity, and the store's sell-through rate sets what the order quantity should have been. When the minimum exceeds the rate, the gap becomes excess inventory on the day it's delivered.
A vendor with a 24-unit minimum, on a line the store sells four units a quarter, has written an 18-month supply. The order looked like a $600 decision and was a six-quarter decision.
Ask for a split minimum across two colorways, or split the minimum with another independent store in a different market. Both requests get granted more often than owners expect.
2. Ordering Against Last Year's Number Without Checking the Trend
Last year's units sold is a starting point, and treating it as the answer builds excess inventory in any declining category. The number to check is the direction of the last three periods, per SKU.
A SKU that sold 40, then 31, then 24 units across three seasons is telling you to buy 18. The reorder screen will suggest 40. Reorder screens read history, and they don't read direction.
3. Case-Pack Math That Nobody Ran
Case packs create excess inventory across dozens of small decisions nobody logs. A 12-pack on an item that sells three a month is a four-month buy. Four of those in one order is a stockroom.
Run the division before the order goes in: case quantity divided by monthly units sold equals months of supply. Anything over four months of supply on a non-seasonal item needs a reason stated out loud.
4. Discount-Driven Buying at Market
Market deals convert margin percentage into inventory months, and the trade is usually bad for a single-location store. A 15 percent buy-in discount on a 12-month supply costs more in carrying cost than it saved. The overrun arrives before the goods are half gone.
The math is straightforward. Say your carrying cost runs near 30 percent a year and the deal doubles your months of supply. The discount has to beat the extra carrying cost to be worth taking.
5. Reorder Defaults Left On in the Point of Sale
Automatic reorder points set once at setup and never revisited are a reliable source of overstock inventory. The threshold that made sense when a SKU sold weekly keeps firing after the SKU slows to monthly.
Pull your reorder point list and check it against trailing 90-day units for every SKU on it. Any reorder point above one month of trailing demand on a non-seasonal item needs to come down.
6. Size and Color Curves Copied From the Vendor's Sheet
Vendor size curves reflect national demand, and your store sells to a neighborhood. Copying the sheet produces excess inventory concentrated in the tails. The stockroom fills with extra-small and 3XL while the middle sizes sell out.
Build your own curve from your last four seasons of unit sales by size. It takes one afternoon and changes every apparel order you place after it.
7. Returns Re-entering Stock Without a Disposition Rule
Returned merchandise re-enters inventory at full cost and often at reduced sellability. Without a disposition rule, returns accumulate as a second, invisible pile of excess inventory beside the first.
Returns run large in retail. The National Retail Federation put 2025 returns at $849.9 billion, or 15.8 percent of annual sales, in its October 2025 returns forecast.
Write a one-line rule and tape it to the return counter. Restock if sellable as new, mark to a fixed clearance price if opened, dispose if damaged. The rule matters more than which thresholds you pick.
8. Category Expansion With No Exit Rule Attached
New categories get entered with enthusiasm and exited with paralysis. A category that never earns its square footage keeps getting reordered because backing out feels like admitting the test failed.
Attach an exit rule at entry. Write down the sell-through percentage and the date at which you'll stop reordering, before the first order ships.
The Ultimate Guide to Exiting a Product Category: Timing, Markdowns, and Liquidation covers how to unwind a category once the rule triggers.
9. Never Running an Aging Report
The ninth cause is the one that makes the other eight invisible. A store that never ages its inventory can't notice a SKU crossing from slow to dead. The crossing happens without a decision.
Inventory aging is the practice of bucketing on-hand units by days since last sale. Ninety, 180, and 365 day buckets are enough to run a store.
How to Run an Inventory Aging Report in 7 Steps walks through the exports and the join. It also covers stores whose point of sale has no aging feature.
Operator Tip: Run the Months-of-Supply Division Before Every Order
Divide the order quantity by the SKU's trailing monthly units sold. The result is months of supply, and it's the most useful number on a purchase order.
Cut or justify in writing anything above four months on a non-seasonal item. This one division prevents more excess inventory than any software purchase.
The Cost of Excess Inventory, Built From Your Own Bills
The cost of excess inventory is the sum of five line items an independent retailer already pays. Those five are interest on the money tied up, occupancy, shrink and damage, handling labor, and insurance.
Build the rate from your own bills. Borrowed industry averages produce a number you won't defend to yourself at 11 p.m.
Line Item One: The Interest on the Money Sitting Still
Inventory is cash you already converted, and the conversion has a price whether you borrowed or not. If you carry a line of credit, the rate on that line is your cost of capital.
The bank prime loan rate stood at 6.75 percent on July 31, 2026, per the Federal Reserve data published by FRED. A small retail line priced at prime plus two puts the rate near 8.75 percent.
If you carry no debt, use the rate you'd pay if you needed the money next week. That's the right figure, because excess inventory is what forces the borrowing.
Line Item Two: Occupancy, Which Is Rent With a Different Name
Occupancy is the largest carrying cost line for most independent retailers, and almost nobody allocates it to inventory. Divide annual rent by total square footage to get rent per square foot, then multiply by the square footage your stock occupies.
A 1,400-square-foot store paying $7,600 a month pays $91,200 a year, or about $65 per square foot. A 320-square-foot stockroom inside that store costs $20,800 a year to keep.
Against $186,000 of inventory at cost, that back room rent alone runs 11 percent per year. The landlord charges the same rate whether the boxes move or sit.
Line Item Three: Shrink, Damage, and the Slow Loss of Sellability
Goods degrade in storage. Boxes get crushed, apparel creases and fades at the fold, packaging yellows, and seasonal graphics date themselves out of sellability.
Track your own number for one quarter rather than guessing. Count what you scrapped, what you marked to clearance for condition, and what walked out unpaid. Divide the total by average inventory at cost.
Line Item Four: The Labor Nobody Bills to Inventory
Handling labor is real money spent moving inventory that produces no sale. Counting it, shifting it to reach other stock, and re-tagging it for a markdown round all cost payroll hours.
Price one cycle count. Two staff at four hours each, at $18 an hour, is $144 for one count of one section. Most stores run that several times a year.
Line Item Five: Insurance on Goods That Aren't Earning
Your commercial policy premium scales partly with the value of insured contents. Inventory you're carrying past its selling window keeps generating premium without generating sales.
One percent of inventory value per year is a reasonable placeholder until you check your declaration page. Check the page.
Adding It Up: A Carrying Cost Rate You Can Defend
Stack the five lines and you get a defensible annual carrying cost rate for your store. For the 1,400-square-foot boutique above, the stack looks like this.
| Carrying cost line item | Annual rate | Where the number comes from |
|---|---|---|
| Cost of capital | 8.75% | Prime at 6.75% on July 31, 2026, plus 2 points on the store's line of credit |
| Occupancy allocated to storage | 11.0% | 320 stockroom square feet at $65 per foot, against $186,000 of inventory at cost |
| Shrink, damage, condition markdowns | 6.0% | Store's own scrap and condition-clearance log |
| Handling labor | 3.0% | Counted hours at store payroll rates |
| Insurance on contents | 1.0% | Commercial policy declaration page |
| Total annual carrying cost | 29.75% | Sum of the five lines above |
Just under 30 cents per dollar per year, on money the owner has already spent. That figure is why the cost of excess inventory compounds faster than owners expect.
The Sixth Cost, Which Doesn't Fit in the Table
Opportunity cost is the buy you couldn't make, and it's usually the largest number in the whole exercise. Cash locked in a 14-month supply of last spring's line can't buy from the vendor whose product turns six times a year.
A dollar in a SKU turning six times a year does six times the work of a slower dollar. The excess inventory doesn't only cost 30 percent. It costs 30 percent plus every turn it prevented.
That's the number I'd put on the wall.
Key Insight: Markdown Cost Rises With Age, So Waiting Is a Decision
The discount required to move a SKU rises the longer it sits. The customers who wanted it at full price have already come and gone.
A slow mover caught at 90 days often clears at 20 to 30 percent off. The same SKU at 400 days usually needs a liquidation channel.
Liquidation returns less per unit, so every month of delay costs recovery value. Holding is never neutral.
Put Your Own Number in Place of 29.75 Percent
Thirty cents on the dollar per year is what the example store pays to hold stock it already owns. Your rate will differ, and so will the dollar base it applies to.
Create a free trapped-cash workspace and use an eligible production connection or compatible item-level upload. After a successful import with sufficient history and cost evidence, it can return the six-state classification and supported at-cost dollars by state. Direct provider availability depends on production launch status and workspace eligibility.
How to Recover Cash From Excess Inventory, in Ranked Order
Cash recovery from excess inventory runs in a fixed sequence: measure, classify, rank, then exit. Independent retailers lose the most money at the ranking step. Ranking by what looks worst in the stockroom differs from ranking by dollars recoverable.
Step 1: Measure Before Anyone Argues About What to Do
Measurement comes first because every downstream decision depends on the dollars at stake. Two exports settle it: current on-hand units with unit cost, and line-item sales for the trailing 12 months.
Join the two files on SKU. Any SKU with on-hand units and no sales rows is dead stock. That single flag usually takes 20 minutes in a spreadsheet.
Cash Margin Partners can run this join after a successful supported import. Direct read-only Shopify, Square Point of Sale, and Lightspeed Retail X-Series availability depends on production launch status and workspace eligibility; compatible item-level uploads remain available after guided column review. The current catalog sits on the CMP integrations page, which also notes Clover as coming next.
Step 2: Classify Recovery Candidates Into Four States
Classification turns a pile of dollars into a set of decisions. Sort eligible SKUs into dead stock, slow mover, overstock, stockout risk, or healthy active, hold new or insufficiently evidenced items as Data Incomplete, and record the supported at-cost dollars in each bucket.
The classification changes the exit. Dead stock goes to a channel exit, and slow movers go to a markdown ladder. Overstock goes to bundling and placement, and healthy stock gets protected from all of it.
Retailers who skip classification run storewide sales. Storewide sales discount the healthy stock that was going to sell anyway. A clearance event can shrink margin without reducing the pile.
Step 3: Rank by Dollars Recoverable per Week of Effort
Ranking is where the cash gets made or lost. Sort the excess by at-cost dollars, then divide by the weeks each group needs.
A single $9,400 overstock position in one SKU family outranks 180 scattered dead SKUs worth $6,100. The first is one decision and the second is 180. Work the concentrated positions first.
"I already know what's stuck." A ranked, SKU-level view still matters because it turns that intuition into an order of work for the week.
Step 4: Move What Still Has a Demand Signal at Full Price
Overstock with a live demand signal often clears without a markdown. Move it to a primary fixture, bundle it with a best seller, or feature it in the next email.
Bundling protects margin better than discounting because the customer perceives added value rather than reduced price. A $48 overstock item bundled with a $32 best seller at $69 clears the overstock at an effective 14 percent off.
Step 5: Run a Structured Markdown Ladder on Slow Movers
Slow movers respond to price, so the goal is finding the lowest discount that restarts unit movement. Ladders beat one-shot markdowns because they stop at the first price that works.
Run 20 percent for 14 days, then 35 percent for 14 days, then 50 percent for 14 days. Measure units moved at each step and stop the ladder the moment the SKU clears.
Set the floor before you start. Below your cost plus handling, a liquidation channel usually returns more per hour of staff time than the fourth markdown round.
Step 6: Send Dead Stock to a Channel Exit Instead of a Fourth Markdown
Dead stock has already failed at full price and at promotional price. A channel exit converts it faster than a fourth discount. Liquidation channels move goods in lots to buyers who resell in other markets.
CMP Exchange is Cash Margin Partners' proposed liquidation marketplace. Its published model connects sellers to participating buyers with no subscription and a 10 percent fee on a closed transaction. The intended Stripe checkout and post-delivery payout sequence remains subject to production acceptance and workspace availability.
A published 10 percent close fee is real money on a large lot. On a big enough position, a direct broker relationship may cost less. The marketplace page describes the intended lot listing and payout sequence; confirm production acceptance and workspace availability before relying on it.
Step 7: Ask the Vendor Before You Assume the Answer
Vendor returns and swaps recover more than owners assume, because most owners never ask. Return-to-vendor windows, seasonal swaps, and credit against next season's order all exist in independent wholesale.
Ask with a specific proposal attached. "I'll take $2,400 of credit against fall for these 60 units" beats a general complaint about sell-through.
Step 8: Donate or Dispose, Last
Donation and disposal are the final stop, and they return no cash to the operating account. Reach them only after markdown, bundling, channel exit, and the vendor conversation.
Donation and write-off treatment are tax questions that turn on your entity and your accounting method. Talk to your accountant before you scrap or donate anything.
Step 9: Fix the Buy That Created the Pile
Recovery without a buying change produces the same pile next season. Trace each excess position back to its cause, then change the behavior that produced it.
A case-pack cause gets a months-of-supply rule, and a reorder-default cause gets a threshold audit. Before the next market, a vendor-minimum cause gets a split-minimum conversation.
The back room stays empty only when the purchase order changes.
A Worked Example: One Boutique, 2,940 SKUs, $186,000 at Cost
The store below is illustrative, built to show the arithmetic end to end. The figures are constructed for teaching rather than drawn from any one CMP account.
Take a 1,400-square-foot apparel and home goods boutique running Shopify, with 320 square feet of stockroom and $7,600 in monthly rent. On-hand inventory runs $186,000 at cost across 2,940 SKUs, against $412,000 in trailing 12-month cost of goods sold.
The Four Recovery-State Split
| State | SKUs | At-cost dollars | Share of inventory value |
|---|---|---|---|
| Dead stock (zero sales, 6 months or more) | 412 | $21,800 | 11.7% |
| Slow mover | 638 | $24,900 | 13.4% |
| Overstock | 511 | $31,200 | 16.8% |
| Healthy | 1,379 | $108,100 | 58.1% |
| Total | 2,940 | $186,000 | 100% |
Dead stock and slow movers together hold $46,700, or 25.1 percent of inventory value. At the 29.75 percent carrying rate built earlier, that $46,700 costs about $13,893 a year to keep.
Thirteen thousand eight hundred ninety-three dollars is 1.8 months of this store's rent. The owner is paying it to store goods she already bought and already paid for.
What the Ranked Plan Looks Like
Ranking by concentration changes the order of work. The 511 overstock SKUs hold the most at-cost dollars and cluster into 34 product families, so they move first.
- Overstock, $31,200 across 34 families. Bundle and re-merchandise at an effective 12 to 15 percent off, with no storewide sale.
- Slow movers, $24,900 across 638 SKUs. Run the 20, 35, 50 percent ladder in 14-day steps, with a floor at cost plus handling.
- Dead stock, $21,800 across 412 SKUs. Build two liquidation lots by category and list them, keeping nothing back for one more try.
- Healthy, $108,100. Protect the reorder and keep it out of every promotion above.
The Illustrative Arithmetic on the Exits
These outcome figures are illustrative assumptions for a constructed store. Real results vary by category, season, and buyer demand, and no tool can promise them.
| Exit | At-cost dollars | Illustrative recovery rate | Cash returned |
|---|---|---|---|
| Overstock: bundling and placement | $31,200 | 1.35x cost at retail after bundle discount | $42,120 |
| Slow movers: 3-step markdown ladder | $24,900 | 1.05x cost after ladder | $26,145 |
| Dead stock: liquidation lots | $21,800 | 0.35x cost, less the 10% close fee | $6,867 |
| Total | $77,900 | $75,132 |
The dead stock line is the one owners argue with. Thirty-five cents on the dollar of cost is a fair illustrative rate for a mixed lot. The alternative is holding $21,800 at roughly $6,485 a year in carrying cost while it ages.
Three years of holding costs more than the liquidation gap. That comparison is the whole argument for moving early.
What Changes on the Balance Sheet
Converting $77,900 of at-cost excess inventory into roughly $75,132 of cash doesn't change the store's net worth much on paper. It changes what the owner can do on Monday, which is the point.
The spring order gets placed without drawing the line of credit. The stockroom loses 412 dead SKUs, so cycle counts get faster and staff stops shifting boxes to reach other boxes.
Recovered cash is the store's own capital converted back from inventory. No loan, no advance, no outside money.
Benchmarks: What Good Looks Like
Benchmarks for excess inventory come in two forms. National ratios come from Census data, and store-level targets come from your own history. National ratios include chains with inventory departments, so read them as context.
The National Inventories-to-Sales Ratio
The U.S. Census Bureau publishes an inventories-to-sales ratio monthly for retail trade. Retailers held a 1.25 ratio in May 2026 against $832.4 billion in inventories, per the Census Bureau's May 2026 report.
A 1.25 ratio means roughly 1.25 months of sales sitting in stock at the end of the month. That figure is dominated by high-turn sectors including motor vehicle dealers, grocery, and gasoline stations.
Apparel runs far heavier. Clothing and clothing accessory stores posted a 2.11 ratio in May 2026, per Census data published by the St. Louis Fed. That sits about 69 percent above the all-retail figure.
Compare yourself to your own subsector rather than to the headline number. A gift shop benchmarking against 1.25 will conclude it's failing when it's ordinary.
Store-Level Targets Worth Setting
National ratios describe the sector. These four store-level targets describe your operation, and each one is computable from exports you already have.
| Metric | How to compute it | An operating target worth defending |
|---|---|---|
| Inventory turns | Trailing 12-month cost of goods sold divided by average inventory at cost | Set against your own trailing four quarters, and move the number up quarter over quarter |
| Dead stock share | At-cost dollars with zero sales in 180 days, divided by total inventory at cost | Under 10 percent of inventory value, checked monthly |
| Excess inventory value | Combined at-cost dollars in dead stock, slow movers, and overstock | Under 25 percent of inventory value on a non-seasonal month |
| Aged inventory | At-cost dollars in the 365-day-plus bucket of an aging report | Under 5 percent, and falling every quarter you work the plan |
The example boutique above sits at 25.1 percent in dead and slow stock alone, before overstock. Adding overstock puts it at 41.9 percent of inventory value in the three problem states.
The metric to track is the combined dead stock, slow mover, and overstock share of on-hand inventory value. No published benchmark exists for it at independent-retail scale. Your own trailing quarters are the comparison that works.
The Benchmark That Matters More Than the Ratio
Direction beats level. A store at 30 percent excess inventory value, falling three points a quarter, beats a store at 20 percent rising two.
Measure the same way every month, from the same exports. Consistency is what makes the trend readable.
Comparing the Recovery Approaches Side by Side
Each recovery approach trades cash recovered against speed and staff time. The table below compares the five approaches covered in this guide.
| Approach | Typical cash recovered per dollar of cost | Speed | Staff time required | Use it when |
|---|---|---|---|---|
| Bundling and re-merchandising | Highest, often near full margin | Slow, follows normal traffic | Low, merchandising hours only | The SKU still sells and the buy went too deep |
| Structured markdown ladder | Moderate to high, depending where the ladder stops | Weeks, in 14-day steps | Moderate, re-tagging each step | The SKU has sales in the last 90 days |
| Liquidation marketplace lot sale | Lower per unit, applied to a large block | Fast once a buyer commits | Low, one listing covers many SKUs | The SKU has zero sales over the measured window |
| Vendor return, swap, or credit | Varies, and can reach full cost as credit | Depends on the vendor's calendar | Low, one conversation per vendor | The goods are current-season and the relationship is active |
| Donation or disposal | No cash returned | Immediate | Low | Every other exit has been tried |
Read the table by state rather than by preference. Dead stock belongs in rows three, four, and five; overstock belongs in rows one and two.
Excess Inventory Management: The Rhythm That Prevents the Next Pile
Excess inventory management is an operating rhythm rather than a one-time cleanup. A store that recovers $75,000 and changes nothing about its buying will rebuild the same position inside four seasons.
The rhythm has three cadences: a weekly check, a monthly measurement, and a quarterly decision. All three run off exports you already produce.
The Weekly Check: Five Minutes on New Arrivals
Every week, look at what arrived and what it committed you to. Run months-of-supply on each receipt: units received divided by trailing monthly units sold.
Flag anything above four months and note the reason. Half will have a good reason, and the other half are the next pile forming.
The Monthly Measurement: The Four Recovery-State Split
Once a month, on the same day, produce the four recovery-state split and record the at-cost dollars in each state. One row per month builds the trend line that runs the store.
Watch the movement between states more than the totals. SKUs crossing from slow mover into dead stock are the leading indicator, because that crossing is where recovery value drops fastest.
Cash Margin Partners can produce the split after a successful supported import with sufficient history and cost evidence. Report and export availability follows successful processing and data sufficiency; history depth and timing vary by source. Forecasts require a recent successful supported live connection with sufficient usable evidence. The workspace is free, with no credit card required.
The Quarterly Decision: Open to Buy and Category Exits
Every quarter, set an open-to-buy figure and enforce it. Open to buy is the dollar amount available for new purchases after committed orders and target ending inventory.
Quarterly is also when category exit rules get checked. Any category below its stated sell-through threshold at its stated date stops getting reordered.
7 Best Inventory Planning Software covers the tools built for the planning side of this work. 7 Best Prediko Alternatives narrows the field for stores already evaluating one specific tool.
Where Judgment Still Belongs
My position, and it's a minority one: buying judgment beats any forecasting model. Apply that judgment to a shorter list.
The model's job is producing the list. Your job is deciding which 20 of those 400 SKUs deserve a real conversation.
No gut-feel decisions on which SKUs are problems. All the gut you have on what to do about them.
Start Here: Five Moves This Week
These five moves run in order, and the first one takes 20 minutes with data you already have. None of them requires a purchase.
- Export two files today. Pull a current on-hand inventory list with unit cost from your point of sale. Pull a line-item sales export covering the last 12 months.
- Join them on SKU and flag the zeros. Any SKU with on-hand units and no sales rows in 12 months is dead stock. The at-cost sum of those rows is your first real number.
- Build your carrying cost rate from your own bills. Stack your line-of-credit rate, your allocated stockroom rent, your scrap log, your handling hours, and your insurance premium.
- Multiply the two. Dead stock dollars times your carrying rate is what you pay per year to store goods producing no sales. One more division converts it to months of rent.
- Pick the single largest concentrated position and exit it this month. One product family, one decision, one exit, before you touch the scattered long tail.
Download the Excess Inventory Recovery Worksheet
The worksheet runs the five moves above in one spreadsheet. It includes the SKU join formula, the four recovery-state worksheet logic, and a carrying cost calculator with the five line items.
A ranked exit sheet sorts by at-cost dollars per product family. Enter your email to get the file.
Frequently Asked Questions
What counts as excess inventory in a retail store?
Excess inventory is any stock a retailer holds beyond what its own trailing sales rate will clear inside a useful window. Six units of a candle that sells one a month is a two-month supply, and healthy. Six units of the same candle selling one a year is a five-year supply, and excess inventory.
How much does excess inventory cost an independent retailer to carry for a year?
Carrying cost is the sum of five line items the retailer already pays. Those five are interest on the money tied up, occupancy, shrink and damage, handling labor, and insurance. A store paying prime plus two, with 11 percent of rent allocated to storage, lands near 30 cents per dollar per year.
What is the difference between excess inventory, overstock, and dead stock?
Excess inventory is the umbrella term for stock beyond what the store's sales rate will clear. Overstock still sells at a normal rate, where the buy went too deep. Dead stock has no verified sales history over the measured window, and each of the two calls for a different exit.
Should I mark down excess inventory or liquidate it?
Mark down inventory that still has a demand signal, and liquidate inventory that has none. A SKU with sales in the last 90 days usually responds to a price change, so a markdown ladder works. A SKU with zero sales in six months has already failed at full price, so a liquidation channel converts it faster.
How do I find excess inventory if my POS has no aging report?
Export a current on-hand inventory list with unit cost and a line-item sales export covering the last 12 months. Join them on SKU, flag eligible SKUs with on-hand units and zero sales rows, and hold missing-history or missing-cost items as Data Incomplete. Cash Margin Partners can run the same join after a successful supported import; direct provider availability depends on production launch status and workspace eligibility.
Can I write off excess inventory instead of selling it?
Write-downs, write-offs, and donation deductions are tax questions, and they turn on your entity type, your inventory accounting method, and your jurisdiction. Talk to your accountant before you scrap or donate anything. A write-off returns no cash to the bank account, so treat disposal as the last stop after every other exit.
How fast can an independent retailer recover cash from excess inventory?
Recovery speed depends on the category, the depth of the excess, and buyer demand, so no tool can promise a timeline. After a recent successful supported live connection supplies sufficient usable history and cost evidence, Cash Margin Partners can forecast cash-at-risk over 30-, 60-, and 90-day windows and rank supported recovery actions by projected dollars. Those projections are forecasts rather than commitments; import and classification timing varies by source and evidence sufficiency.
Measure the Back Room Before You Argue About It
Excess inventory is a measurement problem before it's a pricing problem. Every markdown argument and every category exit gets easier once the at-cost dollars in each state are on a screen.
Run the two exports and the join yourself this week, or connect a store and let the diagnostic do it. Either path ends with the same thing: a number, per SKU, instead of an impression.
Start with a free Cash Margin Partners workspace through the trapped-cash diagnostic. Use an eligible production connection or compatible item-level upload, then review the six-state workspace classification after the import succeeds with sufficient history and cost evidence.