Car dealer inventory management
- Variance in units (negative is a shortfall)
- -86
- What the shortfall cost you to replace
- $1,075
- Count accuracy, percent of expected found
- 96.4
The arithmetic on these sheets is your own count: units, unit cost and reorder point in, variance and value out. Nothing is estimated and no industry average is applied to your numbers. Where a page states an outside figure it names the document it came from and links to it.
Car dealer inventory management, for an independent buying twenty or thirty units at a time, is really a sourcing discipline wearing an operations name. What you hold is decided weeks earlier at an auction or on a trade, and no amount of tidy record keeping rescues a lot full of cars bought because they were cheap. The record's job is to make the consequences of those decisions visible fast enough to change the next ones.
Open the Inventory spreadsheet template Free to use. No account, no card, no trial clock.
Record cost, reconditioning and days separately, always
Three numbers per unit, kept apart. Blend them and every post-mortem becomes an argument about which part went wrong. Kept apart, a pattern shows within a quarter: a particular model, a particular source, or a particular reconditioning shop.
Judge sourcing by what sold, not by what you bought well
The buy price feels like the win and the days to sell is the actual result. Group your sold units by where you sourced them and compare the average days; the answer is frequently uncomfortable and always more useful than the margin figure alone.
Keep the paperwork with the unit from day one
Title status, odometer disclosure as the federal rule requires, and the buyers guide the FTC rule calls for. Held against the unit rather than in a deal folder, these survive a fallen-through sale and a member of staff leaving, which is when dealer paperwork usually goes missing.
Count the things that are not cars
Dealer plates, keys, spare wheels, workshop consumables and valeting stock. None of it is glamorous and all of it disappears. A quarterly count with the sheet on this page prices the gap at your own costs, and the keys line alone usually justifies the exercise.
Stock counts: what people ask before the first one
How many units should an independent hold? Enough that the lot looks like a business and few enough that the slowest unit is still someone's problem. That is a judgement about your own days-to-sell figure, which is why measuring it properly comes before deciding it.
What is the most expensive record-keeping failure? A unit whose title status is unclear. It is invisible in every inventory report, because the car is physically there and looks fine, and it surfaces on the day a buyer wants to drive it away.
Should I track reconditioning by supplier? Yes, if more than one shop does your work. Cost per unit by shop, alongside days held, tells you what the cheaper shop is really costing you in lot time.
Does this need dedicated software? Not at twenty units. It needs the fields to be consistent and someone to look at them weekly. Software helps when the review is no longer possible in one sitting.
What about cars held for parts? Take them off the sellable list and give them a status. They are inventory of a different kind and leaving them in corrupts both your aging and your valuation.
How do I start if the current records are a mess? Draw a line today: every unit currently on the lot gets a record with an honest arrival date, even if it is a guess marked as one. Do not attempt to reconstruct history; the value is in the next ninety days.
Will the Car dealer inventory management fit what you count?
Tell us what you are counting and how you count it today, and we will tell you whether Stocktaka fits before you pay for anything.