How to Track Declined Repair Work and Follow Up on It

Every repair shop runs a second business it never actually operates.

The customer came in for an oil change. You put it on the lift, found rear brakes at 3mm and a weeping rear shock, quoted both, and they said not today. You wrote the estimate, printed a copy, and it went in the bin with the courtesy inspection sheet.

In the worked sample shop used across this cluster, that pile totalled $16,960 over the period. Of it, $4,310 was eventually recovered by calling people back — a 25.4% recovery rate. And $9,940 is still open, of which $3,740 is flagged as a safety item.

That $9,940 has no acquisition cost. No advertising bought it, no discount is needed to get it, and the diagnostic work that identified it has already been done and, in most cases, already paid for. It is the cheapest revenue in the building, and the reason almost nobody collects it is not laziness — it is that a declined job is a small disappointment, and small disappointments do not get written down.

Five Fields, Nothing More

The reason declined-work systems fail is usually that somebody designed a thorough one. Thorough does not survive a Friday afternoon. Five fields do.

  1. Vehicle and customer — with the VIN or plate, so the record attaches to a car rather than a name that may have three cars.
  2. What you found, with the measurement. Not “rear brakes.” “Rear pads 3mm, rotors within spec.” The measurement is what makes the follow-up call a service rather than a pitch.
  3. What you quoted — the dollar figure you actually gave. If you call back with a different number you have a negotiation instead of a booking.
  4. Urgency — safety, deteriorating, or maintenance. Three options. This one field sets everything downstream.
  5. Date quoted — from which the follow-up date calculates itself.

That is thirty seconds at the point where you are already writing the estimate. The follow-up date should never be typed by hand, because a date you have to think about is a date you skip when the phone rings.

Follow-Up Intervals by Urgency

A single blanket interval is the second reason these systems fail. Thirty days is far too long for brakes at 3mm and far too soon for a transmission service the customer deferred on cost.

Urgency Call at Why
Safety — brakes, tires, steering, suspension 5–7 days The condition is deteriorating on a timescale that matters, and the call is a duty of care as much as a sale
Deteriorating — leaks, mounts, belts, bearings 30 days Long enough not to nag, short enough to catch it before it becomes a tow
Maintenance — fluids, filters, scheduled services 60–90 days Usually declined on cost, so time it to a new budget cycle rather than a reminder about the same one

Against the worked shop’s $3,740 of open safety items, the seven-day rule is the single highest-value line in the table — both because those are the jobs most likely to come back as an emergency somewhere else, and because they are the ones you would least like to have found, documented and then never mentioned again.

What the Call Actually Sounds Like

The difference between a follow-up that books and one that annoys is entirely in the specificity, and specificity comes from field two.

Without the record: “Hi, just following up on that work we quoted a while back — did you want to get that booked in?”

That is a sales call. It asks the customer to remember something, reconstruct a number, and make a decision on the spot with no new information. Most people say they will think about it, which is a polite no.

With the record: “Hi Maria — it’s Dave at the shop. When your Civic was in on March 14th we measured the rear pads at 3mm. You’ve probably done four or five thousand miles since then, so they’ll be getting close. The quote was $340 and that still stands. I’ve got Thursday morning free if that works.”

Same request. Completely different call. It carries a date, a measurement, a consequence and a price that has not moved, and it ends with a specific slot rather than an open question. None of that is salesmanship — all of it is just reading back what you wrote down at the time.

Attach It to the Vehicle, Not the Estimate

The structural improvement that makes this compound is attaching declined work to the VIN rather than to a piece of paper.

Do that and the next time that car is booked in for anything at all, the open declined work appears with it. The service advisor knows before the customer arrives that there is $340 of rear brakes outstanding from March. It gets mentioned while the car is already on the lift, which is the single highest-conversion moment that exists in a repair shop — no second trip, no second decision about scheduling, no second inconvenience.

That is also why the recovery rate rises over time rather than in a burst. Some declined work converts on the phone call. A good deal more of it converts on the next visit, automatically, simply because somebody knew to raise it.

Two Numbers to Watch

Once a quarter, two figures tell you whether the system is working.

Recovery rate — recovered dollars divided by total declined dollars. The sample shop is at 25.4%. It is a number that only means anything against your own previous quarter, since it moves with your work mix, but a shop with no follow-up system at all is typically recovering a fraction of that, and the improvement shows up fast.

Open safety value — the dollars of declined safety work still outstanding. This one should trend down, and if it is climbing you have a follow-up process that exists on paper and not on the phone.

Setting It Up This Week

  1. Add the five fields to wherever you already record jobs. Do not build a separate system; a separate system is one more thing to remember on a busy Friday.
  2. Log every decline starting with the next one. Do not go back through old paperwork — the history is gone and the attempt will kill the habit before it forms.
  3. Pick one morning a week and work the list of calls that have come due. Twenty minutes. Tuesday mornings, when the bays are usually quietest and you need the work.
  4. Check open declined work before every booked-in vehicle. This is where most of the money actually converts.

After a month you will have a list worth more than most small shops spend on advertising in a year, and it will already have been paid for.

Declined work is one of four places a repair shop leaks money it has already earned — the others are parts priced flat, an effective labor rate nobody calculates, and comebacks logged as new business. The full picture, and how the two margins fit together.

Featured on ReadySheetGo

Auto Repair Shop & Mobile Mechanic Job Tracker — $16.99

Eleven linked tabs and 11,763 working formulas, with 53 closed repair orders and a full declined-work list pre-filled.

The Declined Work tab holds 120 rows — vehicle, what you found, what you quoted, urgency and the date offered — and calculates the follow-up date for you from that date and that urgency, so nobody has to decide when to call. Safety items are flagged separately, recovered work is counted against what was quoted to give you a recovery rate, and the Dashboard shows what is still unsold, what has already been won back, and how many calls are due today. The Vehicles tab holds 100 VINs with visits, lifetime spend, last mileage and next service due — and carries the declined work still open on that exact car, so the reminder call and the next booking both have something specific to say.

Also inside: Repair Orders across 200 rows with parts and labor margin returned separately on every job; Shop Stats with your effective labor rate and the gap against your posted rate in dollars; Technicians setting hours billed against hours actually worked; Parts Inventory priced by your own matrix; Monthly & Trends across twelve rolling months, by service type and shop against mobile; and Settings holding your rates, targets, supplies percentage and cost per mile.

Works in Excel and Google Sheets. No macros, no add-ons.

Get the Auto Repair Shop & Mobile Mechanic Job Tracker →

Frequently Asked Questions

What is declined work in an auto repair shop?

Any repair you inspected, quoted and the customer chose not to authorize at that visit. It is distinct from a lost estimate — the customer is already yours, the vehicle has already been on the lift, and the diagnosis is already done and paid for. That makes it the cheapest revenue available to a shop, because every cost of generating it has already been incurred.

How much declined work does a typical shop recover?

It depends almost entirely on whether anyone calls. In the worked shop on this page, $4,310 of $16,960 quoted and declined was later recovered — a 25.4% recovery rate — with $9,940 still open. Shops with no follow-up system recover whatever walks back through the door on its own, which is a much smaller number and arrives on the customer's timetable rather than when your bays are quiet.

How long should I wait before following up on declined work?

Set the interval by urgency, not by a single rule. A safety item — worn brakes, a failing tire, a steering component — warrants a call inside a week. Work that is deteriorating but not dangerous fits a 30-day call. Maintenance the customer deferred on cost grounds fits 60 to 90 days, or the next payday cycle. One blanket 30-day rule calls the safety items too late and the maintenance items too early.

Is it pushy to call a customer about work they already declined?

Not if the call carries specific information rather than a sales pitch. 'Your rear brakes measured 3mm in March, they will be near the backing plates by now, and I can do it Thursday for the $340 I quoted you' is a service. A generic 'just checking in, did you want that work?' is a sales call and will be heard as one. The difference is entirely in whether you wrote down the measurement.

You Might Also Like

Auto Repair Shop Spreadsheet Template: Tracking Parts and Labor Profit Separately How to Calculate Effective Labor Rate for an Auto Repair Shop 401(k) vs Roth IRA vs HSA: Which to Fund First in 2026

Separate Parts Margin From Labor Margin — They're Fixed in Different Places

The Auto Repair Shop & Mobile Mechanic Job Tracker — 11 linked tabs and 11,763 working formulas, with a fully worked sample shop already loaded — 53 closed repair orders, five jobs still in the bay — so you can see it running before you type anything. A Settings tab holding your posted labor rate, fleet rate, target gross margin, minimum acceptable parts margin, shop supplies percentage, cost per mile and your own parts pricing matrix, which drive every other tab; a Repair Orders master of 200 rows where parts, labor, sublet, supplies, travel, discount and rework all sit on one line and the job returns its own parts margin and labor margin separately, because those two numbers are fixed by two completely different actions — a pricing decision at the counter and a rate-and-efficiency decision on the schedule — and a blended figure asks for neither; a Shop Stats tab that works out your effective labor rate, which is total labor billed minus every discount given, divided by every hour sold, then multiplies the gap against your posted rate by all your hours so the leak appears in dollars rather than cents; a Declined Work log of 120 rows holding every repair a customer said no to, what it was worth, how urgent it was and a follow-up date the file works out for you from the day you offered it, with safety items flagged and recovered work counted; a Technicians tab setting hours billed against hours actually worked to return efficiency per person and the labor gross profit each one produced after their own pay; a Parts Inventory of 120 lines priced by your matrix, valued at cost and at retail, flagged for reorder and flagged again for anything under your minimum margin; a Vehicles tab holding 100 VINs with visits, lifetime spend, last mileage, next service due from your own interval and the declined work still open on that exact car, so the reminder call has something specific to say; a Monthly & Trends tab running twelve rolling months then splitting by service type and shop against mobile; and a Dashboard returning twelve figures including revenue, gross profit, gross margin, average repair order, hours sold, effective labor rate, parts and labor margins separately, comeback rate, open declined work and the value sitting in the bay. Open jobs are reported as work in progress at estimated value and kept out of revenue, margin, car count and the effective labor rate, because counting the hours logged so far on an unfinished job is the quickest way to make a shop look more profitable than it is. A Row Check column catches a date out before the date in, hours with no rate, parts sold under cost, a discount larger than the ticket, travel miles on a shop job and a technician who is no longer on your list. Works in Excel and Google Sheets, no macros and no add-ons.

View on Etsy — $16.99