Most contractors don't realize they need a CRM until they've already lost the customer. Someone called six months ago for a quote, the conversation went well, the job got delayed, and then the lead disappeared into a notepad page that's now sitting in the bottom of a glove box. By the time you find that note, the customer hired someone else.

This article walks through when a CRM actually starts to matter for a contractor, what the four stages of customer management look like, and how to figure out which stage you're in.

The four stages of contractor customer management

Almost every contractor goes through these stages, in order, as they grow. The mistake most make is jumping ahead too fast (paying for software they don't need) or staying too long in the early stages (losing money to disorganization).

Stage 1: Notepad. Customer info on scraps of paper, phone messages, and the occasional sticky note. Works for the first 5-10 customers. Breaks the moment you have a backlog.

Stage 2: Phone contacts and texts. Customer names go in your phone, conversations live in iMessage. Better than the notepad. Still no follow-up system, no record of past work, no way to remember who needs a call back.

Stage 3: Excel CRM. A real spreadsheet with leads, customers, jobs, and follow-up dates. You can sort by status, filter by month, see who needs a call. This is where most established contractors live.

Stage 4: SaaS CRM. ServiceTitan, Jobber, Housecall Pro, or similar. $59 to $400+ per month, per user. Real automation, dispatch tools, integrated payments, customer portals.

The honest signal that you've outgrown the notepad

You're past Stage 1 the moment any of these are true:

  • You forgot to call a lead back, and they hired someone else
  • You can't remember if a specific customer's job was done last month or last year
  • Two of your trucks have shown up at the same address because nobody knew the other already had the appointment
  • You've quoted the same customer twice without realizing it was the same person
  • You're spending more than 15 minutes a day looking for customer information you know you have somewhere

If any of those happen, you need at least Stage 3. Skipping straight to a $300/month SaaS is overkill for the problem.

The honest signal that you've outgrown Excel

Most contractors stay in Stage 3 indefinitely, and that's fine. But you're past it when:

  • You have 4+ employees and they all need to access and update the same customer data simultaneously
  • You're scheduling 30+ jobs per week and need real dispatch and routing
  • You want customer-facing portals (online booking, payment portals, automated quote acceptance)
  • You need integrated SMS marketing campaigns to past customers
  • Your accountant is asking for QuickBooks-integrated job costing that updates in real time

Notice that none of these apply to a solo operator or a 2-3 person shop. They're problems of scale. If you don't have those problems, paying $300/month to solve them is just lighting money on fire.

The Stage 3 sweet spot

The Excel CRM stage covers most contractors, most of the time. Here's what a working system looks like:

Tabs by function. One tab for leads (people who've inquired but haven't booked), one for active customers (currently scheduled or in progress), one for past customers (done jobs, candidates for follow-up), one for follow-up dates (what's overdue).

Status fields, not just names. Each customer has a status (new lead, quoted, scheduled, in progress, completed, follow-up needed). You can filter the list to see "everyone with a quote out for more than 7 days" in one click.

Notes that survive. Every conversation gets a one-line note with the date. "5/12: wants kitchen rewire, husband is the decision-maker, budget around $4K." Six months later when they call back, you remember the conversation.

Past work history. When the customer calls saying "remember when you did that thing for me," you actually do, because the spreadsheet says you replaced their water heater on 8/3/2024 and it was a 50-gallon gas unit.

That's it. No login. No monthly fee. No learning curve. It works on your phone in the truck and your laptop on the desk.

The mistake that kills the Excel CRM stage

Most contractors who try Stage 3 fail because they try to build the spreadsheet from scratch. They open Excel, make a column for customer name, a column for phone, and stop there. Two weeks in they realize they need 14 more columns, and they don't want to redo all the data they've already entered.

The fix is to start with a working template. The columns are already right. The status fields already work. The follow-up logic is already built. You just type in your customers and let the system do its job.

This is exactly why we built the Contractor Customer Manager. It's the Excel CRM most contractors should be using, with the columns and formulas already set up. $49.99 one-time. No subscription. The same system that works for a solo operator will scale to a 5-person shop without changing.

What about hybrid options?

Some free tools sit in the middle ground between a notepad and a real CRM:

Google Contacts. Free, syncs across your devices, lets you tag contacts. Better than nothing. No follow-up logic, no history, no status tracking.

Trello or Asana boards. Free tiers available. You can build columns for "Leads / Quoted / Scheduled / Done" and drag cards through them. Visual and easy. Falls apart when you have 50+ active customers.

Square Customer Directory. If you use Square for payments, you already have a basic customer database. It auto-populates. Good for tracking past work but lacks the follow-up and lead management functions.

Each of these is a partial solution. They're better than nothing if you're cash-strapped, but they all have gaps. The Excel CRM stage solves the gaps without adding monthly cost.

The math on SaaS

Just to make the cost comparison concrete:

  • ServiceTitan: $400-$600/month per user, often with annual contracts. Real cost over 5 years for a 2-person shop: $48,000 to $72,000.
  • Jobber: $59-$229/month depending on tier. 5-year cost for a single user on the basic plan: ~$3,500.
  • Housecall Pro: $59-$249/month. 5-year cost: similar range to Jobber.
  • Excel CRM: $49.99 once. 5-year cost: $49.99.

The SaaS tools earn that price for the right shop. Dispatch automation alone can pay back $300/month for a 4-truck operation. But for solo and small-shop contractors, the math doesn't work because you're paying for capacity you don't use.

The buying logic, simplified

Use this decision tree:

  • 1-2 people, under 100 customers/year: Excel CRM. Save the SaaS money for years when you actually need it.
  • 2-4 people, 100-300 customers/year: Excel CRM still works for most. Consider SaaS if you're losing more than $5K/year to scheduling errors or missed follow-ups.
  • 4+ people, 300+ customers/year: SaaS is probably worth it. Run the numbers on what scheduling and dispatch automation saves you per week.

Don't let a salesperson tell you you need ServiceTitan when you have 6 active customers. Don't try to run a 12-person shop on a spreadsheet. Match the tool to the actual scale of the business.

The bottom line

Most contractors who think they need a CRM actually need a working Excel system. The customers, the follow-ups, the status fields, and the history; all of it fits in a well-designed spreadsheet that costs $50 once and works forever. SaaS CRMs are real tools for real shops, but most contractors aren't running shops at the scale where the monthly cost pays back.

The decision isn't "CRM vs no CRM." It's "which stage am I in." Get honest about that, pick the right stage, and don't over-buy.

Frequently Asked Questions

Can I use Google Sheets instead of Excel?
Yes. Google Sheets works fine for a CRM and has the advantage of cloud sync and multi-user access for free. The drawback is that it's slower for large datasets and lacks some of Excel's more advanced filter and formula features. For most contractors, either works.

What about CRM features like email automation and SMS reminders?
A spreadsheet won't send automated messages. For solo contractors, that's not a problem since you're personally calling or texting customers anyway. For shops at 4+ employees, automation starts to matter, which is when SaaS makes more sense.

Should I have my employees update the CRM?
Yes, but make it simple. The mistake most shops make is requiring 15 fields per customer entry. The fields nobody fills in correctly become useless. Five fields filled in 100% of the time beats fifteen fields filled in 30% of the time.

How often should I review the CRM?
At minimum, weekly. The follow-up tab should be reviewed every Monday morning, and any customer with an overdue status should get a call or text that week. The leads tab should be reviewed daily during active selling seasons.

What's the most common mistake contractors make with their CRM?
Not using it. The system only works if customer data goes in, every time. The contractor who manually updates the spreadsheet every Friday afternoon for 30 minutes will outsell the contractor with a $400/month SaaS that nobody opens.