CRM vs Spreadsheet: The Four Points It Breaks

Four tabs, about 1,300 rows, and a column called Notes that's holding the whole business together. That's what most drainage and landscape outfits are running when they first start asking whether they need software.

The confusing part is that the sheet usually still works. It opens, it sorts, it has every job you've ever quoted in it. Nothing on the screen tells you it's failing.

It fails at the seams instead — at the handoff between two people, at the lead you didn't call back, at the customer who owns three properties, at the argument six months after the job. If you want the diagnosis of what that feels like day to day, the five failure points of running on spreadsheets covers it. This post is the decision: four thresholds, and how to check which ones you've already crossed.

The four thresholds, and which one you're on

You don't outgrow a spreadsheet gradually. You cross one of four specific lines, and after that the sheet costs you money quietly every week.

One threshold crossed is usually survivable. Two is where the sheet starts eating jobs. Take them one at a time.

Headcount: the break is the second person, not the fifth

Most contractors assume the spreadsheet holds until they've got a real office. It doesn't. It breaks the first day two people both have a reason to write to it.

The failure isn't dramatic. Your wife updates a lead's status to "quoted" from the kitchen on Tuesday. You've got the file open on your phone from Monday night, you type a note into the same row Wednesday morning, and her edit is gone. Or it isn't gone, but neither of you knows which version is current, so you both call the homeowner. Or neither of you does.

Put a number on it from your own records. Count the leads that came in last month. Estimate how many fell into the gap between you and the other person — leads where each of you assumed the other had it. Then run your own close rate and average job:

3 dropped leads × 25% close rate × $6,400 average job = $4,800 per month

Substitute your own three numbers. Most contractors who do this honestly land somewhere between one and five dropped leads a month at the two-person stage, and the answer is almost always bigger than the price of software.

This threshold arrives sooner than people expect, because it isn't about employees. A part-time bookkeeper, a foreman who answers the phone on your day off, a spouse doing follow-up calls — each of those is the second person.

Lead volume: count open leads with a due date, not leads per year

"How many leads do you get?" is the wrong question. The number that matters is how many leads are open right now with something you're supposed to do next.

Take a six-touch follow-up cadence over two weeks, which is roughly what a working follow-up sequence looks like. At ten new leads a week, you've got about twenty leads live at any moment, each with a next action on a specific day. Add the proposals you sent that are still out. That's thirty-odd items you're carrying.

A spreadsheet can hold thirty items. What it can't do is tell you which five are due today without you reading every row and doing date math in your head, every morning, forever. So you stop doing it on the busy weeks, which are exactly the weeks it matters.

Here's the check. Open your sheet, filter to leads that came in during the last 30 days, and count the rows that have no dated next step — no callback date, no "sent proposal 8/14, follow up 8/17," nothing. Just a name and a phone number going stale.

Say you find 41 leads and 12 of them are orphaned. Those 12 won't close at your normal rate, because they've been sitting. Cut your close rate in half to be fair to yourself:

12 orphaned × 12.5% × $6,400 = $9,600 in one month

Run it on your own sheet with your own average job. If the orphan count comes back at zero, your volume hasn't crossed the line yet and you should keep the spreadsheet. If it comes back at ten or more, the sheet stopped being a system a while ago and became a graveyard.

Customer structure: when one customer stops fitting in one row

A spreadsheet has exactly one shape: one row, one thing. That works fine when a job is a homeowner, an address and a price, all the same entity.

It stops working the first time any of these show up in your book:

• A property manager with nine buildings, where the person who signs is not the person who meets you on site and neither one lives there.
• A homeowner who bought a French drain in 2023, a patio in 2025, and is calling about the side yard now — three rows, three sets of notes, no history that reads as one relationship.
• A builder who sends you four jobs a year at four different addresses under one company name and one PO process.
• An HOA where the board contact changes every eighteen months and the property stays the same.

You can fake this in a sheet. People do — a column for company, a column for site address, copy-paste the phone number across the rows. Then the phone number changes and you update it in one place out of six. Six months later you call the old number and leave a message for a person who sold the house.

This is the threshold that has nothing to do with size. A two-truck operation doing commercial property maintenance crosses it before a six-crew residential install company does. If your work is mostly one-off residential installs and every customer really is one address and one job, this threshold may never arrive for you, and that's a legitimate reason to stay on the sheet.

The tell is simple: if you've ever had to look in two places to answer "what have we done for these people before," the structure is wrong for what you're selling.

Proof: what you can put on the table six months later

February. The homeowner calls and says the downspout tie-in was supposed to be in the price. You remember it wasn't. Your spreadsheet says Quoted 8/22 — $13,130 — signed.

That row proves nothing. The actual agreement is a PDF in your sent folder, maybe, if you sent it from the account you still use. You don't know whether they opened it. You don't have a signature with a date and an IP address on it. You have a memory and a number.

Most of the time you eat it, because arguing costs more than the tie-in. Call it $400 and a bad review avoided. Two or three of those a year and the proof threshold has a price.

What closes this gap isn't a better spreadsheet. It's a record that holds the document you actually sent, the version they actually saw, the timestamp on the signature, and a timeline of every send and view against that customer. That's the part of ScapesHQ that exists to answer this specific problem — proposals with send history, e-signature with the evidence attached to the record, and an activity timeline that doesn't get overwritten.

You don't need software to cross this threshold well. A disciplined folder structure and a signed PDF per job will do it. You need something, and a status column isn't it.

What moving off the spreadsheet will not fix

This is where most software comparisons get slippery, so plainly: a CRM handles the front of the job. It does not handle the back.

ScapesHQ does not do invoicing, payments, time tracking, job actuals, job costing against budget, pricing rules, dispatch or route scheduling. Those are not built, and calling the product a CRM doesn't quietly include them.

So if the thing hurting you is that you don't know which jobs made money, a CRM is the wrong purchase. That's a job costing problem, and you can solve it this month with four numbers per job tracked by hand — the worked example here shows the whole method. Keep your spreadsheet for that. A spreadsheet is genuinely good at columns of numbers you add up. It's bad at people, dates and evidence.

Same goes for scheduling and invoicing. If your crew is showing up at the wrong address or your invoices go out three weeks late, fix those with the tools built for them. Crossing the four thresholds above is a separate decision.

How to move without losing the sheet

If two or more thresholds are clearly crossed, the switch is smaller than it looks. The trap is trying to migrate 1,300 rows of history.

1. Draw a line at today. Everything new goes into the new system. Nothing historical moves.
2. Move only the live ones by hand — open leads, outstanding proposals, jobs scheduled but not done. For most contractors that's 20 to 50 records and one evening.
3. Keep the old spreadsheet read-only, in a folder, forever. It's your archive. You'll open it four times a year and be glad it's there.
4. Run both for two weeks only. Longer than that and you'll keep updating the sheet out of habit and trust neither one.
5. Re-run the orphan count after 30 days. Filter the new system for leads with no next step. If that number dropped, the move paid for itself; if it didn't, the problem was never the tool.

That last step is the honest one. Software doesn't make follow-up calls. It removes the excuse that you didn't know who to call, which for most contractors is about eighty percent of the problem — but the calls still have to happen.

FAQ

How many leads a month before I need a CRM?

There's no universal number, because the load depends on your follow-up cadence, not your lead count. Count the leads currently open with an action still owed — if that's under about fifteen and you can name them all without looking, a spreadsheet is fine. Once you're filtering rows every morning to figure out who's due today, the sheet has stopped doing the job.

Can't I just add more columns to my spreadsheet?

You can, and for headcount and volume problems it buys you some time. It does not fix customer structure, because a spreadsheet only has one shape — one row, one thing — and a property manager with nine buildings doesn't fit that shape no matter how many columns you add. It also can't hold proof: a cell that says 'signed' isn't evidence of what was signed.

Does a CRM handle invoicing and job costing too?

Some do, many don't, and you should check before you buy rather than assume. ScapesHQ specifically does not do invoicing, payments, time tracking or job costing against budget — it covers lead intake through signed proposal. If your real problem is not knowing which jobs made money, track four numbers by hand on your next three jobs first and keep the spreadsheet for that.

What's the actual cost of staying on a spreadsheet one more season?

Work it out from your own numbers rather than a benchmark. Count the leads from the last 30 days with no dated next step, halve your normal close rate because those leads have gone cold, and multiply by your average job value. Multiply that monthly figure by the months left in your season and compare it to what the software costs.

Will I lose my history if I switch?

Not if you don't try to migrate it. Draw a line at today, move only the live leads and outstanding proposals by hand, and keep the old spreadsheet as a read-only archive in a folder. You'll open it a handful of times a year to look up an old job, and that's all the access you actually need.

The short version

A spreadsheet stops being the right tool at four specific points: when a second person needs to write to it, when you can no longer name every open lead with an action owed, when one customer has multiple properties or contacts, and when you need to prove what was agreed six months later. Check each one against your own sheet — count the orphaned leads from the last 30 days, multiply by half your close rate and your average job value, and you'll have the cost in dollars. One threshold crossed is survivable; two means the sheet is quietly eating jobs. And if the real pain is not knowing which jobs made money, that's job costing, not a CRM.

Book a walkthrough and we'll go through your own lead sheet and count how many rows have nobody on them.