How Do You Run a Faster Lot Audit and Spot Aging Inventory?

A faster lot audit starts by reconciling your DMS inventory list against a live location record for every unit, instead of walking the lot with a clipboard. A clipboard audit takes a weekend and still misses units that are off-site at a body shop, in a service bay, or already wholesaled. Aging units need a decision while the unit is still fresh, not when the unit finally reaches an aged report.

Two jobs share that weekend. Your floor-plan lender needs proof that every unit you claim actually exists, and your used-car manager needs the units that have quietly gone stale. US used-vehicle inventory stood at 2.14 million units and 47 days' supply at the end of June 2026, with an average listing price of $27,027, according to Cox Automotive (2026). Every unit you cannot account for is real money on somebody else's line of credit.

Missing units are rarely missing. Missing units are in one of these eight places.

What does a floor-plan audit actually require from you?

A floor-plan audit requires you to produce every financed unit on demand, with the VIN readable, while an auditor works down your DMS inventory list. The auditor is not grading your merchandising — the auditor is matching financed VINs against metal that exists.

Any unit that cannot be produced becomes an exception, and every exception has to be cleared with a document: a repair order, a wholesale bill of sale, a demo agreement, a loaner contract. Stores that keep those documents current finish in an afternoon. Stores that reconstruct them afterward lose the weekend.

Why does a clipboard lot audit take a whole weekend?

A clipboard lot audit takes a whole weekend because one person is doing three jobs at once: reading a VIN, matching that VIN to a printed list, and walking. Two or three people split the rows, work them out of order, double-count some units, and skip others. Then somebody reconciles the sheets by hand on Monday.

The lost weekend is not the worst part. A clipboard audit is a snapshot of a lot that keeps moving — units get delivered, traded, and driven off while the count runs — so the count is wrong before the count is finished.

Where do missing units actually turn out to be?

Missing units almost always turn out to be off-site, in process, or already gone: at a body shop, on a lift, in an employee's driveway, at auction, with a service customer, at another rooftop, or in the photo queue.

Theft is the category dealers fear and the category that explains the fewest exceptions. No authoritative source publishes vehicle theft from dealership lots specifically. Nationwide, 659,880 vehicles were stolen in 2025 — a 23% decrease from 2024, according to NICB (2026). Before you assume a unit was stolen, call the body shop.

How do you reconcile the DMS list against the physical lot?

Reconcile the DMS list against the physical lot by sorting before you walk. Export every unit with stock number, VIN, status, and date in inventory, then split the list into four buckets: sellable and on the line, in recon, off-site with a third party, and committed but not yet delivered.

Assign one named owner per bucket and require a document for every exception. Only the sellable bucket needs a physical walk. The other three buckets get cleared from a desk with a phone and a folder.

How do you find aging inventory before the unit goes stale?

Find aging inventory before the unit goes stale by reviewing days in inventory on your schedule rather than on the aged report's schedule. An aged report tells you a decision is overdue. A weekly review of days-in-stock, with a named owner and three permitted actions — reprice, promote, or wholesale — tells you the decision is due while you can still act on it.

The average used vehicle sold at a franchised dealership for $28,602 in the first half of 2025, according to the NADA Data 2025 Midyear Report. A stale unit is not a line on a report. A stale unit is roughly $28,602 of committed money aging against a market that moved on.

What is lot rot and why does it cost you a sale?

Lot rot is what happens to a vehicle that sits too long without being started or driven: dead batteries, flat spots on the tires, and unpleasant surprises during a demo drive, as the Mobile Dealer Data glossary defines it. Lot rot turns an inventory-aging problem into a lost-sale problem at the exact moment a customer is standing next to the car.

A unit that will not start for a test drive costs you twice: the deal in front of you, and the reconditioning you now have to redo. An aging policy that counts days but never moves the metal measures rot instead of preventing it.

How does real-time lot management speed up an audit?

Real-time lot management speeds up an audit by making the count a query instead of a walk. MDD Lot Management runs floor-plan audits in minutes, flags stale units, and covers every lot you run. Mobile Dealer Data (MDD) uses Bluetooth, not GPS, because GPS goes blind indoors and half your exceptions are sitting in a service bay or a covered row.

Tags attach in about 10 seconds at stock-in, need no wiring, and last for years on their own batteries. Stock numbers and VINs auto-populate from Reynolds & Reynolds, CDK, and other major DMS platforms, so the audit list and the location map are one list. Across MDD's 250+ rooftops, MDD's own first-party figures put vehicle location at 85% faster and days to lot at 35% fewer.

"MDD delivers on its promises. Locating a vehicle went from 25 minutes to seconds. Every dealer needs these results."

— Mark Seipel, Fixed Operations Director, Longo Toyota

What else do dealers ask about lot audits and aging inventory?

How long should a dealership lot audit take?

A lot audit should take hours, not a weekend. The time is driven by exception handling rather than by walking: units off-site at a body shop, on a lift in service, out as demos, or already wholesaled all have to be documented before the audit closes. Stores that keep those documents current finish an audit in a single afternoon.

What is lot rot at a dealership?

Lot rot is the deterioration of a vehicle that sits unsold and unmoved for too long. Symptoms include dead batteries, flat spots on tires, and unpleasant surprises during a demo drive. Lot rot matters commercially because it converts an aging-inventory problem into a lost sale at the worst possible moment — with a buyer standing next to the car.

Why does the DMS say a vehicle is in stock when the vehicle is not on the lot?

A DMS records ownership and accounting status, not physical position. A unit stays "in stock" while sitting at an off-site body shop, on a lift in service, in an employee's driveway as a demo, or already sold at auction with paperwork still pending. Physical position only appears in a DMS if a person types it in and keeps typing it in.

What counts as aging inventory?

Aging inventory is any unit whose days in stock have passed the point where your store's own turn policy requires a decision to reprice, promote, or wholesale. There is no universal threshold. For market context, US used-vehicle days' supply was 47 days at the end of June 2026, according to Cox Automotive (2026).

How do you audit vehicles that are off-site?

Audit off-site vehicles from a desk, not from the lot. Build one list per third party — body shop, off-site detailer, upholstery, auction — and require a promised-back date for each unit on it. A vendor that cannot confirm possession of a unit today is an exception to escalate immediately, not a line to carry forward.

A faster lot audit and a healthier aged list come from one discipline: knowing where every unit physically is, on a schedule you control. Reconcile by bucket instead of by row, clear exceptions with documents, and act on days in stock while the unit still drives like a fresh trade. If your problem is one specific car right now, that is a different job — see how to find a car fast on a dealership lot.

Sources

• Cox Automotive — Used Vehicle Inventory report (June 2026)
• NADA — NADA Data 2025 Midyear Report
• NICB — US Vehicle Thefts Experience Historic Decline

See it on your lot in 15 minutes

No commitment. We'll show you exactly how Mobile Dealer Data works on a live dealership lot. Schedule a 15-Min Demo →