<!-- kaynak: https://aksco.com.tr/en/insights/quotation-comparison-template/ · dil: en · güncelleme: 2026-11-07 -->
<!-- başlık: Quotation Comparison Template — Free Excel Sheet -->
<!-- açıklama: Free quotation comparison template in Excel: lowest price per line, missing lines and a comparable total. Four reasons quote totals mislead. -->
# Quotation Comparison Template: Compare Supplier Quotes Line by Line

> **Question:** How do you build a quotation comparison sheet?
> **Short answer:** A quotation comparison sheet sets the unit prices that several suppliers quoted for the same item list side by side, line by line; it shows the lowest price on each line and compares totals only over the lines every supplier quoted.
> Source: https://aksco.com.tr/en/insights/quotation-comparison-template/ · Last updated: 2026-11-07 · Publisher: AKSCO Ticaret ve Tedarik

A free Excel sheet that sets four suppliers’ unit prices side by side, separates missing lines and gives a comparable total — and the four situations that make grand totals mislead.

Published: 2026-11-07 · Last updated: 2026-11-07 · 4 min read · Prepared by AKSCO · [Editorial standards](https://aksco.com.tr/en/editorial-standards/)

Contents

1. Short answer
2. Why the grand total misleads
3. Which fields the sheet needs
4. How to use the template
5. Is the lowest price the only criterion?
6. Ask for quotes in the same format

## How do you build a quotation comparison sheet?

**A quotation comparison sheet sets the unit prices that several suppliers quoted for the same item list side by side, line by line; it shows the lowest price on each line and compares totals only over the lines every supplier quoted.** Before totals are compared, three things are made equal: the unit (box or piece), the tax basis (all excluding VAT) and the scope (missing lines). Terms other than price — lead time, payment terms, quotation validity, freight and equivalents — are kept in separate rows of the same sheet.

## Free quotation comparison template (Excel)

A ready sheet for four suppliers and forty lines: enter the unit prices, and the amounts, the lowest price on each line, the number of missing lines and the comparable total are calculated automatically.

- [XLSX — Quotation comparison template (Excel) — 4 suppliers × 40 lines · lowest unit price on each line in green · number of suppliers quoting each line · “Tie” on equal prices · missing lines · total of lines every supplier quoted · rows for lead time, payment, validity, freight and equivalents · how-to sheet](https://aksco.com.tr/assets/docs/aksco-quotation-comparison-template.xlsx)

No sign-up. Supplier names and prices in the example lines are made up; delete them and enter your own quotes. The template does not choose a supplier.

## Why the grand total misleads

Putting two grand totals side by side is the quickest comparison, but the result is wrong if any of these four situations applies:

Four situations that make quotation totals incomparable

| Situation | What happens | How the sheet handles it |
| --- | --- | --- |
| Missing lines | A supplier that did not quote a line looks cheaper on the total. | The cell is left blank; the summary shows the number of missing lines and, separately, the total of the lines every supplier quoted. |
| Different units | One quotes per box, another per piece; the unit prices cannot be compared. | Each line carries one unit; a price quoted in another unit is converted to it first. |
| Mixed tax basis | If one quote includes VAT and another does not, the gap is the VAT. | All unit prices are entered excluding VAT. |
| Freight and equivalents | A quote with freight charged separately, or with an equivalent product, may not price the same job. | Marked per supplier in the terms rows. |

In the template’s example, Supplier B did not quote the gloves. On the all-lines total B looks cheapest (A 1,297.00, B 1,030.00, C 1,284.00); on the two lines all three suppliers quoted, B is the most expensive (A 1,012.00, B 1,030.00, C 1,020.00).

**Add AKSCO’s quote to the comparison**

Send the same item list to AKSCO — for standard items you get a written, line-by-line quote within 1 business day, with VAT shown separately.

- [Office & Stationery Supplies](https://aksco.com.tr/en/products/office-supplies/)
- [Cleaning & Hygiene Products](https://aksco.com.tr/en/products/cleaning-hygiene/)
- [Safety Equipment & PPE](https://aksco.com.tr/en/products/safety-ppe/)
- [Office Kitchen & Breakroom](https://aksco.com.tr/en/products/office-kitchen-breakroom/)
- [Tools & Hardware](https://aksco.com.tr/en/products/tools-hardware/)
- [IT Hardware & Technology](https://aksco.com.tr/en/products/it-hardware-technology/)

[Send your item list](https://aksco.com.tr/en/request-a-quote/) [All product groups](https://aksco.com.tr/en/products/)

## Which fields the sheet needs

Sections of a quotation comparison sheet

| Section | Fields |
| --- | --- |
| Details | Purchase or project, request number and date, currency, prepared by |
| Suppliers and terms | Supplier name, quotation date, validity, lead time, payment terms, whether freight is included, whether equivalents were offered |
| Line items | Line number, item description and specification, unit, quantity |
| Supplier columns | Unit price and amount (quantity × unit price) for each supplier |
| Line result | Number of suppliers quoting, lowest unit price, lowest from (“Tie” on equal prices) |
| Summary | Lines quoted and missing, total of quoted lines, total of lines every supplier quoted, number of lines where lowest |

## How to use the template

1. Fill in the details and the supplier names at the top; a column without a name is ignored, and a price typed into it turns red.
2. List the items in the order you sent them to suppliers, in one unit each.
3. Enter each supplier’s unit price in its own column, excluding VAT; leave a line blank if it was not quoted. The price cell does not accept 0 or text.
4. The lowest unit price on each line turns green; on equal prices the last column shows “Tie”.
5. Read the totals from the comparable total row of the summary and weigh them against the terms rows.

## Is the lowest price the only criterion?

No. A longer lead time, prepayment, a short validity period, freight invoiced separately or an equivalent offered instead of the specified product can cancel out a lower unit price. That is why the template does not pick anyone: the terms sit in the same sheet above the prices, and the buyer decides.

## Ask for quotes in the same format

Comparison is much quicker when quotes arrive in the same format. Send every supplier the same [request for quotation](https://aksco.com.tr/en/insights/request-for-quotation-rfq-template/) with line numbers, units and quantities already filled in, and the answers come back in the same order.

## Frequently Asked Questions

Should prices in a quotation comparison include VAT? 

They should all be on the same basis; the template asks for unit prices excluding VAT. If a supplier quoted including VAT, take the VAT out before entering the price. Rates can differ from line to line, so do it line by line.

What if a supplier did not quote some lines? 

Leave those cells blank. The summary shows that supplier’s missing lines, and totals are read from the comparable total row, which covers only the lines every supplier quoted.

What does the sheet show when two suppliers quote the same price? 

The last column on that line shows “Tie” and both prices turn green. The template does not choose; check lead time, payment terms and validity.

How many suppliers and lines does it hold? 

Four suppliers and forty lines. A supplier column without a name is left out of the calculations.

## Related guides

### Purchasing Procedure Template

Steps from request to payment, approval limits and records — free Word.

[Read more](https://aksco.com.tr/en/insights/purchasing-procedure-template/)

### Request for Quotation (RFQ) Template

Ask every supplier for prices in the same format — free Excel.

[Read more](https://aksco.com.tr/en/insights/request-for-quotation-rfq-template/)

### Supplier Evaluation Form Template

Score suppliers on more than price — free Word and Excel.

[Read more](https://aksco.com.tr/en/insights/supplier-evaluation-form-template/)

### Purchase Order Form Template

Place the order with the supplier you chose.

[Read more](https://aksco.com.tr/en/insights/purchase-order-form-template/)

### Supplier Consolidation Transaction Cost Calculator

What moving tail spend to fewer suppliers saves.

[Read more](https://aksco.com.tr/en/tools/supplier-consolidation-calculator/)

## Send your list — your quote is ready within 1 business day.

A list, a photo or an Excel file — whatever is easiest. On standard items we aim to quote the same business day. Custom production, imports or 50+ line lists can take longer; when they do, we tell you the timeline in writing on the day we receive the request.

[Request a Quote](https://aksco.com.tr/en/request-a-quote/)[ Send an Email](mailto:info@aksco.com.tr?subject=Quote%20request%20%E2%80%94%20AKSCO&body=Hello%2C%0D%0A%0D%0APlease%20quote%20for%20the%20list%20below%20%28or%20attached%29.%0D%0A%0D%0ACompany%3A%0D%0ADelivery%20city%20and%20country%3A%0D%0AWhen%20needed%3A%0D%0AItems%20%28product%20%E2%80%93%20quantity%20%E2%80%93%20brand/model%20if%20any%29%3A%0D%0A%0D%0A)[Message on WhatsApp](https://wa.me/905343356922?text=Hello%2C%20I%20would%20like%20a%20quote.%0ACompany%3A%0AItems%3A%0ADelivery%20city%3A)

---

AKSCO Ticaret ve Tedarik — https://aksco.com.tr
AKSCO Ticaret ve Tedarik · Esentepe Mah. Talat Paşa Cad. No:5 İç Kapı No:1, Şişli/İstanbul
Türkiye'nin 81 ili ve uluslararası sevkiyat
info@aksco.com.tr · +90 534 335 69 22
