Reconcile Your Closed-Lost Records Before You Believe Them

Your loss reasons are fiction, and everyone knows it

Pull the last 100 unsold showroom customers out of your CRM and look at the loss reason field. You'll see some version of this:

• "Price" — 41
• "Just looking" — 22
• "Bought elsewhere" — 18
• "Payment too high" — 9
• Blank — 10

Now go listen to five of the "price" deals. In two of them the rep never asked what the customer was trying to accomplish. In one, the customer asked twice about a trade payoff and got a monthly payment instead. In one, the number really was the problem — the customer wanted a $520 payment on a unit that pencils at $690. And in one, the customer bought the same vehicle down the street for $400 more.

That last one isn't a price loss. That's a trust loss with a price label on it.

This is why closed lost analysis at most stores is useless. The data isn't wrong because people lie. It's wrong because the loss reason gets picked in four seconds by the person who has the least incentive to be honest about it, and nobody ever checks. So the report says "price," the manager says "we need to be more competitive," and the actual breakdown — reps not confirming trade numbers, not asking about the timeline, not getting a second person involved — never gets touched.

Reconciliation fixes that. It's a short, repeatable process: verify what actually happened, correct the reason, and roll the recurring reasons into one process change. Not a data cleanup project. A weekly habit that takes about 45 minutes.

Step 1: Define outcomes that can be verified

Before you can correct a loss reason, you need categories that mean something. Most CRM pick lists are a mix of outcomes, objections, and excuses. Separate them.

Start with the outcome — what actually happened to the customer:

• Bought from us (later, so the original "lost" flag was wrong)
• Bought elsewhere — you can often confirm this
• Still shopping — no purchase, no decision, still reachable
• Not buying now — timeline moved, credit issue, life change
• Unreachable — no contact after the visit, no valid number
• Unknown — nobody tried

Then, separately, the reason — and here's the key move: split reasons into customer conditions and process breakdowns.

Customer conditions are things you can't coach:

• Wanted a unit you don't stock and can't get
• Negative equity beyond what any lender will cover
• Credit decline after real effort
• Spouse or partner said no and never engaged

Process breakdowns are things you can:

• Trade value never confirmed before the customer left
• Never test drove
• No manager involvement
• Never got a firm next step with a date and time
• Follow-up stopped after two attempts
• Question asked and not answered
• Customer had to repeat information already given to the BDC

If "price" is a valid entry in your list, require a second field: the customer's number and yours. "Price" with no numbers gets kicked back. That one rule alone will cut your price losses in half, because half of them aren't price.

Step 2: Verify a sample, not everything

You cannot audit 200 unsold customers a week and you shouldn't try. Take a sample and take it seriously.

Pull 10 unsold showroom customers per week. Weight the sample:

• 5 at random
• 3 from the reason that dominates your report (usually "price")
• 2 from your two highest-volume reps

For each one, spend three to four minutes:

1. Read the notes. Is there a documented next step with a date?
2. Listen to the last call or check the last two emails. Was the customer still engaged when contact stopped?
3. Check the desk log. Was a number ever presented?
4. If the outcome is unclear, have someone place one verification call.

The verification call is short and not a sales call. It works better from a manager than the rep who lost the deal.

"Mr. Alvarez, this is Dana, I manage the sales floor at Northline. You were in with Marcus about three weeks ago on the Highlander. I'm not calling to sell you anything — I'm going back through the people we didn't take care of well enough. Did you end up buying something?"

Then two follow-ups, in this order:

"What made you go that direction?"

"Was there anything we didn't get you an answer on?"

That second question is where the real lost sales reasons come out. People will tell a manager "nobody ever called me back with the trade number" when they'd tell the rep "we're still thinking about it."

Roughly a fifth of these calls will turn back into a live opportunity. That's a nice side effect, not the point. The point is a corrected record.

Step 3: Correct the record and log the delta

Update the outcome and reason in the CRM. Then log what changed — that log is the whole asset.

Keep it as a simple sheet: date, customer, rep, original reason, corrected reason, evidence.

After four weeks you'll have 40 rows. That's when it gets useful.

The gap between the original column and the corrected column is your real dealership CRM audit finding. If 60% of "price" corrects to something else, your pricing isn't the problem — your process is, and you've been buying inventory and adjusting margin to solve a problem that lives on the floor.

Step 4: Turn the top recurring breakdown into one process change

Count the corrected reasons. Take the top one. Change one thing.

Not five things. One thing, with an owner and a date, and a way to check whether it happened.

Examples of what that looks like in practice:

Corrected reason: trade value never confirmed (11 of 40). Change: no customer leaves the showroom without a written trade number or a stated reason why not. Owner: used car manager. Check: manager reviews the day's unsold desk logs each evening for a trade figure.

Corrected reason: no firm next step (9 of 40). Change: the unsold showroom follow-up starts with a calendar entry, not a task. Rep books a specific time before the customer stands up. Check: the daily CRM look already tells you which unsold ups have a dated appointment and which have a vague task.

Corrected reason: question asked and not answered (7 of 40). Change: the rep writes the customer's open question in the notes verbatim before they leave, and the first follow-up contact leads with the answer. Check: pick three unsold records a day, see if the question is there.

Then run the sample again next month and see whether that reason dropped. If it didn't, the change didn't stick, and that's a different conversation — usually about whether the step is actually doable in the time the rep has.

What this costs you

Ten records a week. Three to four minutes each, plus a handful of verification calls. Call it 45 minutes for you, an hour if you're being thorough. Once a month, 20 minutes to count the corrected reasons and pick the change.

What you get back is a loss report you can act on and an argument you can win. When someone says "we're losing on price," you can say: we checked 40 of them, 22 weren't price, and 11 of those were trade numbers we never gave the customer. That's a fixable problem.

If you're already reviewing calls and emails, most of the verification evidence is sitting there — the customer's unanswered question, the "I'll follow up" with no date, the moment the deal actually went sideways. Tooling that scores conversations against a rubric (MoreSignal does this) shortens the listening step considerably, but the reconciliation habit matters more than the tool. A notebook and one honest hour a week beats a clean dashboard nobody checks against reality.

Start with 10 records this Friday. See how many of your price losses survive contact with the truth.