Journal · Documents

Comparing supplier quotes: criteria and a comparison table

Four suppliers sent four quotes in four different formats, and your buyer has to work out which one is actually cheaper. Here is a table template, the order to compare in, and how an AI agent builds the table from emails and files.

Compare supplier quotes line by line and on one basis: unit price excluding VAT in AED at a recorded exchange rate, delivery, lead time and stock, payment terms, minimum order, warranty and quote validity. Set the weights for each criterion before you open the quotes. The MakeBiz Technologies procurement agent builds this table from emails and files on its own: one agent is AED 5,000 one-off to implement, and the demo is free.

MakeBiz Technologies · 11 November 2026 · 7 min read

Compare line items, not quote totals

A quote total is almost never comparable as it stands. One supplier priced nine items out of ten, another quoted per box instead of per piece, a third included delivery and a fourth did not. Put the totals side by side and the winner is whoever left something out.

So each row in the table is a line item from your request, and each column is a supplier. Before you open any replies, lock the item list, the quantities and the base unit: piece, kilo, metre. Every quote then drops into the same grid, and gaps show up straight away.

Nine columns cover almost any purchase

For every item and every supplier, the same fields get filled in. This template is a good place to start:

ColumnWhat to recordHow to normalise it
Unit pricePrice from the quote and the unit it refers toConvert to the base unit of the request
Currency and rateQuote currencyConvert to AED at the rate on the comparison date, and record both
VATIncluded, on top or not statedPrice excluding VAT, tax in its own column, "not stated" means a question to the supplier
DeliveryDelivered to warehouse, ex-works, who pays freightAdd the delivery cost to the price or show it as a separate line
Lead time and stockEx-stock in the UAE or made to orderDays from order to delivery
Payment termsAdvance, credit terms, instalmentsAdvance share and credit period in days
Minimum orderMOQ and pack multiplesCheck your quantity meets it
Warranty and returnsPeriod and conditionsOne wording for all suppliers
Quote validityDate the price holds untilDo not compare an expired quote without reconfirmation

MakeBiz Technologies template. Add columns for your category: certificates, country of origin, after-sales service.

A word on currency and VAT: the standard UAE VAT rate is 5%, and if one quote includes it and another does not, that gap can easily outweigh the difference between two close offers. We covered four traps like this in our news piece on where money leaks when comparing suppliers.

Set the weights before you open the quotes

Weights invented after the fact quietly bend towards the supplier someone already likes. So write them into the purchase record up front. A hypothetical set for consumables: price 50, lead time 20, payment terms 15, track record 15. For an urgent order you raise the lead time weight, for a large batch payment terms and minimum order matter more.

Scoring is simple: the supplier with the lowest price gets 10 points on price, the others get proportionally less. Lead time works the same way. The total is the sum of scores multiplied by the weights.

Track record comes from history, not gut feeling: how often a supplier missed a date, changed the price after quoting or went silent. You only have that data if purchasing runs in a CRM rather than in personal spreadsheets. How to set up the request process itself is in our guide to procurement automation.

We build your quote comparison table

The procurement agent reads quotes from email and messengers and puts them on one basis. AED 5,000 one-off

Book a demo

The agent builds the table from emails and files

Done by hand, it looks like this: the buyer opens every email, hunts for the price in a PDF, types it into Excel, converts boxes to pieces and hopes nothing was missed. The procurement agent does the same job by the rules you set:

  • picks up quotes from email and messengers connected to the CRM
  • reads PDFs, Excel files, scans and email text and maps the figures to request line items
  • converts units and currency at your rate and separates VAT
  • keeps the source of every value, the file and the spot in it, so it can be checked in one click
  • flags missing items, unstated VAT, expired quotes and prices far from the item's history

If something is missing, the agent sends the supplier a clarifying question and waits for the answer. How AI reads documents and where it stops is covered in our guide to invoice and document recognition.

The recommendation explains the choice, it does not make it

Once the table is complete, the agent scores it with your weights and writes a short note: why supplier B comes first, what the risk is with supplier A, which items to re-request from C. The buyer decides. If they pick someone other than the top scorer, the reason goes into the record in one line, so it can be found six months later.

The boundary is the same as in any agent work: it handles documents and numbers, while negotiation, exceptions and signatures stay with a person. More on how roles split between an agent, an automation rule and an employee on our AI in Bitrix24 page.

Keep the table with the decision

A comparison saved in someone's personal file is gone by the next purchase. In a CRM the table stays in the record together with the original quotes, the chosen supplier and the reason. In Bitrix24 this is a purchasing smart process, see our Bitrix24 development page.

After a few months those records add up to a price history for every item and supplier. It reads well on a BI analytics dashboard: the Basic plan is AED 300 a month, with the first 14 days free. All prices are on our pricing page.

A worked example: four quotes for consumables

A hypothetical company asks four suppliers to quote on ten items. The first has the lowest total, but two items are missing and VAT is not stated. The second quotes per box of 12. The third offers made to order with a long lead time. The fourth includes delivery to the warehouse. Once everything is on one basis, the first quote goes back for clarification, and the real choice is between the second and the fourth, settled by the lead time weight agreed in advance.

Questions and answers

How many suppliers should we compare per purchase?

There is no fixed rule: for routine purchases three to five is common, for a large one-off order you ask more. What matters is that everyone gets the same specification and the same reply deadline.

What if a supplier does not state VAT?

Do not guess, ask in writing. Until they reply, mark the quote as incomplete, otherwise a 5% gap can make the choice for you.

Can we compare quotes in Excel?

Yes, if there is one template for all purchases and the table is kept with the decision. Problems start when every buyer has their own file and the price history leaves with the employee.

How does the agent get supplier quotes?

From email and messengers connected to the CRM. It reads PDFs, Excel files and email text, maps the figures to request line items and records the source of each value.

How much does automated quote comparison cost?

The procurement agent on the Start package is AED 5,000 one-off, with support at 10% of the implementation fee per month. We show the agent on your own process for free in 30 to 40 minutes.

Show us one of your purchases

Tell us how many suppliers usually reply and what format their quotes come in. We reply within a business day

By clicking the button you agree to the privacy policy

CallWhatsAppRequest