Bill My CarDealership Software
How to Track Used Car Sales in a Dealership
Track a used car sale on fifteen fields and you can answer every question that matters at month end. Most dealerships track five, in a register, and then spend the last three days of the month reconstructing the rest from invoice books and memory.
The fix is not a bigger spreadsheet. It is recording the sale once, at the point you already raise the invoice, in a form you can query later.
The fields worth recording
| Group | Fields |
|---|---|
| Vehicle | Registration number, make, model, variant, year |
| Buy side | Purchase date, purchase price, reconditioning cost, source |
| Sell side | Sale date, sale price, payment mode, invoice number |
| People | Buyer name and contact, salesperson, lead source |
That is it. Every report a small dealership needs is derived from these, and nothing here takes more than a few seconds to capture because you are already writing most of it on the invoice.
The two fields dealers skip are reconditioning cost and lead source. Both are the ones that answer the expensive questions later.
The five numbers that tell you if the month worked
1. Gross profit per unit. Sale price minus purchase price minus reconditioning minus direct deal costs. Not the headline margin, the real one. Detail on what is realistic is in used car dealer profit margins in India.
2. Days in stock. Purchase date to sale date. This is the number that separates dealers who feel busy from dealers who are earning. Capital tied up in a slow unit is capital not funding the next deal.
3. Units sold, against units bought. If you are buying faster than you are selling, the stock number is going one way and your cash is going the other.
4. Conversion by lead source. Which channel actually produces a sale, not which produces enquiries. This is why the lead source field matters, and it connects to your lead management process.
5. Ageing stock. Which units have crossed your comfort threshold. This is the report to run weekly, not monthly, because the fix, a price change, only works if you make it early.
Read one and two together. A high margin on a unit that sat four months can be a worse deal than a thinner margin that turned in three weeks.
Register, spreadsheet, or software
| Paper register | Spreadsheet | Dealership software | |
|---|---|---|---|
| Cost | Nothing | Nothing | A subscription |
| Reporting | Manual, at month end | Formulas, if maintained | On demand |
| Ageing stock alert | Nobody notices | Only if you look | Surfaces itself |
| Retyping across documents | Every document | Every document | Enter once |
| Two people at once | No | Awkward | Yes |
| Survives a lost book | No | If it is in the cloud | Yes |
The honest position is that a spreadsheet is a real improvement over a register and is enough for a dealership doing a handful of units a month.
Where it breaks is duplication. The same registration number, engine number, chassis number and buyer details get typed into the tracking sheet, then again into the invoice, then again into the sale letter, then again into Form 29 and Form 30. Four copies of the same fact, four chances to fat-finger a chassis number, and no single version that is authoritative.
Make the invoice the record
The insight that makes tracking sustainable is that the sale record and the invoice are the same event. If the invoice is the entry point, the tracking is free.
That means capturing the fields above at invoice time rather than in a separate log, and generating the documents from that single entry rather than retyping. The vehicle details flow into the sale letter, the delivery note, the Terms and Conditions and the RTO forms, and the sale simultaneously lands in your numbers.
Nobody keeps a parallel log up to date. Everybody raises the invoice.
What this connects to
Sales tracking is the middle layer of three, and it is the one dealerships most often leave empty:
- Inventory tells you what you hold and what it cost.
- Sales tracking tells you what left, at what margin, after how long.
- Leads tell you what is coming and from where.
With inventory and leads but no sales record, you know your stock and your pipeline and nothing about whether the business is actually making money. That is a common and uncomfortable place to be.
Practical habits
- Record reconditioning against the vehicle when you spend it. Not at month end, when it gets absorbed into general expenses and every unit looks better than it was.
- Capture lead source at first contact, not at sale. Nobody remembers accurately three weeks later.
- Review ageing stock weekly. A price correction at week six works. At week sixteen it is a loss.
- Keep buyer contact details with the sale, not in a separate phone. Repeat and referral business is the cheapest business you will get.
- Store the documents with the record. When a query comes eighteen months later, retrievable by registration number is the whole game. See document management for car dealerships.
Doing it without adding work
Bill My Car captures the vehicle, buyer, purchase and sale details once when you raise the invoice, generates every document the sale needs from that entry, and keeps the sale in your records with the documents attached and saved to your own Google Drive. Stock and buyer leads sit alongside it, so the three layers connect instead of living in three places.
Sign in and record your next sale once.
Track every sale from the invoice you already raise
Bill My Car turns one invoice into GST & non-GST bills, sale letters, Form 29, Form 30 and delivery notes, auto-filled and ready to download. Built for Indian used-car dealers.
Try Bill My Car free →Frequently asked questions
What should a used car dealership record on every sale?
Fifteen fields cover it: registration number, make, model, variant, year, purchase date, purchase price, sale date, sale price, buyer name and contact, payment mode, invoice number, salesperson, and the lead source. Everything useful you can compute later comes from those.
What is the most important number to track in a used car dealership?
Gross profit per unit and days in stock, read together. A high margin on a car that sat for four months can be worse than a thinner margin that turned in three weeks, because the slow unit tied up capital that could have funded another deal.
Is a spreadsheet enough to track car sales?
It works up to a point, and it beats a paper register. It breaks when the same vehicle details are typed into the sheet and separately into the invoice, the sale letter and the RTO forms, because the versions diverge and nobody knows which is right.
How do I calculate gross profit on a used car sale?
Sale price minus purchase price minus reconditioning cost minus any direct cost of the deal. Record reconditioning against the vehicle at the time you spend it, not at month end, or it quietly disappears and every unit looks more profitable than it was.