Car inventory management system
- 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.
A small used-car lot has a different problem from a franchise store, and it is not scale. A franchise store has a process imposed on it by the manufacturer; an independent has to invent one. That means a car inventory management system for a small lot is mostly about removing the three ways a car can go untracked: it arrives and nobody records it, it is reconditioned and the clock is quietly reset, or it is sold and stays on the website.
Open the Inventory spreadsheet template Free to use. No account, no card, no trial clock.
Record the car on the day it lands, not the day it is ready
Every day between arrival and listing is a day the car cost you and nobody measured. Recording at arrival makes reconditioning visible as a delay you can manage rather than a gap in the data.
Give each car a single checklist and hold it in the record
Title in hand, inspection done, buyers guide prepared as the FTC used car rule requires, photographs taken, price agreed. Five states against one unit, in one place. The checklist is the part that stops a car sitting for a fortnight waiting on something nobody was assigned.
Make the website read from the record
The most damaging small-lot error is a sold car still advertised, because it costs you a call from a buyer who then finds another dealer. If the listing is generated from the record and the record is updated at sale, this stops happening without anybody being reminded.
Count the consumables too, because they are the part that walks
Oil, wipers, bulbs, valeting supplies and workshop consumables are real money on a small lot and nobody counts them. The sheet on this page prices the gap at your own cost, and on most lots the first count of the valeting cupboard is a surprise.
Stock counts: what people ask before the first one
What fields does a small lot actually need? VIN, stock number, arrival date, cost, reconditioning spend, asking price, status and sale date. That is enough for aging, for margin and for the website. Everything else is refinement that can wait until those eight are reliable.
How should reconditioning spend be recorded? Against the unit, as it is incurred, not lumped in at sale. Recorded at sale it flatters every car until the moment you can no longer change anything; recorded as it happens it tells you when to stop spending.
Should I use a spreadsheet or a product? A spreadsheet is genuinely sufficient for a single lot with one person entering data. The moment two people enter data, or you want last year's aging figures without opening old files, the product is what you are buying.
Does the buyers guide requirement affect the record? Only indirectly: the guide is a document per vehicle, and holding the data behind it against the unit means preparing the document is not a retyping exercise. The rule itself sets out what the guide must say.
What is a useful aging threshold? Set it from your own floor plan cost and your own market rather than a rule of thumb. The number matters less than the fact that something is required to happen when it is crossed.
Can this handle trade-ins? Yes, and they should enter the record the same way any other unit does, on arrival, with cost recorded. Trade-ins that enter the record only when they are ready to retail are where small lots lose track of aging entirely.
Will the Car inventory management system 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.