The spreadsheet is the most successful distribution tool ever built. It handles stock lists, price tables, customer histories, quotes, purchase orders — all of it, often in one shared file. The barrier to entry is zero. Every new hire already knows how to use it. And for a team of one, it works perfectly.
The problem is that distribution companies are never a team of one. They start with a founder who does everything, then hire a second salesperson, then a warehouse person, then a buyer. The spreadsheet that worked beautifully for one person becomes the bottleneck for five, then ten, then twenty.
Where it breaks It breaks at concurrency. Two commercial people editing the same quote tab. A warehouse lead changing stock after a sale closed. A manager adjusting prices mid-quote. Each of those becomes a conflict — reconciled at 8pm by whoever lost.
The technical term is 'last-write-wins,' and it's brutal. One person saves, another saves five minutes later, and the first person's changes silently vanish. The sheet doesn't warn you. It doesn't merge. It just overwrites. If you're lucky, you notice the discrepancy before the customer does. If you're not, you ship the wrong quantity at the wrong price and discover it when the invoice bounces.
Shared workbooks with 'track changes' enabled fare slightly better — they record who changed what — but they don't prevent conflicts. They just document the chaos. And the performance degrades linearly with every tracked change, so most teams turn tracking off by week two.
Where it breaks next It breaks at audit. Someone changes a price on row 47 and a month later nobody can say who, when, or why. The history tab never gets updated; the 'backup' file is from Tuesday.
This isn't just an inconvenience — it's a financial liability. When a customer disputes an invoice, you need to produce the quote they approved. If the spreadsheet has been edited since, you can't. If the price was pulled from a lookup that changed, the printed PDF and the current sheet disagree, and the customer has every right to pay the lower number.
Regulatory pressure compounds this. More distributors are subject to audit requirements from their own customers — large contractors, government agencies, publicly traded companies — who demand traceability on every transaction. 'Trust me, it's in the spreadsheet' doesn't satisfy a third party auditor.
The quiet answer A real tool doesn't mean a more complicated one. Quotery writes every movement to an append-only ledger. Quotes have a status. Stock has reservations. Prices are snapshotted on the quote, not re-read from a mutable table. None of that is exotic — it's just table stakes for any system that has more than one user.
The shift from spreadsheet to platform isn't about adding features. It's about replacing a model where anyone can change anything at any time with one where every change has an author, a timestamp, and a reason. That's not bureaucracy — it's the minimum viable governance for a team that can't all stand around the same monitor.