>>> article

Inventory Aging Analysis: Find the Cash Trapped in Your Stock

Learn how to run an inventory aging analysis: the formulas, the buckets, a worked example and what to do with the 90+ day stock tying up your cash.

Watercolor frame for inventory aging analysis

An inventory aging analysis tells you how long each SKU has been sitting on your shelves and how many dollars sit in each age band. For a founder, the number that matters is not the average age. It is the share of your inventory dollars that is old, because that is the cash you cannot spend on anything else. Run the report monthly, read it in dollars rather than units, and treat everything past 90 days as a decision you owe yourself, not a line item.

This guide shows how to build the report, which formulas to use, how to read the result against turnover and cash, and what to do with what you find. If you run a consumer brand and want a second set of eyes on your numbers, the DTC Operator Diagnostic is where we start.

Commerce Catalyst
Turn Inventory Insights Into Clear Decisions
Commerce Catalyst helps consumer brand founders make sense of financial realities and identify constraints affecting cash flow and profitability.
Visit

TL;DR

  • An inventory aging report groups on-hand stock by how long it has been in the building, usually in 0–30, 31–60, 61–90 and 91+ day buckets, and shows the dollar value in each.
  • Individual item age is today’s date minus the receipt date. Average inventory age is (average inventory ÷ cost of goods sold) × 365.
  • Read the report in dollars. When a large share of inventory value sits in the oldest bucket, cash is trapped and margin is about to be tested.
  • An old bucket is a prompt, not a verdict: seasonal items and critical spares can be old on purpose. Everything else needs a markdown, bundle, return, or write-down decision.
  • Aging tells you where the problem is. SKU profitability, turnover and cash timing tell you what to do about it.

Table of Contents

What an inventory aging report actually shows

Think of it as the accounts receivable aging report’s cousin. Receivables aging tells you which invoices are late. Inventory aging tells you which purchases have not turned back into cash. A professional guide to the report describes the usual columns: item code or description, quantity on hand, total value, and the value in each age category.

The most common layout uses four time-based buckets: 0–30, 31–60, 61–90 and 90+ days, listing each SKU with quantity, receipt date and inventory value. The point is to expose slow-moving, excess and obsolete-risk stock, a pattern Buske describes in its guide to the report.

Some systems go finer. Square’s support documentation describes a report with the weighted average age in days, the last received date per item, and quantities split by the last 30, 60, 90 and 120 days and beyond. Microsoft’s Business Central documentation describes a similar report with configurable aging periods, filterable by warehouse and item. Your tool matters less than the discipline of running it on a fixed date every month.

How to calculate inventory age

There are two calculations, and founders often confuse them.

Age of a single item or lot

The age of a lot is the report date minus the date you received it. Luminous’s documentation gives the example of stock received on January 15, 2024 and measured on April 11, 2025: 452 days. When one SKU has several receipts, the average age is the sum of units times age for each lot, divided by total units. The same source treats items aged 90 days or more as slow-moving or potentially obsolete.

A small example shows the mechanics. Say you hold 80 units received 40 days ago and 40 units received 146 days ago. The weighted average age is (80 × 40 + 40 × 146) ÷ 120, or about 75 days. The simple average of 40 and 146 would say 93, which is wrong. Countlark’s worked example uses the same figures. It also notes that a unit exactly 30 days old belongs in the 0–30 bucket and a 31-day-old unit in the next.

Average age of inventory for the whole business

The company-level figure is the average age of inventory: (average inventory cost ÷ cost of goods sold) × 365. Investopedia’s overview walks through $100,000 of inventory against $600,000 of COGS, which comes to 60.8 days, or about two months to sell through.

Use an average of beginning and ending inventory, not a single snapshot. Shopify’s guide shows $250,000 at the start of a period and $300,000 at the end, giving $275,000 on average. Against $750,000 of COGS that is about 134 days. The same guide says an ideal average age is generally 60 to 90 days and that an item usually is not considered dead stock until 180 days. Treat those as reference points for a conversation, not your target: a brand with long overseas lead times will legitimately hold stock longer than one that replenishes in two weeks.

The company-level number is a blend. A brand can show a comfortable 70-day average while a fifth of its dollars sits in styles that stopped selling a year ago, because fast sellers pull the average down. This is why the bucket view matters more.

Build the report in six steps

You do not need new software. A spreadsheet export from your inventory system or 3PL is enough to start. The Excel walkthrough from a logistics provider covers the mechanics of building the sheet. Here is the logic and where it breaks.

1. Pick the as-of date. Use the last day of the month you are closing, so the report ties to your books. Running it on a random Tuesday makes month-over-month comparison meaningless.

2. Pull the minimum data. For each SKU you need an identifier, the receipt date, quantity on hand and unit cost. Finale’s guide adds location and last sale date, which help later. Most errors begin here. If one product line records the date the pallet hit the dock and another records the date the purchase order was cut, the whole report skews. Pick one definition and apply it everywhere.

3. Calculate age per lot. Subtract the receipt date from the as-of date. If your system only holds one date per SKU and ignores later replenishments, you are overstating age on SKUs you reorder. Ask your 3PL for lot-level receipts.

4. Assign buckets. A common scheme is 0–30, 31–60, 61–90, 91–180 and 180+. Finale’s guide labels these recently received, monitor, potential slow movers, high obsolescence risk and likely deadstock, and suggests custom buckets for seasonal items. Fashion brands often need tighter windows, since Shopify notes fast fashion reveals how a style performs within weeks.

5. Value each lot at cost. Quantity times unit cost, using landed cost (product, freight, duties) if that is how your books carry inventory. Then total the dollars per bucket with a pivot table.

6. Reconcile to the general ledger. The total of your buckets should equal the inventory asset on your balance sheet. If it does not, fix that before you read anything into the buckets. This one check is the difference between a report you can show an investor and one you cannot.

Build the report in six steps

A worked example: reading the buckets in dollars

Here is an illustrative consumer brand with $450,000 of inventory at cost.

Age bucket Inventory at cost Share of total
0–30 days $120,000 27%
31–60 days $90,000 20%
61–90 days $60,000 13%
91–180 days $110,000 24%
180+ days $70,000 16%
Total $450,000 100%

Everything past 90 days adds up to $180,000, or 40% of inventory dollars. The unit count would hide this, because the old stock may be a handful of expensive SKUs. Founders who look only at units tend to see a healthy warehouse. Founders who look at dollars see $180,000 that cannot fund the next purchase order.

Now ask three questions of that $180,000.

Is it old on purpose? Buske cautions that a 90+ day item does not always need to be liquidated, since it may be seasonal or a critical spare part. Match the bucket to the product calendar before you conclude anything.

Which SKUs make up the money? Sort the old buckets by dollars. In most catalogs a few SKUs account for most of the aged value. Those are your decisions. Our SKU profitability analysis guide shows how to decide which to keep, fix or cut, and the SKU rationalization guide covers the long tail behind them.

What does the cash gap cost? Money in aged stock is money you are not spending on ads, new product or payroll, and if you borrow against inventory, you pay for it twice. Our piece on inventory financing explains why turns matter more than the interest rate.

A worked example: reading the buckets in dollars

Connect aging to turnover and cash

Aging and turnover are two views of one fact. Turnover is annual COGS divided by average inventory. Days of inventory is 365 divided by turnover. Exact’s documentation defines average days to stock the same way, as 365 divided by the turnover ratio, which is why the average-age formula and days of inventory give you nearly the same number.

The difference is what each lets you see. Turnover is a single ratio that smooths everything. Aging shows the tail. If you want a target for the ratio, we cover this in inventory turnover targets. Use turnover to set the pace and aging to find the SKUs that break it.

Two related metrics are worth watching next to the report. Sell-through shows whether what you bought is actually leaving, and our sell-in versus sell-through article explains how wholesale shipments can mask unsold stock sitting at retailers. Vendor lead times set how much safety stock you carry, and padding that cushion is a common reason inventory ages. See the safety stock formula and our note on vendor lead time risk.

What to do with the old buckets

A practical way to act is to attach a default response to each bucket. Fishbowl’s bucket-action table is a good template: 0–30 days is healthy, so restock as normal; 31–60 means monitor turnover; 61–90 signals softening demand, so promote or bundle; 90+ carries dead-stock risk, so discount, liquidate or write down. It also favors bundling slow sellers with popular products and limited-time offers over plain across-the-board discounts.

For brands with a direct channel, the order of moves usually runs from least to most painful:

  1. Stop reordering. Pause open purchase orders on any SKU with more than 90 days of cover. This costs nothing and is the most overlooked step.
  2. Bundle and re-merchandise. Pair aged items with best sellers, improve the photos and page placement, and test a limited-time offer before you cut price.
  3. Move it through another channel. Marketplaces and wholesale buyers can take volume your own store cannot. J.P. Morgan’s October 2026 piece on managing excess inventory groups the levers into reducing excess (better forecasting, shorter lead times, fewer rarely selling SKUs) and shifting who funds the stock.
  4. Mark down with a number in mind. Set the floor before the sale begins, so you know what each cleared dollar costs your margin.
  5. Write down or write off what will not sell. Be decisive here. See our guide to audit-ready dead stock write-offs.

What the accounting requires

Under U.S. GAAP (ASC 330), inventory held at FIFO or average cost is reported at the lower of cost or net realizable value, which is the expected selling price minus the costs of completion, disposal and transport. When that value falls below cost, the write-down is recognized immediately and is not reversed. The aging report is the evidence behind that judgment.

Many brands estimate it with a reserve: Cleverence describes a portfolio reserve for slow-moving items built from aging bands, such as 180–360 days and over 360 days, with a percentage factor applied to each. The right percentages, and the tax treatment of any write-down, are questions for your CPA, who signs off on your financials and tax return.

Mistakes that make the report lie

Most bad aging reports fail in familiar ways:

  • Receipt dates reset on transfers. Moving stock between warehouses should not make it young again.
  • Mixed date definitions. Dock date in one system, PO date in another.
  • Units instead of dollars. Cheap accessories can dominate the unit count while one hero product holds the real money.
  • Ignoring inbound. Stock on the water is not aged yet, but it will land on top of whatever you are already carrying. Read aging next to your open purchase orders.
  • No owner. A report that no one is accountable for becomes a monthly PDF no one opens.

Where we stand

The constraint is rarely the whole inventory. It is usually five or ten SKUs, and one purchasing habit.

Get a second read on your numbers

If your report shows a heavy 91+ bucket and you are not sure whether to discount, bundle, write down or reorder, the DTC Operator Diagnostic is a $197 one-off review built to identify the operating constraints holding your business back. For a specific decision, such as how to clear a SKU or how to present aged stock to a lender or investor, a Founder Hour is $500 per hour.

Commercecatalyst

Brands that want ongoing support can look at Founder Advisory or the 90-Day Profit Sprint for consumer brands.

FAQ

What is the difference between an inventory aging report and inventory aging analysis?

The report is the table: SKUs, quantities, values and age buckets. The analysis is what you conclude from it, such as which SKUs hold the old dollars, why they aged, and what each costs your cash and margin. The report takes an hour to produce. The analysis is where the value is.

How often should I run an inventory aging report?

Monthly, on the last day of your accounting close, so it reconciles to the balance sheet and you can compare it to the prior month. Brands with seasonal peaks or fast-moving fashion should also check weekly during the selling season, with tighter buckets.

What is a good average age of inventory?

It depends on your category and lead times. Shopify’s guide cites 60 to 90 days as generally ideal, but your own trend and your share of dollars past 90 days tell you more than any benchmark. Track the number over time and against your sell-through.

When does aged inventory become dead stock?

There is no universal line. Some guides treat 180 days as the point where an item is typically considered dead stock, while others set limits by days since the last sale, such as 90 for slow-moving and 365 for dead. Set a rule that fits your reorder cycle and apply it consistently.

Sources

>>> next step

Want to see where your business actually stands?

Run the numbers through the diagnostic, or talk it through with someone who has been in your seat.

Get the Diagnostic Book a Founder Hour