How an 11-Location Auto Repair Group Is Saving $1M/Year in Margin Leaks With Two Reports and One Hour a Day

When you run 11 auto repair locations, the money you lose isn't always the money you can see. It's the service advisor who fat-fingers a discount. The manager who grabs the wrong parts matrix. The tech who adds a part at zero cost and never creates a PO. Individually, each one looks small. Collectively, they add up to a million dollars a year.

That's not a hypothetical. That's the number one thing a regional operator discovered when he started using WickedFile's custom reports to track discounting and parts margin compliance across his 11 shops, and it's the number he's now systematically eliminating.

"You figure at $20,000 a week, that was a million dollars," he says. "If we can get this down to something manageable, 75 to 100K for the entire year, these two reports are going to help us do that."

The operator's shops run on Tekmetric. It's their system of record for repair orders, parts, and invoicing. But Tekmetric wasn't built to answer one critical question: where is the money going?

"Tekmetric doesn't give you the ability to do what we're doing right now," he says. "It's not possible."

The problems were layered:

• Uncontrolled discounting: Service advisors and managers had multiple ways to discount a job: lowering a part price, applying a percentage discount on the RO, or adjusting line items before presenting to the customer. There was no centralized way to see what was being discounted, by how much, or by whom. The company was running at nearly 14% discounting when their advertised and corporate discount programs should have capped it at 7%.‍
• Wrong parts matrix usage: With multiple parts matrices in play (one for standard mechanical parts, others for batteries, tires, bulbs, dealer-sourced parts) managers frequently selected the wrong one. A pump sourced from a dealer would get marked up using the standard matrix instead of the dealer matrix, resulting in incorrect pricing. Worse, when managers bypassed the matrix entirely and guessed at pricing, the shop almost always lost money.‍
• Zero-cost items slipping through: Parts like R&T (remove and transfer) items were being added to tickets at zero cost. The parts were being purchased with POs, but the customer was never being charged. Without a way to flag these automatically, they simply fell through the cracks.‍
• No practical way to audit: Could someone theoretically open every RO, review every line item, and check every discount manually in Tekmetric? In theory, yes. In practice, no. Generic tools weren't built for this level of auto repair-specific analysis.

"I've never actually done that because that would probably be a full-time job if somebody were to do that," he says. "And this just summarizes it right in front of you."

The operator built two custom reports in WickedFile that together give him complete visibility into discounting and parts markup compliance across all 11 locations. The setup took minutes. The daily review takes about an hour.

Report 1: The Discount Report

This report flags any repair order where the total discount exceeds 7%, the threshold set by the company's corporate and advertised discount programs.

• Filter: Approved work only, so estimates and declined jobs don't clutter the view
• Fields: Repair order number, store location, RO type, discount amount, and order total
• How he uses it: Sort by store to spot patterns: which locations are over-discounting, which managers are repeat offenders, and which discounts are legitimate (corporate fleet accounts, company vehicles) versus unauthorized

"If they try and do it through the discount on the RO, you've got this report," he explains. "If they try and manipulate the part price, you've got the other report. And you've got both, so there's nowhere to hide."

Report 2: The General Parts Margin Report

This report surfaces every part sold below the expected markup defined by the shop's parts matrix.

• Filter: Negative variants only (where the shop lost money), with a 5% tolerance threshold so minor rounding doesn't create noise
• Minimum: $12, which filters out state inspection stickers sold at face value
• Exclusions: Batteries, bulbs, and wipers have their own matrices and are tracked separately
• Fields: Part description, cost, sale price, margin percentage, multiplier, markup percentage, and the dollar amount lost against what the matrix should have produced

Each line item is a specific, actionable finding tied to the core mechanical parts business, where margin discipline matters most.

The Daily Workflow

The operator checks both reports three to four times a day, spending about 15 minutes per session:

1. Morning review checks the previous day's closed ROs. If he flagged something the day before and asked a manager to correct it, the morning review confirms whether they did.
2. Throughout the day he catches open/work-in-progress ROs where the discount or pricing error hasn't been presented to the customer yet. These are the highest-value catches because the price can still be corrected before authorization.
3. Flagging and follow-up for egregious findings triggers a call to the store manager or district manager. He documents which ROs he discussed each day and follows up the next morning.

"If I catch the open ones before they close, the discount rate is correct," he says. "That's really where the value is."

The impact has been measurable from the first week.

Discounting: 14% Down to 9% and Falling

When the operator first started tracking discounts in WickedFile, the company-wide discount rate was nearly 14%, double the 7% target. Within weeks, that number dropped to approximately 9%.

His goal: reduce the rate by half a percentage point each week until hitting the 7% target.

"We were discounting at almost 14%, and we're down to about 9% right now," he says. "By the end of the week, I'm looking to keep taking this down about a half a percent each week."

Margin Leaks: Catching What Was Invisible

The parts margin report surfaced losses that would have gone completely undetected: wrong matrix selections, zero-cost parts, and pricing guesswork that consistently left money on the table.

One example: a pump sourced from a dealer was marked up using the standard parts matrix instead of the dealer matrix. The report flagged a $206 loss on a single part. When the operator investigated, the root cause was clear, and the fix was a process correction, not a one-time adjustment.

"It also catches process problems," he says. "Because they didn't use the tire matrix, it means that the pricing wasn't correct regardless. They guessed at the price.

In another case, four tires from the same manager appeared on the report, all priced without using the tire matrix. The pattern pointed to a training gap, not a one-time mistake.

Projected Annual Impact: $1 Million

In the early weeks of tracking, the operator was identifying approximately $20,000 per week in combined discount and margin losses. Extrapolated over a full fiscal year, that's roughly $1 million in preventable profit erosion, money that goes straight to the bottom line.

Week-to-date figures from one sample week, with only a third of cars cashed out:

• Discount losses: $1,697 (projected full week: ~$5,000)
• Parts pricing losses: $2,891 (projected full week: ~$8,673)
• Combined projected weekly loss: ~$14,000

"That's the money that's going to the bank," he says. "You figure at $20,000 a week, that was a million dollars. These two reports are helping us curve that."

The weekly loss figure has already dropped from $20,000+ to approximately $14,000, and the trend line continues downward.

Time Investment: One Hour That Pays for Itself

The entire daily workflow, reviewing both reports across all 11 locations, investigating flagged ROs, and calling managers, takes approximately one hour per day.

"Each time I look at both of these reports each day, I would say it's like 15 minutes total each time. So I'd say I spend about an hour on this, but I think it's worth an hour of time per day."

The alternative? There isn't one.

"You absolutely cannot do it without the reporting that you have in WickedFile. It's not possible. Tech Metric doesn't give you the ability to do what we're doing right now. All that you can do is muscle management."

This operator didn't have a broken business. He had a profitable, growing 11-location operation with district managers, structured processes, and corporate discount programs. What he didn't have was visibility into the gap between policy and execution, the space where service advisors over-discount, managers grab the wrong matrix, and parts get added to tickets at zero cost.

Two WickedFile reports closed that gap. In roughly one hour a day, he now catches margin leaks that were costing the company an estimated $1 million per year, losses that were structurally invisible in his shop management system.

The discount rate is falling. The margin compliance is improving. And every dollar recovered goes straight to the bottom line.

"A million dollar loss to the bottom line," he says. "That's crazy."