Skip to Content
crossquayCompare Your QuotesList Your Company

Guide · Product Demonstration

Freight Quote Comparison: What a Spreadsheet Misses, and How to Put Quotes on One Basis

Ten ways a freight quote spreadsheet gives the wrong answer, a worked three-quote example where the 'cheapest' comes second, and a free browser tool.

Not market ratesFigures in $
Contents 6

You have three forwarder quotes for the same shipment, and you have typed them into a spreadsheet. One column total is half the others. Before you book it, check what the spreadsheet actually added up: rates in two currencies, per-cubic-metre prices treated as totals, an excluded delivery counted as zero, an origin charge your supplier already pays. This page lists the ten ways a quote spreadsheet gives the wrong answer, works one example where the "cheapest" quote comes second, and shows the free tool that does the normalising for you.

Ten Ways a Quote Spreadsheet Misleads

#What the spreadsheet doesWhat it should doWhat the Normaliser does
1Adds US dollar and Australian dollar lines in one columnConvert each line at one stated rateConverts every line at the rate you enter and prints the rate on the result
2Treats "48.00 per W/M" as 48.00Multiply by the shipment's W/MWorks out W/M, containers or chargeable kilos from the shipment you enter once
3Ignores a minimum chargeApply the minimum after quantityApplies minimums and maximums line by line
4Types "fuel 20%" as 20 or drops itCalculate it on the line it applies toCalculates percentage-of-line charges
5Reads "delivery excluded" as zeroShow a gapShows a gap; adds your estimate only if you enter one, labelled as yours
6Reads "at cost" as zeroShow an open amountShows "at cost, amount unknown" as a gap
7Includes charges for legs your supplier paysSet them aside under your Incoterms® ruleFlags them as possibly double-paid and leaves them out of the total
8Hides validity and "subject to"Show them beside the priceBadges "Expired", "Expires before ship date" and "Price not fixed"
9Ignores free timeCompare days and the daily rateShows free time and your expected exposure separately
10Compares port-to-port with door-to-door transitUse one basisWarns when transit bases differ

Which legs are yours depends on the Incoterms® rule on your purchase; the rules set out all costs for each rule at articles A9 and B9 (S1). Use one scope when comparing the quotes.

Three LCL Quotes, Two Rankings

Not market rates.

An importer buys FOB Publication held Ningbo: 3.6 m³, 1,450 kg, delivered to its warehouse in Brisbane, ship date 20 October 2026. It compares in US dollars and enters its own rate: 1 AUD = $0.66 (a fictional rate). The forwarders' lines are shown as written, some in Australian dollars (AUD); every compared figure is in $.

Quote A: ocean $48.00 per W/M; origin terminal handling $18.00 per W/M; destination depot (CFS) AUD 62.00 per W/M, minimum AUD 120.00; delivery order AUD 95.00 per bill of lading; depot infrastructure AUD 38.00 per W/M; customs brokerage AUD 175.00; delivery excluded.

Quote B: ocean AUD 70.00 per W/M; destination charges AUD 410.00 per shipment; brokerage AUD 150.00; delivery AUD 240.00 plus 20% fuel; valid until 30 September 2026.

Quote C: all-in door to door $890.00 per shipment, subject to space and surcharges at shipment; customs brokerage at cost.

The Spreadsheet

Typing each quote's numbers into a column and summing:

  • A: 48 + 18 + 62 + 95 + 38 + 175 = 436
  • B: 70 + 410 + 150 + 240 = 870
  • C: 890

A looks half the price of the others.

Normalised

W/M = the greater of 3.6 m³ and 1.45 tonnes = 3.6.

$Quote AQuote BQuote C
Ocean freight48.00 x 3.6 = $172.80AUD 70.00 x 3.6 = AUD 252.00 x 0.66 = $166.32
Destination depot and chargesAUD 62.00 x 3.6 = AUD 223.20 (above the AUD 120.00 minimum) x 0.66 = $147.31AUD 410.00 x 0.66 = $270.60
Delivery orderAUD 95.00 x 0.66 = $62.70included above
Depot infrastructureAUD 38.00 x 3.6 = AUD 136.80 x 0.66 = $90.29included above
Customs brokerageAUD 175.00 x 0.66 = $115.50AUD 150.00 x 0.66 = $99.00At cost: gap
DeliveryExcluded: gapAUD 240.00 + 20% fuel (AUD 48.00) = AUD 288.00 x 0.66 = $190.08
All-in door to door$890.00
Confirmed total$588.60$726.00$890.00
Your estimates for gapsDelivery $171.60noneBrokerage $115.50
Comparable total$760.20$726.00$1,005.50
Set asideOrigin terminal handling $18.00 x 3.6 = $64.80: possibly double-paid under FOB
BadgesExpired 30 September 2026Price not fixed

Comparable Totals, Including Your Estimates

Quote Normaliser output on the quotes above. 1 AUD = $0.66, your rate entered for 9 October 2026.

Known chargesYour own estimate
  1. Forwarder A$760.20incl. your $171.60
  2. Forwarder B$726.00nothing unknown
  3. Forwarder C$1,005.50incl. your $115.50

Checks: A confirmed 172.80 + 147.31 + 62.70 + 90.29 + 115.50 = $588.60; B 166.32 + 270.60 + 99.00 + 190.08 = $726.00.

The spreadsheet ranked A first by a wide margin. On one basis, B is lowest at $726.00 but has expired; A is $34.20 higher and depends on your $171.60 delivery estimate; C is $1,005.50 and can still move. Had A's origin terminal handling stayed in the total, A would have been $825.00 and you might have paid a charge your supplier already covers.

The decision is now a set of questions, not a column total: will B hold its rate to 20 October; what does A charge for delivery; has your supplier confirmed it pays origin terminal handling; what could change on C at shipment.

What the Quote Normaliser Does

The free CrossQuay Quote Normaliser is built for the comparison above:

  • One shipment, entered once: mode, origin, destination, your Incoterms® rule, weight, volume or containers, ship date and compare currency.
  • Each quote as written, two to five quotes, line by line, each line with its basis, currency and status (quoted, estimate, at cost, excluded, included elsewhere).
  • Your exchange rates, printed on every result. It does not fetch or suggest rates.
  • Ten legs, from collection at the supplier to unloading at your site, with each charge mapped to the leg it pays for and a check against your Incoterms® rule.
  • Gaps, duplicates and badges: not mentioned, excluded, at cost; possible duplicates; expired, not fixed, transit basis differs.
  • Questions to send each forwarder, drafted from the gaps, ready to copy.
  • Exports to CSV and a printable page.
  • Privacy: it runs in your browser. Nothing you enter is sent anywhere unless you choose to send it.

1Sample output: the quotes above, run through the Quote Normaliser

Quote Normaliser output
Ningbo, CN (port)Importer's warehouse, Brisbane, AU

Sea LCL · 1450 kg gross · 3.6 CBM · 3 quotes held, compared in $

Scroll the table sideways to see all three forwarders.

ChargeForwarder AForwarder BForwarder C
Main freight$172.80$166.32$890.00
SurchargesNone quotedNone quotedIn bundled line: All-in door to door
Destination terminal handling$300.30$270.60In bundled line: All-in door to door
Import clearance and customs broker$115.50$99.00GAP: at cost, amount unknown
DeliveryGAP: excluded$190.08In bundled line: All-in door to door
Known total$588.60$726.00$890.00
Unknown items1 UNKNOWN (1 gap)None1 UNKNOWN (1 gap)

No cheapest quote can be named yet: the quotes leave different charges unknown.

A lower known total can simply mean a charge is missing, so the known totals are not ranked. Send the questions below, or enter your own estimates for the unknown items, then compare again.

Rendered by the Quote Normaliser. Five of ten charge categories shown. 1 AUD = $0.66, your rate entered for 9 October 2026. Not market rates.Open the full comparison

What It Does

  • Converts every line at the rate you enter, and prints the rate
  • Shows gaps, possible duplicates and badges beside each price
  • Drafts the questions to send each forwarder
  • Exports to CSV and a printable page
  • Runs in your browser

What It Does Not Do

  • Quote, book or arrange freight
  • Supply, fetch or suggest rates
  • Read PDFs: you enter each line as written

To understand each line before you enter it, read a forwarder quote line by line Publication held. For air quotes, it applies the divisor you confirm; see chargeable weight Publication held. For Australian imports, enter terminal and depot charges as separate lines; see destination charges Publication held.

Compare Your Quotes

Enter the quotes you hold and see them on one scope, currency and unit, with every gap shown.

Compare Your Quotes

The Quote Normaliser highlights gaps and prepares questions. Confirm missing charges and scope directly with the provider before choosing a quote.

The example is invented to show the method. CrossQuay does not quote, book or arrange freight, does not publish rates and takes no money from freight providers. Last checked: 9 October 2026. This is commercial guidance, not legal advice. Incoterms® is a trademark of ICC.

Sources

Checked 9 October 2026.

Related Guides

See all guides