Excel or TMS? If you run a small transport or forwarding company and every order lives in a spreadsheet, sooner or later you will ask yourself that question. The answer is not always "TMS": some companies do perfectly well with a tidy spreadsheet for years.

This is not a feature checklist for comparing vendors. It gives you honest criteria instead: when a spreadsheet is fine, which signs tell you it costs more than it gives, how to count the cost of waiting in hours, and how to switch without a single load getting stuck.

When is Excel genuinely enough for a transport company?

A spreadsheet is not the enemy. It is free, everyone knows it, and you can build a simple order log in an afternoon. Trouble starts only when the company grows faster than the discipline around the file.

Excel is usually enough if most of these are true:

One person takes and runs the orders, usually the owner, so nobody overwrites anyone else.
You serve a few regular clients on repeat routes and rarely split an order between carriers.
You run a handful of vehicles, and inspection and insurance dates fit in one calendar.
You invoice once a week in your accounting software without losing track of orders.
You know offhand how much you made on each run last month.

Quick test: ask someone on your team to tell you, within two minutes, the status of any three orders from this week and whether they have been invoiced. If they can do it without calling a driver or opening five files, the spreadsheet is still coping.

When does a transport company need a TMS? 7 warning signs

There is no magic number of orders after which you must switch. There are, however, symptoms that repeat in every company that has outgrown Excel. If you recognise three or more of these, it is time to start counting.

1There are several versions of the file: "orders_final", "orders_final2", a copy on a dispatcher's desktop. Nobody is sure which one is current.
2You type the same data three times: into the spreadsheet, into the carrier order in Word and into the invoice.
3You ask for load status by phone, because the sheet only holds what someone managed to enter last night.
4An invoice waits because nobody knows where the CMR is: in a mailbox, in the driver's WhatsApp or in a folder in the cab.
5You learn the margin on an order a month later, when accounting matches cost invoices against sales invoices.
6A truck has gone out with an expired inspection or insurance, because the reminder lived in someone's head.
7One person's holiday paralyses the company, because only they understand the formulas and colours in the sheet.

Each of these can be worked around on its own. Together they mean you are paying for the spreadsheet with people's time, late invoices and errors nobody measures.

Excel or TMS: what changes in each process?

The decision gets easier when you compare tasks from a normal day rather than products. Here is the same work done in a spreadsheet and in a TMS:

Taking an order: Excel: you copy route, dates and rate from a mail into a row. TMS: the order has fixed fields, stops and a linked client, and contractor details come in from the tax ID.
Carrier order: Excel: you paste data into a Word template and send it by hand. TMS: the document is built from the order and goes out by mail in one click.
Status and driver contact: Excel: a call, an answer, a cell update. TMS: the driver confirms status, and you see the change on the order list.
CMR documents: Excel: photos scattered across inboxes and messengers. TMS: the document lands on the right order.
Margin: Excel: worked out at month end, if someone remembers the costs. TMS: shown on every order before you confirm it.
Invoice: Excel: separate software, data typed in again. TMS: the invoice comes from the order with no retyping.
Receivables and limits: Excel: a separate tab someone has to keep updated. TMS: payment terms and credit limit sit on the contractor and show up on a new order.
Fleet and deadlines: Excel: a calendar or coloured cells. TMS: vehicle and driver documents with expiry dates and a filter by upcoming deadline.

Sokar is one example of how this works: an FTL or PTL order with stops, rates, carrier and driver, producing a carrier order PDF, a VAT invoice and a margin preview. The driver gets a link on their phone with no app to install, sees the load and route, confirms status and uploads the CMR, and you get a notification.

What does staying on Excel cost? Count it in hours

Instead of asking what a system costs, count how much time your current way of working eats. Below is an example with round numbers for a company handling 200 orders a month. Plug in your own figures, because your proportions will differ.

Example: retyping order data into the sheet, the carrier document and the invoice takes 15 minutes per order. At 200 orders that is 50 hours a month.
Example: two status calls per order, 3 minutes each. That is another 20 hours.
Example: chasing a missing CMR before invoicing on one order in four, 10 minutes each. That is about 8 hours.
Total in this example: close to 80 hours a month, roughly half of one person's working month spent retyping and chasing.

On the other side is the cost of switching, and that deserves an honest count too. It is usually a few hours of cleaning up data, a few days to two weeks of learning for the team, and a period when some work goes slower while everyone builds new habits.

The most expensive costs of a spreadsheet rarely show up in hours. They are the invoice issued two weeks after unloading, the order accepted below the carrier's cost, or the client who has been paying late for months without anyone noticing.

Managing transport orders in Excel: how to get more out of it first

If you decide it is too early for a system, tidy up the spreadsheet. These rules pay off later too, because a clean file moves into a TMS much faster.

One file in a shared location, with no desktop copies and no sending it around by mail.
One row per order with a unique number that you also use on the invoice.
A separate contractors tab: full name, tax ID, address, payment terms. In orders you pick from the list, not from memory.
Dropdown lists for statuses, so "in transit", "IN TRANSIT" and "on the way" are not three different values.
Client rate and carrier cost columns side by side, with the margin calculated automatically.
A separate tab with inspection and insurance dates, sorted by expiry.

If the warning signs keep coming back despite these rules, the problem is not how tidy the file is. It is the tool itself.

Moving from Excel to a TMS without stopping work: a plan for the first 30 days

The biggest fear is that the company will grind to a halt for a week. It does not have to, as long as you do not move everything at once. A proven sequence looks like this:

1Before you start: pick one person to own the rollout and clean up the contractor and fleet tabs.
2Week 1: enter contractors, drivers, tractors and trailers with document expiry dates. Leave orders alone for now.
3Week 2: create every new order in the system. Orders started in Excel get finished in Excel, with no moving them halfway.
4Week 3: invoice from orders in the system and let drivers send statuses and documents.
5Week 4: compare order handling time before and after. Lock the spreadsheet and keep it as an archive.

You can try Sokar in a free pilot that runs for 30 days, with no commitment. We help move your contractors, fleet and orders, so week 1 of the plan above does not have to mean retyping everything by hand.

If your orders arrive mostly by mail, also look at Bobi, the AI assistant for freight forwarding and transport. Bobi creates an order from one sentence or a client's mail, asks about missing details and saves it in Sokar with a PDF, but saves nothing without your confirmation.

How do you tell after a month whether the switch paid off?

"It feels easier" is not enough. Before you start, measure a few things in the spreadsheet, then measure them again in the system after 30 days:

How many minutes pass between receiving a client order and sending the carrier order.
How many days pass between unloading and invoicing.
How many status calls you make on a typical day.
How many orders are missing a document at invoicing time.
Whether you can state last week's margin within a minute.

If the numbers have not improved, do not carry on out of habit. A pilot exists so you can test software for a transport company on your own orders, not on a sales demo.

Invoicing is a separate matter. Since 2026, issuing structured invoices through KSeF has been mandatory for Polish VAT taxpayers, with start dates depending on company size (Article 106ga of the Polish VAT Act). Invoicing software is enough for KSeF, so the obligation alone does not force a TMS, but it is easier to meet when the invoice comes straight from the order.

For your individual situation, consult a tax adviser.

See on your own orders whether a TMS saves you time. No commitment, with help moving your data.

Try Sokar free for 30 days