Excel or TMS? At what order volume does Excel start costing more
Excel works up to a point — then it stops. At what order volume does it start costing you more than a TMS, and how to spot it in your own company.
Excel is a great tool. Cheap, familiar, opens on any laptop. Most transport companies start with a spreadsheet — and for a long time it's enough.
But at some point Excel stops being enough. And worse — it stops being enough quietly. No alert, no moment of "today it broke." One day you just realize the company is bleeding money into chaos, and nobody knows when it started.
Three signals Excel is already costing you
1. Your dispatcher spends more time in spreadsheets than on the phone
If your dispatcher copy-pastes license plates between four tabs and guesses whether the driver picked up the load — Excel is already costing you. Dispatcher time is your biggest operational cost. 1 hour/day on Excel admin × 20 working days = 20 hours/month per person. At 80 PLN/h that's 1,600 PLN/month per dispatcher leaking into copy-paste.
2. Invoices get issued "based on the last emails"
A classic: order finished, invoice missing. Because the dispatcher forgot to ping accounting, and accounting doesn't know they should. Late invoice = cashflow down 14–30 days.
In a TMS the invoice is tied to the order. Close the order → issue the invoice with one click. Or automatically at month-end.
3. The client asks "where is my truck"
Excel doesn't know. You have to call the driver, the driver may not pick up, the client waits. In a TMS the client checks for themselves in the portal or via notifications. Your dispatcher doesn't field 5 calls a day about status — they take 5 calls about new orders.
The threshold number
In practice we see it around 40 orders/month per dispatcher. Below — Excel can manage. Above — chaos grows faster than order count.
That doesn't mean below 40 isn't worth it. If you care about a professional image with the client, automatic VAT invoices with KSeF (Poland's e-invoicing system), CMRs auto-generated from driver documents — a TMS does that for 469 PLN/mo. Three hours of dispatcher work per month = the full subscription cost.
What you actually gain by leaving Excel
- Real-time order status — no calling. The driver scans POD in the app, you see it in the panel.
- Invoices tied to the order — issued with the CMR number, amount, and due date already filled in.
- Driver file always at hand — driving licence, ADR, Code 95, insurance, expiration dates with alerts.
- GPS and route history — not just "where they are" but also "where they were and when."
- Export for accounting — JPK_FA with one click.
Check this before switching
- How much time does the dispatcher actually waste on admin? Measure for a week. You'll be surprised.
- How many invoices went out late last month? Each one = lost cashflow.
- How many status calls do you take per day? That's clients asking because they have no visibility.
If any of these numbers is higher than you'd like — it's time to think about a TMS.
RoadTMS gives 14 days of trial without a card. Upload your data, lay out the panel, check if it works. If not — back out with no consequences. If it does — continue from 469 PLN/month.
Try RoadTMS for 14 days
No credit card, no commitments. Upload your data, see if it works for you.