What an Excel order form really costs a wholesaler
A spreadsheet order form is free, works immediately, and is genuinely better than nothing. Here is the arithmetic on what it costs once you have more than a handful of accounts.
Almost every distributor starts with a spreadsheet, and they are right to. An order form in Excel costs nothing, needs no training, works offline, and can be emailed to a customer in ten seconds. For a business with twenty accounts it is a perfectly reasonable answer, and anyone who tells you otherwise is selling something.
The problem is not that spreadsheets are bad. It is that the cost of one grows with the square of your account count, while the benefit stays flat, and the crossover happens quietly.
Why the cost grows faster than the business
A single order form is one file. Two hundred accounts on negotiated rates is two hundred files, each a copy taken at a different moment, each with a different version of your pricing baked into it.
When a price changes, you do not update a price. You update it in as many files as have been sent out, or you accept that some customers are ordering against a stale one. Most businesses accept it, because the alternative is a day of work, and the acceptance is invisible until a customer queries an invoice.
The tell: somebody in your business can name the accounts whose spreadsheets are out of date. That knowledge only exists because the problem is real and being managed by memory.
Do the arithmetic on your own numbers
Rather than quote an industry statistic at you, here is the calculation. Fill in your own figures, because yours are the only ones that matter.
- How many orders arrive per week as a spreadsheet, an email or a phone call?
- How many minutes does it take to key one into your system, including chasing the ones that are ambiguous?
- Multiply. That is the weekly hours your team spends transcribing.
- Now: what fraction of those orders need a follow-up because something was unclear, discontinued, or priced wrong? Multiply that by the time it takes to resolve one.
- Add the two. That is what order entry costs you every week, before anybody has sold anything.
Most distributors who do this exercise are surprised, not by the transcription number, which they roughly knew, but by the follow-up number, which nobody was counting because it is spread across several people's days.
The four failure modes
In practice a spreadsheet order process fails in the same four ways everywhere:
- Stale pricing. The customer orders at a price you no longer offer, and somebody decides whether to honour it.
- Discontinued lines. The form still lists a product you stopped carrying, and the substitution conversation happens after the order.
- Free-text quantities. "2 boxes" against a line that sells by the case, resolved by a phone call.
- No audit trail. When a delivery is disputed there is an email thread rather than a record, and the thread never quite settles it.
None of these are the spreadsheet's fault. They are all consequences of the same thing: the file is a snapshot, and your business is not.
What actually changes with a portal
The honest version is that a trade portal does not remove work so much as move it. The catalogue and the pricing rules still have to be right, and getting them right is a real project. What changes is that they have to be right in one place instead of two hundred.
A price change becomes a price change. A discontinued line disappears from every account at once. A quantity is validated against the pack size when it is entered, by the person entering it, who is the one best placed to fix it. And the order exists as a record rather than as an attachment in somebody's inbox.
If you are at twenty accounts, keep the spreadsheet. If you are at two hundred and can name the ones with stale pricing, the spreadsheet is already costing you more than it saves, and you have known that for a while.