Six Signs Your Organization Has Outgrown Its Spreadsheet
A spreadsheet is a perfectly good place to keep customer information right up until the moment it is not. The transition is gradual and nobody announces it, so most organizations pass it a year or two before they notice.
TL;DR
- The threshold is not company size. It is whether more than one person needs the same customer information and gets it by asking someone.
- Six specific symptoms tell you the line has been crossed. Two or three of them is a strong signal. Four is a reporting problem you have not found yet.
- The cost is already being paid, just not on an invoice. It shows up as reconciliation time, missed follow-ups, and knowledge that leaves with the person who held it.
- A spreadsheet one person maintains is fine. The problem starts at the second editor, not at some headcount.
- Buying a CRM does not fix this by itself. If the process was never agreed, the new system reproduces the disagreement somewhere more expensive.
None of what follows is an argument that spreadsheets are bad. A spreadsheet one person maintains for their own accounts is a legitimate and cheap answer, and replacing it with software nobody needed is its own failure. The question is narrower than that.
The six signs
Somebody needs to know where an account stands, so they message the person who owns it. That is a functioning process at three people and a bottleneck at eight. The cost is two people's time per lookup, and it scales with every hire.
Producing a pipeline figure means opening two or three sources and resolving the differences by hand. The output is usually correct. The problem is that it takes a person, so it happens monthly instead of whenever a decision needs it.
Not forgotten by a careless person. Missed because it lived in one person's memory or inbox and there was no system holding it. If this has happened once it will happen again, and you will not learn about most of the instances.
Answering it requires building something first. This one matters because it is the question that gets asked when a decision is already overdue, and the delay in answering is the delay in deciding.
When someone resigns, the history of their accounts either stayed in a system or walked out with them. Most organizations discover which one during a notice period, at the worst possible moment to find out.
Accounting, an inbox, a shared drive and a spreadsheet, with no agreement on which is authoritative. Every report built on top of that inherits the ambiguity, and everyone quietly develops a private opinion about which source to believe.
How to read the count
One of these on its own is normal and probably not worth acting on. Two or three is a strong signal. Four or more usually means there is a reporting problem that has not surfaced yet, because the reconciliation work is hiding it. That work is being done by someone, and it is not in anyone's job description.
What it is costing before you notice
The spreadsheet is free. The arrangement around it is not, and the cost is real enough to estimate even though it never appears on an invoice.
Reconciliation time. Somebody merges sources before a number can be trusted. It is usually a senior person, because it requires judgement about which version is right, and it is invisible because it looks like ordinary work.
Decisions made late. Not wrong decisions, late ones. When answering a question takes half a day, the question gets asked less often, and the interval between something changing and somebody noticing gets longer.
Follow-ups that did not happen. The ones you know about are a small share of the ones that occurred. There is no way to audit what was never recorded, which is precisely the problem.
Knowledge concentrated in people. Every account whose history exists only in one person’s head is a dependency. This is fine until it is not, and it becomes not fine without warning.
A caution before you go shopping
Recognising these symptoms tells you a spreadsheet is no longer sufficient. It does not tell you that buying software will fix it. If two people describe your sales process differently, a CRM will faithfully encode one of those versions and the other person will keep working the way they always did. Settle the process first. That step involves no software and it is the one that decides the outcome.
What to do next
-
Count how many of the six apply
Honestly, and ideally by asking two people separately rather than deciding alone. If the two answers differ, that difference is itself the seventh sign.
-
Write down the process before you look at software
Stages, owners, what has to be true before something moves forward, what happens at the exceptions. A page is enough. This is the step that determines whether anything you buy will hold.
-
Then, and only then, compare tools
With the process written down, most of the selection criteria answer themselves. Our Canadian buyer's guide covers what the main options cost, including which ones bill in Canadian dollars.
Frequently asked questions
How many people does it take before you need a CRM?
There is no headcount. A three-person team where everyone touches the same accounts needs one more than a fifteen-person firm where each person owns their clients end to end. The threshold is shared information, not size.
Can a spreadsheet work as a CRM?
For one person maintaining their own accounts, yes, and it is cheaper and faster than anything you could buy. It stops working when a second person edits it, because there is then no way to know which version is current without asking.
What is the real cost of not having a CRM?
Reconciliation time from a senior person, decisions made later than they needed to be, follow-ups that were never recorded so cannot be audited, and account knowledge that leaves when people do. None of it appears on an invoice, which is why it runs for years.
Will a CRM fix our sales process?
No. It enforces the process you already have, including the parts nobody agreed on. If the process is undefined, the system encodes whichever version was described during configuration, and everyone else works around it.
What does a CRM cost?
Entry plans from the main vendors run roughly C$18 to C$25 per user per month billed annually, and both Zoho and HubSpot have free tiers. The licence is rarely the main cost. See the buyer's guide for current figures and the implementation guide for what sits around them.
Takeaways
- The threshold is the second editor, not a headcount. One person with a spreadsheet is a solution, not a problem.
- Two or three of the six signs is a strong signal. Four or more usually means the reconciliation work is hiding a reporting problem.
- The cost of the current arrangement is already being paid, in senior time and late decisions. It is invisible because it looks like ordinary work.
- Settle the process before buying anything. Software will encode whatever disagreement it finds.