Quarterly Inventory Audit: Physical vs System Counts
A quarterly inventory audit comparing physical units to system counts: count-day roles, mismatch categories, sold-unit ghosts, and a closeout that fixes listings the same afternoon.
Count day is when the used car manager finds out the DMS has been optimistic. Two trucks "in inventory" that left on a dealer trade. A SUV in the system that has been at the body shop since last quarter. A convertible on the back row that was never stocked. Quarterly inventory audit: physical vs system counts is the process that makes those surprises a scheduled event instead of a lender, insurance, or angry-buyer event.
This is not the daily opening walk and not the weekly exposure meeting. Those catch yesterday. The quarterly audit catches the drift that daily habits missed: ghost units, unstocked units, status lies, and public listings that do not match the ground. Do it on a quiet morning, with clipboards or a phone sheet, and close the same day. An audit that takes a week becomes folklore.
This is operational guidance, not an accounting engagement. Your CPA, floor-plan lender, and counsel may require additional procedures. Confirm those with them.
Why a Quarterly Inventory Audit Finds Physical vs System Drift
Used-car operations create mismatches as a natural byproduct of speed. The audit exists because speed without a quarterly hard reset produces a book nobody trusts.
Typical drift sources
- Sold or traded units never fully debooked.
- Auction purchases sitting on a transporter or in recon without a stock number.
- Dealer trades and wholesales recorded in one system and not the other.
- Keys and cars in different places (service, detail, off-site storage, employee driver).
- Status still "available" on units that are hold, wholesale, or parts.
- Public listings created from a spreadsheet that was already wrong.
Why quarterly is the right cadence for most small lots
Monthly full counts are heavy for a small staff. Annual counts are how ghosts live a full year on your insurance schedule and your floor plan. Quarterly is frequent enough that the exception list still fits on a few pages. If you are floor-planned, your lender may want more often; follow that. If you are not, quarterly is a conservative operating standard, not a law.
Prepare the Packet Before Anyone Walks a Row
An audit fails when people count while the office is still posting, delivering, and wholesaling. Freeze what you can.
The day before
- Print or export the system list: stock number, VIN last eight, year/make/model, status, location if you have it.
- Export or screenshot what is live on consumer channels you control, or at least the PostToMarket posted list if that is how you go to Marketplace.
- Stop adding new stock numbers after a cutoff time, or tag anything received after cutoff as "after count."
- Tell the floor: no silent dealer trades, no "just run it to the shop" without a note.
- Assign count teams: two people per zone is better than one person who will skip the back fence.
Zone the lot
Draw the property: front row, back row, recon, wholesale, overflow, off-site. Count by zone so two people are not double-counting the same truck while missing the side street.
Tools
- One sheet per zone with system units expected in that zone (if you have locations) plus blank lines for found-not-listed.
- A VIN scanner or at least a habit of reading the last eight off the dash or plate.
- A keys audit in parallel: board versus cars found.
Run the Physical Count Like a Procedure, Not a Stroll
On the unit
For every vehicle you physically see:
- Stock number on the windshield versus VIN.
- Mileage if the audit is also catching odometer surprises (optional but useful).
- Obvious status: retail pad, recon, wholesale sticker, no keys.
Do not "know that car." Read the VIN. Twins are how audits fail.
Found-not-in-system
Write it down immediately: location, VIN, description. Do not wait until the office "probably has it." Unstocked units are how you sell or list a car with no cost basis and no title process.
In-system-not-found
Do not delete yet. Tag as missing and start the hunt list: service, body shop, employee, transporter, already sold, already wholesaled. The quarterly inventory audit is not complete until each missing unit has a fate, not a shrug.
Off-site and in-transit
Call the vendor. A car at a recon shop is still yours. A car that "might be at the auction" needs a sale document or it is missing. In-transit purchases belong on a separate in-transit list so they do not get posted as if they were on the pad.
Reconcile in Categories, Not as One Scary Number
When the walk is done, sit down and sort exceptions. A single "we're off by seven" is not actionable.
| Category | Meaning | First fix |
|---|---|---|
| Ghost sold | System available, physically gone, deal or wholesale exists | Debook; pull listings |
| True missing | Gone, no document | Stop listing; escalate; do not "wait and see" |
| Unstocked found | On lot, no system row | Intake before anyone desks it |
| Status lie | Here, but recon/wholesale/hold while system says retail | Change status; pull or hold public ads |
| Location miss | Here, wrong zone | Fix location; no drama |
| Twin / VIN mismatch | Stock number on the wrong car | Halt listings until VIN and photos match |
Same-afternoon listing cleanup
The audit is wasted if the lot is now true and Marketplace is still wrong. Same day:
- Archive sold and missing units that were live.
- Hold listings on recon and wholesale.
- Do not post unstocked finds until they have a VIN, price, and photos of the correct car.
Sold-unit hygiene is the daily version of this. The quarterly audit is how you catch the ones the daily process missed. Dirty DMS exports that create the next quarter's drift are a cleanup-before-posting problem; fix the export mapping as an action item, not as a speech.
Cost basis and identity
If you track cost in a sheet as well as the DMS, this is the sitting where you notice a car with no cost, two costs, or a VIN that does not match the folder. Tracking inventory cost basis in one place is the ongoing habit; count day is the audit of that habit.
Close the Quarterly Inventory Audit With a Signed Packet
Do not leave exceptions in a group text. Produce a one-page closeout.
Closeout contents
- Count date, who counted, zones.
- System count versus physical count of retail-available, recon, wholesale, in-transit.
- Exception list with category, owner, and due date.
- Listings pulled the same day (stock numbers).
- Process change for the next 90 days (one or two, not twelve).
Process changes that actually reduce next quarter's drift
- Same-day debook on delivery.
- No posting without a stocked VIN.
- In-transit and recon statuses that sales cannot override from a phone.
- A keys board that is part of the daily opening checklist, not only count day.
What not to do on count day
- Recut the whole lot because you are in a counting mood.
- Fire a recap meeting that relitigates last month's gross.
- Leave missing units in "available" overnight because "it will show up."
If a unit is missing, it is not available. Treat it that way in every system that a buyer can see.
How PostToMarket Automates This
A physical vs system audit fails at the edges: the DMS says available, Facebook still shows the car, the posting queue still has it, and nobody can see failed or draft rows that were never real. PostToMarket is not a DMS and does not replace your count. It is the public-inventory layer you reconcile on the same afternoon.
A second system list that should match the ground
- Inventory statuses (draft, posting, posted, sold, failed) you can export mentally during closeout: anything posted must exist on a pad or in a documented off-site status.
- Mark as sold and archive from inventory or the queue the hour you confirm a ghost sold.
- Unlimited vehicles in inventory so the audit list is complete, not a subset someone chose to upload.
Stop creating next quarter's ghosts at intake
- Bulk CSV and Excel import with row-level error logs and import history, so a bad VIN is a rejected row instead of a live ad on the wrong car.
- Capture from auction and wholesale sites into draft, which is the right status for in-transit and not-yet-counted units.
Ownership during and after count day
- Team queue view to release claims on units you just recategorized.
- Manager assignment and rep self-queue once the book is true again.
- AI copy and photo picker when an unstocked find is finally allowed to go live — after the VIN and the car match.
No tool can guarantee the lot and the database stay forever aligned. The quarterly walk still belongs to humans. The software keeps listings from lagging a week behind the clipboard.
Count What You Own Before You Advertise It
Quarterly inventory audit: physical vs system counts is how a small dealership finds ghost trucks before a buyer or a lender does. Walk the zones, categorize the misses, pull the ads the same afternoon, and write two process changes. Then go back to selling a book that exists.
PostToMarket holds listing status next to the inventory record so count-day cleanup is a queue action, not a scavenger hunt across profiles. Starter is $59 per month for a one-login lot. Dealership is $299 per month for up to 13 logins when several people are counting, posting, and marking sold on the same afternoon.
Start your 10-day free trial through secure Stripe checkout. Load the book, archive what the clipboards did not find, and enter the next quarter with a lot and a listing list that agree. Cancel anytime.