Reconciling the Up Log With Your CRM Lead Records
The desk log and the CRM rarely match. A weekly process for reconciling the up log with CRM lead records so source reports, pay plans, and GM reviews stop arguing with each other.
Saturday morning. The desk log shows fourteen walk-ins. The CRM shows eight new leads. The GM asks which source actually drove the traffic, and three people give three answers. The BDC manager points at internet appointments that showed. The used-car manager points at a truck that sold to someone who "just walked in." The desk greeter shrugs and says most people write "looking." None of those answers is a reconciliation. They are stories competing with a clipboard.
Reconciling the up log with CRM lead records is the unglamorous work that makes every other source report usable. If the desk captured a body and the CRM captured a name, and nobody ever lined those two records up, you will over-count walk-ins, under-count Marketplace and website traffic, and pay spiffs on the wrong origin. Floor-plan interest does not care which system you trust. Attribution should.
This guide is for general managers, internet directors, and used-car managers who already run a desk log and a CRM and still cannot get them to agree. It is not a CRM vendor tutorial. PostToMarket does not integrate with your CRM. The process below works whether you use a full dealership CRM, a spreadsheet, or both.
Why Reconciling the Up Log With CRM Lead Records Is a Weekly Job
A one-time cleanup feels productive and decays in ten days. People skip fields under a lunch rush. Internet leads arrive in Messenger, email, and the main line, then appear at the desk as "walk-ins" if the greeter never asks how they found the car. Phone-ups get written on the log and never created in the CRM. CRM leads get created and never appear on the log because the customer never set foot on the lot. Those four leaks are normal. Leaving them unreconciled is a choice.
What "match" actually means
A match is not "we had about the same number of ups." A match is a named person, a date, a vehicle of interest, and a source that both systems can defend. Until you can point at a row in the log and a record in the CRM and say they are the same visit, you are comparing two different businesses.
Treat these as separate objects:
- Desk up: a person who arrived, called, or was physically on the lot, captured at the moment of contact.
- CRM lead: a person entered into the pipeline, often from a digital inquiry, a phone-up, or a desk write-up after the fact.
- Sold deal: a unit that left inventory. The deal jacket source is a third dataset, and it is often overwritten at F&I.
Why GMs should care before they care about ROI
You cannot track Marketplace lead source ROI in your CRM if the CRM is missing the people who actually showed. You cannot run a fair one-page lead source report for the GM if the up log is counting internet appointments as fresh walk-ins. Pay plans, BDC headcount, and posting labor all get argued from whichever system makes a department look busier. Reconciliation is how you stop that argument.
Where the Up Log and the CRM Diverge
Mismatches are not random. They cluster in a handful of operational gaps. Find the gap before you blame the greeter.
Internet leads who show without a CRM flag
A buyer messages on Marketplace Friday night, confirms Saturday at 11, and walks in. If the greeter does not see an appointment on the board, the log says walk-in. If the CRM still says "new internet lead" with no show recorded, the internet director thinks the appointment no-showed. Both systems are wrong about the same person.
Phone-ups that live only on paper
The desk takes a call, writes a name and a stock number, and promises a callback. Nobody creates the CRM record because "they might not be real." If that person later walks in, they become a walk-in. If they never walk in, the call vanishes. Either way, phone-up volume in your CRM is a fiction.
Duplicate people, split sources
Same customer, two entries: one from a website form on Tuesday, one from a desk write-up on Thursday. The CRM may keep both. The log may keep only Thursday. First-touch source dies unless you have a merge rule. See duplicate lead merge rules for your dealership CRM before you invent a new one at the Saturday meeting.
Sold units that never had an up
A deal writes and there is no matching log line. That usually means a manager worked the customer off-desk, a service-to-sales conversion was never logged, or a wholesaler walked the lot. It can also mean the log was skipped because the customer was "already in the CRM." Skipping the log to avoid double work is how you create a third, invisible channel.
A Procedure for Reconciling the Up Log With Your CRM
Run this every Monday for the prior seven days. Forty minutes is enough if the log is complete. If the log is a mess, the first two weeks will take longer, and that is the point.
- Export both lists for the same date range. Desk log (walk-ins, phone-ups, appointments that showed). CRM (new leads, appointments, shows, sold). Same store, same days.
- Normalize names and phones. Strip extra spaces, compare last name plus last four of the phone, then VIN or stock of interest. Do not match on first name alone.
- Mark three buckets. Matched. Log-only. CRM-only.
- Work log-only first. For each unmatched up, search the CRM by phone, email, and vehicle. Create the missing record, or attach the visit to an existing one. Write the true source, not "walk-in," if the customer told you they saw the car online.
- Work CRM-only second. For each unmatched CRM lead, check whether they showed, called, or stayed digital. If they showed and the log missed them, add the log line. If they never showed, they are not an up. Leave them in the CRM as a digital lead.
- Reconcile sold deals last. Every deal in the date range should have a CRM record and, if they were on the lot, a log line. Missing either is a process failure, not a reporting quirk.
- Write a one-paragraph exception log. Three bullets: how many log-only, how many CRM-only, what you changed in the process so next week is smaller.
A small matching table you can keep in a shared sheet
| Signal | Treat as a match if | Do not treat as a match if |
|---|---|---|
| Name + phone | Last name and last four digits agree | Common last name, no phone |
| Same stock, same day | Plus a name or phone overlap | Two different people on the same truck |
| Appointment time | Show recorded within a reasonable window of the booked slot | "Came by later" with no time on either system |
| Exact match | Store-generic addresses used as placeholders |
Illustrative example: consider a lot that logs 60 ups in a week and creates 45 CRM leads. After matching, you might find 38 true matches, 22 log-only (mostly phone-ups and unlogged internet shows), and 7 CRM-only (digital leads who never arrived). Those 22 log-only records are the hole in your internet report. They are also the hole in anyone's pay plan that credits "floor ups" as if they were unassisted.
Who owns the Monday pass
Pick one owner. Internet director or used-car manager, not "the desk." The desk produces the log. The owner of reconciliation is the person who has to defend source numbers in the GM meeting. If two people "share" it, it will not happen the week the lot gets busy.
Rules That Keep Both Systems Honest After You Reconcile
Reconciliation without rules is a weekly rewrite of history. Lock a few operating standards. These are store rules, not software features.
Source is first touch, visit is a status
The CRM source field should not change because the customer later walked in. "Walk-in" is a visit type, not a source. If they first messaged on Marketplace, the source stays Marketplace even when they become a desk up. If you need a second field for how they arrived today, add one. Do not overwrite the first.
Every show updates both systems the same day
When an internet appointment shows, the desk marks the log and the CRM marks showed. One without the other recreates the Saturday-morning argument. Make it a desk standard, not a BDC afterthought.
Phone-ups get a CRM record before the callback
If the call was worth writing on the log, it is worth a CRM record. Incomplete is fine: name, number, stock, source = phone. Waiting until they are "serious" is how phone-ups disappear.
Sold-unit hygiene is part of this, not separate
A car that sold and is still advertised will generate messages, phantom appointments, and CRM leads for a unit that is gone. That pollutes both the log and the pipeline. Same-day sold status is inventory hygiene and attribution hygiene. See why sold units must leave Marketplace the same day.
Naming conventions beat memory
If one rep types "FB," another types "Facebook Marketplace," and the desk writes "online," reconciliation becomes translation. Use a short pick-list. Lead source naming conventions that keep attribution clean belong next to the log, not in a training slide nobody opens.
Checklist for the desk, not a lecture
- Ask every walk-in where they saw the car, and write the actual channel.
- Check the appointment board before labeling someone a fresh up.
- Capture phone number on every log line.
- Circle internet shows so they are not counted twice in a walk-in total.
- Initial the line. Anonymous logs cannot be coached.
How PostToMarket Automates This
Reconciling the up log with CRM lead records fails when Marketplace conversations never become structured inventory and lead activity the store can see. The problem is not a missing export button into your CRM. The problem is that posting, sold status, and inbound interest live in personal inboxes until someone copies them by hand.
PostToMarket keeps the Marketplace side of that story in one dashboard so the Monday reconciliation has something real to match against.
- Leads inbox for managers, so Marketplace inquiries are not trapped in a single rep's Messenger thread when you try to line them up with the desk log.
- Team analytics by rep and source, so you can see posting activity and which source produced work, instead of reconstructing it from memory.
- Inventory statuses (draft, posting, posted, sold, failed) plus mark as sold and archive from inventory or the queue, so a unit that left the lot is not still generating appointments you will later call "walk-ins."
- Per-rep posting queues and a team queue view, so ownership of the live listing is clear when you ask who talked to the customer who showed.
- Unlimited vehicles in inventory on every plan, with bulk CSV and Excel import and a row-level error log, so the stock numbers on the desk log can actually match what was advertised.
- Mobile dashboard so a rep can update queue and status on the lot instead of waiting until they are back at a desktop.
No tool can make Facebook distribute every listing, and PostToMarket does not write into your CRM. What it does is give you a clean Marketplace inventory and lead trail so reconciling the up log is matching records, not archaeology.
Make the Up Log and the CRM Tell the Same Story
If your Saturday desk total and your CRM new-lead count cannot be explained in one paragraph, you do not have a traffic problem. You have two books. Every week you skip reconciling the up log with CRM lead records, you teach the floor that whichever number is convenient is the number that counts.
PostToMarket will not replace your CRM. It will give the Marketplace side of the business a queue, a sold status, a leads inbox, and analytics a manager can read before the Monday pass. Starter is $59 per month for a solo seller or independent lot with one login. Dealership is $299 per month when you need up to 13 team logins and two managers.
Start your 10-day free trial through secure Stripe checkout. Import inventory, assign queues, and bring a real Marketplace trail into next week's reconciliation. Cancel anytime. Questions: info@posttomarket.com.