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 does | What it should do | What the Normaliser does |
|---|---|---|---|
| 1 | Adds US dollar and Australian dollar lines in one column | Convert each line at one stated rate | Converts every line at the rate you enter and prints the rate on the result |
| 2 | Treats "48.00 per W/M" as 48.00 | Multiply by the shipment's W/M | Works out W/M, containers or chargeable kilos from the shipment you enter once |
| 3 | Ignores a minimum charge | Apply the minimum after quantity | Applies minimums and maximums line by line |
| 4 | Types "fuel 20%" as 20 or drops it | Calculate it on the line it applies to | Calculates percentage-of-line charges |
| 5 | Reads "delivery excluded" as zero | Show a gap | Shows a gap; adds your estimate only if you enter one, labelled as yours |
| 6 | Reads "at cost" as zero | Show an open amount | Shows "at cost, amount unknown" as a gap |
| 7 | Includes charges for legs your supplier pays | Set them aside under your Incoterms® rule | Flags them as possibly double-paid and leaves them out of the total |
| 8 | Hides validity and "subject to" | Show them beside the price | Badges "Expired", "Expires before ship date" and "Price not fixed" |
| 9 | Ignores free time | Compare days and the daily rate | Shows free time and your expected exposure separately |
| 10 | Compares port-to-port with door-to-door transit | Use one basis | Warns 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 A | Quote B | Quote C |
|---|---|---|---|
| Ocean freight | 48.00 x 3.6 = $172.80 | AUD 70.00 x 3.6 = AUD 252.00 x 0.66 = $166.32 | |
| Destination depot and charges | AUD 62.00 x 3.6 = AUD 223.20 (above the AUD 120.00 minimum) x 0.66 = $147.31 | AUD 410.00 x 0.66 = $270.60 | |
| Delivery order | AUD 95.00 x 0.66 = $62.70 | included above | |
| Depot infrastructure | AUD 38.00 x 3.6 = AUD 136.80 x 0.66 = $90.29 | included above | |
| Customs brokerage | AUD 175.00 x 0.66 = $115.50 | AUD 150.00 x 0.66 = $99.00 | At cost: gap |
| Delivery | Excluded: gap | AUD 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 gaps | Delivery $171.60 | none | Brokerage $115.50 |
| Comparable total | $760.20 | $726.00 | $1,005.50 |
| Set aside | Origin terminal handling $18.00 x 3.6 = $64.80: possibly double-paid under FOB | ||
| Badges | Expired 30 September 2026 | Price 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.
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
Scroll the table sideways to see all three forwarders.
| Charge | Forwarder A | Forwarder B | Forwarder C |
|---|---|---|---|
| Main freight | $172.80 | $166.32 | $890.00 |
| Surcharges | None quoted | None quoted | In bundled line: All-in door to door |
| Destination terminal handling | $300.30 | $270.60 | In bundled line: All-in door to door |
| Import clearance and customs broker | $115.50 | $99.00 | GAP: at cost, amount unknown |
| Delivery | GAP: excluded | $190.08 | In bundled line: All-in door to door |
| Known total | $588.60 | $726.00 | $890.00 |
| Unknown items | 1 UNKNOWN (1 gap) | None | 1 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.
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 QuotesThe 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.
- S1. ICC, Incoterms 2020: https://iccwbo.org/business-solutions/incoterms-rules/incoterms-2020/