A comeback — a car back for the same problem — eats labor, parts, and trust. Tracking comebacks as a share of total repair orders turns shop quality into a number you can watch.
Format as a percentage; lower is better. Many shops target under 2–3%.
The example
A shop closed 200 repair orders last month and 8 cars came back.
| A | B | |
|---|---|---|
| 1 | Label | Value |
| 2 | Total repair orders | 200 |
| 3 | Comebacks | 8 |
| 4 | Comeback rate | 4% |
The formula
Comebacks over the total work you did:
How it works
How to read it:
- Count every closed repair order for the period (B2).
- Count how many vehicles returned for the same complaint (B3).
B3/B2gives the comeback rate as a decimal; format it as a percentage.- 8 ÷ 200 = 0.04 = a 4% comeback rate.
Trend this monthly. A rising rate points to training, parts quality, or inspection gaps.
Try it: interactive demo
Enter total ROs and comebacks — the rate updates live.
Variations
Comeback-free percentage
Flip it to a positive 'first-time-fix' metric for the team board.
Cost of comebacks
Multiply comebacks by the average rework cost to dollarise the problem.
Pitfalls & errors
Define 'comeback' consistently — same complaint within a set window (often 30 days). Counting unrelated visits inflates the rate.
Pair the rate with a first-time-fix goal on the shop board; a positive metric motivates technicians more than a failure rate.
Practice workbook
Frequently asked questions
What's a good comeback rate?
Should warranty jobs count?
How do I see the dollar impact?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class