Declined work log template

A declined work log records every job a customer said no to, filed against the vehicle and not the ticket, with the reason and a follow-up date. It is the cheapest work in the building. Below is the template, the reason codes that make follow-up land, the recovery arithmetic you run on your own numbers, and the one decline a fleet vehicle is not free to make.

Key takeaways

• The reason code is the field that decides whether follow-up works.
• Declined jobs live with the vehicle, so the next visit finds them.
• A safety-rated decline gets the measurement printed next to it.
• Check the VIN for an open recall before you quote work a dealer would do free.

What fields does a declined work log need?

What reason codes are worth having?

Six, and they map to six different follow-up calls.

The last one saves more time than the others earn money. A shop that never records "selling the truck" keeps calling about a differential on a vehicle that left the county in April.

What does a filled-in log look like?

Four illustrative rows, written the way the fields above ask for them. Nothing here came off a real ticket and no vehicle, price or customer on it belongs to anybody. The shape is the point.

Four rows, $2,320.60 of work, and three of the four are still live. Notice what the fourth row does. Somebody wrote "doing it myself" against the fuel filter and closed the line, so nobody calls that customer about a filter again.

What is the log worth?

Your own numbers answer that, and the log is the thing that produces them. Three figures come off it once a quarter has run.

Multiply the three and you have the gross profit the log recovered in a month. Multiply by twelve and you have the year. Every input is yours, and none of them can be borrowed from a page like this one, because a shop selling fleet brake work and a shop selling diesel diagnostics recover declined work at rates that have nothing to do with each other.

The recovery rate is the figure worth watching. It is the only one the follow-up call moves, which is why the reason code and the follow-up date are fields rather than habits. Run the calculation before the log exists and you are guessing at all three. Run it after a quarter and you have a number you can defend to yourself, plus a way to tell whether last month's calling changed anything.

What can a customer not decline?

On a commercial vehicle, a listed safety defect. 49 CFR 396.11 puts the duty on the carrier and its agent, and a repair shop working on that truck is often the agent:

"Prior to requiring or permitting a driver to operate a vehicle, every motor carrier or its agent shall repair any defect or deficiency listed on the driver vehicle inspection report which would be likely to affect the safety of operation of the vehicle."

The same section requires a certification that the defect was repaired or that repair was unnecessary before the vehicle runs again. A driver declining that line is not a log entry, it is a phone call to whoever holds the DOT number.

For everything else the answer is your state's, not this page's. What travels everywhere is the documentation habit. Print the measurement next to the declined line, keep the photo, then take an initial on a safety-rated finding. The FTC tells customers why some of them decline in Auto Repair Basics:

"If you need expensive or complicated repairs, or if you have questions about recommended work, consider getting a second opinion."

Read that as a reason code. A customer taking the FTC's advice is a trust decline, and the follow-up that works is the photo and the measurement rather than a lower price.

One check belongs before any quote reaches the log. Run the VIN through the NHTSA recalls lookup. Work covered by an open recall gets done free at a dealer, and a customer you send there comes back for the work nobody else will do. The warranty question sits next to it: the FTC's Businessperson's Guide to Federal Warranty Law is a reminder that a warranty is a promise somebody made in writing, so a declined job that a manufacturer still covers belongs on their ticket rather than yours.

When should the follow-up call happen?

On a cadence the reason code sets, and never more than twice per declined job.

Two calls, then the job waits for the vehicle to come back on its own. A third call is what turns a service reminder into a sales chase, and the cost of it is not the declined job, it is the next three conversations with a customer who now screens your number.

The call itself has a shape worth writing down. Open with the vehicle and the measurement. Repeat the customer's own stated reason back to them, which proves somebody wrote it down. Then say what has changed since: a part price that moved, an alternate tier that fits the budget, or nothing at all except that the pads are six weeks thinner. Close by asking whether they want it scheduled, and log the outcome either way.

A shop that runs this cadence off a filtered spreadsheet is working from a list instead of from memory, which is the whole trick. The arithmetic above tells you what that list is worth on your own numbers, and the calls it produces are the cheapest work anybody in the building does.

One rule sits above the cadence. Nothing on the log gets a call if the vehicle is already booked in, because the conversation belongs at the counter with the truck on the lift and the measurement in front of the customer. Filter the follow-up list against the appointment book before anybody picks up a phone, and the calls that remain are the ones that need making.

Where do declined work logs fail?

The deletion habit is the expensive one and it comes from a good instinct. A closed ticket with four declined lines on it looks like a failure, so somebody tidies it. What they are tidying away is next quarter's schedule.

How do you build the log in a spreadsheet?

One row per declined job, keyed on the VIN so the next visit can find it. Filter on follow-up date each Monday.

date_declined,ro_number,vin,year,make,model,engine,odometer,job_name,finding_measurement,severity,price_quoted,price_valid_until,reason_code,reason_verbatim,acknowledged_by_customer,follow_up_date,follow_up_owner,outcome,outcome_date

reason_code,follow_up_action,default_interval_days
price,offer alternate part tier or split the job,30
timing,call on the date the customer named,0
trust,send photo and measurement,7
scope,raise at next visit,0
diy,offer parts at counter price,90
vehicle_leaving,close the row,0

Why does most declined work never get re-quoted?

Because re-quoting is the whole job again. A line declined in March carries a March parts price, so re-selling it in July means finding the labor hours, chasing supplier prices, then keying it in, all for a second time on work somebody already turned down once. Faced with that, an advisor reads the line, decides it is stale, then goes back to the car in front of them.

Mechanica removes the second pass. The estimate is drafted from the completed inspection with the source of every number attached, so a job that has sat on a vehicle since March gets re-priced against today's supplier quotes without an advisor doing the lookups again. Nothing reaches the customer until a person reads it and sends it.

The vehicle inspection checklist is where the measurements in this log come from, the estimate template is what the re-quote looks like, and the repair order template is where a declined line lives on a closed ticket. For the vocabulary, see declined work and upsell. Every form is listed on the shop forms roundup and the guides hub.

Sources

• 49 CFR 396.11, Driver vehicle inspection report(s)
• Auto Repair Basics, Federal Trade Commission
• Businessperson's Guide to Federal Warranty Law, Federal Trade Commission
• NHTSA recalls lookup
• Last verified: July 2026