Skip to content
← All articles

Inventory Aging Report: How Dealers Read and Use It

Inventory Aging Report: How Dealers Read and Use It

Dealer reviewing an inventory aging report

An inventory aging report shows how many days each unit has been on your lot and how much money is tied up at each age. For a dealership, the report that matters sorts every vehicle into day buckets (usually 0-30, 31-60, 61-90 and 91+), totals the dollars in each bucket, and tells you which units need action this week. This guide shows how to build one, how to read it, and what to do when it flags a unit.

Autolenstudios
Get Inventory Listed Sooner
AutoLens creates AI-generated Facebook Marketplace listings from captured vehicle data, helping dealers get inventory in front of buyers sooner.
Visit AutoLens

TL;DR

  • An aging report groups units by days in stock and shows the dollars in each bucket. The dollars matter more than the unit count.
  • NADA treats 30 days as a reasonable turn time, and units past 90 days need a decision, not another week of waiting.
  • Powersports and seasonal inventory need season-adjusted buckets. A 60-day-old motorcycle in November is not a 60-day-old motorcycle in April.
  • Use the report on both sides of the business: reprice and promote aging units, and buy more of what moves fast.
  • Listing speed is part of aging. A unit that is not advertised on day one starts aging with no buyers looking at it.

Table of Contents

What an inventory aging report contains

The generic definition, found in every ERP help page, is a report that segments stock by how long it has been held in period buckets with quantities and values. A dealership version is the same idea with vehicle-specific columns.

A useful dealer report has these fields per unit:

  • Stock number, VIN, year, make, model, trim
  • Date the unit entered inventory (not the date you listed it)
  • Days in stock
  • Total cost basis, including reconditioning and any pack
  • Current asking price and price change history
  • Floor plan balance or financing status, if applicable
  • Online views, leads and last lead date

Then a summary on top: units and dollars in each bucket, plus average days in stock.

The standard buckets, as summarized from NADA’s inventory guidance, are 0-30, 31-60, 61-90 and 91+ days. NADA’s guidance also stresses tracking dollars in inventory per bucket, so management looks at capital efficiency and not just volume.

Why age matters more than most dealers admit

NADA’s analysis, based on its 20 Group data, makes a blunt point: as long as a used vehicle sits unsold, its gross profit margin deteriorates. The same material shows that about half of used vehicles sell within the first 30 days, and units sold after 91 days often suffer significant margin deterioration.

Two costs hide behind that:

  1. Carrying cost. Floor plan interest, insurance, lot space and depreciation, all running daily.
  2. Opportunity cost. The cash in a 100-day-old unit could be in a vehicle that turns in 25 days.

Cost basis makes it worse. A unit with a heavy pack and a long stay can end up with a cost that retail buyers will not pay, so the loss is locked in until you take it.

How to build the report

You can start with the DMS export or even a spreadsheet. Here is the process.

Step 1: Pull the right date

Use the date the unit became sellable inventory, whichever your accounting treats as in-stock. Be consistent. If one manager counts from purchase and another from the end of recon, the numbers will not compare.

Step 2: Calculate days in stock

Days in stock is today’s date minus the in-stock date. In a spreadsheet, that is a single formula on the date column. Average age is the sum of days across all units divided by the unit count.

Step 3: Assign buckets

Start with 0-30, 31-60, 61-90 and 91+. Add a row of totals for units, cost dollars and asking dollars in each.

Step 4: Add the performance columns

Age alone does not tell you why a unit is stuck. Add views, leads and price changes. A 70-day unit with zero leads has a visibility or price problem. A 70-day unit with many leads and no sales has a different problem: price, condition or follow-up.

Two 70-day inventory cases and likely issues

Step 5: Review it on a schedule

Weekly is the minimum. Many dealers also run a quick daily glance at units crossing 30 and 60 days so nothing goes over a boundary unnoticed.

A worked example

Say a lot has 60 units with a total cost of $1,200,000. The report shows:

Bucket Units Cost dollars Share of dollars
0-30 days 30 $540,000 45%
31-60 days 14 $300,000 25%
61-90 days 9 $210,000 17.5%
91+ days 7 $150,000 12.5%

This is illustrative, not benchmark data. The reading is that 12.5% of capital sits in units past 90 days, and the 61-90 bucket holds another 17.5% that will cross the line within a month unless something changes. The action list is those 16 units, ranked by cost and by lead activity.

Reading the report: what to look for

Dollars, not just units

Seven old units can be a rounding error or a real problem depending on what they cost. Always read the dollar column first.

The shape of the distribution

A healthy lot is front-loaded: most of the dollars in the youngest bucket. A lot with a fat middle (31-90 days) is turning too slowly even if few units are technically old.

Patterns by segment

Sort by body style, price band or brand. If trucks under $20,000 clear in under 30 days and luxury sedans sit, the report is telling you what to buy next.

Units with no activity

Cross the age column with lead count. Old and quiet means reprice, re-photograph or rewrite the listing. Old and busy means look at price and follow-up speed.

Set action rules before you need them

Decisions made unit by unit tend to drift. Write the rules down so the weekly meeting is short.

Age Typical response
Day 1-3 Confirm photos, description and listing are live on every channel
Day 15-30 Check views and leads against similar units; adjust if the unit is invisible
Day 30-45 Review price against the local market; refresh photos and copy
Day 60 Decide: reprice, promote, or send to auction or wholesale
Day 90+ Manager-level decision on every unit, with a documented reason to keep it

These thresholds are a starting framework. Adjust them to your market and floor plan terms. Check your lender’s curtailment schedule, since many floor plan agreements require principal payments at set ages, and fit your action days ahead of those dates.

Use the report to buy better

The aging report is not only a cleanup tool. Industry practitioners, including NIADA’s reporting on tight used-vehicle supply, point out that knowing which vehicles move helps a dealer decide what to buy as well as what to sell. If a segment or price point consistently sells inside 30 days, shape your appraisal and auction buying around it.

That same logic applies to any dealer comparing the broader market before buying. Browsing what other sellers carry, for instance on a vehicle marketplace like Wizmoto’s inventory, gives you a quick read on which models and price points are plentiful and which are scarce before you commit cash.

Seasonal inventory needs seasonal buckets

Powersports dealers know the problem. The industry is seasonal: a recent filing from a large powersports retailer states that traffic and sales are generally strongest in the spring and summer quarters and slower in winter.

A flat 30-day bucket therefore misleads twice:

  • In winter, it flags healthy units as aged and tempts you into early markdowns.
  • In peak season, it can lull you into thinking a 45-day unit is fine when buyers are plentiful and it should have sold.

What works better:

  1. Keep the standard buckets for the financial view, because the floor plan clock does not care about the season.
  2. Add a second view that compares each unit against the same model’s typical selling time in the current season, using your own past sales.
  3. Plan the transition. Units that will enter the slow season aging should be priced and promoted in late summer and early fall, not in January.

If you run a powersports store, our page on powersports dealer marketing software covers how seasonal listing flexibility works in practice.

Pricing and promotion by age

Price cuts work best when they follow a plan. A common approach is smaller, earlier adjustments rather than one large cut at day 90. Each adjustment should be paired with something that gets the unit seen: new photos, a rewritten description, a fresh post on your sales channels.

Age-based pricing is also a good use of local comparison. Dealers who sell premium used vehicles, such as the stock shown on a used Audi inventory page, show how a dealer lists vehicles with full specs and financing terms up front, which helps a unit be found and compared quickly.

Where aging starts: the first days

Most aging reports start the clock at in-stock, but the unit often is not advertised until days later. In that gap, no buyer can find it. If photos take two days and listing takes three more, a five-day head start is gone before the first shopper sees the vehicle.

Facebook Marketplace is a good example. Manually creating listings for every unit is slow, and the work is easy to put off, especially on busy weekends. Dealers with many units end up with listings that are late, thin or inconsistent.

Perspective: what we see at AutoLens

We build software for independent and mid-size dealers and powersports dealers, and the pattern is the same in every conversation. Dealers rarely lack an aging report. They lack the first week. The unit lands, the report starts counting, and the listing and the first reply to a buyer happen days later or only on weekdays.

That is why our product is deliberately narrow. We capture inventory from your own website or feed with a Chrome extension, write descriptions from the actual unit specs with the tone and required details you set, and post to Marketplace without retyping. Our AI Responder answers buyer inquiries by SMS in your dealership’s voice and hands the conversation to your staff when it is time to negotiate. The goal is to make sure a unit is live and answered quickly, so the aging clock is running while buyers can see it.

Perspective: what we see at AutoLens — overview diagram

We also track leads across a nine-stage pipeline, with metrics such as speed-to-lead and inventory aging, so a unit with a lot of attention but no sale is visible next to the units nobody is asking about.

Our view: an aging report is a diagnostic. It tells you where the problem is, not how to fix it. The fixes are price, presentation and response time, and only the last two are cheap to fix on day one.

— Adam

Put the first days to work with AutoLens

If slow listing and slow replies are part of your aging problem, AutoLens automates the Marketplace side. Inventory capture pulls units from your site or feed, the AI Responder answers leads by SMS, and the AI dealership CRM tracks them through the pipeline.

Plans on the pricing page are billed monthly: Extension at 79 CAD per month, Individual at 130 CAD per month and Team at 219 CAD per month. Extra users are 100 CAD per month per user, and Dealer Groups has no published price. You can also book a demo to see it on your own inventory.

Common mistakes with aging reports

  • Starting the clock inconsistently. Pick one in-stock definition and keep it.
  • Ignoring recon time. A unit in the shop is aging too. Show recon days as their own column.
  • Reviewing too rarely. A monthly look finds problems after they have already crossed the boundary.
  • Cutting price without fixing visibility. A cut on a poorly listed unit often changes nothing.
  • Treating all units the same. A $9,000 commuter and a $45,000 truck carry different risks at day 60.
  • Skipping the buying feedback loop. If the report never changes what you buy, you are only managing the symptom.

FAQ

What is a good inventory aging benchmark for a used car dealer?

NADA describes 30 days as a reasonable turn time, and its data shows about half of used vehicles sell in the first 30 days. Units past 90 days usually deserve a manager-level decision. Your own market, price mix and floor plan terms should set the final targets.

How do I calculate inventory age?

Subtract each unit’s in-stock date from today’s date to get days in stock. For average age, add the days of all units and divide by the number of units. Do the same with dollars to see how much capital sits in each bucket.

How often should I run an inventory aging report?

Weekly is a sensible minimum, with a quick daily check on units about to cross 30, 60 or 90 days. Faster-turning stores review more often because a week is a large share of a 30-day turn.

How do I reduce aged inventory?

Start with visibility: check that the unit is listed everywhere with good photos and a full description, and that buyer inquiries get quick answers. Then reprice in smaller steps and, if a unit still does not move, wholesale it and redeploy the cash into a segment that sells faster.

Do powersports dealers need different aging buckets?

Yes. Because sales are seasonal, a unit’s age should be read against the season as well as the calendar. Keep the standard buckets for finance, and add a season-adjusted view for pricing and markdown decisions.

Sources