Excel is enough for a food distributor while each order is entered once, stock on file matches the warehouse, no single person holds the system together, and month-end takes hours rather than days. When several of those stop being true, it is time for an ERP or a connected middle step, decided on your own data.
What Excel does well
Excel is not the problem it is often made out to be. For a young distributor it has real strengths:
- Everyone already knows it, so there is no training cost.
- It bends to any process, including the odd ones every food business has.
- It costs almost nothing, and changes take minutes, not a project.
- The data in it is often good, because the people who type it care about it.
Many distributors run well on spreadsheets plus an accounting package for years. The question is not whether Excel is "professional enough". It is whether it has started to cost more than it saves.
Five signs Excel has stopped working
1. The same order is typed more than once
An order arrives in LINE, is typed into the order sheet, then again into the invoicing software, and perhaps again into a delivery list. Each copy is a chance for a mistake and a few minutes lost. If you can count three copies of one order, the spreadsheet has become a relay, not a record.
2. Stock on the sheet doesn't match the shelf
When the stock file and the warehouse disagree, people stop trusting the file and start walking to the shelf, or keep a private version. For food, with batches and expiry dates, this shows up as short-dated stock found too late.
3. One person holds the system in their head
If the master file only works because one colleague knows which tabs to update and in which order, the business depends on that person's health and holidays. Ask what happens the week they are away.
4. There is no reliable history
You cannot easily answer "what did this restaurant buy from us in March, and at what price?" Files are overwritten, copies multiply, and the price agreed on a call last month lives in someone's chat.
5. Month-end takes days
If producing the monthly sales and margin figures takes someone two days of copying and checking, the spreadsheet is consuming the time it was meant to save.
One or two of these signs is normal. Four or five means the business has outgrown the tool.
What an ERP gives you, and what it costs
An ERP (SAP Business One, Odoo and many local packages used in Thailand) puts orders, stock, invoices and accounts in one database, with one version of each record and a history of who changed what. Stock moves when an order is delivered, invoices come from orders, and month-end figures come from the same data.
It also costs, and not only licences:
- Implementation: setting it up to match how you work, usually with a partner.
- Data migration: cleaning customer and product lists before they go in.
- Training and habit change: the biggest cost, and the one most often underestimated.
- Rigidity: the ERP's way of doing things replaces your workarounds, for better and for worse.
The middle path most distributors miss
The choice is rarely "Excel forever" or "full ERP now". Often the right step is in between:
- Keep the accounting software you have, and move orders into one shared system so they are entered once.
- Or adopt an ERP for accounts and stock, and connect a small app for the job the ERP does badly, such as reps' customer files or LINE order intake.
- Or simply clean up: one master product list, one customer list, and a rule about who updates the stock file and when.
The middle path is cheaper to try and easier to undo. It also tells you, on your own data, whether a full ERP is worth it.
A decision checklist
| Question | If yes |
|---|---|
| Is the same order typed into more than one place? | Fix order entry first, whatever else you decide. |
| Does stock on file regularly disagree with the warehouse? | You need one stock record that orders update; that points toward an ERP or a connected stock tool. |
| Would the business struggle if one person left? | Document the process now; then move it into a shared system. |
| Do you need batch or expiry tracking? | Spreadsheets handle this badly; it is a strong reason to move. |
| Does month-end take more than a day? | Reports should come from the system, not be rebuilt by hand. |
| Are you planning to grow customers or staff a lot this year? | Move before the growth, not during it. |
Mostly "no"? Excel is probably still enough; tidy it and revisit in six months. Mostly "yes"? Start with a short diagnosis of one order route before buying anything, so the decision is based on where your time actually goes.
Where this fits: this decision is what our digital consulting diagnosis answers. Also see software for food and beverage distributors.