Excel Template for Quotation Comparison: Build One

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, create supplier columns in B:D, enter each quote’s comparable costs in rows 5:9, and calculate a total in row 10. With supplier names in B4:D4, goods subtotals in row 5, delivery in row 6, other fees in row 7, discounts in row 8, and quoted tax in row 9, enter =SUM(B5:B7)-B8+B9 in B10 and fill it right. This simple quotation comparison template makes cost differences visible while leaving room to weigh delivery, specifications, warranty, and other non-price factors.

What a quotation comparison template should do

A quotation comparison, sometimes called a bid comparison or quote tabulation, puts offers for the same purchase into a consistent format. Instead of switching between PDFs, emails, and spreadsheets, you can inspect each supplier’s price and terms side by side. The workbook should support a decision, not make one automatically: the lowest number is not always the best offer if it excludes an important requirement or carries a longer delivery time.

The most useful template separates two kinds of information:

  • Commercial figures: price, delivery, setup or installation, discounts, quoted tax, and the resulting total.
  • Evaluation details: whether the supplier meets the specification, delivery timing, warranty, payment terms, and any other criteria that matter for this purchase.

Record the source and context of the figures as well. A quote date, expiry date, currency, supplier contact, and notes about exclusions help someone reviewing the workbook understand what was compared. These details are especially important when offers arrive at different times or use different assumptions.

Set up the workbook and enter the quotes

Start with a worksheet named Quote Comparison. Put a descriptive title and purchase reference near the top, then use row 4 for supplier names: A4 can say Cost item and B4:D4 can hold Supplier A, Supplier B, and Supplier C. Add the cost rows described in the opening paragraph, followed by a total row. The example can be expanded with additional supplier columns or additional cost rows.

Before entering figures, establish a common basis for comparison. Confirm that every supplier is pricing the same quantity, model or service scope, delivery destination, and required quality. If the offers use different currencies, do not simply add the figures together. Either compare them in their original currencies with the limitation clearly shown or apply a documented exchange-rate assumption and note its date and source.

Use the same units throughout. For a purchase of 10 identical items, compare the total for 10 rather than one supplier’s unit price against another supplier’s package price. If one supplier quotes a package and another quotes line items, calculate or obtain a comparable subtotal before ranking the offers. Keep the original quote files so the spreadsheet can be checked against the source.

A practical set of fields alongside the cost table includes supplier name, quotation reference, quote date, expiry date, currency, lead time, and the person who entered the figures. These are useful records, not decorative extras: an expired offer or a quote for a different delivery location may not be directly comparable.

Calculate comparable total cost

In the example layout, rows 5 through 9 contain amounts for each supplier. Row 5 is the goods or service subtotal; row 6 is freight or delivery; row 7 is setup, installation, or other fees; row 8 is a discount entered as a positive amount; and row 9 is the tax amount quoted by the supplier. The formula in B10 adds the first three amounts, subtracts the discount, and adds quoted tax. Copy it from B10 across to C10 and D10 to calculate the other suppliers’ totals.

For example, suppose Supplier A lists 1,200 for goods, 35 for delivery, no additional fee, a discount of 20, and quoted tax of 96. The result is 1,200 + 35 + 0 − 20 + 96 = 1,311. Suppose Supplier B lists 1,150, 60, 25, 0, and 92 in those rows. Its total is 1,327. Supplier A is cheaper by 16 in this illustration, but that alone does not settle which offer is preferable.

Tax treatment varies by location, product, and transaction. The template deliberately uses the tax amount stated in the quote rather than assuming a tax rate or deciding which charges are taxable. If tax is not included in any quote, enter zero consistently and label the comparison as excluding tax. If some quotes include tax and others do not, ask for clarification or adjust the comparison on a clearly documented, consistent basis. Do not present a tax estimate as a supplier-confirmed total.

With supplier totals in B10:D10, enter =RANK.EQ(B10,$B$10:$D$10,1) in B11 and fill right to rank the totals from lowest to highest. For the example totals of 1,311, 1,327, and 1,397, the ranks are 1, 2, and 3. A rank is a quick visual aid, not a quality score; it does not account for specification, service, or risk.

Format the cost cells as the relevant currency using Home > Number, and make sure the displayed decimal places are appropriate. Keep the underlying values numeric rather than typing currency symbols into the cells. That lets Excel calculate totals correctly and makes it easier to change the display format if needed.

Compare non-price criteria fairly

Many purchases need a structured way to compare factors beyond price. Add a separate evaluation table, for example beginning in A16. Put criteria in A17:A21, weights in B17:B21, and supplier scores in C17:E21, with supplier names in C16:E16. One possible set of criteria is specification fit, delivery, warranty, support, and payment terms. Choose criteria that are relevant to the particular purchase rather than using a generic list without thought.

For a straightforward weighted score, give each criterion a weight in points that adds to 100, and score each supplier from 1 to 5 using the same definitions. For instance, define 1 as poor or does not meet the requirement, 3 as acceptable, and 5 as strong; decide what 2 and 4 mean before scoring. A high score should always mean a more favorable result. If a criterion such as lead time is better when shorter, translate the actual days into a consistent score rather than awarding more points for a larger number of days.

With weights in B17:B21 that add to 100 and Supplier A’s 1-to-5 scores in C17:C21, enter =SUMPRODUCT($B$17:$B$21,C17:C21)/SUM($B$17:$B$21) in C22. For weights of 30, 25, 20, 15, and 10 and scores of 3, 5, 4, 3, and 4, the result is 3.8 out of 5. Copy the formula across to D22 and E22 for the other suppliers. This average is a decision aid; it is not a financial measure or an objective guarantee of supplier performance.

Write down the reason for subjective scores, especially when two evaluators are involved. A short note such as meets all required dimensions or warranty is shorter than requested is more useful than an unexplained number. You can also make a requirement a pass/fail gate: a supplier that fails a mandatory safety, technical, or service requirement may be excluded from scoring, according to the organization’s own purchasing process.

Use the template step by step

  1. Define the purchase. Note the quantity, specification, delivery destination, and required date before comparing offers.
  2. Collect complete quotes. Record quote dates, validity, currency, inclusions, exclusions, and supplier contact details.
  3. Normalize the figures. Put comparable costs on the same quantity and scope. Ask suppliers to clarify missing or ambiguous charges instead of silently guessing.
  4. Enter and check the cost data. Compare each entered amount with the original quote, then verify the formula totals and ranking.
  5. Score the criteria. Apply the agreed definitions consistently and add a brief explanation for scores that may be questioned.
  6. Review the outcome. Compare the total cost, mandatory requirements, weighted scores, and any material risks before recording the decision and its rationale.

For easier review, use descriptive headers, bold the total row, and keep assumptions near the figures they affect. Excel’s Home > Conditional Formatting > Color Scales can add a visual scale to a selected range, but colors should not be the only way to communicate a result. A printed or exported copy should still have clear labels and readable numbers. If the workbook will be shared, protect its meaning with a note that explains what the scores and cost rows include.

Common problems and how to avoid them

Comparing unlike offers: A low quote may cover fewer units, a different specification, or delivery to a different location. Confirm scope first and flag any difference that cannot be normalized.

Missing costs: Installation, packaging, service charges, minimum-order fees, or delivery can change the total. Use a separate row for each material charge and enter zero only when the charge is confirmed absent or not applicable. A blank cell can mean unknown, so do not treat it as proof of zero cost.

Mixing tax assumptions: One quote may include tax while another excludes it. Label the basis and seek comparable figures. The sample formula adds the tax amount entered; it does not determine whether tax is legally due or correctly calculated.

Overweighting price: A large weight for price can dominate the score even when an essential requirement is weak. Set criteria and weights before looking at the final result where practical, and explain why each factor matters. Keep mandatory requirements separate from preferences.

Changing the scoring rules mid-way: Scoring after seeing supplier names or prices can introduce inconsistent judgments. Write simple definitions first, apply them to each supplier, and record the evidence. A score should be traceable to the quote or another documented source.

Relying on a formula without checking inputs: Excel can calculate a total accurately from incorrectly entered numbers. Verify units, decimal placement, discounts, and whether a fee is already included in a supplier’s quoted total. If the quote already gives an all-inclusive total, avoid adding its component charges again.

When to use another approach

A small purchase with a few suppliers can work well in one worksheet. For a recurring process, consider a separate worksheet for each purchase or a structured table of quote records, with a summary sheet for decisions. Keep a clean copy of the original template so old data does not carry into a new comparison. Restrict editing or store the file in an approved shared location if several people need to review it.

For a formal tender, regulated purchase, or complex project, a spreadsheet may be only one part of the process. An organization may require an approved procurement system, an evaluation panel, documented approvals, or specific record-retention procedures. Follow those requirements rather than treating a template as a replacement for them. For a very simple purchase, a side-by-side table in a document may be enough, but it will not recalculate totals as conveniently as Excel.

Frequently Asked Questions

Is there a built-in Excel quotation comparison template?
Excel may offer workbook templates through its template gallery, but available templates can vary. A custom sheet with supplier columns, comparable cost rows, and an evaluation section is often easier to adapt to a specific purchase. The layout and formulas above can be entered into a blank workbook.

How many supplier quotes should I compare?
There is no universal number that fits every purchase. Compare the offers available under the applicable purchasing rules, while checking that each one covers the same scope. Some organizations or purchasing situations have their own competition or approval requirements.

Should I choose the supplier with the lowest quotation?
Not automatically. First confirm that the supplier meets mandatory requirements and that the total includes comparable costs. Delivery, warranty, reliability, service, and documented risks may matter as much as price, depending on the purchase.

How do I compare quotes in different currencies?
Do not rank unconverted amounts as if they were in the same currency. Obtain comparable currency figures or apply a clearly stated conversion rate, date, and method consistently, then note that exchange rates can change. Include any relevant conversion or transaction charges if they affect the buyer’s actual cost.

Can I use this template for services as well as products?
Yes. Replace goods subtotal with the relevant service fees and add rows for recurring charges, setup, travel, or other applicable costs. Compare the same service period, deliverables, service levels, and exclusions so that the totals describe equivalent offers.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.