Track Quote to Close Conversion Without a CRM: Contractor Guide

Every contractor needs to know their quote-to-close rate, even without a CRM. A spreadsheet and 10 minutes a week is enough to start. The contractors in Elizabethtown KY and Radcliff KY who track this one number consistently beat the ones who guess, because the number tells you exactly where money is leaking out of the business.

This guide walks through the simplest way to track quote to close conversion for a home service contractor in Hardin County KY, what a healthy number looks like, and what to do when the number is off in either direction.

What is quote-to-close conversion and why does it matter?

Quote-to-close conversion is the percentage of written quotes a contractor sends out that turn into signed jobs. A contractor who sends 20 quotes in a month and books 6 of them has a 30 percent close rate. That single number is the most important sales metric a home service business can track, because it tells the owner whether the constraint is leads, pricing, or follow-up.

Contractors often obsess over lead count and ignore close rate. That is backwards. Doubling leads when the close rate is broken just wastes more money. Fixing the close rate first means every new lead is worth more, and the same marketing spend produces more revenue.

What's a healthy close rate for home service contractors?

A healthy close rate for a home service contractor in Hardin County KY sits between 25 percent and 40 percent. Under 15 percent signals a follow-up leak or a pricing mismatch. Over 50 percent usually means pricing is too low and the contractor is leaving margin on the table.

The exact target depends on the trade. Roofing and HVAC replacement run lower because the ticket size is larger and customers shop more quotes. Handyman work, small plumbing calls, and service tickets run higher because the customer is already in pain and wants someone to show up today. A 30 percent close rate is the rough middle for most residential trades serving Elizabethtown KY, Radcliff KY, and Fort Knox KY.

How do you track quotes without a CRM?

A Google Sheet is enough. Open a new sheet, name it "Quote Tracker 2026," and build four columns. Every time a quote goes out, the contractor or the office manager adds one row. Every time a job closes or dies, the row gets updated. That is the entire system.

There is no software to buy, no integration to set up, no login to forget. The spreadsheet lives in Google Drive, opens on a phone, and updates from the truck. A contractor doing 20 to 40 quotes a month can run the entire pipeline on this sheet for 12 to 18 months before outgrowing it.

What 4 columns does the spreadsheet need?

The four columns are: Date Quoted, Customer Name, Quote Amount, and Status. Status has three values only: Open, Won, or Lost. Anything more than that adds friction and the contractor stops updating it within two weeks.

Add a fifth column if follow-up is a known weak spot: Last Follow-Up Date. That column turns the spreadsheet into an action list. Any row marked Open with a follow-up date older than 3 days gets a call or text that morning. This is where most revenue gets recovered, and it is covered in detail on the quote follow-up service page.

Do not add columns for job type, referral source, zip code, or sales rep until the first 90 days of data is clean. More columns mean more places the sheet breaks down. Keep it boring.

How often should you update it?

Update the sheet daily during the closing process and review it weekly for 10 minutes. Daily means every quote sent gets a row before end of day. Weekly means the owner opens the sheet every Monday morning, marks any dead quotes as Lost, and counts the Won versus Total ratio for the trailing 30 days.

The weekly review is where the number becomes useful. A contractor who looks at the sheet once a quarter will not catch a close-rate drop until three months of revenue is already gone. Ten minutes a week catches the drop inside two weeks and gives the owner time to fix it.

What does the close rate tell you?

The close rate is a diagnostic tool. It tells the owner which part of the business is broken without needing a consultant to explain it. Three ranges matter: under 15 percent, 25 to 40 percent, and over 50 percent. Each range points at a different constraint.

A contractor who knows the number also knows what to work on this week. Without the number, every week feels the same: chase leads, run jobs, hope the bank account grows. With the number, the work gets directed.

What if your close rate is under 20%?

A close rate under 20 percent almost always points at a follow-up leak. Industry data shows that 80 percent of sales require 5 or more follow-up touches, and most contractors stop after 1 or 2. The quotes get sent, the customer goes quiet, and the contractor assumes they bought from someone else. They usually did not. They got busy, forgot, and bought from whoever called them back.

The fix is a written follow-up sequence: text within 1 hour of the quote, call on day 2, text on day 4, call on day 7, text on day 14. Five touches across two weeks. Contractors in Hardin County KY who implement this sequence typically see close rates lift 30 to 50 percent inside 60 days. That means a contractor at an 18 percent close rate moves to 24 to 27 percent without changing pricing, leads, or anything else.

If the close rate is under 20 percent AND pricing is already in line with local competitors, the entire gap is follow-up. See the quote follow-up automation fix for how this gets systemized so it runs without the owner remembering.

What if it's over 50%?

A close rate over 50 percent is usually a pricing signal, not a sales-skill trophy. It means the contractor is underbidding the market and customers are saying yes because the quote is obviously the cheapest one on the table. The business is leaving margin on every job.

The test is simple: raise prices 10 to 15 percent on the next 20 quotes and watch what happens. If the close rate drops to 40 percent, the contractor just made more money on fewer jobs with less work. If it drops to 20 percent, pricing went too far and needs to settle between the two points. Most Hardin County contractors find they can raise prices 10 percent without any meaningful close-rate drop, because the customer was never price-shopping in the first place.

The close-rate-over-50 problem is hidden revenue. The jobs are already getting done. The contractor just is not charging for them.

How does quote follow-up automation change the number?

Quote follow-up automation lifts close rates 30 to 50 percent because it removes the single biggest failure point in the sales process: the contractor forgetting to call back. An automated sequence sends the first text within 60 seconds of the quote going out, drops a reminder on the owner's phone to call on day 2, and sends additional touches on days 4, 7, and 14 without anyone remembering to do it.

The math is ruthless. A contractor doing 30 quotes a month at a $4,000 average ticket with a 22 percent close rate produces $26,400 in booked revenue per month. Lift that close rate to 30 percent with automated follow-up and the same 30 quotes produce $36,000 per month. Nothing else changed. No new leads, no new trucks, no new marketing spend. Just the follow-up gap closed.

That is the full missed revenue audit in one paragraph. Most contractors are running at 60 to 75 percent of the revenue their existing quote volume could produce.

When does a spreadsheet stop scaling?

A Google Sheet stops scaling at roughly 50 quotes per month or 3 people touching the pipeline. Past that point, rows get missed, status columns go stale, and two people update the same row with conflicting information. The sheet becomes untrustworthy, which means the close-rate number becomes untrustworthy, which means the whole system breaks.

The move from spreadsheet to CRM should happen when the spreadsheet is actively failing, not before. Jumping to a CRM too early creates 6 months of setup work for a business that could have kept using a sheet. Jumping too late creates 6 months of revenue leakage while the spreadsheet rots. The trigger is simple: the third time the owner catches a missing quote or wrong status inside a single week, the sheet has outgrown the business.

When that moment hits, the CRM buildout should be designed around the same 4 columns the spreadsheet used, not a generic template with 40 fields nobody fills in.

Frequently Asked Questions

Can I track quote to close conversion in Excel instead of Google Sheets?

Yes. Excel works the same way. The only reason Google Sheets wins for most Hardin County contractors is that it syncs to the phone automatically, so a quote sent from the truck gets logged before the contractor drives back to the office.

How many months of data do I need before the close rate is meaningful?

60 to 90 days of data or 50 quotes, whichever comes first. Anything shorter has too much noise from seasonal swings, referral clusters, and one-off large jobs to draw a clean conclusion.

Should I separate close rate by job type?

Not in the first 90 days. Track the overall number first and get it stable. Splitting by job type too early creates small sample sizes that swing wildly and lead to bad decisions.

What counts as a "quote" for tracking purposes?

A written number delivered to the customer, whether in person, by email, or by text. Verbal ballpark estimates do not count. If the contractor never wrote a number down, there was no quote to close.

Do I count repeat customers in the close rate?

Yes, but track them in a separate tab. Repeat customers close at 60 to 80 percent and will distort the new-customer close rate if mixed together. The new-customer rate is the one that tells you whether the sales process works.

---