Guide
Footwear bill format: free Excel, Word and PDF for shoe and chappal shops
What is the bill format for a footwear (shoe) shop?
A footwear bill shows the shop’s name, address and phone, a bill number and date, the customer, and one line per pair: item, size and colour, number of pairs, rate and amount, then the discount, the total, how it was paid and the shop’s exchange rule. A GST-registered shop gives a tax invoice that adds its GSTIN, HSN codes (6401 to 6405), taxable value and CGST + SGST: 5% on a pair up to ₹2,500 and 18% above. Download both formats free below in English, Hindi or Gujarati, or make the same bill on your phone with Tap & Bill’s Free plan (60 bills a month at ₹0).
No card · no ads in the app · your bills, customers and udhaar stay yours: nothing is deleted if you stop paying

Download the footwear bill formats (free, no sign-up)
| Format | English | हिंदी | ગુજરાતી |
|---|---|---|---|
| GST tax invoice: A4, size / colour and pairs columns, HSN, GST 5% or 18% per pair, print and fill by hand (20 lines) | PDF · 130 KB | PDF · 194 KB | PDF · 214 KB |
| Bill / cash memo without GST: A5 bill book size, size and pairs columns, exchange date line (13 lines) | PDF · 111 KB | PDF · 164 KB | PDF · 184 KB |
| Excel with formulas: GST bill (5% or 18% picked per pair), bill without GST, and footwear HSN codes with the GST rate | 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 a printing press for a bill book. The Excel file adds up every line, picks 5% or 18% GST per pair and rounds the total; its third sheet lists the footwear HSN codes with the rate. The Word file is the same layout for typing your shop name, logo or exchange rule before printing. Use them as you like in your shop.
Selling clothes as well? The cloth shop bill format has the same layout with pieces instead of pairs. In Hindi: जूते-चप्पल की दुकान का बिल और GST.
What goes in each column
The sample above is a GST bill from a shop in Gujarat with rates written before GST. Line 1 shows why footwear needs a rate per line: the sports shoes are ₹3,200 less ₹200 discount, so the pair sells for ₹3,000 and takes 18%, while the two pairs of school shoes on line 2 are ₹800 each and take 5%, although together they cost ₹1,600.
| Column | What to write | Sample (line 1) |
|---|---|---|
| Item | The type, and the brand or article number if you keep them: customers ask for “the same one” next season | Sports shoes |
| Size / colour | The size as printed on the box (UK 8, EU 42, Kids 4) and the colour, so a size exchange matches the bill | UK 9 / Black |
| HSN | The 4-digit heading of the pair (GST bills only): 6402, 6403, 6404… | 6404 |
| Pairs | Number of pairs on this line | 1 |
| Rate ₹ | Price of one pair before GST | 3,200.00 |
| Discount ₹ | Discount on the line in rupees | 200.00 |
| Taxable value ₹ | Pairs × rate − discount | 3,000.00 |
| GST % | 5% if one pair is ₹2,500 or less after discount, 18% above | 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 |
The whole sample: taxable value ₹5,160, GST ₹648 (CGST ₹324 + SGST ₹324), total ₹5,808, paid UPI ₹5,000 + cash ₹808. The chappal at ₹260 and the socks at ₹100 a pair are 5%.
Price on the box includes GST (MRP)? Work back first
Most footwear is sold at the MRP printed on the box, and MRP includes GST. The format asks for the rate before GST, so divide the MRP by 1.05 for a pair that falls in 5% and by 1.18 for a pair in 18%:
| MRP of one pair | GST rate | Rate before GST (write this) | GST inside the MRP |
|---|---|---|---|
| ₹299 | 5% | ₹284.76 | ₹14.24 |
| ₹499 | 5% | ₹475.24 | ₹23.76 |
| ₹999 | 5% | ₹951.43 | ₹47.57 |
| ₹1,999 | 5% | ₹1,903.81 | ₹95.19 |
| ₹2,625 | 5% | ₹2,500 | ₹125 |
| ₹3,499 | 18% | ₹2,965.25 | ₹533.75 |
A pair stays in 5% up to an MRP of ₹2,625 (₹2,500 + 5%). Between ₹2,626 and ₹2,950 the two rates disagree (at 18% the value without GST comes out under ₹2,500): Tap & Bill charges 18% there, and you should ask your CA how to price such a pair. Any other price: the free GST calculator removes GST from a price in one step.
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 bill of supply format. Limits and what an unregistered shop may write: how to give a bill without a GST number.
The exchange line: write it on every bill
Footwear comes back for size more than anything else, so the format has two places for it: Exchange up to (date) and Exchange policy. Write your own rule and keep it short, for example “Exchange within 7 days with the box and this bill. Worn pairs are not taken back.” The size on the bill line is what you check the returned pair against.
When a pair does come back, don’t strike off the old bill: give a credit note against it and bill the new size. Free formats: credit note and exchange slip. In Tap & Bill an exchange is made from the old bill (Basic plan and up): how exchange works.
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 | Pairs × rate − discount |
| GST % | =IF(H9/E9<=2500,0.05,0.18) | 5% when one pair 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 |
One case the formula can’t know: goods that are not footwear or socks. Shoe polish and insoles are 18% at any price, so type 18% in their GST % cell. The second sheet is the bill without GST, and the third lists the HSN codes:
| Goods | HSN (4-digit) | GST from 22 Sep 2025 | Entry in Notification 9/2025 |
|---|---|---|---|
| Waterproof footwear with soles and uppers of rubber or plastics, uppers not stitched or riveted to the sole (for example gumboots) | 6401 | 5% up to ₹2,500 a pair, 18% above | Sch. I 392 / Sch. II 202 |
| Other footwear with soles and uppers of rubber or plastics (many slippers, chappals, sandals and floaters) | 6402 | 5% up to ₹2,500 a pair, 18% above | Sch. I 392 / Sch. II 203 |
| Footwear with uppers of leather (many formal shoes, school shoes, leather chappals) | 6403 | 5% up to ₹2,500 a pair, 18% above | Sch. I 392 / Sch. II 204 |
| Footwear with uppers of textile materials (many sports and canvas shoes) | 6404 | 5% up to ₹2,500 a pair, 18% above | Sch. I 392 / Sch. II 205 |
| Other footwear | 6405 | 5% up to ₹2,500 a pair, 18% above | Sch. I 392 / Sch. II 206 |
| Parts of footwear, removable insoles, heel cushions | 6406 | 18% | Sch. II 207 |
| Socks (hosiery, not footwear) | 6115 | 5% up to ₹2,500 a piece, 18% above | Sch. I 388 / Sch. II 197 |
| Shoe polish and cream | 3405 | 18% | Sch. II 70 |
More on the rate, with old and new slabs: GST on footwear.
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 footwear shop 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; an old bill is hard to find when a pair comes back |
| 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 by size |
| Free GST bill maker | Quick bills in the browser: 5% / 18% per pair, thermal or A4 print, WhatsApp | Nothing is saved: no bill history, udhaar or reports |
| Tap & Bill app | Every bill: size buttons, GST per pair, print, WhatsApp, UPI QR, udhaar, daily sales | The Free plan stops at 60 bills a month, owner only, no exchanges; paid plans from ₹199 a month or ₹1,499 a year; stock by size and box barcodes need Growth (₹999 a month) |