
A dealership physical inventory count means walking the lot, listing every unit you find by VIN, and reconciling that list to your books. Do it blind, have someone other than the counter approve the adjustments, and then fix the cost records behind every variance. Most independent lots can finish the count in an afternoon. The reconciliation is where the real work, and the real value, sits.
This guide covers a count built for used-vehicle lots: what to prepare, how to count, how to reconcile, who should do what, and how often to repeat it.
TL;DR
- Count by VIN, not by headcount of cars. Every unit on the lot, in recon, at auction, on loan or at a transporter gets matched to a record.
- Count blind. The counter lists what is physically there and does not work from the inventory report.
- Separate duties: the person who counts should not approve the adjustments. On a small lot, add owner or manager review to compensate.
- Reconcile the count to the general ledger inventory balance, not only to your inventory list, and investigate every difference.
- Count at least once a year, spot-check monthly, and always count before a lender audit or a change of inventory manager.
Table of Contents
- Why a count matters on a used-car lot
- Before count day: preparation
- How to run the count
- Reconcile the count to your books
- Who counts and who approves
- How often to count
- What to do with the findings
- Our perspective
- Using software to make the count shorter
- A one-page count day checklist
- FAQ
- Sources
Why a count matters on a used-car lot
A parts room holds thousands of cheap items. A used lot holds a few dozen to a few hundred expensive ones, each with its own title, cost basis and floorplan balance. That changes what a count is for. You are not estimating quantities. You are proving that every vehicle your books say you own is where you think it is, and that every vehicle on the lot is on your books.
There are three practical reasons to do it properly.
Tax and reporting. The IRS says that if the purchase or sale of merchandise is an income-producing factor, you need an inventory to show income clearly. IRS Publication 538 is the place to start for the rules on inventory methods. Your CPA will want a year-end number that ties to something you can show.
Lender confidence. If you finance cars on a floorplan, your lender can check that you hold what you financed. A captive finance company’s public filing describes auditing dealer inventory and sales records to verify the dealer has the financed vehicles and pays promptly after each sale. A clean count is your best preparation for that visit.
Money you are losing quietly. A car that is sold but still in your inventory list, a car that left for auction and never came back to the books, a unit sitting in a body shop with no recon cost assigned: each distorts your profit picture until someone counts.
Before count day: preparation
Prep decides whether the count takes three hours or three days. Do these things in the days before.
- Freeze the paperwork. Post every pending deal, purchase and transfer. A deal posting checklist helps here, because a sale that was delivered Friday but posted Monday will show up as a false variance.
- Print or export the inventory report as of count day. Keep it sealed or hidden from the counter. You will use it afterward.
- List off-lot locations. Cars at auction, at a detailer, a body shop, a transporter, a wholesale buyer’s lot, or on a demo or customer loan. Each needs a phone call or photo confirmation on count day.
- Collect titles and floorplan lists. If a lender advanced funds on a unit, you need to know it is on the floorplan statement. If you want a refresher on tying payoffs to VINs, our floorplan payoff checklist walks through it.
- Pick a time with no sales traffic. Early morning before open, or a closed day. Moving cars during a count is how units get counted twice.
- Assign the people. Decide now who counts, who approves and who reconciles (more on that below).
How to run the count
Count blind, by VIN
Give the counter a blank sheet, a tablet or a phone, and ask them to record every vehicle they find. Counters should list what is physically present rather than start from the system record, because working backward from the report makes it easy to see what you expect to see. The VIN is the identity of the vehicle, so read it from the dash or door jamb, not from a window sticker or a key tag that could be swapped.
For each unit, record:
- Full 17-character VIN (or hull or serial number for boats, RVs, bikes and trailers)
- Year, make, model
- Physical location (front line, back lot, service bay, off site)
- Status: ready for sale, in recon, sold awaiting delivery, held
- Anything notable: damage, missing keys, no plates, a title issue flagged on the file
Walk the lot in a fixed pattern, row by row, and mark finished rows. Check service bays, storage buildings, offsite lots, the back corner behind the shop and any spot where cars end up parked and forgotten.
Confirm off-site units
Call the auction, shop or transporter and get the VIN confirmed in writing, by email or text with a photo where possible. A car that is “at the body shop” for four months with no recon invoices is worth a visit.
Do a second pass on high-risk units
The units most likely to cause a variance are:
- Cars sold but not yet delivered
- Units on consignment or held for another dealer
- Trade-ins not yet booked
- Cars out on loan, test drive or customer demo
- Wholesale units that left the lot but have no sale record
Second-check those by hand.
Reconcile the count to your books
Now open the sealed report. Match the counted list against the inventory list, VIN by VIN. You will end up with three groups.
| Result | What it usually means | What to do |
|---|---|---|
| On the lot, not in the books | Unposted purchase, trade-in not booked, wrong VIN entry | Find the bill of sale and the payment; book the unit with its true cost |
| In the books, not on the lot | Unposted sale, wholesale not recorded, unit at an unlisted location, or loss | Locate the deal or the car; if neither exists, treat it as a loss and follow your theft process |
| On both, cost looks wrong | Missing recon, transport or fee entries | Assign the missing costs to the VIN |
The third row gets ignored far too often. A count that confirms the car exists but not what you have invested in it only proves half of what you need. Recon work in progress is a frequent culprit, and our guide to recon WIP accounting shows how to catch overruns before the car is sold.
Tie the list to the general ledger
Once the VIN list agrees with the count, total the cost of the units and compare it to the inventory account on your balance sheet. They should match. If they do not, the gap is a bookkeeping problem, not a lot problem: cost entries posted to the wrong account, a floorplan fee capitalized or expensed inconsistently, or a deal that relieved inventory at the wrong amount.
One piece of dealer-accounting advice is to reconcile the physical inventory to the general ledger on a monthly basis. A CPA firm that works with dealerships describes a parts fraud case in which stolen parts never reached the dealer’s inventory system, yet payments to the manufacturer were recorded in the GL inventory account, creating a growing gap. The same logic applies to vehicles: when the ledger and the physical reality drift apart, something is wrong, and an annual count may find it long after the damage is done.
If you want the costing side to be audit ready, see our walkthrough on per-VIN inventory costing.
Who counts and who approves
Segregation of duties sounds like something for large corporations. It matters just as much on a five-car lot, because the owner often buys, receives, prices, sells and does the books.
The basic rule, in guidance on inventory controls written for public companies but sound anywhere: the person who counts should not be the person who approves adjustments to the records. Whoever has custody of the cars should not be the only person who reconciles them.
A workable setup for a small lot:
- Counter: a salesperson, office employee or a trusted outsider who does not post inventory entries.
- Reconciler: the person who keeps the books, who compares the count to the records.
- Approver: the owner or general manager, who signs off on every write-on and write-off.
If you are a two-person operation and cannot split these roles, add oversight to compensate. Personally review every variance, keep the count sheets, and consider having your outside accountant review the reconciliation. A CPA who knows dealership books can design role separation and compensating oversight that fits your size.
How often to count
There is no single schedule that suits every lot, but the pattern in dealer guidance is consistent: a recurring check plus a full count. The NADA white paper on parts inventory recommends consistent bin checks through the year and a comprehensive physical count at fiscal year end. It is written for parts departments, but the two-layer idea carries over to vehicles.
For a used-car lot, that translates to:
- Weekly or monthly spot checks: pick a row or a random 10 to 20 units and verify them against the system.
- Monthly reconciliation: compare the inventory list total to the general ledger balance.
- Full count at year end: every unit, every location, signed and filed with your tax records.
- Event-driven counts: before you hire an inventory or parts manager (the same NADA paper advises a full count first, for a clean handoff), after a theft or break-in, when you change accounting systems, and before an expected lender visit.
Keep the count sheets. Our guide to dealership document retention maps which records to hold and for how long.
What to do with the findings
The count is only useful if it changes something.
Missing vehicles. Do not just write them off. Search for a deal, a transfer, a loan. If none exists, file a police report and follow the steps in our stolen vehicle accounting playbook. Talk to your insurance agent about coverage and reporting deadlines.
Unbooked vehicles. Find the bill of sale, the payment record and the title. Book the car at its true cost.
Aged units. Your count is the best moment to see which cars have been sitting. Industry data put total used-vehicle inventory at 2.15 million units, or 46 days’ supply at the end of July 2026. If your lot has cars well past that, ask why. One approach is a hard turn policy: set target exit dates at purchase, such as day 45, 60 or 90, to trigger price cuts and wholesale decisions before holding costs eat the profit.

Floorplan exposure. Cars that sit cost interest every day. Check your count against the floorplan statement and see which units are carrying balances longest. For a deeper look at how holding time and financing interact with cash flow, inventory financing and credit lines are worth understanding, and our own floorplan utilization analysis shows how to read interest per VIN.
Our perspective
We build software for independent used-car dealers, and the pattern we see is simple: a physical count is painful because the records it is compared against are scattered. The purchase price sits in one place, transport in a text message, recon in a shop invoice, floorplan interest on a lender statement. When the count turns up a variance, nobody can say what the car actually cost, so the discussion ends at “it is probably fine.”
Our view is that the count should confirm your books, not reconstruct them. If every cost is assigned to the VIN as it happens, the count becomes a short verification and the reconciliation is mostly done before you walk the lot. That is why Loturn tracks every cost against each vehicle, from purchase price through transport and recon, and why we built a mobile inventory app so the person walking the lot can check units against the record on a phone rather than a clipboard.
We would also push back on the idea that counting is just about theft. Theft matters, but the more common loss is slow: unposted costs, forgotten units, aged cars carrying interest. Count to learn the true profit position of each car, then act on it.
— Eric Dosset
Using software to make the count shorter
A spreadsheet can run a count. It struggles with the part after: assigning costs, reconciling to the ledger and keeping an audit trail. If you want a process that stays current between counts, a few features matter:
- Per-VIN cost records that include purchase, transport, recon and floorplan interest
- Native double-entry accounting, so the inventory balance in the ledger is the same data as the vehicle list
- Mobile access for the person on the lot
- Reports on days on lot, so aged cars show up before count day
Loturn includes these in one platform for independent used-vehicle dealers, along with free data import to get your existing inventory in. Plans are published: Flipper at $99 per month, Dealer at $349 per month and Multi-Lot at $699 per month. You can compare them on the Loturn pricing page. To see how the audit side works on a phone, read our guide to mobile inventory audits.
A one-page count day checklist
- Post all pending deals, purchases and transfers.
- Export the inventory report and seal it.
- List every off-site unit and the contact who can confirm it.
- Assign counter, reconciler and approver.
- Count blind, by VIN, row by row, including bays and storage.
- Confirm off-site units in writing.
- Match counted VINs to the report.
- Investigate each variance and document the cause.
- Approve adjustments by someone other than the counter.
- Tie the cost total to the general ledger and to the floorplan statement.
- File the signed count sheets.
- Schedule the next spot check.
FAQ
How do I perform a dealership inventory count?
Prepare by posting all pending deals, then have someone count every unit by VIN without looking at the system report. Confirm off-site cars, compare the list to your records, and investigate each difference. Finish by tying the cost total to your general ledger.
How long does a physical inventory count take?
For a small independent lot, plan on a few hours for the walk and a day or so for reconciliation. Preparation shortens both, especially posting open deals beforehand and listing off-site units. Larger lots with several locations need more people, not necessarily more days.
Who should do the count?
Someone who does not post inventory entries or approve adjustments. If your staff is too small to separate roles, the owner or manager should review every variance and keep the signed sheets. An outside accountant can add a second check.
What if a car is missing?
Search for an unposted sale, wholesale or transfer first. If the car cannot be found, treat it as a possible theft: contact the police and your insurer, and book the loss only after that is documented.
Sources
- IRS Publication 538, Accounting Periods and Methods
- Captive finance company filing on dealer inventory audits (SEC)
- Fraud in the Parts Department, Albin, Randall and Bennett
- SOX Inventory Controls: Section 404 Compliance Checklist
- Managing Your Parts Inventory for High Performance, NADA
- Used Cars Under $15K Are Vanishing, Carscoops
- Wholesale exit rules, Dealership News
- CPA with PBS systems experience for automotive dealerships
- Inventory Financing vs. Line of Credit