Bottom Line: Database Differences Cost You - BodyShop Business

Bottom Line: Database Differences Cost You

If our estimates match in content but a “database difference” hoses me out of money, I insist the insurance appraiser split the difference with me.

Isn’t it amazing that no matter what you write for an estimate, the insurance appraiser can find a way to cut the price?

You could write six hours for an eight-hour dent, and the appraiser will write five hours and then tell you what a hero he is for “giving” you the five hours. It also always seems their software comes up with fewer hours for the same operations.

How can this happen? Are there body shops pressuring the database providers to lower the flat-rate times because they feel guilty they’re actually squeezing out a profit? We can’t have that.

Sure, on a rare occasion, the appraiser might actually over-write you, but if this happens, it’s because you missed something or because the appraiser was doing more of a guestimate to save himself a trip to your shop for a supplement. (More than once I’ve had an appraiser call me while he was writing an estimate to tell me that he’d added some extra items. “Don’t call me for a supplement,” he says.) But we all know the odds of that happening are slim.

Up until a few years ago, if an appraiser told me the reason his estimate was lower than mine was because of the different databases, I’d shrug and figure “that’s life.” After all, .1 here and .3 there weren’t a big deal. Why should I nit-pick over a few tenths? The appraisers never do.

Then one day something happened that changed my outlook on database differences.

I had a wreck sitting in the lot, and there was a question of liability for the accident. As is common in this situation, both insurance companies came out to write an appraisal. I had already written one — it was pretty minor, with just a few parts needed — so both appraisers followed my estimate to the line. Both appraisers used ADP, and I wrote mine with Pathways.

The same part on each estimate had different paint times.

One would think that both insurance estimates would be identical. And they were. Line by line, both estimates listed the same items. However, the bottom lines were different. And much of this difference was paint labor. The same part on each estimate had different paint times.

I called ADP and asked their tech support department how this could happen, and they told me that each insurer had set up their software differently.

“How different can the settings be? We’re talking about changing a fender here.” I asked him.

He let out a little chuckle and explained all the different options. Pathways has options too but, in my opinion, they’re more transparent.

We all know that each estimating system approaches the estimate-writing process differently, but they (don’t ask me who “they” is) say that if used properly, all three of the major estimating systems will come up with similar figures for the same damage.

Apparently no one is using the software properly, since the discrepancies seem to get larger and larger.

So, from that point on, I decided that I wasn’t going to let these little “database differences” slide by.

Accepting that few people really know how to use their estimating software properly, I decided that the fair thing to do was to insist that the insurance appraiser split the difference with me. If, after our estimates match in content, there’s still a “database difference” that hoses me out of the precious few dollars so generously offered by said insurance appraiser, I add up the difference and divide it in half. I then expect the appraiser to make a concession for his half.

Now, doesn’t that sound perfectly fair? Who could argue with this solution?

You’d be surprised. It amazes me how human beings can be conditioned to shut down their thought process.

“I’ve got to ask my boss.”

“I can’t make that decision.”

“They (there’s that “they” again) won’t let me do that.”

Sound familiar?

I spend a lot of time comparing estimates, trying to figure out just how the appraiser performed his magic trick and made so many dollars vanish into thin air. I also spend plenty of time trying to teach some appraisers what the words, “negotiation” and “compromise” mean.

I also hold my ground. And seldom do I get a refusal from an appraiser to split the difference of this mysterious lost time anymore. After all, I’m being fair. A simple line item on their estimate, “concession for database difference,” is all they have to do.

Writer John Shortell is body shop manager at Secor’s Collision Technology in New London, Conn. He’s been in the collision industry for more than 20 years and has developed computer software for shop scheduling called Body-Shop Schedule Pro, for subletting towing called Tow Bill Helper and for printing estimates in dollars called Dollars & Sense. For more information, visit

You May Also Like

Reader’s Choice: Required Vehicle Safety Inspections

If we are going to agree that inspections are needed when a collision occurs, then we should all be on the same page on what that means.

What is the definition of a “collision” as it pertains to required safety inspections? OEMs haven’t provided a clear answer to this question, and so it is left up to the shop to decide how to interpret these requirements. It seems like each shop I speak with has a different idea/definition of collision. If we are going to agree that inspections are needed when a collision occurs, then we should all be on the same page on what that means — and the OEMs should provide clearer guidelines. – Loni Waltasi, Old Dominion Collision, Eugene, Ore.

Reader’s Choice: Why Don’t Insurers Pay the Prevailing Rate?

If in the past insurance companies would only pay the prevailing rate, then why do they not have to pay the prevailing rate now, since the prevailing rate went up?

Meet the Auto Body Instructor: Norm Markham

Norm Markham was a student at Dennis Technical Education Center in the early 1980s and is now one of the collision repair and automotive refinishing instructors there.

Auto Body Shop Financials: Breakeven Point and Beyond

Knowing your fixed costs and breakeven point up front may be the difference in making money in a month or not.

Putting Your Passion for Your Auto Body Business to Work

It’s critical to create a culture where everyone embraces doing his or her job with the highest quality and providing excellent customer service — with the same passion that you as the owner have.

Other Posts

Appraiser Invents Digital Image Renaming Tool for Estimators

Image Rename It results in a 60-70% time savings for appraisers and estimators tasked with renaming collision damage image files.

Body Bangin’: Stop Estimating and Start Repair Planning

Live from the Southeast Collision Conference, Micki Woods interviews Michael Bradshaw on creating a thorough repair process.

Body Bangin’: Write Your Strongest Sheet with Danny Gredinberg

Live from the Southeast Collision Conference, Micki Woods interviews DEG Administrator Danny Gredinberg on how shops can utilize the DEG to get paid for what they do.

Don’t Eat the Bear in One Bite: Planning Your Future in Steps

Just like you don’t need to eat the bear in one bite, you don’t need to have a fully fleshed-out plan in order to have a successful future as a retired body shop owner.