Rate Quotation Format in Excel: A Practical Guide

How-to basics · Updated November 18, 2026

A rate quotation in Excel is an itemized document that shows what you will charge for specified goods or services, how each amount is calculated, and the terms under which the price is offered. Create columns for quantity, unit, rate, discount, and line total, then use formulas to calculate the subtotal and any applicable tax; clearly label the quote number, date, customer, and validity period.

What a rate quotation includes

A quotation, sometimes called a quote or price estimate, tells a prospective customer the proposed price for a defined scope of work or set of products. A rate quotation focuses on the unit prices behind that total: for example, a price per hour, per item, per kilometre, or per day. It is normally sent before work begins or a sale is agreed. It is not automatically an invoice, receipt, or proof of payment.

Excel is useful for quotations because it can calculate totals from rates and quantities while keeping the document easy to revise for different customers. A practical quote usually identifies both parties, describes what is being priced, and explains important conditions. Consider including:

  • Your business name and contact details, and the customer’s name and contact details.
  • A unique quotation number, issue date, and date through which the offer is valid.
  • Item or service descriptions, units, quantities, rates, discounts, and line totals.
  • Subtotal, any applicable tax, and the final quoted amount.
  • Scope, exclusions, payment terms, delivery details, and a way for the customer to accept.

The precise information needed depends on the transaction and local requirements. A clean layout helps readers understand the offer, but it does not replace checking the terms that apply to your business.

Plan the worksheet before entering prices

Start with one worksheet for the customer-facing quote. Put the business and customer details near the top, followed by the quotation number, date, and validity date. Leave enough space for a logo if you use one. Below that, make a single item table, with one row for each separately priced product or service. A consistent table is easier to review and less likely to hide a charge.

For the example in this guide, use columns A through G for the item table: A is item, B is description, C is quantity, D is unit, E is rate, F is discount, and G is line total. Put the headers in row 10 and the first item in row 11. Use rows 11 through 15 for up to five lines. Put the subtotal in G16, the tax rate in G17, the tax amount in G18, and the final total in G19. Label the corresponding totals in column F. If your quote has more items, add rows and adjust the subtotal range accordingly.

Choose units that make the rate unambiguous. For example, writing 75 as a rate is not enough by itself; the unit should clarify whether that is 75 per hour, per visit, or per item. If a service has a fixed project price rather than a measurable quantity, a quantity of 1 and a unit such as project can work, provided the description explains the scope.

Build the quote in Excel for Microsoft 365

Open a blank workbook and enter the labels and details in the planned positions. Use descriptive column headings such as Quantity, Unit, Rate, Discount, and Line total rather than relying on abbreviations a customer might not recognize. Keep the quote’s identifying information separate from the item table so that a reader can locate the customer, date, and reference number quickly.

  1. Enter business and customer details in the upper rows, and add a quotation number and issue date.
  2. Enter the item-table headings in row 10 and the product or service details in rows 11 to 15.
  3. Enter quantities, units, rates, and discounts as numbers or percentages, not as text containing currency symbols.
  4. Add formulas for line totals, subtotal, tax if applicable, and total.
  5. Review the calculations and terms, then save an editable workbook and prepare a customer-facing copy.

To make the item area easier to maintain, select the headings and item rows and choose Home > Format as Table. In the dialog, confirm the selected range and that the table has headers. This is optional; a regular formatted range also works. A table can make it easier to extend the item list, but make sure formulas and print settings still include every quote line.

Calculate line totals, subtotal, and tax

Assume row 11 contains a quantity of 12 in C11, a unit rate of 25 in E11, and a discount of 10% in F11. With quantity in column C, rate in E, discount in F, and the result in G, enter this formula in G11: =C11*E11*(1-F11). It returns 270, because 12 multiplied by 25 is 300 and a 10% discount reduces that amount by 30. Format F as Percentage so a value such as 10% is visible as a discount, rather than entering 10 to mean ten percent.

With the five line totals in G11:G15 and the subtotal to be displayed in G16, enter this formula in G16: =SUM(G11:G15). For an illustrative quote with line totals of 270, 320, and 285 in G11:G13, and blank or zero-value remaining lines, the result is 875. The total is the sum of the discounted line amounts.

Tax treatment varies by place, product, and service, so include a tax calculation only when appropriate to the quote. For an illustration only, with the subtotal in G16 equal to 875 and a tax rate of 8% entered in G17, put this formula in G18: =G16*G17. It returns 70. With the subtotal in G16 and tax amount in G18, enter this formula in G19: =G16+G18. It returns a quoted total of 945. These figures demonstrate spreadsheet arithmetic, not a recommendation about which tax rate to charge; check the applicable rules or consult a qualified professional.

If a discount is not offered, enter 0% in the discount cells or adapt the calculation consistently. Do not leave a cell blank if your workflow depends on staff understanding whether the discount was intentionally set to zero. For a quote with several tax categories or different tax treatment across items, a single tax-rate cell may not represent the calculation correctly; seek appropriate guidance and structure the worksheet to show the categories clearly.

Format rates and totals for readability

Make the rate and total columns display a consistent currency. Select the relevant cells and use Home > Number, then choose a currency or accounting number format. Choose the correct currency symbol for the quote; a symbol alone can be ambiguous when a customer operates in another country, so state the currency code or name in the document as well. The number format changes how a value appears, not the underlying arithmetic.

Format quantity as a number, discount and tax rate as percentages, and dates as dates. Use bold text or a restrained fill color to distinguish the final total from the line items. Keep descriptions readable and avoid merging cells inside the item table, since merged table cells can make sorting, copying, and editing more awkward. Use borders sparingly to separate the headings, item rows, and totals without making every cell visually heavy.

For print layout, choose Page Layout > Orientation if the table needs landscape orientation, and use Page Layout > Print Area > Set Print Area after selecting the portion of the worksheet that belongs on the quote. Check the result through File > Print before sending it. Excel for the web has a similar printing workflow, but some page-layout controls may be more limited than in the Windows desktop app. On Mac, the ribbon and print preview are arranged differently, so locate the equivalent Page Layout and print controls in that version rather than assuming every screen is identical.

Set clear quotation terms

A price without boundaries can lead to misunderstandings. State what the quoted rate covers, including quantities, service hours, delivery, installation, or other relevant scope. Identify exclusions that could change the price, and explain whether a change in scope requires a revised quotation. If the offer expires, include a specific validity date rather than a vague phrase such as prices may change.

Include payment timing and any deposit or delivery conditions only when they reflect your actual offer. If the customer must approve the quote, add a clear acceptance area or explain how to confirm. Avoid presenting an estimate as a guaranteed fixed price if it is conditional on a site visit, final measurements, or other information not yet known. The wording should match the calculations: for example, say whether a displayed amount includes tax or whether tax is added separately.

Quotation terms can have legal or tax implications, and requirements differ by location and type of work. Treat a reusable Excel template as a document aid, not as a substitute for professional advice on the terms your business should use.

Common errors and useful checks

A frequent mistake is typing currency symbols or words directly into cells that formulas need to multiply. Enter a numeric value such as 25 in the rate cell and apply a currency format. Another is entering a discount of 10 when the formula expects a percentage value of 10%; in Excel, the numeric value 10 is ten, not ten percent. Enter 10% or 0.1 for a ten-percent discount.

Before sharing the quote, check these points:

  • Confirm the formula is filled down for every item row and that the subtotal range covers all of them.
  • Check that blank item rows do not contain old rates or quantities from a previous quote.
  • Verify that discounts are applied to the intended items and that tax is calculated on the correct base.
  • Confirm currency, decimal places, customer details, quote number, date, and validity date.
  • Review the print preview for clipped descriptions, missing totals, extra blank pages, or unreadably small text.

Also test a simple line by hand. If a quantity of 2 at a rate of 50 with no discount does not produce 100, pause before sending the document and inspect the cell references and number formats. A displayed dash may mean the cell is formatted to show zero that way; it does not necessarily mean the cell is empty. Make sure the customer-facing sheet does not expose internal notes, cost prices, or other information that should not be included in the offer.

Save and share the finished quotation

Keep the Excel workbook as the editable source, using a filename that helps identify the customer and quote reference. Before sending it, save a separate PDF if the customer only needs to read or print the quotation. In Excel for Microsoft 365 on Windows, use File > Export > Create PDF/XPS Document, or use File > Save As and choose PDF as the file type. Review the PDF after creating it; exporting does not guarantee that a poorly set print area or page break will look right.

Send the file through a suitable channel and retain a copy of what was issued. If the customer requests a change, update the quote deliberately and make the new version identifiable, for example with a revised date or version note. This reduces the risk that both parties refer to different prices or scope. Do not overwrite the only record of an accepted or previously issued quotation if your recordkeeping process requires preserving it.

Frequently Asked Questions

How do I make a quotation in Excel?
List the business and customer details, quote reference and date, then create an item table with descriptions, quantities, units, rates, discounts, and totals. Add formulas for the line amounts and subtotal, include tax only when applicable, and check the print preview before sharing.

What is the formula for a quotation total in Excel?
For a line with quantity in C11, rate in E11, and discount in F11, =C11*E11*(1-F11) calculates its discounted amount. Add line totals with a SUM formula, then add any correctly calculated tax to the subtotal.

How do I calculate a rate per hour in Excel?
Enter the number of hours in a quantity cell and the hourly charge in the rate cell, then multiply them in the line-total formula. Label the unit as hour so the customer can distinguish an hourly charge from a fixed project fee.

Should I send an Excel file or a PDF quotation?
A PDF is often more convenient when the customer only needs to view or print a stable copy. Keep the workbook for editing and calculation, and inspect the exported PDF to confirm that all lines, terms, and totals appear as intended.

Can I reuse one Excel quotation template?
Yes. Save a clean template with the layout and formulas, then make a new copy for each quote. Before sharing, replace previous customer information and check that no old quantities, rates, discounts, notes, or totals remain.

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.