Wedding season 2026 · weddings from 21 Nov · fast bills in the rush, udhaar with limits · 14 days free, then the ₹0 Free plan or ₹199/month · Shop checklist · Free sale poster

Guide

Quotation format for shops: free estimate format in Excel, Word and PDF

By the Tap & Bill team · Updated · हिंदी में पढ़ें

What should a quotation for a shop include?

A quotation (or estimate) is a written price offer, not a bill. Put “Quotation” or “Estimate” at the top, your shop’s name, address and GSTIN (if registered), a quotation number from its own series (like QT-0001), the date and a valid-till date, the customer’s name and mobile, each item with quantity, rate, discount, GST and amount, the total, and your terms (delivery, advance, alterations). Download a ready format below in Excel, Word or PDF, in English, Hindi or Gujarati.

Free forever: 60 bills a month + 10 automatic WhatsApp bills · paid plans from ₹199 a month, no GST added · 14-day full trial first

No card · no ads in the app · your bills, customers and udhaar stay yours: nothing is deleted if you stop paying

Quotation format filled in as a sample: QT-0007 for a wedding order, 5 Banarasi silk sarees, 4 kurta pyjama sets with ₹1,200 discount and 2 kids sherwanis, GST 5% and 18%, total ₹29,602, valid till 27-10-2026
The A4 quotation format, filled in with a sample wedding order.

Download the quotation format (free, no sign-up)

FormatEnglishहिंदीગુજરાતી
Quotation / estimate: A4, print and fill by hand (16 lines, valid till, terms)PDF · 144 KBPDF · 215 KBPDF · 233 KB
Excel with formulas: discount, GST 5% / 18% for clothes, total, and a filled exampleExcel · 8 KBExcel · 9 KBExcel · 9 KB
Word: type your shop name, logo and terms once and printWord · 4 KBWord · 4 KBWord · 4 KB

The PDF is a blank A4 form to fill by hand, or to take to your printer for a quotation pad. In the Excel file, type the quantity, rate and discount and the taxable value, GST and amount fill in; for clothes the GST % is set by itself (HSN 50 to 59, fabric and sarees, 5%; other clothes 5% if one piece is ₹2,500 or less after discount, 18% above). Type over it for other goods, or type N at the top if your shop is not registered for GST. The second sheet is the filled example below. The Word file is for typing your shop name, logo and terms once.

Quotation, estimate, proforma invoice or bill?

QuotationEstimateProforma invoiceBill (tax invoice)
What it isA firm price offerAn approximate priceA draft bill, often to ask for an advanceThe record of a sale
PriceFixed till the valid-till dateMay change a littleAs the final bill will beWhat was charged
Number seriesOwn series (QT-0001…)Own seriesOwn seriesBill series (INV-0001…)
Goods and moneyNot yetNot yetNot yet (advance maybe)Goods given, paid or on udhaar
In sales, GST return, gallaNoNoNoYes

At a shop counter a quotation is usually enough. Never hand one over as if it were a bill: the word “Quotation” or “Estimate” at the top and a line such as “This is a price offer, not a bill” keep it clear.

What to write on a quotation

  • Top: Quotation or Estimate, shop name, address, phone; GSTIN if you are registered.
  • Number and dates: quotation number (QT-0001), date, and valid till (for clothes, 7 to 15 days is common, because prices change with new stock).
  • Customer: name and mobile; for a school, company or trust, the address and their GSTIN.
  • Items: item, size or colour, HSN, quantity, rate, discount, taxable value, GST % and amount.
  • Bottom: total, amount in words, terms, “not a bill”, your signature and a line for the customer to accept.

Worked example: a ₹29,602 wedding order

Rakesh Mehta asks for a price for his son’s wedding: 5 Banarasi silk sarees, 4 kurta pyjama sets and 2 kids sherwanis. The shop makes QT-0007, valid for 7 days, with ₹300 off each kurta set:

ItemQty × rateDiscountTaxableGSTAmount
Banarasi silk saree (HSN 5007)5 × ₹2,200–₹11,0005% = ₹550₹11,550
Kurta pyjama set (6203)4 × ₹2,800₹1,200₹10,0005% = ₹500₹10,500
Kids sherwani (6203)2 × ₹3,200–₹6,40018% = ₹1,152₹7,552
Total11 pieces₹1,200₹27,400₹2,202₹29,602

The ₹300 discount brings each kurta set to ₹2,500, so its GST drops from 18% to 5%: without the discount the four sets would cost ₹11,200 + 18% = ₹13,216; with it, ₹10,500. That is ₹300 off and ₹379 less GST on each set, ₹2,716 in all. Sarees are fabric, 5% at any price; a ₹3,200 sherwani is 18%. The full rule: GST on clothes: 5% or 18%.

Terms worth writing on a clothing quotation

  • Valid till: “Prices valid till 27-10-2026; new stock may be priced differently.”
  • Delivery: “Ready in 5 days from confirmation”, or a date for wedding orders.
  • Advance: “30% advance to confirm the order; balance on delivery.”
  • Alterations: free or at a charge, and how many days they take.
  • Colour and size: “Shades may differ slightly from photos; sizes as per the size chart.”
  • Exchange: your exchange policy for confirmed orders (why a blanket “goods once sold will not be taken back” line is a risk, in Hindi: goods once sold का मतलब).

Make the quotation in Tap & Bill and turn it into a bill

  1. Open Quotations

    Android app: Settings tab → Quotations and challans → Quotations → New quotation. Computer: Quotations in the left menu → New quotation.

  2. Customer and items

    Name, Mobile (optional) and Address (optional). Tap item tiles or Find item, pick a size, or add an Other item. A discount for the whole quotation goes in Discount ₹. GST is worked out like a bill, from your shop’s GST setting.

  3. Valid till, then Save

    Pick 3, 7, 15 or 30 days, or No date, and Save. The quotation gets its own number, QT-0001, QT-0002…, separate from bill numbers.

  4. Send the PDF

    PDF opens an A4 PDF to print from the computer or save. WhatsApp opens WhatsApp on your phone with the customer’s number and a link to the PDF; you press send.

  5. Customer says yes: Make bill

    Make bill loads the same items, discount and customer into the billing screen. Change a price if you agreed on one, choose the payment and save. The quotation shows Bill made with the bill number.

The Quotations screen has tabs for Open, Date passed, Done, Cancelled and All, and a search by number, name or mobile. An open quotation can be changed (staff change only their own); a cancelled one keeps its number and the PDF says CANCELLED. The owner’s reports show open quotations, their value and how many became bills in the last 30 days. The heading (Quotation or Estimate) is an owner setting; on the computer you can also pick it per quotation and add the customer’s GSTIN. The PDF comes in the customer’s language: English, Hindi or Gujarati.

In Tap & Bill
WhereAndroid app and any computer browser, one shop account; needs internet (bills still work offline)
NumbersQT-0001… per shop, never reused, separate from bills
PDFA4 in English, Hindi or Gujarati, “This is a price offer, not a bill.”; not printed on the thermal receipt printer
WhatsAppFrom your own phone or browser with a link to the PDF, free; not sent automatically
ReportsQuotations are not sales: never in sales, the galla or the GST report until they become a bill
PlansEvery paid plan, from ₹199 a month or ₹1,499 a year, no GST added; 14-day free trial

Sending clothes out without a bill instead, on approval or to the tailor? That is a delivery challan. Everything about both: quotation & delivery challan. Hindi: कोटेशन कैसे बनाएं.

Frequently asked questions

What is the difference between a quotation and an estimate?

Both are price offers before a sale. A quotation is usually a firm price that holds until a date; an estimate is an approximate price that can change a little once the work or goods are final, such as a stitching order before measurements. Neither is a bill. In Tap & Bill the owner chooses whether the heading says Quotation or Estimate.

Where can I download a quotation format in Excel?

On this page, free and without sign-up: an Excel quotation with formulas (discount, GST 5% / 18% for clothes, total, round off) and a filled example, plus Word and PDF versions, each in English, Hindi and Gujarati.

Is GST charged on a quotation?

No. A quotation is not a sale, so nothing from it goes into your sales or GST return. The quotation shows GST only so the customer knows the full amount; GST is charged on the bill when the goods are supplied.

How long should a quotation be valid?

There is no legal rule; you decide. For clothes, 7 to 15 days is common because prices change with new stock; for big wedding or uniform orders, 30 days. Write the valid-till date on the quotation.

Should quotation numbers be separate from bill numbers?

Yes. Keep a separate series (QT-0001, QT-0002…) so your bill numbers stay continuous. Tap & Bill does this by itself and never reuses a quotation number, even a cancelled one.

What is the difference between a quotation and a proforma invoice?

A quotation is an offer the customer may accept or refuse. A proforma invoice is a draft of the final bill, usually sent after the order is agreed, often to collect an advance or for a loan or tender. Neither is a tax invoice. Tap & Bill makes quotations and estimates, not a separate proforma invoice.

Can I convert a quotation into a bill?

In Tap & Bill, yes: open the quotation and tap Make bill. The items, discount and customer load into the billing screen, prices stay editable, and on saving the quotation shows Bill made with the bill number. If that bill is cancelled, the quotation opens again.

Which Tap & Bill plan has quotations?

Every paid plan, from Basic at ₹199 a month (or ₹1,499 a year), with a 14-day free trial. Quotations are not bills, so they don’t count towards the monthly bill limit.

See quotations and challans on a free demo

We call you within one working day and show Tap & Bill on your own items and prices.

  • 10-minute demo on phone or video call
  • 14-day free trial, no card
  • We set up your categories and prices with you

Prefer to talk now? Call +91 73838 34343.

or leave your number and we call you

Your shop
Add more details (optional)
What do you need most? (optional)

The call is free. Nothing to buy, no card needed.

Try Tap & Bill free

Bill, print and WhatsApp from day one. 14-day free trial.