EN
Inventory and Products

What Is Dead Stock, How Do You Spot It and How Do You Clear It? A Guide to Stock Aging, Holding Costs and a Clearance Plan

How do you identify and clear dead stock? Inventory aging, holding cost, comparing discounting with waiting and a prevention plan: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is dead stock, and how does it differ from slow-moving stock?
  3. Lesson 2: How do you identify dead stock?
  4. Lesson 3: How do you prepare an inventory aging table?
  5. Lesson 4: Why does dead stock occur?
  6. Lesson 5: How is the holding cost of dead stock calculated?
  7. Lesson 6: What are the ways to clear dead stock?
  8. Lesson 7: Discount or wait? The 12-month results of three options
  9. Lesson 8: How do you prevent new dead stock and set up a monthly routine?
  10. What are the most common mistakes with dead stock?
  11. How does NetKasam make tracking dead stock easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Pull your inventory aging table this month
  14. Frequently Asked Questions About Dead Stock

You look at the boxes on the back shelf of the warehouse: the 400 units you bought two years ago thinking "this will sell this season" are still there. They are listed on the sales page, and five units go out a month. These products cost ₺40,000, and that money can neither turn into new inventory nor go toward payments. Shelf space, insurance and the hassle of counting come on top of that. This situation is called dead stock, and its most dangerous side is that it is silent: it does not appear as any line in the profit statement, but it slows down your cash flow a little more every month.

This article is not a narrative but an 8-lesson practical training. We will answer the question how do you identify and clear dead stock with numbers: using a sample warehouse, we will work through the inventory aging table, the holding cost formula, the "discount or wait" comparison (the 12-month results of three options for the same product) and the rules that prevent dead stock from forming. At the end there is a mini quiz and a monthly routine. You can find how to classify products by speed and value in the ABC analysis article and the effect of discounting on profit in the article how to discount without making a loss; here we apply both to the dead stock problem.

What will you be able to do by the end of this training?

In short: You will age your inventory, identify dead stock, calculate the holding cost, compare the results of clearance options and set up a monthly routine that prevents new dead stock from forming.

Training mapSix steps from identifying dead stock to clearing it
  1. 01
    DataExtract each product's last sale date and stock quantity.
  2. 02
    AgeDivide inventory into age brackets and set the dead stock threshold.
  3. 03
    CostCalculate the monthly holding cost of tied-up cash.
  4. 04
    OptionsCompare discounts, bundles, channel changes and returns to the supplier.
  5. 05
    PlanSet the price and timeline and write the clearance plan.
  6. 06
    PreventionSet ordering and monitoring rules so that no new dead stock forms.

The training's 8 lessons: (1) what dead stock is, (2) how to identify it, (3) the aging table, (4) why it occurs, (5) holding cost, (6) clearance options, (7) discount or wait, (8) prevention and monthly routine.

Lesson 1: What is dead stock, and how does it differ from slow-moving stock?

In short: Dead stock is inventory that has sold not at all, or almost not at all, for a certain period and is very unlikely to sell under current conditions. Slow-moving stock is still selling but clearing more slowly than expected.

TypeDefinition (sample thresholds)RiskAction
Healthy stockSales in the last 30 daysLowNormal management, critical stock monitoring
Slow-moving stockNo or very low sales for 31-180 daysMediumLight intervention such as price, visibility or bundles
Dead stockNo sales for more than 180 daysHighClearance plan: discount, bundle, channel, return

Thresholds vary by business: in fashion it is the season, in electronics the model cycle and in consumables the expiry date that decides. The numbers above are only examples; set them according to your own sales cycle. For the importance of inventory turnover, see the article the role of inventory turnover.

Lesson 2: How do you identify dead stock?

In short: For each product, look at the last sale date and units sold in the last 90 days. Products with high stock and zero or near-zero sales are candidates; if days of inventory (stock ÷ daily sales) is far above the threshold, it is dead stock.

  1. Pull the stock list: Product, variant, warehouse, quantity and unit cost.
  2. Add the last sale date: Find when each product was last sold.
  3. Add sales for the last 90 days: How many units were sold in the last three months?
  4. Calculate days of inventory: Stock ÷ (sales in the last 90 days ÷ 90).
  5. Flag against the threshold: Items whose days of inventory or time since last sale exceed the threshold are dead stock candidates.
  6. Consider the cause: Has the season ended, has the product become outdated, is the price too high, or has visibility been lost?

If you have distributed inventory across marketplace channels, a product that looks dead in one channel may be selling in another; view inventory from one central point: how to manage store and e-commerce inventory in one place. In NetKasam, you can see inventory movements on one screen, track inventory turnover rates and set critical stock quantities for products (inventory management).

Lesson 3: How do you prepare an inventory aging table?

In short: Inventory aging divides the cost value of inventory into brackets based on the time since the last sale (or since it entered the warehouse). It shows at a glance how much of the total inventory value is not moving.

Sample warehouse: total inventory cost ₺1,200,000 (the figures were chosen only to illustrate the method).

ChartDistribution of the sample warehouse's inventory value by time since last sale
  • 0-30 days₺540,00045%
  • 31-90 days₺360,00030%
  • 91-180 days₺180,00015%
  • 181-365 days₺84,0007%
  • Over 365 days₺36,0003%

Prepared with sample values. 181 days and over is ₺120,000.

Age rangeInventory valueShareInterpretation
0-30 days540.000 ₺%45Healthy, fast-moving
31-90 days360.000 ₺%30Normal
91-180 days180.000 ₺%15Put on watch, slow-moving stock
181-365 days84.000 ₺%7Dead stock, clearance plan
Over 365 days36.000 ₺%3Dead stock, liquidation plan
Total1.200.000 ₺%100Over 181 days: 10% (₺120,000)

Check: 45 + 30 + 15 + 7 + 3 = 100. The dead stock share is 10%; looking at this share every month is half the job.

Lesson 4: Why does dead stock occur?

In short: Dead stock is mostly caused by overbuying, the end of a season, a wrong forecast, an outdated product or a price and visibility problem. Knowing the cause determines both the clearance method and how to prevent it from happening again.

ReasonSignPrevention
OverbuyingPurchase quantity far above the sales forecastTie purchases to the sales forecast (sales forecasting)
End of seasonSeasonal products left over at the end of the seasonAn end-of-season plan and an early discount calendar
Product obsolescenceA new model has come out, the old model is waitingClear the old stock ahead of a model change
Price or visibility problemThe product has a page, but no one looks at itCheck title, images and price
Supply ruleMinimum order quantity is high, the remaining stock sits waitingCalculate the minimum order together with total need
Channel problemThe product is waiting in the wrong channelTrack inventory from one central point, change the channel

Lesson 5: How is the holding cost of dead stock calculated?

In short: Holding cost = tied-up inventory cost × monthly financing cost × number of months. While inventory sits on the shelf, the money cannot be used for purchasing, paying debts or investing; this opportunity cost is a real loss.

FormulaFive formulas for dead stock analysis
  1. Days of inventory = Stock quantity ÷ (Sales in the last 90 days ÷ 90)
  2. Dead stock share = Value of stock above the threshold ÷ Total inventory value
  3. Holding cost = Average tied-up inventory cost × Monthly financing cost × Number of months
  4. Clearance result = Sales revenue − Cost of goods sold − Holding cost
  5. Cash recovered = Units sold × Discounted price

The monthly financing cost is your loan or cash cost; 3% is assumed in the examples, so use your own rate.

Example: ₺120,000 of dead stock × 3% per month = ₺3,600 a month and ₺43,200 a year in holding cost. The more inventory decreases, the lower the cost; you can see your own financing cost with the loan calculator. For the effect of tied-up cash on working capital, see the article how to calculate working capital.

Recommended readingHow Do You Calculate Working Capital?

Lesson 6: What are the ways to clear dead stock?

In short: The main options are discounted sales, product bundles, switching channels or markets, returning to or swapping with the supplier and bulk sales. Whichever is chosen, the goal is to get cash back.

LeverHow does it work?When is it appropriate?Note
Discounted salesThe price is lowered in stagesThe product has demand, but the price is highBrand perception; the discount loss must be calculated
BundleA slow product is sold together with a fast oneComplementary productsBundle price and stock matching
Channel changeThe product is sold on another marketplace, in a store or abroadThe product is stuck in one channelCommission and shipping differences
Return to or swap with the supplierUnsold products are returned or swapped for new productsIf the supplier allows flexibilityContract terms
Bulk saleSelling the whole lot to a single buyerLarge quantity, long-standing dead stockHigh discount, cash arrives quickly
Scrapping, destruction, donationProducts with no remaining sales valueNo chance of a saleConsult your certified public accountant on tax treatment and documentation

You can use the campaign module for discount plans: in NetKasam, you can create and report on campaigns by branch, warehouse, product, category or customer group. To move sales abroad, see the integrations page.

Lesson 7: Discount or wait? The 12-month results of three options

In short: Waiting at normal price is slow and expensive; clearing quickly with a reasonable discount is often more profitable after holding cost. The decision is made with numbers.

Sample product: unit cost ₺100, normal price ₺250, dead stock 400 units (₺40,000). The assumptions for the three options were chosen only to illustrate the method:

A: Wait at normal priceB: 20% discountC: 40% discount
Price250 ₺200 ₺150 ₺
Sales rate (assumption)5 units / month20 units / month100 units / month
Sold in 12 months60 units240 units400 units (sold out in 4 months)
Revenue15.000 ₺48.000 ₺60.000 ₺
Cost of goods sold6.000 ₺24.000 ₺40.000 ₺
Gross profit9.000 ₺24.000 ₺20.000 ₺
Holding cost (3% monthly)13.320 ₺10.080 ₺2.400 ₺
12-month net result−4.320 ₺13.920 ₺17.600 ₺
Stock remaining after 12 months340 units160 units0 units
ChartDead stock left after 12 months: the bigger the discount, the faster it clears
  1. A: Wait at normal price340 units
  2. B: 20% discount160 units
  3. C: 40% discount0 units

Prepared with sample values. The sales rate assumptions should be replaced with your own data.

Calculations: for A, average tied-up stock (400 + 340) ÷ 2 = 370 units × 100 = ₺37,000; 37,000 × 3% × 12 = ₺13,320. For B, (400 + 160) ÷ 2 = 280 units = ₺28,000; 28,000 × 3% × 12 = ₺10,080. For C, (400 + 0) ÷ 2 = 200 units = ₺20,000; 20,000 × 3% × 4 = ₺2,400. In C, ₺60,000 of cash is also freed up after month 4 for new inventory or another need. If the sales rate assumption does not hold, the result changes; that is why you should track each campaign weekly and lower the price in stages.

Lesson 8: How do you prevent new dead stock and set up a monthly routine?

In short: The cheapest solution is never creating dead stock: tie purchases to forecasts, track products monthly by age and intervene early on products that are slowing down.

When?What to do?Output
Every monthPull the inventory aging table; flag items entering the 91-180 day bracketWatch list
Every monthCheck the decisions on the dead stock list and clearance progressDead stock share
Before every purchaseCompare the order quantity with the sales forecast and current stockApproved order
Before the seasonWrite down the end-of-season clearance plan and datesSeason calendar
Once a quarterAnalyze the sources of dead stock (supplier, category, buyer)Purchasing rules
Takeaways from the exampleFour numbers from the sample warehouse
  • 10%dead stock share (120,000 ÷ 1,200,000)
  • ₺3,600holding cost per month
  • ₺17,60012-month net result with a 40% discount
  • −₺4,320net result from waiting at normal price

To prevent overbuying, safety stock and the sales forecast are used together. Record outdated and damaged products found during counting separately, following the rules in the stock count article.

Recommended readingHow Do You Simplify a Product Catalog? Training on Core, Middle and Tail Products, Management Cost per Product, the Net Contribution Table, Criteria for Products to Remove and the Break-Even Point

What are the most common mistakes with dead stock?

  1. Treating waiting as free. The cost of tied-up cash accrues every month.
  2. Not aging inventory. Dead stock is invisible when you look only at total inventory value.
  3. Discounting too late. As the product ages, its value drops and the season is missed.
  4. A very large discount all at once. Staged discounts protect price perception and let you measure the sales rate.
  5. Discounting without calculating the margin. The sale may fall below cost.
  6. Not moving dead stock to another channel. What is dead in one channel may sell in another.
  7. Repeating the same mistake. If the purchasing rule does not change, new dead stock forms.

How does NetKasam make tracking dead stock easier?

  • Inventory movements on one screen. You see all movements of your inventory in detail and track the last movement date (inventory management).
  • Inventory turnover and cost report. You see inventory turnover rates and product expenses and report on your costs.
  • Critical stock report. You prevent unnecessary purchases by setting critical stock quantities for your products.
  • Campaign module. For dead stock, you create campaigns for a specific product, category, branch, warehouse or customer group and report on the results.
  • Multiple warehouses and branches. You see inventory by warehouse and branch and direct it to where sales happen (branch and warehouse management).
  • Saved reports. You save the monthly aging report and export it to Excel (reports).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If total inventory value is ₺800,000 and stock over 180 days is ₺64,000, what is the dead stock share?
  2. For ₺80,000 of dead stock, what is the 6-month holding cost at a monthly financing cost of 2%? (assume stock stays constant)
  3. If you sell 300 units of a product with a unit cost of ₺50 at ₺80 over 2 months, what is the gross profit?
  4. Why is product aging more informative than total inventory value?
  5. If you cannot sell dead stock in one channel, which option can you try?

Answer key:

  1. 64.000 ÷ 800.000 = %8.
  2. 80.000 × 0,02 × 6 = 9.600 ₺.
  3. 300 × (80 − 50) = 9.000 ₺.
  4. Total value mixes healthy stock with dead stock; aging shows which share is not moving.
  5. Moving it to another channel, marketplace or market, bundling it or selling it in bulk.

Frequently Asked Questions About Dead Stock

What is dead stock?

It is inventory that has not sold for a long time and is unlikely to sell under current conditions. The threshold is set by each business; for example, inventory with no movement for 180 days can be considered dead.

How do you identify dead stock?

Look at each product's last sale date and sales over the last 90 days, prepare an inventory aging table and flag products that exceed the turnover-days threshold as dead stock.

How do you clear dead stock?

Methods such as discounted sales, bundles, switching channels, returning to or swapping with the supplier and bulk sales are used. The goal is not profit but getting cash back.

How is holding cost calculated?

Average tied-up inventory cost, monthly financing cost and the number of months are multiplied. ₺120,000 of inventory at a monthly cost of 3% is ₺3,600 a month.

Does discounting cause a loss?

If the price stays above cost, every sale makes a contribution and lowers the holding cost. Dropping the price below cost is a deliberate liquidation decision and should be calculated separately.

Does dead stock require tax treatment?

Transactions such as scrapping, destruction or donation have documentation and tax consequences; consult your certified public accountant (mali müşavir). This article only explains the calculation method.

Can I see inventory turnover in NetKasam?

Yes. You can see inventory turnover rates, report your product expenses and costs and track inventory movements on one screen.

Can I run campaigns for dead stock in NetKasam?

Yes. You can create campaigns by branch, warehouse, product, category or customer group, and report on and analyze them.

Conclusion: Pull your inventory aging table this month

Dead stock is invisible at first glance, but the aging table brings it to light. This month, divide your inventory into five brackets by last sale date, add up the value over 180 days and write down a decision and a date for the three largest items. Once you calculate the holding cost, the discount decision becomes much easier.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeInventory Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools