Dealership Software

How to Track Used Car Sales in a Dealership

By Bill My Car · Updated 20 September 2026 · 4 min read

For Car and Bike Dealers in India

Start free →

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 isn't a bigger spreadsheet. It's recording the sale once, at the point you already raise the invoice, in a form you can actually query later.

The fields worth recording

That's it. Every report a small dealership needs comes out of these, and none of it takes more than a few seconds to capture, because you're already writing most of it on the invoice. The two fields dealers skip are reconditioning cost and lead source, and those are exactly 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. What's 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 car is capital not funding the next deal.

3. Units sold, against units bought. If you're buying faster than you're selling, your stock number goes one way and your cash goes the other.

4. Conversion by lead source. Which channel actually produces a sale, not which produces enquiries. That's why the lead source field matters, and it connects to your lead management.

5. Ageing stock. Which cars have crossed your comfort threshold. Run this 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 car that sat four months can be a worse deal than a thinner margin that turned in three weeks.

Register, spreadsheet, or software

The honest position: a spreadsheet is a real step up from a register, and it's enough for a dealership doing a handful of cars a month. Where it breaks is duplication. The same registration, engine and chassis numbers 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's the truth.

Make the invoice the record

The thing that makes tracking stick is realising the sale record and the invoice are the same event. If the invoice is the entry point, the tracking comes free. So capture the fields above at invoice time instead of in a separate log, and generate the documents from that one entry instead of retyping. The vehicle details flow into the sale letter, the delivery note, the terms and conditions and the RTO forms, and the sale lands in your numbers at the same time.

Nobody keeps a parallel log up to date. Everybody raises the invoice.

How this fits together

Sales tracking is the middle layer of three, and it's 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's coming, and from where.

With inventory and leads but no sales record, you know your stock and your pipeline and nothing about whether you're actually making money. It's a common and uncomfortable place to be.

A few habits that help

• Record reconditioning against the car when you spend it, not at month end, when it gets swallowed into general expenses and every unit looks better than it was.
• Capture the 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's a loss.
• Keep the buyer's contact details with the sale, not in a separate phone. Repeat and referral business is the cheapest you'll get.
• Store the documents with the record. When a query lands eighteen months later, finding it 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, makes 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 leads sit alongside it, so the three layers connect instead of living in three places.

Sign in and record your next sale once.