Reviewed & updated by WordNExcel Team — Updated November 10, 2026
A price quote template lets you give customers a clear, professional price before they commit to a purchase or a job. A good quote lists exactly what is included, shows the subtotal, any discount and tax, states the total and says how long the price is valid. On this page you can use the free price quote calculator above to work out a quick total, then download five free price quote templates in Excel: a product price quote, a service quote with hours and rates, and a sales quotation, plus a volume tier price quote and a quote follow-up tracker.
Each file is a real, editable .xlsx spreadsheet created for this page. Line amounts, subtotal, discount, tax and total are calculated automatically, and the “valid until” date is set 30 days after the quote date. The templates also open in Google Sheets and LibreOffice Calc, and they print on one page or save as a PDF to email.
Price Quote Calculator
| Item | Qty | Unit price | Amount |
|---|
Runs in your browser; nothing is sent or saved. Tax is applied after the discount.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is a Price Quote?
A price quote, also called a quotation or estimate, is a document a seller sends to a potential customer stating the price for specific goods or services. It usually includes the seller’s and customer’s details, a quote number and date, a list of items with quantities and prices, the subtotal, discounts, taxes, the total and the terms, such as payment conditions and how long the quote is valid.
A quote and an estimate are often used interchangeably, but in many businesses a quote is a fixed price for a defined scope, while an estimate is an approximate figure that may change. Whichever word you use, make it clear on the document whether the price is fixed or approximate.
Price Quote vs. Invoice
A quote is sent before the sale, to win the work. An invoice is sent after the goods or services are delivered, to request payment. Many businesses use the same item list for both: once the customer accepts the quote, the details are copied onto an invoice with an invoice number and due date.
How to Use the Price Quote Calculator
The calculator at the top of this page gives you a quick total without opening a spreadsheet. Enter up to five line items with a quantity and unit price, then enter a discount percentage, a tax percentage and any shipping or other charges. The calculator shows the subtotal, the discount, the tax, which is applied after the discount, and the final quote total. It runs entirely in your browser and nothing you type is sent or saved. When you are happy with the numbers, download a template below to send a formal quote.
Download the Free Price Quote Templates
All five templates are hosted on this website and free to download. The preview shows each spreadsheet as it prints.
1. Price Quote Template

The product price quote has a header for your company and the customer, followed by the quote number, quote date and a “valid until” date that is calculated 30 days after the quote date. The item table has up to twelve lines with description, quantity, rate and amount. Below the table, the sheet calculates the subtotal, applies a discount percentage, adds tax at the rate you enter and shows the total. A terms line and a customer acceptance line with signature and date complete the quote.
2. Service Quote Template

The service quote uses the same layout but with hours instead of quantity, so it suits consultants, designers, developers, cleaners, tradespeople and other service providers. Enter each task with the estimated hours and the hourly rate, and the line amounts and totals are calculated. Use the terms line to explain what happens if the work takes longer than estimated, for example “additional hours billed at the same rate with prior approval”.
3. Sales Quotation Template

The sales quotation is a more formal version for B2B sales, with a darker header suited to companies that send quotations as part of a tender or purchasing process. It includes the same calculations and acceptance section. Many purchasing departments will issue a purchase order once they accept the quotation, quoting your quotation number.
4. Volume Tier Price Quote

A quote that applies quantity discounts automatically. Set two volume thresholds and their discount rates at the top, for example 5% from 20 units and 12% from 100 units. For each line, enter the item, quantity and list price; the sheet picks the right tier discount, shows the net unit price and the line total. Wholesalers, printers and manufacturers use tiered pricing to reward bigger orders without negotiating every line by hand. Change the thresholds to match your price book, and keep the list price visible so the customer sees the saving.
5. Quote Follow-Up Tracker

Most lost quotes are not lost on price; they are forgotten. Log every quote with its number, client, date sent, amount and status (draft, sent, negotiation, won, lost or expired). The sheet sets a follow-up date seven days after sending and highlights it when it is due. The header shows how many quotes are open, their total value and your win rate. Review it every Monday and call the oldest open quotes first. Over a few months, the win rate tells you whether your pricing or your follow-up needs the most work.
What to Include in a Price Quote
- Your business details. Name, address, phone, email and any registration or tax number.
- The customer’s details. Name, company, address and contact person.
- Quote number and date. A unique number makes it easy to find and reference the quote.
- Validity period. How long the price is valid, often 14, 30 or 60 days.
- Itemized list. Clear descriptions, quantities or hours and unit prices.
- Totals. Subtotal, discounts, tax, shipping and the final total.
- Terms. Payment terms, deposits, delivery times and what is not included.
- Acceptance. A line for the customer to sign or a note on how to accept.
How to Write a Winning Quote
- Understand the request. Ask questions so you quote for exactly what the customer needs.
- Be specific. List each item or task separately rather than one lump sum.
- Show what is included. Mention delivery, installation, revisions or warranties where relevant.
- State what is excluded. Avoid misunderstandings by noting anything not covered.
- Price clearly. Show the tax and any discount separately so the customer understands the total.
- Set a validity date. Protect yourself against changes in costs.
- Send it promptly. A fast, professional quote often wins the work.
- Follow up. Contact the customer a few days later to answer questions.
Discounts and Taxes in Quotes
If you offer a discount, show it as a separate line so the customer can see the saving. In the templates, the discount is a percentage of the subtotal, and tax is calculated on the discounted amount, which is the usual approach. Tax rules vary by country, region and type of product or service, so enter the rate that applies to you, or set it to zero if you are not registered for sales tax or VAT. If some items are taxable and others are not, list them in separate quotes or adjust the tax cell to a blended amount, and check with an accountant if you are unsure.
Pricing Tips for Small Businesses
Make sure your prices cover all your costs, not just materials. Include your time, travel, equipment, insurance and overheads, and add a profit margin. For service work, track how long similar jobs have taken before and use that to estimate hours. Review your prices at least once a year, and keep a copy of every quote so you can see which prices win work and which do not.
Following Up on Quotes
Many quotes are not accepted simply because the customer got busy. Keep a short list of open quotes with the quote number, customer, value, date sent and valid-until date, and follow up a few days after sending and again shortly before the quote expires. A polite question such as “Do you have any questions about the quote?” often moves the decision forward. If a customer declines, ask why, because the answers help you price and present future quotes better.
Turning an Accepted Quote Into an Invoice
When the customer accepts, save a copy of the signed quote and create an invoice using the same items, quantities and prices. Reference the quote number on the invoice. If the scope changed during the work, list the changes clearly on the invoice and make sure the customer agreed to them before you start.
Sending Quotes as PDF
Before sending, save the quote as a PDF so the layout and formulas cannot be changed by accident. In Excel, choose File > Save As and select PDF, or use File > Export. Name the file with the quote number and customer name, for example “Q-0001 Client Name.pdf”, so it is easy to find later. Keep the original spreadsheet for your records and to convert into an invoice if the quote is accepted. In Google Sheets, use File > Download > PDF.
You can also check these important templates like the service invoice templates for billing after the quote is accepted, and the price list templates for publishing your standard prices.
You may also like the purchase order templates for orders your customers send back, and the sales proposal templates for larger bids that need more explanation.
Frequently Asked Questions
What is the difference between a quote and an invoice?
A quote is sent before the sale to state the price. An invoice is sent after delivery to request payment.
How long should a price quote be valid?
Many businesses use 30 days. Shorter periods suit prices that change often, and longer periods suit stable prices. The template sets the date 30 days after the quote date, which you can change.
Is tax calculated before or after the discount?
In these templates and the calculator, tax is calculated after the discount, which is the usual approach. Check the rules that apply to your business.
Can I use the quote templates in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All formulas work.
Does the calculator save my information?
No. The calculator runs in your browser and nothing you enter is sent or saved.
