What to track on a used vehicle from auction to front line

Decide the ceiling before the bid

The number that determines whether a unit makes money is set before you own it. Work backward from what you believe the unit retails for under your own assumptions, subtract your reconditioning estimate, pack, transport, and the gross you want, and what is left is the most you would pay.

Write the assumptions down next to the number. When the unit comes in at four hundred dollars over the recon estimate, you want to know whether the miss was the estimate or the bid. A ceiling with no recorded assumptions teaches you nothing after the fact.

This is a planning calculation on your own inputs. It is not a market valuation, a lending decision, or a guarantee of profit.

The fields you will chase if you do not capture them

Every small dealer loses time on the same handful of unknowns. Each one is a field.

• Title status — in hand, applied for, or waiting, with a date
• Key count — the second key is a real cost and it is always discovered late
• Inspection status — passed, failed, scheduled
• Lot location — because a unit nobody can find cannot be shown
• Assigned owner and next action — one name, one verb, per unit

Recon: estimate and actual, per task

Log recon as tasks with vendor, estimate, and actual cost. Not one lump figure. The lump figure hides the tyre bill that doubled and it makes total invested a number you distrust exactly when you need it, which is when you set the price.

Total invested is purchase plus transport plus recon actual plus pack. Until every recon task is closed, treat the figure as provisional and label it that way rather than pricing off it.

Front-line readiness is a checklist, not a feeling

A unit is not for sale until it is photographed, described, priced, and posted. Track those four states per unit and the gap between "recon done" and "actually listed" stops swallowing a week.

Then track leads against the stock number with source, status, and next contact date. Follow-up that lives in text messages is follow-up that stops when the day gets busy.

Days in stock is the discipline

Days in stock and aging flags are the only thing that forces a decision on a unit that is not moving. Set your own thresholds, look at the aged list weekly, and make the call — reprice, move it, or wholesale it — rather than letting it sit another month while it depreciates.

When the unit sells, close it out with final gross and margin against total invested. That closes the loop back to the ceiling you set at the start, and over twenty units it tells you whether your recon estimates and retail assumptions are honest.

Where a workbook helps

The Independent Dealer Operations System carries the acquisition pipeline, appraisal and purchase-ceiling sheet, vehicle inventory with those chased fields, recon tasks and actual cost, listing and photo readiness, leads and follow-up, days in stock, and sold gross profit.