A roofer in Mesquite is sitting in his truck at 6 p.m., scrolling his pipeline sheet, when he hits a row from three weeks ago. Homeowner in Sunnyvale. Hail damage. Wanted a quote “this week.” He never called back. He meant to. The row just scrolled off the screen and out of his head, and now the job is somebody else’s. That homeowner already signed with the next guy who actually picked up the phone.
That row was a real job. A spreadsheet just doesn’t care.
A spreadsheet is a great place to store a list. It is a terrible place to run a service business, because it can’t remind you, can’t trigger a follow-up, and can’t survive the day the one person who built it walks out the door. It feels free. The cost shows up later as deals you forgot to chase. Let me show you exactly where sheets break, when one is genuinely the right call, and what to move to when you’ve outgrown it.
I’m not anti-spreadsheet. I keep a dozen of them. But I’ve opened too many service businesses running their entire pipeline on one to pretend it’s a system.
Why “just a sheet” feels right at first
It’s free, it’s open, and you already know how to use it. For your first twenty customers, it genuinely works. The problem isn’t the sheet. The problem is that the sheet does exactly what it did on day one while your business gets more complicated around it every month. The gap between what you need and what it does widens quietly. You usually notice it as a “how did I forget to call that lady back” moment, in the truck, at 6 p.m.
Where the spreadsheet actually breaks
No follow-up triggers. This is the big one. A CRM can say “it’s been 14 days since you touched this lead, call them.” A sheet sits there silent while the lead goes cold and signs with your competitor. Every follow-up depends on you remembering to scroll, and on your worst week, you won’t. The jobs you lose are the rows you didn’t look at.
Version chaos. The minute a second person touches the file, you have a problem. Your office manager is in “Pipeline_FINAL_v3,” you emailed a copy to your lead tech last Tuesday, and now two people have updated two different versions of the truth. Which one is real? Nobody knows. A real system has one record everyone sees at the same time.
Reporting you can’t trust. You want to know where your best jobs come from, your close rate, how many quotes are stuck waiting on a callback. In a sheet that’s a manual afternoon with a pivot table, and it’s already stale by the time you finish. A CRM answers that on a dashboard, live, while you’re standing in someone’s driveway.
And then there’s the one that should actually scare you. Key-person risk. The color-coding, the hidden columns, the formula buried in cell H47 that quietly runs the whole thing: all of it lives in one person’s head. The day they quit, or just take a week in Galveston, your business can’t read its own pipeline. A system only one human understands isn’t an asset. It’s a liability wearing a green checkmark. I’ve watched a $2M company go blind for nine days because the woman who built the sheet had her gallbladder out.
That whole list has a name. I call it the spreadsheet tax: the slow, invisible bleed of deals, hours, and sanity you pay every single month for the privilege of “free.”
A spreadsheet stores what already happened. A CRM tells you what to do next. That one difference is the entire reason CRMs exist.
Put a real number on the spreadsheet tax
Generalities don’t move anybody, so let’s put a real number on it.
Meet Andre. Andre runs a 9-tech electrical company in Garland. He’s an illustrative composite, not a real client, but every piece of him is stitched from real DFW service businesses I’ve sat across from.
Here’s the math on Andre’s spreadsheet tax. Stated assumptions, so you can argue with them:
- He logs about 80 leads a month in his sheet (call-ins, website forms, referrals).
- Be generous and say only 15% slip through with no real follow-up. That’s the row that scrolled away. 12 leads a month.
- His team closes about 1 in 4 of the leads they actually work. So 3 of those 12 lost leads would have become jobs.
- His average job ticket is $1,800 (panel upgrades, rewires, the bigger stuff, not service calls).
So: 3 lost jobs a month times $1,800 is $5,400 a month. Times 12 is about $65,000 a year, gone. Not to a competitor who’s better than Andre. Gone to a competitor who simply called back.
Your numbers will be different. Maybe you log 40 leads, maybe your ticket is $600, maybe your slip rate is 8% because you’re sharp. Run it with your own figures. Even if you halve every number I used, that’s still 32 grand a year falling through a sheet, and 32 grand a year is a real hire or a second truck.
Skip this if
Let me be fair to the sheet, because it isn’t always the enemy.
Stay on the spreadsheet if you’re tracking under ~40 contacts and you personally touch every one of them. Stay on it if it’s a one-time list and not a living pipeline: a material order, a job-site punch list, a crew schedule for one build. Stay on it if one person owns it, nobody else edits it live, and there’s no follow-up timing that hurts you when it slips.
If that’s you, ignore the rest of this post and don’t let anyone sell you a $300-a-month platform to manage 30 names. The myth was never that spreadsheets are bad. The myth is that they scale. They don’t.
What to graduate to
The move isn’t “buy the biggest CRM in the catalog.” It’s matching the tool to where you actually are.
Light and cheap first. A simple CRM like HubSpot’s free tier, or a structured tool like Airtable or Monday. You keep the spreadsheet feel and you finally get reminders, one shared record, and basic automation. For a lot of DFW service shops, that alone kills most of the spreadsheet tax overnight.
Then, when your follow-up has real rules (speed-to-lead on hail season, multi-step nurtures, referral tracking back to the agent who sent the job), a generic template starts fighting you. That’s when you want a system wired to your process, not somebody else’s. That’s the part we build.
The signal you’ve outgrown the sheet is dead simple. You forgot a follow-up that mattered, or two people edited two versions in one week. When that happens, it’s time to move. We handle that graduation inside the HTS Operating System tier, and you can see how one looked in a recent HTS engagement.
Ready to find out if you’ve outgrown the sheet?
If a forgotten row has already cost you a real job, or your whole pipeline lives in one person’s head, that’s your signal. Book a discovery call. We’ll look at your actual sheet, run the spreadsheet tax on your real numbers, and tell you straight whether you need to move yet. You walk away with the math either way.
