Free quotation template with the VAT already worked out
Excel, Word and PDF. In the Excel version you set your VAT rate once — 5% in the UAE, 15% in Saudi Arabia, 20% in the UK, 9% in Singapore — and every line's net, VAT and total calculates itself. No sign-up, no email, no watermark.
Free, no sign-up and no email required. Use them for your own business as you like.
How it works
- Step 1
Fill in your details
Company name, address and tax registration number at the top; your customer below.
- Step 2
Set the VAT rate once
Cell C14 in the Excel file. Every line follows it unless you override that line.
- Step 3
Add your lines
Description, quantity, unit and unit price. Net, VAT and line total compute themselves.
- Step 4
Send it
Save as PDF and email or WhatsApp it. Keep the numbering consistent so you can find it later.
What belongs on a quotation
A quotation is a commercial offer, not a tax document, but the business receiving it compares it against others and passes it to someone who checks the arithmetic. Leaving a field out is what gets a quotation questioned or ignored. At a minimum it carries:
- Your business name, address and contact details, and your tax registration number if you are registered.
- The customer's name and address, and their tax registration number for a business-to-business supply.
- A unique quotation number and the date of issue.
- A validity date, after which you are not bound by the price.
- Each line: a clear description, quantity, unit, unit price and the amount.
- The net total, the tax shown separately by rate, and the gross total.
- Payment terms, delivery or completion time, and anything explicitly excluded.
Showing tax correctly
Show the tax as its own column and its own total, never folded into the unit price. A buyer who can reclaim the tax needs to see the net amount; a consumer who cannot needs to see the gross. If some lines are zero-rated or exempt — exports, certain healthcare and education supplies — they should appear at 0% rather than being left out, so the document adds up and the reason is visible.
Round each line to the currency's decimals and add the rounded lines, rather than taxing the rounded total. The two methods differ by a few fils or pence on a long quotation, and that difference is exactly what a finance team queries. The Excel template does it the first way. You can check any figure against the VAT calculator.
Numbering and version control
Give every quotation a number in one unbroken series — QT-0001, QT-0002 — and never reuse one. When you revise a quotation, issue it as a revision of the same number rather than a new one, so that the conversation stays attached to a single reference. This sounds trivial until a customer accepts the second version of a quotation you have already superseded.
When the template stops being enough
The spreadsheet does the arithmetic. What it will not do is tell you that a quotation expires on Friday, show that the customer opened it twice and did not reply, let them accept it without printing and scanning, or carry the accepted lines into an invoice without retyping. Proposora does those things, in 35 countries and their own currencies, with the tax handled the same way this template handles it. The free plan has unlimited quotations and needs no card.
Frequently asked questions
Keep the template. Or let the software do the rest.
The files are yours either way. When you want numbering, expiry reminders, one-tap acceptance and an invoice at the end of it, the free plan is a minute away.