OmniDocQuotation Format in Excel: Build a Price Quote Sheet
Build a price quotation sheet in Excel with formulas for quantities, unit prices and totals, plus a layout checklist and the common mistakes to avoid.
If you searched for a quotation format in Excel free download, you probably want a sheet that already has the layout and only needs your numbers. The problem with many quote sheets is that the totals are typed in by hand. Change one quantity, forget to update the total, and the customer receives a quote that does not add up.
A downloaded template can save time, but it is only a starting point. This guide shows you how to build a price quote sheet in Excel with formulas for quantities, unit prices and totals, so the math updates itself. You will get a simple layout, the formulas to use, a checklist of the parts every quote should include, and the mistakes to check for before you send it.
Whether you build the sheet from scratch or adapt a template, the steps are the same. Set up the fixed sections first, then add the item table and formulas, and test the result with real numbers.
Which quotation format in Excel should you use? The short answer
Use one sheet with a fixed header, a single item table and a totals block driven by formulas. Keep a blank master copy and duplicate it for each new quote, rather than editing the last quote you sent.
| Your situation | What to do | Why |
|---|---|---|
| You quote a handful of products or services | Use one item table with 5 to 15 blank rows | The layout stays simple to read and print |
| You quote the same services to many customers | Save a blank master copy and duplicate it for each quote | Formulas and terms stay intact from quote to quote |
| Your tax rate changes by customer or location | Put the tax rate in its own labeled cell and reference it | You change one cell instead of rewriting every total |
| You need to send the quote as a PDF | Set the print area to the quote and save a PDF copy | The customer sees a clean page without gridlines or helper cells |
| A template you downloaded has typed-in totals | Replace each total with a SUM formula or a multiplication formula | Totals stay correct when quantities change |
📊 The template at a glance
| Part | What goes in it | Suggested length |
|---|---|---|
| Header | Your business name, contact details, quote number and quote date | 4-6 lines |
| Customer block | Customer name, company, address and contact person | 3-5 lines |
| Validity and terms | Valid-until date, payment terms and delivery window | 3-4 bullets |
| Item table | Item code, description, quantity, unit price and line total | 5-15 rows |
| Totals block | Subtotal, discount (if any), tax and total | 4 rows |
| Notes | Exclusions, warranty and how to accept the quote | 2-3 sentences |
How to write each part
Header
Put your business details in fixed cells at the top of the sheet. Give each quote a number that follows a pattern, such as [year]-[number], so you can find it later.
Enter the quote date as a typed date, not a formula that returns today's date. A date formula changes every time the file is opened, which can make a sent quote look different from the copy on file.
Example: "Quote No. [year]-[number], dated [date]."
Customer block
Keep the customer name, company and contact in separate labeled cells. Separate cells make it easy to copy the block into the next quote without retyping the whole address.
Example: "Prepared for: [customer name], [company name]."
Validity and terms
State how long the price holds and when payment is due. Use plain wording so the customer does not need to ask what the terms mean.
Example: "This price is valid for [number] days from the quote date. Payment is due within [number] days of the invoice."
Item table
Use five columns: Item, Description, Quantity, Unit price and Line total. The line total is the quantity multiplied by the unit price.
Suppose the quantity is in column C and the unit price is in column D, starting in row 8. Enter this formula in E8 and fill it down through the blank rows:
=IF(C8="","",C8*D8)
The IF part keeps blank rows empty, so unused lines do not show zeros. Each row then calculates its own total as you type.
Example line: "Consulting, [number] hours at [rate] per hour, line total [amount]."
Totals block
Place the totals below the item table. Use simple formulas that refer to the cells above them:
- Subtotal: =SUM(E8:E22), covering all item rows
- Discount, if you use one: subtotal multiplied by a discount rate in its own cell
- Tax: the amount after discount multiplied by a tax rate in its own labeled cell
- Total: subtotal, minus discount, plus tax
Keep the tax rate in a separate labeled cell so you can see it and change it. Check that the subtotal matches the sum of the line totals before you send anything.
Notes
Use two or three sentences to say what is excluded and how the customer can accept the quote.
Example: "This quote excludes [item]. To accept, reply in writing before [date]."
Format it in the editor
You can build the sheet in UniCell, the spreadsheet tool included in the OmniDoc desktop client, which you can download at download.omnidoc.top. The same steps work in any spreadsheet app.
- Type the header and customer block into the top rows, and bold the labels so they stand apart from the entries.
- Add the item table with clear column names, then apply borders and a light fill to the table area only.
- Enter the line total formula in the first data row, test it with a sample quantity and price, and fill it down through the blank rows.
- Add the totals block below the table, then check that the total equals the subtotal plus tax using a simple test value.
- Set the print area to the quote, check the page in print preview, and save a PDF copy for the customer while keeping the spreadsheet file for future edits.
If a supplier sends your prices as a PDF, the PDF editor in the desktop client can export tables to Excel. Check every number against the original PDF before you use it in a quote, because the export may not match the source exactly.
Common mistakes
- Typing totals by hand instead of using formulas, so later edits leave the total wrong.
- Filling the formula into only the first few rows and forgetting the blank rows you may use later.
- Using a date formula for the quote date, so the date changes each time the file opens.
- Showing tax without a labeled rate, which leaves the customer unable to check the calculation.
- Copying a previous quote and leaving the old customer name, address or item prices in place.
- Sending the spreadsheet file with hidden rows, helper columns or test numbers still visible.
❓ FAQ
1. Is a quotation format in Excel free download safe to use?
Open the file on a computer that has security software running, and check for macros, external links and hidden sheets before you rely on it. Save a copy and review every formula, since a template may contain typed-in totals that do not match the items.
2. Should I use a Word template or an Excel sheet for quotes?
An Excel sheet works better when a quote has many line items, quantities or discounts, because formulas handle the math. A Word template suits a short quote with few numbers and mostly text.
3. Does an Excel quote template handle GST or other local tax rules?
A template can show tax as a separate line with a rate cell, but it cannot decide which rate applies to your sale. Confirm the rate and labeling rules with your accountant or local tax authority before you send the quote.
📝 Summary
A quotation format in Excel works well when the header, item table and totals stay in fixed places and formulas do the math. Start from a clean master copy for each quote, test the totals with sample numbers, and save a PDF for the customer. Check important figures every time, because a template only works as well as the numbers you enter into it.
