Reading your dealership's aging report: the numbers that actually move gross

Every dealer software package prints an aging report, and almost every store looks at it. Far fewer stores get anything out of it, and the reason is usually not the data. It is that the report is read as a status update rather than as a list of decisions that are overdue.

An aging report is a list of decisions. Here is how to read it that way.

Age is a symptom. Cost is the disease.

Start with the obvious column and then leave it behind. Days in stock tells you how long a unit has been on the lot; it does not tell you what that is costing.

The number that matters is total cost in the unit: acquisition, transport, reconditioning, pack, and every day of flooring interest since it arrived. Two units at the same age are not the same problem if one has significantly more money in it than the other.

So read the report twice. Once sorted by age, which tells you what to work. Once sorted by total cost among units past your aging threshold, which tells you what it costs to be wrong. The second list is short, and it is where the month is decided.

The column most reports bury

Somewhere in the report there is a field for the date the price last changed. In a lot of systems it is optional, off by default, or three screens away. Bring it to the front.

Age plus days-since-last-price-change is the single most diagnostic pair on the page, because together they separate two very different situations that look identical when you only see age.

A unit at 90 days that has been repriced three times is a car the market has answered on. It is priced where it is priced, and it has not sold anyway. That is a wholesale conversation, or a merchandising problem, or a reconditioning problem - but it is not a pricing problem, because pricing has been tried.

A unit at 90 days that has never been repriced is not a slow car. It is an unworked car. Nobody has tested anything. The market has not rejected the price; it has never seen a different one.

Those two units need opposite decisions, and a report that shows only age puts them side by side as if they were the same.

Average days in stock is a trap

Almost every store tracks average age, and almost every store is misled by it. The average is dominated by the healthy majority, which is exactly the part you do not need to manage.

The distribution is what matters. How many units are past your threshold - whatever your number is - and what is the total money in them? That count can double while the average barely moves, because a growing tail of old units gets diluted by a healthy front end. By the time the average shifts enough to notice, the tail has been growing for a while.

Watch the count and the dollars past the threshold. Watch the direction week over week. The average is a chart for the wall, not a number to act on.

Aging is where front gross goes to die

The mechanism is not subtle, but it is worth stating plainly because it explains why aging is a gross problem rather than a tidiness problem.

Money in the unit only goes up. Flooring interest accrues every day. Reconditioning is done once but paid for forever. Meanwhile the market moves - depreciation, seasonality, a competitor listing three of the same thing at a lower number.

So cost rises and the achievable price falls, and the gap between them is your front gross, closing a little every week. The decision to hold a unit for another 30 days is a decision to accept less gross for it, and the only question is whether the extra 30 days is likely to produce a buyer willing to pay the difference.

That is a decision worth making deliberately. What usually happens instead is that nobody makes it, and the unit ages into a wholesale loss by default.

What a good weekly routine looks like

The stores that keep aging under control do not have a better report. They have a fixed appointment with it.

Same day, every week, one person who can decide. Not a discussion - a working session with an outcome per unit.

Work the threshold list, not the whole lot. Everything past your aging threshold, sorted by money in the unit.

Every unit gets one of four outcomes. Hold with a reason and a review date. Reprice, with the new number recorded. Re-merchandise - fresh photos, rewritten description, republish the feed. Or move it - wholesale, auction, trade to another lot.

Write down what you decided. The value of the decision is largely in being able to see, next week, that it was made and what happened.

Check the price-change date first. Any unit past the threshold that has never been repriced is a failure of process, not of pricing, and it should be dealt with before anything else on the list.

Cross-reference with the floor plan

If your inventory is floored, the aging report and the flooring schedule are the same conversation, and reading them separately is how stores get surprised.

A curtailment - a scheduled principal payment that comes due because a unit has been floored for a certain length of time - is an aging event with a bill attached. A unit approaching its first curtailment is a unit where a decision is about to become expensive, which makes it the highest-priority line on the aging report that week.

Practically, that means the aging report is most useful when it shows, per unit, the flooring lender and the date of the next scheduled payment. Then the list orders itself: the units where inaction costs cash soonest come first.

Where the numbers go wrong

Three data problems make an aging report lie, and all three are worth checking before you trust the ordering.

Dates that reset. If a unit's acquisition date changed when it was edited, moved between lots, or migrated between systems, its age is wrong and it will sit quietly at the bottom of the list.

Recon that never landed. If reconditioning is tracked somewhere other than the unit record, the total cost column understates the problem on exactly the units where it matters most.

Sold units still on the report. Every stale record makes the totals wrong and the list longer, and a list that is longer than it should be is a list nobody reads to the end.

None of these are exotic. They are all consequences of the same thing: the numbers that describe one car living in more than one place. Which is, in the end, why aging is worth reading closely - it is the report where every other loose end in the store eventually shows up.