Procurement Automation

Freight Quote Comparison Automation: Can It Keep the Detail?

How automated intake turns forwarder quotes from email, PDF and Excel into one comparison without dropping surcharges, TBA lines or validity.

By
PhaseVane
Published
Reading time
7 min
On This Page

Three forwarders have answered your request for one container from Ningbo to Sydney. One replied in an email body with an "all in" figure and "local charges at cost". One sent a PDF with eleven lines. One attached its rate sheet with a BAF (bunker adjustment factor, a fuel surcharge) column that says TBA. The comparison you build from these will be wrong if it drops any of those phrases, and those phrases are exactly what gets lost when someone copies totals into a spreadsheet at 5 pm.

This guide follows those three quotes through automated intake step by step: what is read, how charges are mapped, which checks fire, and what the buyer sees at the end. The aim is automation that keeps the detail, not automation that hides it.

In short

  • The hard part of freight comparison is the charges, not the rate. Different names for the same charge, unpriced lines and "subject to" wording decide the real total.
  • Map every charge to a standard code, using a dictionary you own. The model proposes a mapping for a new label; a person confirms it once.
  • Unknown is a value. "At cost", "TBA" and "subject to" are recorded as unknown, shown in amber and never treated as zero.
  • Check charges against the Incoterms rule on your supplier contract. Incoterms rules allocate tasks, costs and risks between seller and buyer (S1), so a forwarder can quote you for work your supplier has already priced.
  • Below a few shipments a month, comparing by hand is usually enough. Automated intake earns its keep on volume.

The shipment and the three quotes

An importer has bought 700 lengths of galvanised ladder tray from a supplier in Ningbo on FOB (Free On Board) Ningbo terms, packed into one 20-foot container. It asks three forwarders to quote sea freight to Sydney, customs clearance and delivery to Wetherill Park NSW. Quotes are compared on 12 October 2026, excluding GST (Australian goods and services tax), at a buyer-entered rate of USD 1 = AUD 1.52.

Forwarder Arrives as What it says
X Email body "USD 1,150 all in to Sydney, plus local charges at cost. Valid to end of month."
Y PDF, 11 lines Ocean freight USD 950; BAF USD 180; origin receiving charge USD 120; destination THC AUD 420; documentation AUD 95; customs clearance AUD 160; delivery to Wetherill Park AUD 520; valid until 31 October 2026, "subject to space and equipment"
Z Excel rate sheet Ningbo to Sydney 20GP USD 1,050; BAF column "TBA"; destination package AUD 1,180 "including delivery up to 30 km from port"

Step 1: intake

Quotes reach a dedicated freight mailbox, either by a forwarding rule or because the request asked forwarders to reply to it. Each email is grouped with its attachments under the shipment reference in the subject line. A reply with no reference is held for a person to assign, never guessed.

Step 2: reading the documents

The email body, the PDF text and the spreadsheet cells are turned into text, keeping the line, page or cell each value came from. The model then fills a fixed set of fields for each charge: label as written, amount, currency, basis (per container, per shipment, per kg), and any condition attached ("at cost", "TBA", "subject to"). It is told to copy, not calculate, and to return "not stated" rather than fill a gap.

Step 3: mapping charges to standard codes

Every forwarder names charges differently. The mapping uses a charge dictionary owned by the buyer, built up as new labels appear.

Label as written Standard code Who confirmed the mapping
"all in" ocean (X) OCEAN_FREIGHT, BAF included per wording Proposed by model, confirmed by buyer
Ocean freight (Y), 20GP (Z) OCEAN_FREIGHT Existing dictionary
BAF (Y, Z) BAF Existing dictionary
Origin receiving charge (Y) ORIGIN_TERMINAL Proposed by model, confirmed by buyer
Destination THC (Y) DEST_THC Existing dictionary
Documentation (Y) DEST_DOC Existing dictionary
Customs clearance (Y) CUSTOMS_CLEARANCE Existing dictionary
Delivery to Wetherill Park (Y) DELIVERY Existing dictionary
Destination package (Z) DEST_PACKAGE (THC, documents, clearance and delivery combined) Proposed by model, confirmed by buyer
"local charges at cost" (X) DEST_ALL, amount unknown Proposed by model, confirmed by buyer

Once a label is confirmed it is reused automatically. The model only ever proposes; the dictionary decides.

Step 4: checks

Check Quote Result
Destination charges priced X Flag: "local charges at cost" leaves destination costs unknown
Every surcharge priced Z Flag: BAF is TBA
Delivery address within quoted scope Z Flag: the package covers delivery up to 30 km from port; the distance to Wetherill Park is not stated in the quote, so the buyer must confirm it is within scope
Charges consistent with the supplier's Incoterms rule Y Flag: the goods were bought FOB Ningbo, and origin terminal charges on an FOB purchase are often part of what the seller has already priced. Check the supplier contract before paying for the same work twice
Validity All X valid to 31 October; Y valid to 31 October "subject to space and equipment" (recorded as a condition); Z validity not stated, flagged
Currency All Two currencies; converted at the buyer's rate of 1.52

Step 5: the comparison

All figures AUD, excluding GST. Code computes every line.

Line Forwarder X Forwarder Y Forwarder Z
Ocean freight 1,150 × 1.52 = 1,748.00 (all in) 950 × 1.52 = 1,444.00 1,050 × 1.52 = 1,596.00
BAF included 180 × 1.52 = 273.60 unknown (TBA)
Origin receiving 120 × 1.52 = 182.40 (flagged)
Destination charges unknown (at cost) 420 + 95 + 160 + 520 = 1,195.00 1,180.00 (package)
Known total 1,748.00 + unknown 3,095.00 2,776.00 + unknown
Known total without the flagged origin charge 2,912.60

What the buyer sees, in one sentence: Forwarder Y is the only complete quote, at AUD 3,095.00, or 2,912.60 if the origin charge is the seller's; Z looks lowest at 2,776.00 but its BAF is unpriced, and X cannot be compared until it prices destination charges.

The point of the flags is visible in the numbers. If Z's BAF turns out to match Y's USD 180 (273.60), Z becomes 2,776.00 + 273.60 = 3,049.60, which is higher than Y without the origin charge. A spreadsheet that treated TBA as zero would have picked Z.

Step 6: questions and decision

The drafted questions, one per flag, go to the buyer to send:

  • To X: please itemise destination charges for one 20GP into Sydney, including clearance and delivery to Wetherill Park NSW 2164.
  • To Z: please confirm the BAF amount for this sailing, the quote validity, and that Wetherill Park is within your delivery package.
  • To Y: please confirm who is billed the origin receiving charge on an FOB Ningbo shipment, and the space and equipment conditions on your validity.

Choosing the forwarder stays with the buyer: transit time, sailing schedule, service record and how each forwarder handled the last delay are not in the quotes.

Automated intake or a manual comparison

For an importer moving a few shipments a month, putting the quotes on one basis by hand is usually enough. Automated intake is worth considering when quotes arrive every day, when several people handle them, or when you want the same comparison feeding your supplier quote comparison as a landed-cost input.

Where Freight Quote Comparison fits

Freight Quote Comparison is a PhaseVane workflow built to the steps above, using the same extraction and checking design as Quote Desk with a freight charge dictionary. It is in development and not on sale.

Book a 20-minute workflow call. Bring the forwarder quotes for your last three shipments. You leave with a note on whether your volume justifies automated intake or whether a manual comparison is enough. Book a workflow call

Sources

Checked 9 October 2026.

Bring the forwarder quotes for your last three shipments. You leave with a note on whether your volume justifies automated intake or whether a manual comparison is enough.

Book a 20-Minute Workflow Call

Or see Quote Desk.

Related Research

See all research notes

Topic: Procurement Automation

  1. Cost Driver Monitoring: Is This Supplier Price Increase Justified?

    Map each supplier cost element to a free public index, track it monthly, and test a price increase claim against the weighted move. Worked example.

    Procurement Automation
    Read More
  2. Human Review in Procurement Automation: What Stops a Misread Value?

    Ten controls that stop a wrong extracted value reaching a purchase order: source text checks, code-only maths, blocking flags and an approval log.

    Procurement Automation
    Read More
  3. Procurement Automation: Which Workflow Should You Automate First?

    Score purchasing workflows on volume, error cost, document regularity, data access and decision risk to pick the first worth automating.

    Procurement Automation
    Read More