Price comparison sheet: what it is and how to build one without losing your afternoon to retyping

You asked five suppliers for a price. Five answers came back, each in its own way: a PDF from their system, a WhatsApp photo, a messy spreadsheet, a crooked scan. Now you have to decide who to buy each item from. Without pulling it all into a single table, the choice turns into a guess — or a whole afternoon copying price after price into a spreadsheet. The price comparison sheet exists to solve exactly that.

What a price comparison sheet is

A price comparison sheet is the table that compares, side by side, the prices of several suppliers for the same items. Each purchase item takes a row. Each supplier takes a column. And each cell shows what that supplier charges for that item. It's also called a quote comparison sheet — or a supplier comparison table, or a bid comparison sheet. The name changes; the idea is the same: turn several loose answers into a single comparable view.

It's the point in the procurement quotation where the proposals stop being scattered papers and become a decision. Without it, comparing ten items across five suppliers means opening five files at once and trying to hold the numbers in your head. With it, everything is on one screen.

The columns of a good sheet

A sheet that decides well doesn't have just "supplier and price." It needs the right columns for the comparison to be honest:

• Item / code. The product identifier, to match the same thing across suppliers.
• Description. The item's name, standardized — otherwise each proposal calls the same product something different.
• Unit. Piece, box, meter, roll. If one quotes by the box of 100 and another by the piece, the prices aren't comparable until they're in the same unit.
• Quantity. How much of that item you're going to buy. It's what gives the price its weight.
• Unit price per supplier. One column per supplier, with each one's value.
• Total per supplier. Unit price × quantity, summed down the column. That's the number that decides.
• Best option. The highlight of who wins each row and who wins overall.

The column most people forget is quantity. Without it, you compare only the unit price — and the unit price misleads when the volumes differ. The total (unit price × quantity) is what lets you truly add things up and compare.

A worked example

To make it concrete, here's a price comparison sheet built with three suppliers. The numbers below are only an illustrative example, with round values to keep it easy to read. Notice how each cell carries the unit price and the row total, and how the last row consolidates the total per supplier:

Item	Qty	Supplier A	Supplier B	Supplier C
Flexible cable 2.5 mm² 750 V (m)	200	$2.10 ea · $420.00	$2.30 ea · $460.00	$1.95 ea · $390.00
Single-pole breaker 16 A (pc)	50	$9.00 ea · $450.00	$8.40 ea · $420.00	$9.20 ea · $460.00
Electrical tape 19 mm (roll)	40	$4.50 ea · $180.00	$4.20 ea · $168.00	not quoted
Total per supplier	—	$1,050.00	$1,048.00	$850.00*

*Supplier C has the lowest total, but didn't quote every item — which is why the sheet has to show coverage, not just the final number. One glance and you already see two things: the lowest price on each row and the best option across the whole order. That's what the sheet is for.

Building it by hand eats your afternoon

Building this sheet in a spreadsheet is entirely possible. The problem isn't the table — it's what goes inside it. Each price comes out of a supplier file and goes, by hand, into the right cell. Multiply that by ten items and five suppliers and add up how much time slips away.

And it's not just the clock. Every retyped number is a chance to misplace a decimal. One extra zero in a cell contaminates the total and the decision — and that error doesn't show up right away, it shows up on the invoice, when it's already too late. Add the rework on top: a new proposal arrives or a supplier revises a price, and you redo the data entry and recheck every total.

That's why a lot of people start the sheet by extracting the quote to Excel before filling it in: pulling the items out of the PDF or photo without typing already cuts most of the work and the risk.

Decide by the total, not the lowest unit price

The most common mistake when using a sheet is choosing by the unit price. It looks like the obvious number, but it rarely decides the purchase. What hits your budget is the total: unit price multiplied by the quantity you're going to buy.

The lowest unit price isn't always the cheapest purchase. What decides it is the row total — and, in the end, the total for the order.

Look at the example above: for the flexible cable, Supplier C has the lowest unit price ($1.95) and also the lowest row total. But in other scenarios quantity flips the result — a cent less per piece becomes hundreds of dollars when you buy thousands of units, and the opposite happens too. That's why a good sheet always shows both numbers: the unit price, which you negotiate, and the total, which decides.

There's also a second axis: lowest price per item versus fewer suppliers. Buying each item from whoever has the lowest price can scatter the order across many suppliers, with more shipping and more paperwork. Sometimes concentrating with two or three comes out cheaper overall, even if some item isn't the cheapest in isolation. That trade-off is what you settle when you go to compare supplier quotes for real.

The sheet ready, straight from extraction

It's exactly the manual work of copying, standardizing, and adding up that OrbitQuote takes off your back. Instead of retyping cell by cell, you send the quotes as you received them — PDF, Excel, WhatsApp photo, crooked scan, even the supplier's catalog — and the AI reads each proposal, extracting the code, description, unit, quantity, and price of every item.

What gets extracted lands in a review table with inline editing: you check and adjust any field before comparing. With the proposals in the system, the sheet builds itself in the item × supplier structure — the same one you saw here, only filled in and summed without you typing a thing.

When it's time to decide, instead of marking cells with a pen, you pick the criterion and the sheet rearranges itself: lowest price per item, lowest total cost, fewer suppliers, or manual selection, with the totals always recalculated. In the end, you export the result per supplier as Excel, PDF, or text ready for WhatsApp to close the order. And if you want to refine it outside, you adjust the Excel and send it back for a new extraction.

The gain isn't only speed. It's stopping retyping what the machine has already read — and deciding the purchase with the right total in front of you.

To understand the whole picture, it's worth seeing the procurement quotation process step by step. And to take your first steps with the file, the help center shows how to upload the quote.

Frequently asked questions

What is a price comparison sheet?

It's the table that puts the prices of several suppliers side by side for the same items. Each item is a row, each supplier is a column. It's also called a quote comparison sheet or supplier comparison table.

What columns does a good price comparison sheet need?

Item or code, description, unit, quantity, each supplier's unit price, total per supplier (unit price × quantity), and the highlight of the best option. Without the quantity and the total, you compare only the unit price and get the math wrong.

Should I choose by the lowest unit price?

No. What hits your budget is the row total (unit price × quantity) and, in the end, the total for the order. A cent less per piece becomes hundreds of dollars when you buy thousands of units, and the opposite happens too.

Do I have to build the sheet by hand?

You can build it in a spreadsheet, but retyping price after price eats your afternoon and opens the door to decimal-point errors. OrbitQuote extracts the items from each quote and builds the sheet ready, with the total per supplier already calculated.