Free template · Excel

Quotation Format (Free Excel Download)

A quotation format is the standard layout a seller uses to offer prices to a buyer before an order is placed. It shows both parties' details, a quotation number, date and validity. Each item lists HSN code, quantity, unit, rate, discount and GST, then the grand total and terms for payment, delivery and price basis. A quotation is an offer, not a tax invoice.

Download the Excel template

What is a quotation format?

A quotation is the price offer you send after a buyer's enquiry or RFQ, before their purchase order. Once the buyer accepts, use our sales order format. An estimate is a rough figure; a quotation is a firm price for a fixed time.

What a quotation format must include

  • Header: both parties' name, address and GSTIN; quote number, revision, date, validity and enquiry reference.
  • Item table: code, description, HSN, quantity, unit, rate, discount, taxable value, GST and lead time.
  • Totals: taxable value, GST, packing and freight, grand total in figures and words.
  • Terms: price basis (Ex-works or FOR), payment, delivery, validity, raw-material clause and signature.

Every column explained

FieldWhat to writeExampleWhy it matters
Item code / drawing no. (Rev)Part code and drawing revisionSH-2040 Rev BStops quoting an old drawing.
DescriptionPart name, material, finishDrive shaft, EN8Checked against their spec.
HSNThe goods' HSN code8483Must match the tax invoice.
Qty and unitQuantity and unit200 NosA rate means nothing without the unit.
Rate (₹)Price per unit, without GST450.00Buyers compare pre-tax rates.
Disc %Discount on this line5%Taken before tax.
Taxable value (₹)Qty × rate, less discount85,500.00GST is worked out on this.
GST %Rate for this HSN18%Items can carry different rates.
CGST / SGST / IGST (₹)Tax in the right columns7,695 + 7,695Wrong type means a corrected invoice.
Lead timeDelivery time for this line3 weeksLines often differ.

CGST + SGST or IGST?

A quotation does not charge GST. It shows the GST the buyer will pay on the invoice. Place of supply decides the type.

  • Same state: CGST + SGST, half each. 18% becomes 9% + 9%.
  • Another state: IGST at the full 18%.

HSN code on a quotation

HSN is not required on a quotation, but it is on the tax invoice. Use the same code on both: see our GST invoice format.

How to fill the quotation format, step by step

  1. Read the enquiry and drawing. Costing from a parts list? Use our bill of materials format.
  2. Give a quote number. New quotes start at Rev 0.
  3. Enter the buyer and place of supply. Copy the GSTIN exactly.
  4. Add item lines with HSN, quantity, unit, rate and lead time.
  5. Apply discount before tax.
  6. Add packing and freight per your price basis, at the goods' GST rate.
  7. Check the totals. Taxable value plus GST must equal the grand total.
  8. Add terms and signature, then send as a PDF.

Worked example: a Pune engineering firm quotes a Nashik buyer

The numbers are illustrative. Both firms are in Maharashtra, so GST is CGST 9% + SGST 9%. Terms: Ex-works Pune, 30 days from invoice, valid 15 days.

LineMathsTaxable value (₹)CGST + SGST (₹)
Drive shaft SH-2040 Rev B200 × 450 = 90,000, less 5% (4,500)85,5007,695 + 7,695
Bearing housing BH-1120 Rev A100 × 78078,0007,020 + 7,020
Hex bolt M12 × 501,000 × 12.5012,5001,125 + 1,125
Packing and forwardingFlat charge3,500315 + 315
Total1,79,50016,155 + 16,155

GST = ₹32,310. Grand total = 1,79,500 + 32,310 = ₹2,11,810. For a buyer in Gujarat, it becomes IGST 18%, also ₹32,310.

[[IMAGE {"type":"steps","title":"From enquiry to dispatch: the paper trail","items":["Buyer sends an enquiry or RFQ","You send the quotation, Rev 0","Buyer accepts with a purchase order","Proforma invoice if an advance is due","Tax invoice and e-way bill at dispatch"]}]]

When Excel stops working

Excel is fine for a few quotes a month. It breaks when you send many quotes a week.

  • Follow-ups get lost because nobody knows which quotes are open.
  • The same details are retyped into the order, the invoice and the e-way bill.
  • Team members work from different versions of the file.

Where the quotation fits in TranZact

TranZact is manufacturing AI software used by 10,000+ manufacturers. The quotation sits inside one sales flow: enquiry, quotation, order timeline, dispatch, e-invoicing and payment.

TranZact generates the e-way bill from the GST invoice, with the e-invoice (IRN) in the same flow, on all plans. Accounting stays in Tally, Busy or Zoho Books, with one-way sync and no double entry.

Custom document formats, for your own quotation layout, are on the Dominate plan (see pricing). TranZact goes live in 2–3 weeks.

Book a demo →

Quotation validity and revisions

15 or 30 days is common. Keep it short when steel or copper prices move.

Yes, you can revise a sent quote. Keep the number and raise the revision: Rev 0, Rev 1, Rev 2.

Is a quotation legally binding?

A quotation is an offer. It becomes a contract once the buyer accepts it on its terms, usually with a PO. If the PO changes your terms, confirm in writing before production. This is general guidance, not legal advice.

Quotation vs proforma invoice vs tax invoice

PointQuotationProforma invoiceTax invoice
PurposeOffer price and termsConfirm the order or ask for advanceBill for goods supplied
When sentAfter enquiry, before POAfter order, before supplyAt or before dispatch
Asks for payment?NoYes, often an advanceYes
GST effectNoneNone, not a tax documentGST due; buyer claims credit
Can it change?Yes, by revisionYesOnly by credit or debit note

Next document? Use our proforma invoice format.

Common mistakes that cost orders or margin

  1. No price basis: freight becomes a fight.
  2. No validity date: old prices come back months later.
  3. Wrong tax type: forces a corrected invoice.
  4. Discount after GST: tax must be on the discounted value.
  5. No drawing revision: you quote Rev A, they want Rev B.
  6. Hidden extras: packing or freight appears only on the invoice.
  7. Totals that don't add up: the buyer questions every number.
  8. Titled "Tax Invoice": always title it "Quotation".

Don't be the bottleneck. Become the AI-Run Factory.

Download the format and send today's quote. When quotes pile up, see the whole flow from enquiry to dispatch in one call.

Book a demo →

Frequently asked questions

Can I use this quotation format for free in my business?

Yes. The Excel file is free to download and use, with no sign-up. Change the columns and terms to suit your products.

Should I quote prices with or without GST?

For B2B buyers, quote the rate without GST and show the tax separately on each line. The buyer sees the taxable value and the GST they can claim as credit.

How do I quote when raw material prices keep changing?

Keep validity short, for example 15 days, and add a line that prices are based on raw-material rates on the quote date. If rates move, send a revised quote with a new revision number.

What is the difference between Ex-works and FOR in a quotation?

Ex-works means the price is at your factory gate and the buyer pays freight. FOR destination means your price includes delivery to the buyer's site. State which one you mean, or freight becomes a dispute.

When should a factory move from Excel quotations to software?

When you send many quotes a week, lose track of follow-ups, or retype the same details into the order, invoice and e-way bill. Excel is fine for a few quotes a month.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.