Your Parts Reconciliation is Talking, Are You Listening? - Insight Vol. 36

BY SAMANTHA MILLARD

Let’s talk about the parts department—the quiet workhorse of the dealership.

It doesn’t usually steal the spotlight like variable sales. It doesn’t generate daily drama like service capacity or technician shortages. However, it does quietly hold a material chunk of your balance sheet, feeds your service department, supports customer satisfaction, and (when managed well) prints reliable gross month after month.

And yet… it’s often one of the most neglected areas from an internal control perspective.

Why? Because the parts department is specialized. It lives in its own operational ecosystem of bin locations, cores, returns, emergency orders, backorders, and DMS quirks that most upper management did not grow up mastering. So what happens?

We get the classic approach:

“The Parts Manager knows what they’re doing. Let them run it.”

Which is fine—until the numbers stop agreeing with each other.

And while you may not want to count oil filters for fun, everyone understands dollars. When parts inventory drifts out of alignment, it doesn’t just “live in parts”—it leaks directly into your financials, your gross, and eventually your year-end surprises.

What bridges the gap between day-to-day parts operations and the financial statements? The parts reconciliation.

The Parts Reconciliation: The Most Underrated Tool in Your Dealership

The parts reconciliation is not busy work. It is not a box to check and it’s definitely not something meant to be dusted off once a year when the auditors show up.

At its core, a parts reconciliation compares:

What your shelves physically hold vs. what your DMS and general ledger think you own

In theory, these numbers should agree. In reality? They often nod politely at each other from opposite sides of the room.

We regularly see dealerships that: rely solely on annual physical inventories to “true up,” perform monthly reconciliations but never actually review them, or accept variances as normal without understanding why they exist. That’s not reconciliation, that’s hope accounting.

What the Parts Reconciliation Actually Does (When Used Correctly)

A properly prepared and reviewed parts reconciliation delivers three things upper management cares deeply about:

1. Financial Accuracy

Parts inventory is a material balance sheet asset. When it’s wrong:

• Gross margins get distorted

• Expenses quietly creep in

• Financial statements stop telling the truth

  
  

A small monthly variance can turn into a very expensive year-end adjustment.

2. Operational Efficiency

If your system says a part is in stock but the bin says otherwise:

• Repair orders stall

• Technicians wait

• Customers lose patience

• CSI quietly takes a hit

  
  

Accurate inventory supports faster service, cleaner workflows, and fewer “where did that part go?” moments.

3. Fraud Prevention & Accountability

No one likes to talk about it, but reconciliations reduce opportunity for fraud. When inventory is reviewed monthly, discrepancies surface early, accountability increases, and “inventory drift” doesn’t become an accepted norm.

How Often Should You Be Reconciling? (Hint: Not Annually)

Monthly. Always monthly.

The standard process:

1. Parts manager prepares the reconciliation using the DMS inventory value

2. Reconciling items are identified, such as:

   • Open repair orders

   • Warranty work in process

   • Parts returns

   • Vendor payables

3. The adjusted DMS value is compared to the general ledger

4. Remaining variances are investigated—not shrugged off

   
   

As a control benchmark, inventory differences should stay within 4% or less. If you’re consistently outside that range, reconciliation isn’t the problem—the process is.

What Variances Are Trying to Tell You

Think of reconciliation variances as symptoms, not annoyances:

• Consistent Overages: May point to duplicate receipts, miscounts, or data entry errors. In other words: the system thinks you’re richer than you are, or worse yet; parts are not being installed when they should be.

• Recurring Shortages: These are more concerning and often tied to process breakdowns, misallocated parts, or yes, occasionally theft.

• Wild Swings Month to Month: Typically signal unstable processes, inconsistent counting, or “we’ll fix it next month” behavior.

  
  

None of these will resolve themselves.

Real-World Blind Spots We See

From the field, some greatest hits are:

• Discounted Parts: Parts sold at discounts but not properly recorded in the DMS create phantom gross. It looks great—until it doesn’t exist.

• Obsolescence That Never Left: Scrapped or obsolete parts sitting in the system inflate inventory and guarantee painful write-offs later.

• Unprocessed Returns: Special orders canceled in real life but still alive in the system = ghost inventory and accounting confusion.

  
  

These aren’t rare edge cases—they’re everyday issues in stores that don’t actively manage their parts reconciliation.

How This Hits Your Bottom Line (Where It Actually Hurts)

Let’s be blunt:

• Do you enjoy large obsolescence write-offs?

• Are you excited about carrying unreturnable, dead inventory?

• Do you love paying tax or commissions on gross that never actually existed?

• Are surprise year-end adjustments fun to explain?

  
  

Because ignoring the parts reconciliation is how you get all of the above.

The Takeaway: Look Before It Hurts

You don’t need to become a parts expert. You do need visibility.

Review your parts reconciliation monthly. Ask questions. Look for trends. Push for explanations that make sense—not just ones that make the number go away.

A little attention now saves a lot of money later, a lot of cleanup at year-end, and a whole lot of unnecessary heartache. Because the parts reconciliation isn’t just reconciling inventory—it’s reconciling reality with your financials. And reality always wins.