For a long time, a spreadsheet was the right tool for the job. When you were dealing with one or two carriers, a manageable consignment volume and rate structures that didn’t change much, a well-maintained Excel file could give you a reasonable picture of what freight was costing the business. It wasn’t pretty, but it worked.
The problem is that most businesses’ freight operations have grown significantly more complex since then: more carriers, more lanes, more frequent rate changes and far more invoices hitting the inbox each month. The spreadsheet hasn’t changed. The freight environment has. And somewhere in that gap, money is being lost.
The spreadsheet isn’t the problem. The volume is.
Nobody builds a manual reconciliation process expecting it to fail. It fails gradually as the operation grows, while the process doesn’t.
When you’re managing freight across multiple carriers, each with its own rate cards, surcharges, fuel levies and billing cycles, the data volume quickly exceeds what a spreadsheet can practically handle. The cells are still there. The formulas still calculate. But the data feeding them is incomplete, delayed, or entered inconsistently. The resulting picture is a rough approximation of what freight is actually costing, not an accurate one.
This isn’t a failure of the person managing the spreadsheet. It’s a structural limitation. Manual data entry introduces errors. Cross-referencing invoices against rates takes time that most operations teams don’t have. And in a multi-carrier environment, even a small discrepancy per consignment can add up quickly over a month’s worth of freight.
Overcharges don’t announce themselves
Carrier billing errors and rate discrepancies are more common than most businesses realise. Weight rounding, incorrect zone classification and surcharges applied in error. These aren’t always the result of bad intent, but they happen regularly and they’re rarely corrected unless someone catches them.
In a spreadsheet-based environment, catching them means manually comparing the quote at the time of booking with what appears on the invoice. For a business processing hundreds of consignments a month, that work is significant. In practice, it often doesn’t get done consistently, which means the errors go unnoticed and the business keeps paying.
The challenge is that there’s rarely a single large discrepancy that raises a flag. It’s a pattern of small ones – a fuel levy applied twice, a weight bracket rounded up, a remote area surcharge on a delivery that doesn’t qualify. Individually, they’re easy to miss. Cumulatively, across a full month of freight, they add up to real money, leaving the business without anyone noticing.
And because the problem is invisible in a spreadsheet environment, it tends to stay that way. There’s no mechanism to surface a variance unless someone builds one and maintaining that kind of manual audit process alongside everything else an operations team is responsible for is rarely sustainable.
Reporting from spreadsheets shows you the past, not the pattern
Even when a spreadsheet-based reporting process is working well, it has an inherent lag. Someone has to compile the data, structure it and produce something usable. By the time that’s done, the window to act on what it shows has often already closed.
More importantly, the reports most businesses can produce from a spreadsheet are limited by what data they thought to collect in the first place. Spend by carrier is straightforward. Spend by lane, zone, or time period (broken down in a way that’s actually useful for making routing decisions) is significantly harder to pull together manually, and is rarely done with enough regularity to drive real change.
The other issue is the source of the data. Many businesses rely on their carriers to provide performance and dispersion reports, which means the data arrives on the carrier’s schedule, in the carrier’s format and reflects what the carrier chooses to include. That’s a reasonable starting point, but it’s not the same as having your own view of what’s happening across your freight network.
When reporting has to be compiled rather than generated, it tends to be compiled quarterly rather than monthly and to be reactive rather than proactive. By the time the picture is assembled, it’s usually describing a problem that’s already been running for a while.
What a more structured approach actually looks like
Moving away from spreadsheet-based freight cost management doesn’t require a wholesale operational overhaul. In practice, it comes down to three things working together:
- Rate cards that stay current without manual maintenance. When rate cards update automatically as carriers adjust their pricing, the comparison between quoted and charged amounts is always working from accurate data, not last quarter’s rates that someone hasn’t had time to update yet.
- Invoice reconciliation that runs as an ongoing process, not a quarterly project. When reconciliation runs against every invoice rather than just the ones someone has time to check, freight leakage gets addressed at the source rather than discovered after months of accumulation.
- Reporting that’s accessible enough to actually inform decisions. When spend reporting is built into the day-to-day workflow rather than compiled separately, the insights it produces arrive when they’re still useful, not after the window to act has closed.
The automated rate cards updating, the ability to input an invoice from one of the freight companies, and then have MachShip tell you where there’s a variance — that’s saving us a lot of time because that was previously a manual activity.
For Lawrence & Hanson, moving to a structured freight management approach contributed to a 30% reduction in supplier numbers – a direct result of having the spend visibility to consolidate carriers and negotiate from a position of understanding rather than assumption.
The operational shift is less about adopting new technology and more about moving freight cost management out of reactive mode. Instead of finding out at the end of the month what freight costs, you’re working from data that’s current enough to influence what it costs next month.
If you can’t see it, you can’t manage it
Freight cost reduction is often framed as a negotiation problem: get better rates, tighten contracts, push back harder on carriers. That matters. But for many businesses, the more immediate opportunity is in the data they’re already generating and not fully using.
- Overcharges being absorbed without detection.
- Reporting that arrives too late to act on.
- Spend patterns that only become visible when someone has time to build a pivot table.
These aren’t edge cases. They’re the everyday experience of businesses managing freight in spreadsheets that were never designed for this level of complexity.
If you’re heading into Q2 wanting a clearer picture of what your freight operation is actually costing and where the savings are hiding, the MachShip team can walk you through what that visibility looks like in practice.