Supplier Quote Comparison Template: Compare Like for Like

A quote comparison template puts every supplier quote into the same columns, in one currency, on one Incoterm basis, so you compare landed cost and not headline price. If one quote is FOB in USD, another is CIF in EUR and a third is delivered in AED, the totals mean nothing until you convert and add what is missing. This post gives you the layout, the steps and a worked AED example for a UAE or Saudi buyer.

What should a quote comparison template include?

A good quote comparison template has one column per supplier and one row per cost or term. Every quote gets the same rows, even when the supplier left something out. A blank cell is a question to ask, not a zero.

Use these rows as your starting layout:

Add a "not included" row for each quote. Suppliers often leave out packing, testing, installation, or the cost of a certificate. Write down what each quote assumes.

How do you compare quotes in different currencies?

Convert every quote into one currency, using one rate source and one date. Do it in the sheet, not in your head.

1. Pick your base currency. Use AED for a UAE buyer and SAR for a Saudi buyer.
2. Put the exchange rate in a single input cell for each foreign currency, with the date next to it.
3. Convert the goods total for each quote using that cell.
4. Convert any freight or charges quoted in a different currency in the same way.
5. Note the quote validity date. A quote in a volatile currency or with an escalation clause can change before you order.
6. Re-run the sheet with the rate you actually pay on the day you transfer funds.

For customs, the rate used on the declaration can differ from your bank rate. One secondary source says the rate applicable when the declaration is submitted is used (Shuraa). We could not confirm that on a Dubai Customs page, so check with your broker or Dubai Customs before you rely on it.

Why do Incoterms change the comparison?

Incoterms decide who pays for what and where risk passes, so the same goods can have very different real prices under different terms. Incoterms are eleven three-letter trade terms published by the ICC, and Incoterms 2020 is the current edition, in force since 1 January 2020.

Here is how four common terms differ for a buyer importing into the UAE or KSA:

The pattern comes from the ICC rules and guides such as Ovrsea's who-pays-what overview. Confirm the exact split for the term and named place on each quote.

Two details trip people up:

• CIF is for sea freight only. The ICC reserves CIF for maritime trade. For containers, guides suggest FCA, CPT or CIP instead.
• Insurance levels differ. Under CIF the default cover is Institute Cargo Clauses (C). CIP needs cover under Clauses (A) or similar. Two quotes that both say "insurance included" may not give the same cover.

Also remember that Incoterms are not the whole contract. The ICC introduction lists matters the rules do not deal with, such as transfer of property.

How do you work out landed cost for a UAE import?

Start from the customs value, add duty, then add your local costs. Dubai Customs says duty is 5% of CIF value for most goods, with alcohol at 50% and cigarettes at 100% (Dubai Customs FAQ). The FAQ gives the customs value basis as CIF under the GCC Common Customs Law, which includes transport, insurance and relevant charges up to the place of importation. Your goods' actual rate depends on the tariff code, so confirm it with your customs broker.

For import VAT, secondary guidance says VAT is 5% of the customs value plus insurance, freight, customs duty and excise tax, and VAT is not included in its own base (Uppersetup). Check the rule with the FTA or your tax adviser.

Worked example (hypothetical numbers)

Say a Dubai trading company wants 5,000 units of an item and gets three quotes. All rates and local costs below are assumptions for this example only.

• Quote A: Shenzhen supplier, FOB Shenzhen, USD 40,000. Example rate 3.67 AED per USD. Your forwarder estimates AED 11,000 freight and AED 600 insurance to Jebel Ali.
• Quote B: European supplier, CIF Jebel Ali, EUR 38,500. Example rate 4.20 AED per EUR.
• Quote C: UAE distributor, delivered to your warehouse, AED 172,000, VAT extra. The goods are already imported.

Assume AED 4,500 for port, clearance and local delivery on A and B.

Quote A looks cheapest on goods, and it stays cheapest here, but only by AED 1,180 over Quote C. Quote B looked mid-priced on goods and ends up last. That is why the comparison has to be done on landed cost. With gaps this small, lead time, payment terms and quote validity should decide.

What changes for buyers in Saudi Arabia?

The structure is the same, but you work in SAR and the authority is ZATCA. A Saudi buyer clearing through Jeddah Islamic Port or Dammam still needs the customs value, which ZATCA guidance describes as the transaction value including freight and insurance to the place of import, and the VAT base follows that same value. Confirm the current VAT rate and your tariff rate on zatca.gov.sa or with your customs broker, because both can depend on the goods and change over time.

Keep one extra row for the Saudi National Address, or the delivery point on the quote, so every supplier prices delivery to the same place.

What mistakes make quote comparisons unfair?

These are the ones we see most often:

• Comparing goods totals only. FOB, CIF and delivered prices are not the same thing.
• Different specifications. One supplier quotes a cheaper grade and the sheet doesn't show it.
• Mixed exchange rates. One quote converted at last month's rate, another at today's.
• Treating VAT as a cost when you can recover it. Show it on its own row.
• Ignoring validity. A quote that expired last Thursday is not a quote.
• Forgetting exclusions. Packing, testing, installation and certificates are common gaps.
• Scoring too early. Fix the landed cost first, then score lead time, warranty and payment terms.

Can software do this for you?

A spreadsheet works for a few quotes a month. It gets hard to trust once several people send RFQs, quotes arrive by email and WhatsApp, and nobody knows which version is current. Quickship's Sourcing module is built for RFQs, supplier quotes and purchase orders, so quotes sit in one place and you compare them side by side before you raise the PO. It is software only. Quickship doesn't buy, import, ship or clear goods for you.

If you're building your own sheet first, copy the rows above and keep the exchange rate and date in cells you can see. Then move to a tool when the manual work starts to cost you time.