Why calculating freight costs in Excel goes wrong quickly
Most freight forwarders start with a spreadsheet. That makes sense: it works in the beginning, everyone knows how to use it, and changes can be made quickly. The problem is that the spreadsheet grows alongside the complexity of the operation, but was never actually built to handle that complexity. Rates are scattered across multiple tabs or sitting loose in emails. Someone adjusts a formula without telling anyone. A new client agreement on additional costs gets added manually after the fact. Meanwhile, the number of shipments grows, and with it the likelihood that something, somewhere, is incorrect. At that point, the spreadsheet is no longer a tool — it is a liability.
Bottleneck 1: tracking currency rates and fuel surcharges manually
Sea freight is settled in dollars, as is air freight, while the client expects a euro invoice. Today's exchange rate is not last week's. At the same time, fuel surcharges — also known as BAF or bunker adjustment factor — fluctuate monthly or sometimes fortnightly, depending on the carrier. Anyone tracking this manually in a cell is constantly playing catch-up. A calculation that is correct on Monday may already be outdated by Thursday. In practice, this means quotes are either priced too broadly to absorb margin risk, or too tightly, causing the margin to evaporate at execution. Good freight forwarder software for calculating freight costs pulls current rates from a central source and automatically includes the surcharge in the calculation at the moment of quoting.
Bottleneck 2: no direct link between calculation and invoice
The calculation is made in one tool, the invoice is drawn up in another system, and the bridge between them is a staff member transferring data by hand. Every manual handover is a risk: a surcharge that appears in the calculation but never makes it onto the invoice, a wrong quantity, a client rate that was just updated but has not yet been entered into the invoice template. The result is margin loss that you only discover after the fact, when you work back the realised margin per shipment and find that it is structurally lower than the calculated margin. Good software for calculating freight costs connects the calculation directly to the sales invoice: what you calculate is what you invoice, with no copy-and-paste steps in between.
Bottleneck 3: calculating multi-modal routes in a single overview
A shipment from Shanghai to a distribution centre in the Ruhr area travels by sea to Rotterdam, through the port with transhipment costs, and then by road to the final destination. Three modes of transport, three cost categories, three sets of rates and surcharges. In Excel, these are often calculated in separate tabs or even separate files and then manually added together. This makes comparison difficult: if you want to place two route alternatives side by side, you are essentially building two separate models. Freight forwarder software built specifically for calculating freight costs treats a multi-modal route as one continuous calculation. Sea, port, and road are all within the same model, including the applicable surcharges per segment. This allows you to compare routes and present the client with a well-founded choice.
When is custom software or an AI layer the logical next step?
Not every freight forwarder needs custom software. A forwarder processing ten shipments per week with fixed routes and fixed clients can get by for some time with a well-structured spreadsheet or a standard TMS. But as soon as the combination of variable surcharges, multiple modes of transport, and a growing client base becomes too large for manual management, it is worth looking at purpose-built software. There are two paths. The first is an AI layer on top of the existing system: an AI Worker that retrieves current rates and surcharges, populates the calculation, and forwards the output to the invoicing process, without replacing the existing TMS. This is useful when the current system performs well enough across the rest of the operation, but one or two steps in the calculation chain are causing problems. The second path is a fully rebuilt core system, a digital twin of the operational process, in which calculation, invoicing, and route optimisation are connected from the ground up. This is the right approach when the existing system is structurally blocking growth. The choice between the two depends on exactly where the pain lies and whether the existing foundation still holds up.