Guide

How to track used-car reconditioning

A practical way to keep every car's recon status current at a small dealership, whether you use a whiteboard, a spreadsheet or software. It includes a tracking table you can copy, a worked example and a ten-minute daily review.

Published by LotStages, a Wynn Systems product · October 23, 2026

This guide describes a general method, not measured results. The example dealership, vehicles and people are fictional.

1. What tracking is for

Reconditioning is the work between acquiring a car and having it ready to sell: inspecting it, repairing what's needed, cleaning it, photographing it and listing it. Several people touch each car, often at the same time.

Tracking works when anyone at the store can answer three questions about any car without asking around:

• Where is it: which stages are done, in progress or not started?
• What's holding it up, and when should that clear?
• What happens next, and who's doing it?

2. Name your stages and what "done" means

Write down the stages a car goes through at your store and agree what "done" means for each. The table below is a starting point; rename or drop stages to match how you work.

Keep the list short. Five or six stages everyone recognizes are easier to keep current than fifteen. When a stage doesn't apply to a car, mark it "Not needed" rather than leaving it blank, so it isn't mistaken for unfinished work.

3. Give every stage its own status

A common habit is one "current stage" per car: the car is "in mechanical". That can't show a car that's waiting for parts while it's being detailed, and it hides work that's already finished.

Instead, give each stage its own status, using the same five words everywhere:

• Not started
• In progress
• Blocked
• Complete
• Not needed

Stages don't have to happen strictly in order. If detail doesn't depend on a part that's on order, it can go ahead while mechanical waits.

4. A tracking table to copy or download

One row per car and one column per stage, plus four working columns:

• Blockers: what each blocked stage is waiting on and when it's expected (more on this below).
• Follow-up (optional): who's chasing the blockers or the next action. Leave it blank if your team shares the work; the point is that anyone can see who to ask.
• Last update: the date the row last changed. It shows which rows have gone quiet.
• Next action: the very next thing that moves the car forward.

Sort by intake date, oldest first, and filter for "Blocked" during the daily review.

To start your own, download the table as a TSV file (tab-separated text that Excel, Google Sheets and LibreOffice can open), or select everything in the box below and paste it into a spreadsheet. Each value lands in its own column.

Stock #	Vehicle	Intake	Inspection	Mechanical	Detail	Photos	Listing	Blockers (stage: waiting on, expected)	Follow-up (optional)	Last update	Next action
2210	2018 GMC Sierra 1500 (example)	Oct 20	Complete	Blocked	In progress	Not started	Blocked	Mechanical: rear brake pads, expected Oct 23; Listing: title from the lender, expected Oct 27	Jordan	Oct 22	Finish interior detail
2211	2020 Toyota Corolla (example)	Oct 21	Complete	Not needed	Complete	Complete	In progress			Oct 22	Write the listing
2212	2017 Chevrolet Tahoe (example)	Oct 22	In progress	Not started	Not started	Not started	Not started		Sam	Oct 22	Finish the inspection write-up

Rename the stage columns to match yours, and delete the example rows when you start. Spreadsheets usually turn the Intake and Last update values into real dates (for example "20-Oct"), which lets you sort by them.

5. Write blockers the next person can act on

"Waiting on parts" tells people a car is stuck, but not what to do about it. A useful blocker note answers four questions: what it's waiting on, from whom, when it's expected, and who's following up.

When the expected date changes, update it instead of leaving the old one, and change the row's "Last update" date. A blocker with a date that has passed is the first thing to look at in the daily review.

When more than one stage is blocked

A car can be held up in two places at once, such as parts for Mechanical and the title for Listing. Keep every active blocker, each labelled with its stage and with its own expected date, so clearing one doesn't hide the other:

Mechanical: rear brake pads, expected Oct 23; Listing: title from the lender, expected Oct 27

• Mark each of those stages "Blocked" in its own column, so the stage columns and the blocker list agree.
• When a blocker clears, remove only its entry, set that stage back to "In progress" or "Complete", and update "Last update".
• If a cell gets crowded, keep a second sheet with one row per blocker: stock number, stage, what it's waiting on, expected date, follow-up and last update.

6. Worked example: one pickup through recon

Fictional: the dealership, the truck and the people are invented to show the method.

A 2019 Ram 1500, stock 2201, arrives on day 1. Here's its row at the end of each day.

With a single "current stage" column, this truck would have read "Mechanical" from day 2 to day 4, and nobody would have known detail and photos were finished. Tracked stage by stage, the board shows it's waiting on exactly one thing, the brake pads, and when they're due.

Some stores prefer to take photos last, in case mechanical work leaves marks. Either way works; the point is that the board shows what's actually been done.

7. A ten-minute daily review

A short stand-up at the same time each day, in front of the board or the spreadsheet, keeps it current. Work through this list:

• Blocked cars first. Is each reason still true? Is the expected date still right? Who's following up?
• Decisions waiting on someone. If a car is waiting on an approval, make the call in the meeting or name who will, and by when.
• The oldest cars by intake date. What's the next action for each, and who's doing it?
• Rows whose "Last update" is older than yesterday, especially stages marked "In progress". Are they really being worked, or quietly stuck?
• Priority cars, such as one a customer is waiting for. Is anything in their way?
• Cars ready to show. If one goes out before every stage is done, note what's left.
• Update the board before everyone leaves.

8. Measuring time to line

"Time to line" usually means the number of days from acquiring a car to having it ready for the sales line. Definitions vary, so pick yours and use it for every car:

1. Choose a start: the day you acquire the car, or the day it arrives.
2. Choose an end: the day it's ready for sale, or the day it's listed.
3. Record both dates for every car, in your table or system.
4. Each month, look at the typical number of days (the median is less thrown off by one slow car than the average) and at the slowest cars.
5. Read the blocker notes on the slowest cars. Hold-ups that keep repeating are where to start.

Your own starting figure matters more than anyone else's target, because stores count from different points and recondition to different standards.

9. Whiteboard, spreadsheet or software?

Where LotStages fits

LotStages is recon software built around this approach: a status for every stage, blockers with a reason, a shared Work Queue and a history of changes, in the browser on phones and computers. It doesn't connect to a DMS or calculate time to line. See how LotStages works, screen by screen.