The Four Leak Ledger: a repair shop revenue recovery sheet you can start this week

The four leak ledger is one sheet with a row for every open item, sorted by where the work leaked, in the same order as the video:

1. Declined work. The repair your advisor recommended and the customer said not today.
2. Estimates with no answer. Sent, never approved, never declined.
3. Lapsed customers. Regulars you haven't seen in longer than their usual gap.
4. Calls nobody answered. A lead that never became an estimate, so it has no repair order at all.

Then every Friday you count what you contacted, what booked and what is still open, in dollars from real repair orders only. Below are the columns, how to fill each leak, the Friday count and the rules that keep follow-up honest.

Who this is for

Owners and service managers who suspect money is sitting in old tickets but can't say how much. You need read access to your shop management system and an hour a week. The sheet works in any spreadsheet. Many shop systems can already send part of the follow-up. Tekmetric, for example, lists service reminders for declined jobs and upcoming maintenance among its post-visit follow-ups. The ledger comes first because you can't judge any tool until you know how big each list is.

The columns

Copy these into a spreadsheet, one row per open item.

Column	What goes in it
Customer	Name, or the phone number for a missed call
Vehicle	Year, make, model
Source	Declined, No answer, Lapsed, Missed call
Opened	The date the item started
Estimate	The amount from the repair order, or blank
Advisor	Who owns the follow-up
Last contact	Date and channel
Outcome	Booked, declined again, no reply, wrong contact, still open

Leave the estimate blank when there is no repair order. Never fill it with a guess.

Leak one, declined work

Where to find it. In your shop system, filter for recommended or declined line items over the last six to twelve months. Most systems keep them on the repair order.

What to log. One row per declined job, not per customer. A customer who declined brakes and a timing belt gets two rows.

How to follow up. Safety items get a call from the advisor who saw the car. Other items can get a short message that names the car and the finding. AAA advises customers to insist on a written estimate, with the shop contacting them in advance if the repair will cost more than a set amount. A follow-up reopens the conversation. It never replaces that approval, and if the estimate is old, an advisor re-quotes before anything is booked.

Leak two, estimates with no answer

Where to find it. Estimates sent and still open, older than three days.

What to log. The amount, the date sent and the advisor.

How to follow up. The customer is often waiting on something ordinary: a price check, a spouse or a payday. A short check from the advisor asking if they have questions works better than a reminder that the quote exists. Stop after a couple of tries.

Leak three, lapsed customers

Where to find it. Customers with no visit in longer than your regulars' usual gap. If your regulars come every five to seven months, twelve months is a fair line. Take out anyone with an open complaint first, because they need a call from a manager.

What to log. Last visit date and last job. The estimate column usually stays blank.

How to follow up. A message from a named person about their own car and last visit, never a coupon blast.

Leak four, calls nobody answered

Where to find it. Your phone system's missed-call log, plus web forms and texts that never got a reply. This is the leak most shops never count, because it never reaches the shop system.

What to log. The number, the date and time, and what you know about why they called.

How to follow up. Call back the same day when you can. If you can't, a text in the shop's name asking how you can help. Log the outcome either way.

The Friday count

Every Friday, in fifteen minutes:

1. Count the rows you contacted this week.
2. Count the ones that booked.
3. Count the ones still open, by source.
4. Add up dollars only from booked repair orders, never from estimates that didn't turn into work.

After four Fridays you'll know which leak is biggest in your shop and how much of it comes back when someone asks. That is the honest number to compare any software against.

Rules that keep follow-up honest

• No pressure on safety items. Say what the technician found and let the customer decide. Scare language costs trust you can't get back.
• Approval stays written. A booked follow-up still needs the normal estimate and authorization.
• Opt-outs are honored. Marketing email needs a clear opt-out, and under the CAN-SPAM Act a stop request has to be honored within 10 business days. Treat text opt-outs the same day.
• Old prices get re-quoted. Parts and labor change.

What the national numbers can and can't tell you

You will see big figures for deferred work. An Auto Care Association survey reported by THE SHOP put delayed maintenance at $24.9 billion, but that is 2019 data for the whole country and says nothing about your shop. Be wary of any vendor that quotes a recovery percentage without seeing your data. If you can't count your declined jobs yet, no tool can tell you what recovering them is worth.

How to tell it worked

Look at the ledger after a month. Each source should have fewer old rows than when you started, booked rows should be traced to real repair orders, and every open row should have an owner and a last contact date. If one source keeps growing, that's the leak to fix at its cause, such as estimates that go out late or a phone that rings to voicemail at lunch.

For the longer explanation, read repair shop revenue recovery software. For the first leak in depth, see declined work follow up software, and for the fourth, missed call automation for auto repair.