Guide

Car dealer inventory: how to track every vehicle by VIN, from purchase to sale

A simple system for knowing where every vehicle and part is, and what each sale really earned.

DeviSofts Engineering Team Updated 2 November 2026 7 min read

A car dealer's stock is expensive, easy to mix up and slow to count. Two silver hatchbacks of the same model and year look identical on a list, and a sold car still on the "available" sheet can cost you a customer. The fix is simple: give every vehicle one identity, move it through clear stages, and tie every purchase and sale to it. Here is how.

One identity per vehicle: the VIN

A Vehicle Identification Number (VIN) is a 17-character code a manufacturer gives each vehicle. No two vehicles share one, which makes it the safest key for stock, sales and service history. Some imported vehicles carry a chassis or frame number instead of a 17-character VIN, so keep separate fields for both and allow searching on either.

For each vehicle, record at least:

  • VIN and chassis (frame) number
  • Engine number and registration number
  • Make, model, year, colour
  • Purchase cost and asking (selling) price
  • The current stage, and the date it entered that stage

Four stages, no grey areas

Every vehicle should be in exactly one of these stages at any time:

StageMeaningWhat moves it on
PurchasedBought but not ready to sell (paperwork, repairs, cleaning)Ready for display
AvailableOn display, can be soldA customer pays a token or deposit
ReservedPromised to a customerFull payment and invoice, or the deal falls through
SoldInvoiced and handed overNone

The "Reserved" stage is the one most dealers skip, and it is the one that prevents two salespeople selling the same car on the same day. A "trace" for each vehicle (every stage change with a date) answers "what happened to this car?" in seconds.

Worth a monthly look: vehicles that have stayed in Available for a long time. Ageing stock ties up cash; knowing which cars they are is the first step to moving them.

Spare parts: codes, compatibility and low stock

Parts move fast and in small quantities. Give each part a code, a category and a brand, and record which car models it fits, so a counter clerk can find the right part from the model name. Keep cost and retail price per part, and set a low-stock level so the dashboard warns you before you run out of a fast mover. Use stock adjustments (with a reason) for damage, returns and count differences, instead of editing quantities directly.

Purchases that update stock and supplier balances

Raise a purchase order, then record a goods received note (GRN) when the vehicles or parts actually arrive. The GRN is what adds stock; the supplier's ledger shows what you bought, what you paid and what you still owe. Matching orders, receipts and supplier bills is how you catch short deliveries and price differences.

From quotation to invoice to payment

A quotation becomes a sales order, and the sales order becomes an invoice, without retyping. The invoices ledger should show which invoices are paid, part-paid or open, and payments received should be recorded against invoices. Each customer then has a statement you can share on request.

Reports that tell you how the business is doing

  • Stock valuation: what the vehicles and parts on hand cost you.
  • Low-stock audit: parts below their reorder level.
  • Sales summary and purchases log for any date range.
  • Profit and loss for the period.
  • Sales trend and cash flow: sales revenue against purchase cost over time.

A simple weekly routine

  1. Check the dashboard for low-stock parts and reorder.
  2. Review Reserved vehicles: confirm or release each one.
  3. Follow up open invoices and customer balances.
  4. Reconcile supplier balances against their statements.
  5. Once a month, look at stock valuation, ageing stock and profit and loss.

Checklist for your dealer software

  • VIN and chassis number fields, searchable, plus engine and registration numbers.
  • Purchased, Available, Reserved and Sold stages with a trace per vehicle.
  • Parts catalog with compatible models, cost and retail price, low-stock levels and adjustments.
  • Purchase orders, goods received notes and a supplier ledger.
  • Quotations to sales orders to invoices, payments and customer statements.
  • Stock valuation, low stock, sales, purchases and profit and loss reports.
  • User accounts with their own logins.

Our Auto Dev ERP does all of this in a web dashboard, and you can open its live demo from the product page before talking to us.

Questions

Quick answers

What is a VIN and why track vehicles by it?
A Vehicle Identification Number is a unique 17-character code given to a vehicle by its manufacturer. Because no two vehicles share one, it is the safest key for stock, sales and service history.
What if an imported car has no 17-character VIN?
Some imported vehicles carry a chassis or frame number instead. Record both the VIN and the chassis number fields, along with the engine and registration numbers, and search on any of them.
Which reports should a car dealer check every month?
Stock valuation, low stock for parts, sales and purchases for the period, and profit and loss. Vehicles that have stayed in the Available stage for a long time are worth a separate look.
DeviBot
Usually replies in a few seconds
Hey there 👋 I'm DeviBot. What's your name?