Guide
Cloth shop bill format: free Excel, Word and PDF
What is the bill format for a clothing shop?
A cloth shop bill shows the shop’s name, address and phone, a bill number and date, the customer, and one line per piece with the item, size or colour, quantity, rate and amount, then the discount, the total and how it was paid. A GST-registered shop gives a tax invoice that also shows its GSTIN, HSN codes, taxable value and CGST + SGST: 5% on a piece up to ₹2,500 and 18% above. Download both formats free on this page, in English, Hindi or Gujarati.
Download the bill formats (free, no sign-up)
| Format | English | हिंदी | ગુજરાતી |
|---|---|---|---|
| GST tax invoice: A4, print and fill by hand (20 lines) | PDF · 129 KB | PDF · 190 KB | PDF · 207 KB |
| Bill / cash memo without GST: A5 bill book size (13 lines) | PDF · 111 KB | PDF · 163 KB | PDF · 180 KB |
| Excel with formulas: GST bill, bill without GST and an HSN code list | Excel · 8 KB | Excel · 9 KB | Excel · 9 KB |
| Word: both bills, type your shop name once and print | Word · 4 KB | Word · 5 KB | Word · 5 KB |
The PDFs are blank forms to print and fill in by hand, or to take to your printer for a bill book. The Excel file adds up every line, picks 5% or 18% GST per piece and rounds the total. The Word file is the same layout for typing your shop name, logo or terms before printing. Use them as you like in your shop.
What goes in each column
The sample above is a GST bill from a shop in Gujarat. Line 3 shows why clothes need their own format: the lehenga is ₹3,200 less ₹200 discount, so one piece sells for ₹3,000 and takes 18%, while the kurtis on line 1 take 5%.
| Column | What to write | Sample (line 3) |
|---|---|---|
| Item | What the customer bought, in words they recognise | Lehenga choli |
| Size / colour | Size (S to XXL, 28 to 40, Free) and colour, so an exchange matches the bill | Free / Maroon |
| HSN | The 4-digit code of the item (GST bills only) | 6204 |
| Qty | Number of pieces | 1 |
| Rate ₹ | Price of one piece before GST | 3,200.00 |
| Discount ₹ | Discount on the line in rupees | 200.00 |
| Taxable value ₹ | Qty × rate − discount | 3,000.00 |
| GST % | 5% if one piece is ₹2,500 or less after discount, 18% above; sarees and fabric 5% | 18% |
| CGST ₹ / SGST ₹ | Half the GST each, for a sale inside your state | 270.00 / 270.00 |
| Amount ₹ | Taxable value + CGST + SGST | 3,540.00 |
Codes for kurtis, leggings, sarees, kids wear and more: HSN code list for clothes. All the fields a tax invoice must carry under Rule 46: GST bill format for clothing shops.
GST bill or bill without GST: which format do you need?
| Your shop | Bill to give | Title on top | Tax on the bill |
|---|---|---|---|
| GST-registered (regular) | Tax invoice | TAX INVOICE | GSTIN, HSN, taxable value, CGST + SGST |
| Composition scheme | Bill of supply | BILL OF SUPPLY, with “composition taxable person, not eligible to collect tax on supplies” | None |
| Not registered for GST | Bill or cash memo | BILL or CASH MEMO | None, and no GSTIN |
Use the A4 tax invoice if you are registered, and the A5 bill without GST if you are not; a composition dealer can use the A5 format with “Bill of Supply” written on top. Limits, the ₹40 lakh rule and what an unregistered shop may write: how to give a bill without a GST number.
How the Excel format works out GST
Type rates before GST. Each line uses these formulas, so you can check any figure by hand:
| Cell | Formula in the file | In words |
|---|---|---|
| Taxable value | =E9*F9-G9 | Qty × rate − discount |
| GST % | =IF(H9/E9<=2500,0.05,0.18) | 5% when one piece is ₹2,500 or less, else 18% |
| CGST and SGST | =ROUND(H9*I9/2,2) | Half the GST each, to the paisa |
| Amount | =H9+J9+K9 | Taxable value plus both taxes |
| Grand total | =ROUND(L24,0) | Rounded to the rupee, with the round-off shown |
Two cases the formula can’t know: a saree or fabric sold by the piece takes 5% at any price, so type 5% in its GST % cell; and if your price tags include GST, work back to the rate before GST first with the GST calculator for clothes. The second sheet is the bill without GST, and the third lists HSN codes for common garments.
A4, A5 or a thermal roll?
| Paper | Good for | Use |
|---|---|---|
| A4 | Tax invoices, bills to GST-registered buyers, wholesale | The GST tax invoice PDF, Excel or Word |
| A5 (half of A4) | A bill book at the counter, carbon copy for the shop | The bill without GST PDF |
| 80 mm or 58 mm thermal roll | Fast counter bills from a phone or computer | The free GST bill maker or the Tap & Bill app |
Getting a bill book printed? Ask the printer to number the pages in order and keep one copy for the shop. Under GST a bill number may be used only once in a financial year, so never tear out a wrong bill: write CANCELLED on it and keep it in the book.
Paper, Excel, a bill maker or an app?
| Way | Good for | What it can’t do |
|---|---|---|
| Printed bill book (PDF) | A few bills a day; no phone or power needed | Totals and GST added by hand; no copy on WhatsApp; old bills hard to find |
| Excel or Word on a computer | A computer at the counter; GST worked out by formula | One bill at a time; no customer history, udhaar or stock; last month’s bill is easy to overwrite |
| Free GST bill maker | Quick bills in the browser: 5% / 18% per piece, thermal or A4 print, WhatsApp | Nothing is saved: no bill history, udhaar or reports |
| Tap & Bill app | Every bill: sizes, GST per piece, print, WhatsApp, UPI QR, udhaar, returns, daily sales | Paid after the 14-day free trial: from ₹199 a month or ₹1,499 a year |
In Tap & Bill the same columns fill in by themselves: tap the item, pick the size, and GST, totals, the bill number and the amount go on the bill, which you print on a thermal printer or send on WhatsApp in English, Hindi or Gujarati. Made a mistake after saving? The owner can edit the saved bill and the old version is kept.
Kapde ki dukan ka bill format kya hota hai? Upar wale format mein dukan ka naam, bill number, tareekh, grahak, har piece ki line (size, rate, amount) aur total hota hai; GST wali dukan mein GSTIN, HSN aur CGST + SGST bhi. Hindi mein padhein: कपड़े की दुकान का बिल फ़ॉर्मेट.