EN
Inventory and Products

How Do You Run an Inventory Aging Analysis? A Guide to Inventory Age, Age Brackets and the Value Table, Sell-Through Time, Carrying Cost, the Wait-or-Discount Decision and the New Purchase Limit

How do you do an inventory aging analysis? Inventory age, age brackets, sell-through time, carrying cost and the hold-or-discount decision: 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: How is inventory age defined?
  3. Lesson 2: How do you build age brackets and a value table?
  4. Lesson 3: How many months does each bracket take to sell through?
  5. Lesson 4: What is the carrying cost of old stock?
  6. Lesson 5: Is it more profitable to hold or to discount?
  7. Lesson 6: How do you clear old stock?
  8. Lesson 7: How do you limit new purchases based on inventory age?
  9. Lesson 8: How do you monitor inventory aging?
  10. What are the most common mistakes in inventory aging?
  11. How does NetKasam make inventory aging tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Write your inventory's age in a table
  14. Frequently Asked Questions About Inventory Aging Analysis

Every product sitting in the warehouse locks money onto the shelf. But not all stock carries the same burden: a product that arrived yesterday is likely to sell tomorrow, while there is no guarantee that a product that arrived eight months ago will sell this month. Looking at the total inventory value hides this difference; an inventory aging analysis slices the same amount by age and shows which part is really the problem.

This article is not a lecture but an 8-lesson hands-on course. We will answer how to do an inventory aging analysis using a sample warehouse with a cost value of ₺1,200,000: the correct definition of inventory age, a value table by age bracket, how long each bracket takes to sell through, the carrying cost of old stock, the break-even point between holding and discounting, ways to clear stock, limiting new purchases and monitoring indicators. At the end there is a mini quiz with an answer key. All figures are sample values chosen to illustrate the method; follow the same steps with your own data.

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

In short: You will slice your inventory by age, calculate how long each bracket will take to sell, find the cost of old stock, make the "hold or discount" decision with numbers and limit new purchases based on age.

Course mapSix steps of an inventory aging analysis
  1. 01
    DefineCalculate inventory age from the entry date.
  2. 02
    SliceDivide inventory into age brackets and write down their value.
  3. 03
    Find the timeCalculate how many months each bracket will take to sell through.
  4. 04
    Cost itWork out the monthly carrying cost of old stock.
  5. 05
    DecideCompare holding and discounting using the break-even point.
  6. 06
    PreventLimit new purchases based on inventory age.

The course's 8 lessons: (1) how inventory age is defined, (2) age brackets and the value table, (3) how many months each bracket takes to sell through, (4) the carrying cost of old stock, (5) hold or discount, (6) how to clear old stock, (7) how to limit new purchases based on inventory age, (8) monitoring indicators.

Lesson 1: How is inventory age defined?

In short: Inventory age is the number of days from the date the product entered the warehouse until today. The last sale date is a different indicator and should not be used in place of age.

FormulaFormulas for inventory age and sell-through time
  1. Inventory age = Today's date − Batch's warehouse entry date
  2. Bracket value = Quantity in the bracket × Unit cost
  3. Sell-through time (months) = Bracket's cost value ÷ Cost sold from the bracket per month

If batches of the same product arrived on different dates, age is calculated per batch. Under the first in, first out (FIFO) assumption, sales use up the oldest batch first; so the aged part of the report is the goods that have actually been waiting on the shelf the longest. Looking at the last sale date instead of the entry date can be misleading: selling two units of a product a month does not show that a four-year-old batch on the shelf is selling through. The entry date and the last movement date should be read together; you can isolate the products that the second indicator alone cannot explain with the method in the article how to clear dead stock.

Cost value is always calculated at the unit purchase cost, not at the selling price. The selling price shows not how much money is tied up on the shelf but how much revenue you will earn later. We explained how unit cost is built up in the article how to calculate inventory cost.

Lesson 2: How do you build age brackets and a value table?

In short: Divide inventory into five brackets such as 0–30, 31–60, 61–90, 91–180 and 181+ days; write down each bracket's cost value and its share of the total.

The sample warehouse carries inventory with a cost value of ₺1,200,000. The breakdown by age bracket is as follows:

Inventory ageCost valueShare of total inventory
0 – 30 days480.000 ₺%40,0
31 – 60 days300.000 ₺%25,0
61 – 90 days180.000 ₺%15,0
91 – 180 days150.000 ₺%12,5
181 days and over90.000 ₺%7,5
Total1.200.000 ₺%100
ChartBreakdown of inventory by age bracket
  • 0 – 30 days₺480,00040%
  • 31 – 60 days₺300,00025%
  • 61 – 90 days₺180,00015%
  • 91 – 180 days₺150,00012.5%
  • 181 days and over₺90,0007.5%

Prepared with sample values. The brackets add up to ₺1,200,000.

Since total inventory is ₺1,200,000 and the monthly cost of sales is ₺400,000, the warehouse carries enough stock for 1,200,000 ÷ 400,000 = 3 months of sales on average. That average looks reasonable; but the breakdown shows that stock older than 91 days is 150,000 + 90,000 = ₺240,000, or 20%. The tail can be a problem even when the average is healthy; the purpose of the aging analysis is to make this tail visible. To read the same inventory through turnover, see the article how to calculate inventory turnover.

Lesson 3: How many months does each bracket take to sell through?

In short: Sell-through time is found by dividing the bracket's cost value by the cost sold from that bracket per month. As age increases, the monthly outflow drops quickly.

In the sample warehouse, sales in recent months were broken down by which age bracket they came from. The cost of products sold totals ₺400,000 a month, distributed across brackets as follows:

Inventory ageBracket valueMonthly cost soldSell-through time
0 – 30 days480.000 ₺220.000 ₺2.2 months
31 – 60 days300.000 ₺110.000 ₺2.7 months
61 – 90 days180.000 ₺50.000 ₺3.6 months
91 – 180 days150.000 ₺15.000 ₺10.0 months
181 days and over90.000 ₺5.000 ₺18.0 months
Total1.200.000 ₺400.000 ₺3.0 months
ChartSell-through time by age bracket: the last two brackets alone skew the average
  1. 0 – 30 days2.2 months
  2. 31 – 60 days2.7 months
  3. 61 – 90 days3.6 months
  4. 91 – 180 days10.0 months
  5. 181 days and over18.0 months

Prepared with sample values. Each time: bracket value ÷ monthly cost sold.

Note that the monthly costs sold add up to 220,000 + 110,000 + 50,000 + 15,000 + 5,000 = ₺400,000, which is consistent with total sales. The sell-through time, 3 months overall, rises to 18 months in the oldest bracket. While fresh stock turns quickly, aged stock barely moves; with every new month, the products in this bracket become even less likely to sell. To find which products skew the brackets, you can add the method from the article how to do an ABC analysis, which classifies products by sales and value, to the same report.

Lesson 4: What is the carrying cost of old stock?

In short: Stock sitting on the shelf generates capital, storage and shrinkage costs. In the sample warehouse, this cost is assumed to be 24% a year, or 2% a month.

In the example, the 24% a year is assumed to consist of: cost of capital 18%, storage, insurance and shrinkage 6%. To calculate your own rate, you can find your borrowing or opportunity cost with the article how to calculate the true cost of a business loan, and take warehouse expenses from your own records. If the monthly rate is 2%:

  • 181+ bracket: 90,000 × 2% = ₺1,800 a month in carrying cost.
  • 91–180 bracket: 150,000 × 2% = ₺3,000 a month.
  • Total for 91 days and over: 240,000 × 2% = ₺4,800 a month, ₺57,600 a year.

These costs do not appear on any invoice; they leak into the profit calculation only as reduced return on capital and shrinkage. If we assume the entire 181+ bracket sells through in 18 months and stock decreases linearly (meaning average stock over the period is halved), the total carrying cost of this bracket is about 90,000 × 2% × 18 ÷ 2 = ₺16,200. This figure is 18% of the bracket's value: in other words, the product loses close to a fifth of its cost just by sitting on the shelf. You can read the other items added to the total cost of inventory, along with the cash side, in the article how to calculate working capital.

Lesson 5: Is it more profitable to hold or to discount?

In short: Holding is profitable only if the stock will later sell close to full price. The break-even point tells you above what rate the discount you give at the end of the wait makes discounting today the better option.

The normal sales value (excluding VAT) of the stock in the 181+ bracket, with a cost of ₺90,000, is ₺135,000. A sale brings selling expenses such as commission, shipping and packaging; in the example these are assumed to be 15% of the sales amount.

Option A: Sell today at a 30% discount. Revenue is 135,000 × 0.70 = ₺94,500. Selling expenses are 94,500 × 15% = ₺14,175. Net cash is ₺80,325, which is ₺9,675 below cost; but the money is freed up immediately and carrying cost stops.

Option B: Wait 18 months and sell at full price. Revenue is ₺135,000, selling expenses at 15% are ₺20,250, and carrying cost is ₺16,200. The net result is 135,000 − 20,250 − 16,200 = ₺98,550.

ChartNet result of holding: even a full-price sale leaves ₺98,550 after carrying cost
  1. Normal sales value of 181+ stock₺135,000
  2. Selling expenses (15%)−₺20,250
  3. 18-month carrying cost−₺16,200
  4. Net cash from the holding scenario₺98,550

Prepared with sample values. Total: 135,000 − 20,250 − 16,200 = ₺98,550. The sale is assumed to happen at full price.

If a full-price sale were guaranteed, holding (₺98,550) would look better than discounting (₺80,325). But there is no way to know that the product will still sell at full price 18 months from now. Let's calculate the break-even point: let d be the discount you give at the end of the wait; the net cash of the holding scenario is 135,000 × (1 − d) × 0.85 − 16,200. The two options are equal at the point where this equals ₺80,325: 135,000 × (1 − d) × 0.85 = 96,525; (1 − d) = 96,525 ÷ 114,750 = 0.8412; d ≈ 15.9%.

Rule: if you will have to give more than a 15.9% discount after 18 months, it is better to sell today at a 30% discount. In addition, the ₺80,325 freed up today can be used for new purchases; in the holding scenario, this money stays on the shelf for 18 months. If the product depends on fashion, season or an expiry date, the break-even point is reached much more easily. To test the profit impact of a discount before this calculation, use the method in the article how to discount without losing money.

Lesson 6: How do you clear old stock?

In short: Rank your clearance tools starting with the least damaging: bundling, switching channels, targeted campaigns, returning to the supplier and, as a last resort, a deep discount.

  1. Bundles and multi-buys. Sell the old product together with a fast-moving product. An old product added to the basket of a high-contribution product goes out without needing a deep discount of its own. For the math on increasing the number of items in the basket, see the article how to calculate and increase average order value.
  2. Switching sales channels. A product that does not move on one channel may sell on another channel with a different customer base. Calculate the difference in commission and shipping; to compare channels, see the article how to measure profitability by sales channel.
  3. Targeted campaigns. Offer the discount not to everyone but to those who bought the product before or to a specific customer group; unnecessary discount losses decrease. For setting up a campaign, see the article how to set up a store campaign.
  4. Transfers between warehouses. A product sitting in one warehouse may be selling in another; a transfer is cheaper than a discount (how to transfer stock between warehouses).
  5. Returning to or exchanging with the supplier. If there is an agreement, returning unused products does less damage than a discount. Back up the data that will help in negotiating with the supplier with the indicators in the article how to measure supplier performance.
  6. Deep discount. If none of the above works, use the calculation in lesson 5; choose the discount rate based on the break-even point.
Recommended readingHow Do You Clear Dead Stock?

Lesson 7: How do you limit new purchases based on inventory age?

In short: If the stock you have exceeds a certain multiple of monthly sales, do not place a new order for that product. The threshold is set according to the product's aging risk.

A simple rule: if a product's current stock exceeds 6 times its monthly sales, no new order is placed. In the example, there are 600 units of a product in the warehouse and monthly sales are 50 units. The stock will last 600 ÷ 50 = 12 months. Since this is twice the 6-month threshold, no new purchase is made for this product. Another product has 90 units in stock and monthly sales of 60 units; it will last 1.5 months and a new order may be needed.

ProductInventoryMonthly salesMonths of coverDecision
Product 1600 units50 units12.0 monthsNo new order
Product 290 units60 units1.5 monthsPlan a new order
Product 3240 units40 units6.0 monthsBorderline; monitor

The threshold does not have to be the same for all products. Choosing 3 months for a fashion-dependent product and 9 months for a durable, non-seasonal product may be reasonable. For seasonal products, the threshold should be considered together with the season calendar; for this, see the article how to plan seasonal product inventory. Do not forget the safe lower limit: if new orders are stopped completely, stock runs out; you can calculate the sales lost to stockouts with the article how to calculate the cost of stockouts and set safety stock with the article how to calculate safety stock. To size the first order correctly from the start for new products, see the article how to determine the initial order quantity for a new product.

Lesson 8: How do you monitor inventory aging?

In short: Monitor three indicators in a monthly table: the share of stock 91 days and over, the share of stock 181 days and over, and how many months of sales the stock covers.

IndicatorHow it is calculatedSample value
Share of 91+ day stockValue of 91+ day brackets ÷ Total inventory%20,0
Share of 181+ day stockValue of the 181+ day bracket ÷ Total inventory%7,5
Inventory coverTotal inventory ÷ Monthly cost sold3.0 months
Sell-through time of the oldest bracket181+ value ÷ Monthly outflow18.0 months
Monthly carrying cost of old stock91+ value × Monthly rate4.800 ₺
Takeaways from the exampleFour numbers from the inventory aging example
  • 20%share of stock older than 90 days in total inventory
  • 18 monthstime for the oldest bracket to sell through
  • ₺4,800monthly carrying cost of 91+ day stock
  • 15.9%break-even discount between holding and discounting

Once the indicator is in the monthly table, the trend matters: if the 91+ share rises two months in a row, purchasing decisions or campaign timing are off. The easiest way to lower the share is not to clear the old bracket but to control new purchases from the start, because stock that looks 0–30 days old today will be in the old bracket 6 months from now. To pull the report on the same day each month and compare it with the previous month, add an aging line to the routine in the article how to prepare a weekly management report. If there are count differences, the report itself will be wrong; to verify the count, see the article how to do an inventory count.

Recommended ReadingHow Do You Find and Close Inventory Discrepancies? A Course on Count Difference Tables, the Inventory Movements Report, Types of Discrepancies, Correcting Entries and Unexplained Differences

What are the most common mistakes in inventory aging?

  1. Looking only at total inventory value. Even if the average looks reasonable, the aged tail stays hidden.
  2. Valuing at selling price. Money tied up on the shelf is measured at purchase cost.
  3. Using the last sale date instead of the entry date. The old batch of a product that sells a few units a month is assumed to be selling through.
  4. Ignoring carrying cost. Holding looks free, yet at the sample rate of 2% a month it eats 24% of old stock a year.
  5. Discounting deeply and all at once. Choosing a rate without calculating the break-even point causes unnecessary losses.
  6. Placing new orders for aged products. The bracket grows and the tail gets longer.
  7. Running the report once a year. The problem is noticed only after it has grown; monthly tracking is needed.

How does NetKasam make inventory aging tracking 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.
  • Multiple warehouses and branches. You see stock separately by warehouse and branch (branch and warehouse management).
  • Campaign module. You create campaigns for old stock targeted at a product, category or customer group, and report on the results.
  • Saved reports. You save the monthly 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 is ₺1,200,000 and the monthly cost sold is ₺400,000, how many months of sales does the stock cover?
  2. If the value of the 91+ day brackets is ₺240,000, what percentage of total inventory is it?
  3. If 181+ day stock is ₺90,000 and the monthly outflow is ₺5,000, how many months is the sell-through time?
  4. If the monthly carrying rate for old stock is 2%, what is the monthly carrying cost of ₺240,000 of 91+ day stock?
  5. If a product has 600 units in stock and monthly sales of 50 units, how many months will the stock last?

Answer key:

  1. 1,200,000 ÷ 400,000 = 3 months.
  2. 240.000 ÷ 1.200.000 = %20.
  3. 90,000 ÷ 5,000 = 18 months.
  4. 240.000 × %2 = 4.800 ₺.
  5. 600 ÷ 50 = 12 months.

Frequently Asked Questions About Inventory Aging Analysis

What is an inventory aging analysis?

It is a method of dividing inventory into brackets by the number of days since it entered the warehouse and calculating each bracket's cost value and the time it will take to sell through.

How is inventory age calculated?

The batch's warehouse entry date is subtracted from today's date. If there are different batches of the same product, age is calculated per batch.

Which age brackets should be used?

0–30, 31–60, 61–90, 91–180 and 181 days and over is a good start. Shorter brackets are chosen for products with a short season or limited shelf life.

How is sell-through time found?

The bracket's cost value is divided by the cost sold from that bracket per month. For example, if ₺5,000 a month goes out of a ₺90,000 bracket, the time is 18 months.

Is old stock worth holding?

Only if it will later sell close to full price. If, after deducting carrying cost and selling expenses, the discount you would have to give at the end of the wait exceeds the break-even point, it is better to discount today.

What does carrying cost include?

Items such as the cost of capital, storage, insurance and shrinkage. The example assumes 24% a year; calculate your own rate from your records.

Should new orders be placed for aged stock?

Usually not. If current stock exceeds the multiple of monthly sales you set (for example 6 times), no new order is placed.

How often should an inventory aging report be run?

Monthly. A report pulled on the same day each month shows the trend in the share of 91+ days and 181+ days.

Conclusion: Write your inventory's age in a table

The most useful thing you can do today is to split your inventory report into five brackets by entry date and look at the share of stock older than 91 days in the total. This single number tells you how much of the money sitting on the shelf is a problem. The next step is to calculate the sell-through time of the oldest bracket and decide between holding and discounting with numbers, using the break-even point from lesson 5.

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