Free Excel Sales Quotation Template — Professional Quotes with Tracking
Create professional sales quotations with automatic line-item calculations, discount handling, and a quote tracking dashboard to monitor win rates.
In B2B sales, the quotation is the first step toward closing a deal. This template lets you create professional quotes quickly and track every quotation from draft to won or lost — all in one workbook.
Key Features
📋 Quotation Builder
- Client company, contact person, and auto-generated quote number
- Pull products/services from your item database
- Enter quantity and unit price — subtotal, tax, and grand total calculated automatically
- Discount support — per-line-item or overall percentage discount
- Validity date with automatic red warning when expiration approaches
📦 Product / Service Database
- Pre-register frequently quoted items with code, name, and standard price
- On the quote sheet, enter an item code and the name and price auto-fill
- Keeps pricing consistent across all your quotes
📊 Quote Tracking Dashboard
- All quotations listed on one sheet with current status
- Status options: Draft / Sent / Won / Lost / Expired
- Monthly quote volume and win rate calculated automatically
- Expiring quotes highlighted for follow-up
How to Use
Step 1: Set Up Your Item Database
In the “Items DB” sheet, register your products or services with codes, descriptions, and standard unit prices.
Step 2: Create a Quotation
On the “Quotation” sheet:
- Select the client (pulls from customer database)
- Set the validity period
- Enter item codes — names and prices auto-fill
- Adjust quantities and apply discounts
- Save as PDF for sending
Step 3: Track Your Quotes
After sending, update the status in the “Quote List” sheet. Mark won deals with the close date and final amount.
Tips
Track Competitor Pricing
Use the notes column to record competitor quote amounts. Over time this builds a pricing intelligence dataset.
Renew Expired Quotes
Expired quotes are automatically flagged. To re-quote, duplicate the row and update the date — a new quote number is generated automatically.
FAQ
Can I create quotes in foreign currencies?
Yes. Change the currency symbol and enter the exchange rate to display both local and foreign currency amounts.
Can multiple people create quotes simultaneously?
Convert to Google Sheets for real-time collaboration. The auto-numbering feature may need minor adjustment.