Why Excel Is Killing Your Freight Margins (And What to Do About It)

Most small freight forwarders and carriers run their operations on a combination of Excel and WhatsApp. The spreadsheet holds orders, rates, and a rough tally of what customers owe. WhatsApp holds the actual conversation — the load confirmation, the driver update, the "can you send the CMR?" message chain that nobody ever exports to anywhere.

This feels manageable. And for a while, it is. The problem is not that Excel fails suddenly — it is that Excel hides failure quietly. The real cost of staying in spreadsheets is not visible until a specific expensive event forces you to count it. This article explains exactly where the losses accumulate.

The 5 Ways Excel Hides Your Real Cost-per-Load

Your margin on a load is not simply the customer rate minus the subcontractor rate. Every load has additional costs that need to be accounted for to know whether you actually made money. In a spreadsheet, most of these costs are estimated, missing, or entered inconsistently.

1. Diesel Surcharges That Never Get Updated

Fuel surcharges change weekly. Most forwarders set a rate in their spreadsheet at the start of the month and forget to update it. By week three, the surcharge in the spreadsheet is €0.08/km when the actual carrier cost has moved to €0.11/km. Across 60 loads, that is €1,800 in margin that was never there.

2. Toll Costs Estimated or Missing

Cross-border routes through Germany, Austria, France, and Switzerland carry significant toll charges. Estimating these from memory or from a two-year-old rate card understates cost on high-toll routes by 8–15%. On a €900 subcontractor invoice for a route through Switzerland, that is €72–€135 that was not in the plan.

3. Driver Cost Not Allocated per Order

Carriers that mix owned trucks with subcontracted loads often track driver wages as a monthly overhead — not per order. This means they cannot tell you whether the load from Bucharest to Munich made money or lost it once the driver's time, overnight allowances, and border wait time are factored in.

4. Invoice Errors Arriving Undetected

Subcontractor invoices arrive by email. In a spreadsheet-based operation, the check is: does the total look roughly right? A systematic comparison against the agreed rate per kilometre, with the correct fuel surcharge for that week, is not practical to do manually on 80 invoices per month. Studies across EU freight markets find 3–8% of freight invoices contain billing errors — overcharges that go unpaid when caught, but paid silently when they are not.

5. Late Payments Not Aged Properly

A customer who pays 75 days late instead of the agreed 30 is effectively borrowing money from you at no cost. In a spreadsheet, this shows up only when someone reviews the sheet carefully — which may be at month-end, or quarter-end, or when cash flow forces the question. An aging receivables report generated automatically makes this visible in real time.

What You Cannot See in a Spreadsheet

Beyond the cost-per-load problem, spreadsheets create several structural blind spots that become more dangerous as operation size increases:

• Carrier document expiry — CMR liability insurance, vehicle registration, and driver CPC certificates all have expiry dates. There is no practical way to track these in a spreadsheet for 20+ subcontractor carriers with alerts triggered before expiry.
• Subcontractor invoice accuracy — comparing each incoming invoice against the agreed rate for that specific load, with the correct surcharges for that week, requires a database relationship that a spreadsheet cannot maintain reliably.
• Per-order margin in real time — profit and loss per load is only visible after month-end reconciliation, not during the month when decisions can still be made.
• Overdue payment aging by customer — knowing that Customer A has €8,400 outstanding with 45 days past due while Customer B is always on time requires a receivables system, not a column in a spreadsheet.

A Worked Example: 10-Truck Operation, Excel vs. Automated

Consider a freight forwarder coordinating 10 truck equivalents — a mix of owned and subcontracted — moving approximately 80 loads per month.

The Trigger Points That Tell You It's Time to Switch

Most operators do not switch proactively. They switch after one of these specific failures makes the cost undeniable:

1. A subcontractor carrier delivered a load with expired CMR liability insurance — discovered only during a claim, when the insurer declined to pay
2. A disputed invoice with no audit trail — the customer claims they were overcharged; you have no documented record of what was agreed and when
3. A bad-payer customer accumulated €15,000 in outstanding invoices before anyone noticed the aging pattern
4. A key dispatcher left — and the knowledge of which carriers to use for which lanes, what rate was agreed with which customer, and where the CMR for Load #4217 is filed left with them
5. A VAT audit required reconstructing three months of transaction records from email threads and WhatsApp screenshots — a process that took the accountant four days

If any of these scenarios sounds familiar, the switch is overdue. If none of them have happened yet, the question is not whether they will — it is which one arrives first.

Our guide on what freight forwarder software actually does explains the full feature set to look for. For a focus on invoice auditing specifically, see how freight invoice auditing software works. If price is the deciding factor, see our comparison of affordable TMS options for small trucking operations.

Frequently Asked Questions

Why do freight companies still use Excel?

Excel is familiar, flexible, and free. For operations running fewer than 30–40 loads per month with one dispatcher, it works well enough that the pain points are not obviously urgent. The problems tend to accumulate silently — invoice errors not caught, margins not visible per load, compliance documents not tracked — until a specific expensive failure makes the cost undeniable.

What does freight management software do that Excel can't?

Freight management software provides real-time cost-per-load visibility (including diesel surcharges, tolls, driver costs, and subcontractor invoices), automated invoice auditing against contracted rates, carrier compliance document tracking with expiry alerts, customer payment aging with automated reminders, and a searchable audit trail of every order, document, and communication. None of these are practical to maintain manually in a spreadsheet.

How long does it take to move from Excel to freight software?

For most small operations, the transition takes two to four weeks. The first week is data import: active customers, carriers, and open orders. The second week is running both systems in parallel to confirm the new platform is capturing everything correctly. By week three or four, the old spreadsheet becomes read-only history. The migration is faster than most operators expect — the bigger investment is the discipline to enter data consistently in the new system.