How to do a dealership stocktake in an hour

Most dealership stocktakes take far longer than they should, and the time is not spent counting cars. It is spent afterwards: typing registrations into a spreadsheet, chasing the three that were written down wrong, arguing about whether the silver Golf in the workshop is stock or a customer’s, and finding out on Thursday that the "missing" Qashqai was out on a demo all along.

Here is a method that gets a 250-vehicle site counted, reconciled and signed off in about an hour with two people. None of it depends on software, though the software makes several steps disappear.

1. Lock the list before you start

Export the stock list from the DMS the morning of the count and treat that export as the thing you are counting against. Do not let anyone re-run it halfway through. A stocktake compares a physical position with a paper position at one moment; if the paper moves under you, the exceptions are meaningless.

Check three things on the export: every vehicle has a registration or a VIN, the status column is filled in (in stock, sold awaiting collection, demo, courtesy, in transit), and cost prices are present. Cost prices are what turn "four cars missing" into "£71,000 unaccounted for", which is the number the DP and the funder care about.

2. Know what should not be there

Before anyone walks the site, list the vehicles that are legitimately elsewhere: demonstrators out with customers, courtesy cars on loan, cars at auction or with a trader, anything at the bodyshop. And list the customer cars that are on site for work. Both lists cost ten minutes with the service manager and save an hour of false alarms later.

The status on the DMS covers some of this, but rarely all of it. The demo that went out this morning is still "in stock" on the export.

3. Walk the site once, in a fixed order

Split the site into zones (front row, display, compound, workshop, prep bays) and give each person zones, not "half the cars". Walk every zone in the same direction and photograph or record every plate you pass, including cars you are sure are customers’, demos or trade. The rule is simple: if it has a plate and it is on our land, it goes on the list. Deciding what it is happens later, not on the forecourt.

Photographs beat pen and paper for two reasons. A photo cannot be misread as a 5 instead of an S, and a photo with a time on it is evidence an auditor will accept.

4. Reconcile as you go, not at the end

The expensive mistake is treating the reconciliation as a separate job for the afternoon. If a plate is matched to the list the moment it is captured, three things happen: the person counting is told immediately when a car is not on the list (so they can check the windscreen VIN there and then), the running total tells you which zones are done, and the end of the walk is the end of the stocktake.

With a spreadsheet you can approximate this by having one person at a laptop marking off plates as they are radioed in. It works. It also takes the second person off the forecourt.

5. Deal with the exceptions in three piles

Whatever is left falls into three piles. Missing: on the list, expected on site, not seen. Unexpected: seen, not on the list. Status wrong: seen, on the list, but the list says it should not be here (sold and delivered, or in transit).

Each exception gets a decision with a name against it: found after all, off site with a reason, sold and not yet updated, data error, or escalated. Do not close the stocktake with unexplained exceptions; close it with explained ones. The difference is what the audit file is for.

6. Sign it off with evidence

The output should be a report that says who counted, when, against which list, what was found, what was not, what each exception was, who resolved it, and what value was at risk. Attach it to the month-end file. A funder audit or a manufacturer stock check becomes a matter of handing over last month’s report.

That is the whole method. Forecourt does steps 3 to 6 on a phone, reading plates as they are photographed and reconciling against the locked list as you walk, which is how "an hour, not weeks" stops being a slogan.