When Your Freight Quoting Spreadsheet Starts Costing You Deals

The spreadsheet that worked fine last year

Most export operations start quoting freight the same way: a shared Excel or Google Sheets file, a tab per carrier, rates pasted in after a phone call or email, and a formula or two to spit out a total. It works. For a business doing a handful of shipments a month, it works well enough that no one questions it.

The problem is not that the spreadsheet is wrong. The problem is that it is quietly fragile — and the fragility only becomes visible at the worst possible moment: when a customer is waiting on a quote, a rate has quietly changed, or a junior team member has overwritten a formula cell without realising.

For exporters in the UK and Australia moving physical goods — manufactured products, industrial equipment, trade-show freight, perishables — the shift from manageable to messy tends to happen gradually, then all at once.

Four signs your quoting process is breaking

1. Quote turnaround has become a bottleneck

When producing a freight quote requires one specific person — because only they know where the rates live, which surcharges to apply, or how the margin logic works — that is not a system. That is a dependency. If that person is on leave, in a meeting, or simply overloaded, quotes queue up. Customers waiting on quotes buy from whoever replies first.

2. Margins are inconsistent across quotes

Spreadsheets do not enforce rules. A sales manager quoting a new lane manually applies a margin from memory. A different team member applies a different one. Neither is wrong by intent, but the outcome is inconsistent floor prices and unpredictable gross margin. When you review quotes retrospectively — if you review them at all — the variance is often surprising.

3. Rates go stale between updates

Carrier rates change. Fuel surcharges move. Port congestion fees appear and disappear. In a spreadsheet world, someone has to manually update those rates, usually after they have already caused a problem on a live quote. Purpose-built systems pull from rate cards or carrier APIs and flag when rates are due for review — the stale data problem becomes visible before it becomes a loss.

4. You cannot easily audit what was quoted and why

When a customer comes back three weeks later and disputes what they were quoted, can you reconstruct exactly what rates, surcharges and margin assumptions were in play at the time the quote was sent? In most spreadsheet setups, the honest answer is: probably not with confidence. Quote history is scattered across email threads and versioned files named things like quote_v3_final_FINAL.xlsx.

If any of these sound familiar, the Import/Export Quote-Time Estimator is a useful starting point — it surfaces where slow quoting is actually costing capacity.

What spreadsheet quoting cannot do at volume

Beyond the day-to-day friction, there are structural limitations that spreadsheets simply cannot overcome:

Multi-mode comparison. When a customer wants to know air vs sea vs road for a given consignment, a spreadsheet requires someone to manually retrieve and compare rates across modes. Software does this in one step, from the same interface.

Volumetric and weight logic. Chargeable weight calculations — particularly the interaction between actual weight, CBM and carrier-specific volumetric divisors — are easy to get wrong in a formula. The error is invisible until a carrier invoice arrives with a different number. A CBM calculator handles the arithmetic correctly every time, and purpose-built quoting software embeds the same logic natively.

Currency and FX buffers. UK exporters quoting in GBP against USD or EUR freight costs, or Australian exporters quoting in AUD against USD-denominated sea freight, carry FX exposure on every quote. A spreadsheet does not model that exposure; it just shows a number. Quoting software can apply a buffer at the point of quote generation, so the margin is protected even if the rate moves before the shipment confirms. The Quote Margin Protector illustrates the logic.

Approval workflows. Above a certain value or margin threshold, quotes may need a second pair of eyes before they go out. There is no clean way to enforce that in a spreadsheet. Software can route quotes for approval automatically.

What purpose-built quoting software actually looks like for exporters

The term "freight quoting software" covers a wide range, from bolt-on modules in TMS platforms to lightweight tools built specifically for a company's rate card and margin structure. For most UK and Australian exporters not running at enterprise scale, the relevant question is not which off-the-shelf platform to buy, but whether a custom or lightly configured tool would serve them better.

A purpose-built quoting system for an exporter typically does the following:

• Stores carrier rate cards with version history and expiry dates
• Applies surcharges, fuel levies and port fees as configurable rules
• Calculates chargeable weight automatically based on mode and carrier rules
• Applies margin rules at a lane, customer or product-category level
• Generates a quote document in the company's format, ready to send
• Logs every quote with the rate snapshot used at the time
• Optionally integrates downstream with order management or invoicing

The gap between what a spreadsheet does and what this list describes is not a technology gap — the underlying logic is not complex. It is a configuration and workflow gap. The reason most exporters have not closed it is not cost; it is that no one has sat down and specified what the system needs to do.

For teams that have done that specification work, AI-assisted product delivery can compress the time from requirements to working software significantly. Where a traditional build cycle might run months from discovery to first release, structured tooling and AI-assisted development can move faster through the boilerplate — data models, form logic, PDF generation — so that the time is spent on the decisions that actually require a human: the margin rules, the carrier relationships, the edge cases in a particular lane. We have seen this pattern on operational tooling builds in trade and logistics, though outcomes always depend on scope and team.

Build, buy or configure?

For exporters evaluating their options, the decision usually comes down to three paths:

Configure an existing TMS or freight platform. If you are already on a platform like CargoWise or a mid-market equivalent, quoting modules may already exist. The question is whether they match your margin logic and customer-facing output requirements, or whether they would require significant workarounds.

Buy a standalone quoting tool. Several SaaS products address freight quoting for SME exporters. They are fast to onboard but may not integrate cleanly with your existing ERP, order management or CRM — creating a new rekeying problem to replace the old one.

Commission a custom build. This makes sense when your quoting logic is genuinely differentiated — unusual surcharge structures, complex multi-leg routing, or customer-specific pricing tiers — or when you need the system to integrate tightly with adjacent tools you already use. A custom build costs more upfront but produces a system that fits your process rather than one you adapt your process to fit.

The guide on how to stop email chaos in import export ops covers adjacent ground on where process breakdowns hide in operational teams.

What to specify before you commission anything

Whether buying or building, the quality of the outcome depends on how clearly you can describe your current process. Before approaching a software partner, it is worth documenting:

• How many quotes you generate per week, and at what average value
• How many carriers and lanes you regularly quote across
• What your current margin rules are, and whether they are consistent
• What format your customers expect quotes in
• Which systems the quoting tool needs to connect to (ERP, WMS, CRM)
• What the approval workflow looks like above a given threshold

With that documented, a scoping conversation becomes productive. Without it, you will spend the first meeting explaining the basics and the second one realising the first produced the wrong assumptions.

For exporters managing landed cost variability as well as freight quoting, the Managing Landed Cost Discrepancies in Import Shipments guide covers the downstream problems that start here.

The transition is less disruptive than it looks

The common objection to replacing a quoting spreadsheet is disruption — the fear that a new system will break a process that, however imperfect, is at least understood. In practice, the transition for most exporters involves running the old and new systems in parallel for a few weeks, then switching when the team has confirmed the new tool produces consistent output.

The bigger risk is waiting. Every month of spreadsheet quoting at volume is another month of inconsistent margin, slow turnaround and unauditable history. The spreadsheet that worked fine last year is not getting better as the business grows — it is getting more fragile.