Supplier Quote Comparison Automation: What Can Be Automated Safely, and What Stays with the Buyer
Four quotes for the same job have landed in the shared inbox: a PDF from Ningbo, a spreadsheet from Vietnam with a formula in the amount cell, a two-paragraph email from Malaysia, and a PDF from a Sydney wholesaler. Someone will retype all four into a comparison sheet before anyone can say which is cheapest. Most of that retyping can be automated. Some of the judgement around it cannot, and a system that blurs the two is how a wrong number reaches a purchase order.
This guide splits quote comparison into its separate tasks and says which ones software can do on its own, which it can do only with a person checking, and which stay with the buyer. It works through four sample quotes so you can see each decision point.
Contents09 Sections
In Short
- Automate the reading and the arithmetic. Copying values out of documents and doing the maths are where manual work is slowest and least reliable.
- Let the model extract, never calculate. Every total, conversion and landed-cost line should come from ordinary code with fixed rules, so the same inputs always give the same answer.
- Make problems block, not just display. An expired price, an MOQ above your quantity or a total that does not add up should stop a quote entering the ranking until a person accepts or fixes it.
- Keep supplier choice with the buyer. The software compares documents. It does not know which supplier missed two deliveries last year.
- Do not automate below roughly 15 quotes a month. Below that volume a good template is usually enough.
The Four Quotes
A buyer needs 700 lengths of 300 mm hot-dip galvanised ladder cable tray, 3 m long, delivered to Wetherill Park NSW, compared on 12 October 2026, excluding GST.
| Quote | Arrives as | Terms as written | Price (A to C in the supplier's currency) | The problem a busy buyer could miss |
|---|---|---|---|---|
| Supplier A, Ningbo | FOB Ningbo | 18.40 a length | None. Clean quote, valid to 31 October | |
| Supplier B, Binh Duong | Excel, amount cell is a formula | EXW factory | 17.10 a length | Valid 14 days from 25 September, so expired on 9 October. MOQ 1,000 against a need for 700 |
| Supplier C, Port Klang | Email body | "price delivered your port Sydney" | 21.30 a length | No Incoterms rule named, no freight split, "valid this month" |
| Supplier D, Sydney | Delivered to site | $39.50 a length | Line total shows 27,850.00. 700 × 39.50 is 27,650.00 |
The Split: Task by Task
| Task | Who does it | Why |
|---|---|---|
| Collect quotes from the shared inbox | Automated (a forwarding rule to a dedicated quote mailbox, or an upload folder) | No judgement involved; the risk is a quote that never arrives, so the file list stays visible |
| Turn a PDF, spreadsheet or email into text | Automated | Text PDFs, spreadsheets and email bodies read reliably. Scans and handwriting go to manual entry |
| Copy each commercial field (price, quantity, currency, terms, validity, MOQ, lead time, payment) | Model, with the source text for every value | This is the retyping. The model is told to copy exactly and return "not stated" instead of guessing |
| Read Incoterms wording | Model copies the wording; code flags anything that is not one of the eleven rules; buyer decides | "Delivered your port" could mean CFR or CIF. A guess here changes insurance and duty |
| Work out the validity date | Code, from the document date and stated days; flagged when the wording is relative | "Valid this month" on an email dated 5 October is read as 31 October and marked for confirmation |
| Check quantity × unit price against the stated total | Code | A model asked to check arithmetic can agree with a wrong total. Code cannot |
| Check MOQ against your requirement | Code | A comparison on 700 lengths is meaningless if the supplier will not sell 700 |
| Convert currency | Code, using a rate the buyer enters and dates | The rate is your decision, not the software's |
| Add freight, insurance, destination charges and duty | Code, using estimates the buyer enters | These are inputs. The software applies them consistently; it does not research them |
| Rank quotes on one landed basis | Code | Deterministic: the same inputs always give the same order |
| Draft clarification questions | Templates triggered by each flag | Questions never mention another supplier's price |
| Send questions to suppliers | Buyer | A message to a supplier is a commercial act |
| Choose the supplier | Buyer | Delivery record, quality, dependence and relationships are not in the documents |
The pattern is consistent.
Automate
Anything that is copying or arithmetic can be automated.
Automate with Review
Anything that is interpretation is flagged for a person.
Buyer Only
Anything that commits money or speaks to a supplier stays with the buyer.
The detail of each control is in the controls that make extraction safe to use.
What Each Party Does
- You provide
- the quotes (forwarded or uploaded), the requirement they answer (item, quantity, delivery address, date needed, spec), and the commercial inputs: exchange rate, freight and insurance estimates, destination charges and a duty rate if you import.
- The system does
- reads each document, extracts the fields with the text each value came from, runs the checks, puts every quote on one landed basis, ranks them, and drafts the questions each flag raises.
- The reviewer approves
- every blocking flag (accept with a one-line reason, or correct the value), any low-confidence field, and any field the system could not read.
- What is exported
- an Excel workbook with the comparison, every extracted field and its source text, the flags with who cleared them and why, and the draft questions. CSV for anything else.
- What stays manual
- sending questions, negotiating, choosing the supplier, deciding whether a dearer quote with a shorter lead time is worth it, and anything that needs a duty classification or a tax view.
The Worked Comparison
The example is priced in Australian dollars. The buyer entered these inputs: an exchange rate of 1.52 from the supplier's currency to $; sea freight $2,600 from Ningbo and $2,400 from Ho Chi Minh City; export clearance in Vietnam $250; marine insurance $100; destination charges $1,450; duty at 5% for the purpose of the example. All are example figures, not market rates and not a duty determination.
Duty in Australia is charged on the customs value, which is generally the FOB value, excluding overseas transport and insurance (S2). So each quote needs an FOB value before duty can be applied.
| Line ($) | A: FOB Ningbo | B: EXW Binh Duong | C: "delivered your port" | D: delivered to site |
|---|---|---|---|---|
| Goods | 12,880.00 × 1.52 = $19,577.60 | 11,970.00 × 1.52 = $18,194.40 | 14,910.00 × 1.52 = $22,663.20 | 700 × 39.50 = 27,650.00 |
| Inland haulage to port | 380.00 × 1.52 = $577.60 | |||
| Export clearance | 250.00 | |||
| Sea freight | 2,600.00 | 2,400.00 | included (unclear) | |
| Insurance | 100.00 | 100.00 | 100.00 allowance | |
| Destination charges | 1,450.00 | 1,450.00 | 1,450.00 | |
| Delivery | 220.00 | |||
| Duty at 5% of FOB value | 5% × 19,577.60 = 978.88 | 5% × 19,022.00 = 951.10 | 5% × 22,663.20 = 1,133.16 | |
| Landed total | 24,706.48Lowest landed, no blocking flags | 23,923.10 | 25,346.36 | 27,870.00 |
| Per length | 35.29 | 34.18 | 36.21 | 39.81 |
| Blocking flags | none | expired; MOQ 1,000 | none (three warnings) | arithmetic mismatch |
Notes on the lines. B's FOB value is goods plus haulage plus clearance: 18,194.40 + 577.60 + 250.00 = 19,022.00. C's price includes freight that the supplier has not separated, so the code treats the term as CFR (adding an insurance allowance, the cautious reading), uses the full price for duty and raises a warning asking for the split. D's goods line uses 700 × 39.50, not the stated 27,850.00, and shows both.
The headline the system produces: lowest landed quote without blocking issues, Supplier A at $24,706.48. B is $783.38 lower on paper but cannot be awarded as quoted. D costs $3,163.52 more than A (12.8%) but is in stock, 3 working days from order.
That last sentence is where the software stops. Whether 3,163.52 buys enough programme certainty depends on the site, the date the tray is needed and A's actual shipping time, none of which is in the quotes. The buyer decides. The questions go out:
- To B: confirm the price and validity are still current; confirm whether 700 lengths can be supplied and at what price; confirm the galvanising standard and coating thickness.
- To C: confirm CFR Sydney or CIF Sydney; split FOB value from sea freight; confirm validity date, MOQ and packing.
- To D: "Your line total shows 27,850.00 but 700 × 39.50 is 27,650.00. Please confirm the correct total."
This is commercial guidance, not customs advice. Duty rates and customs value depend on classification and the full transaction; confirm with a licensed customs broker. Last checked: 9 October 2026.
Where Quote Automation Goes Wrong
These are the failure modes specific to supplier quotes, and the control that catches each.
| Failure | What happens | Control |
|---|---|---|
| The model fills a gap | A missing MOQ becomes "1" or a missing validity becomes 30 days | Schema allows "not stated"; missing required fields block |
| A spreadsheet formula | B's amount cell holds =C10*D10. A reader that takes only saved values can find the cell empty; a reader that takes only the formula text gets no number | Evaluate the formula, then keep both the result and the formula in the source text |
| Relative validity | "Valid this month", "valid 14 days" | Code computes the date from the document date and flags relative wording |
| Terms that are not Incoterms rules | "Delivered your port", "CNF", "landed" | Copy the wording verbatim; flag anything that is not one of the eleven rules (S1) |
| Units that differ | Per length, per piece, per carton of 10, per metre | Unit is a required field; the comparison refuses mixed units until a person sets the conversion |
| Exclusions in free text | "Excludes fixings", "price subject to zinc surcharge" | Listed side by side for the buyer; never judged by the software |
| A wrong total that matches a wrong reading | The model misreads both unit price and total consistently | Every value carries its source text, so the reviewer sees the original |
When Not to Automate
- Fewer than about 15 quotes a month. A well-built comparison template is cheaper than any system and easier to maintain.
- Your suppliers already answer through an e-sourcing platform that structures their responses. The extraction problem has already been solved upstream.
- Most quotes are scans or handwriting. Extraction will fall back to manual entry, and the saving disappears.
- Nobody owns the output. A comparison that nobody reviews is worse than a slow one that somebody does.
If you are unsure whether your volume justifies it, run a time and error model you can run on your own numbers, or score your workflows first.
Where Quote Desk Fits
Quote Desk is PhaseVane's quote comparison system, built to the split above: the model extracts with source text, code calculates and checks, blocking flags hold a quote out of the ranking, and the buyer approves every exception and makes every decision. It is in development and not on sale. PhaseVane is looking for design partners to test it on real quotes before it is offered more widely.
Book a 20-Minute Workflow Call. Bring one recent quote comparison. You leave with a one-page note on which steps of your process are worth automating first and which should stay manual.
Book a Workflow CallOr see the Quote Desk walkthrough: the same four sample quotes, taken from inbox to export.
Sources
Checked 9 October 2026.
- S1: International Chamber of Commerce, Incoterms rules. https://iccwbo.org/business-solutions/incoterms-rules/
- S2: Australian Border Force, Customs duty calculation (ICS calculation routines). https://www.abf.gov.au/help-and-support/ics/integrated-cargo-system-(ics)/software-developers/reference-materials/calculation-routines/customs-duty-calculation
Related Research
See all research notesRelated topics: Quote Comparison
Human Review in Procurement Automation: The Controls That Make Document Extraction Safe to Use
Ten controls that stop a wrong extracted value reaching a purchase order, from source text checks to approval logs.
Quote ComparisonRead MoreEditorial Review: Publication Held
Freight Quote Comparison When Quotes Arrive by Email: Automating Intake Without Losing the Detail
Turn forwarder quotes from email, PDF and Excel into one comparison without dropping surcharges or validity.
FreightRead MoreEditorial Review: Publication Held
Where to Start with Procurement Automation: Score Your Workflows Before You Spend Anything
Score purchasing workflows on volume, error cost, document regularity, data access and risk before you automate.
Workflow scoringRead MoreEditorial Review: Publication Held