Kirana store bill format (grocery bill in Excel, Word and PDF)

Quick answer

A kirana GST bill must carry the Rule 46 basics: your name, address and GSTIN, a serial number, date, HSN, item, quantity and unit, taxable value, GST rate and amount, and a signature. A grocery shop also prints its 14-digit FSSAI licence or registration number, and shows nil-rated loose items and 5% packed items on separate lines.

Excel + Word + PDFFree · WhatsApp number to downloadGST rates from 22 Sep 2025

Loose dal billed by the kg, a low-stock alert, then an udhaar reminder on WhatsApp

Preview: Kirana / grocery store bill format

Fill online →

Free. Excel and Word ask for your name and WhatsApp number once; Print / Save as PDF and Fill online need nothing. The Excel file works out taxable value, CGST, SGST or IGST and the total as you type. Fill online opens the free GST invoice generator with these sample items.

SAMPLE: Your shop name

Address: Shop address, City, PIN

Phone: 98xxxxxxxx

GSTIN: 24AAAAA0000A1Z5

State: Gujarat (24)

FSSAI lic./reg. no.: 1xxxxxxxxxxxxx (14 digits)

TAX INVOICE

ORIGINAL FOR RECIPIENT

Invoice no.
INV/26-27/001
Date
16-10-2026
Place of supply
Gujarat (24)
Reverse charge
No

Bill to

Customer name: Customer name

Address: Customer address

GSTIN (if registered): -

State: Gujarat (24)

#DescriptionHSNMRP (₹)QtyUnitRate (₹)Disc. %Taxable value (₹)GST %CGST (₹)SGST (₹)Amount (₹)
1Basmati rice 5 kg pack10065991bag540.00-540.005%13.5013.50567.00
2Toor dal (loose, not packed)0713-1.5kg150.00-225.000%0.000.00225.00
3Ghee 1 L04056501pcs590.00-590.005%14.7514.75619.50
4Biscuits family pack1905552pcs48.00-96.005%2.402.40100.80
5Toilet soap 100 g x 434011751pack152.005%144.405%3.613.61151.62

Amount in wordsRupees One Thousand Six Hundred Sixty Four Only

Composition dealer? Print BILL OF SUPPLY instead and drop the tax columns (Rule 49).

Taxable value
1,595.40
CGST
34.26
SGST
34.26
Round off
+0.08
Total
₹1,664.00

Authorised signatory

Sample rows and rates for the layout (rates from 22 Sep 2025). Check the GST rate for your own HSN. Free format from richdaddy.in/bill-format/kirana-grocery-store

What a kirana / grocery store bill must show

Every tax invoice needs the Rule 46 fields in the table further down. On top of those, a kirana bill needs:

What to printWhy / source
FSSAI licence or registration number (14 digits)FSSAI order of 8 June 2021, enforced from 1 January 2022, for food businesses on receipts, invoices, cash memos and bills
Unit with every quantity (kg, g, L, pcs, pack)Rule 46(i): quantity and unit; loose goods are sold by weight
Separate GST rate for each lineLoose unpacked pulses can be nil-rated while pre-packed, labelled food and daily-use items such as toilet soap are at 5% (rates from 22 Sep 2025)
A daily consolidated invoice for small un-billed salesSection 31(3)(b) and Rule 46: sales under ₹200 to unregistered buyers who do not ask for a bill
BILL OF SUPPLY title if you are a composition dealerRule 49: a composition dealer does not charge GST on the bill

The shop columns in this format

  • MRP: Lets the customer see the printed price next to your selling rate. MRP is not required by Rule 46, but it answers the most common counter question.
  • Unit: kg, g, L, pcs or pack. A bill showing 1.5 kg of loose dal is clearer than one showing 1.5.
  • GST %: Mixed rates are normal on a grocery bill. The Excel sheet has a dropdown with the current rates.

GST rates on the sample items

From 22 September 2025 ghee and butter, biscuits, packed namkeen, toothpaste, shampoo and toilet soap bars moved to 5%, and UHT milk became exempt (PIB, 56th GST Council). The sample rows use these rates. Rates depend on the exact item and packing, so check your HSN on the GST portal or with your CA.

Common mistakes on kirana bills

  • Charging 5% on loose, unbranded pulses or grains that are nil-rated, or 0% on the pre-packed and labelled pack of the same item.
  • Leaving out the FSSAI number. It is easy to add once in the header and then it prints on every bill.
  • Writing only a total on a chit. Without HSN, rate and tax split it is not a tax invoice.
  • Issuing a tax invoice with GST while registered under composition. Composition dealers issue a bill of supply and cannot collect tax.

How to use this format

  1. Download the format. Choose Excel (.xlsx) for automatic GST totals, Word (.docx) to edit the layout, or Print / Save as PDF to get the A4 sample as a PDF.
  2. Put in your shop details. Replace the sample shop name, address and GSTIN, and add your FSSAI lic./reg. no.
  3. Type over the sample items. Enter each item with its HSN, mrp (₹), quantity, rate, discount and GST rate. In Excel the taxable value, CGST, SGST or IGST and the total fill in by themselves.
  4. Print, sign and keep a copy. Print on A4 or save as PDF, sign it and keep the office copy with the next invoice number in your series.

Fields every GST tax invoice needs (Rule 46)

FieldRule
Your name, address and GSTINRule 46(a)
Invoice number: consecutive, up to 16 characters, unique for the financial yearRule 46(b)
Date of issueRule 46(c)
Buyer's name, address and GSTIN if registered; for an unregistered buyer, name and address when the value is ₹50,000 or moreRule 46(d)-(f)
HSN code of each itemRule 46(g); digits per Notification 78/2020-CT
Description, quantity and unitRule 46(h)-(i)
Taxable value after discountRule 46(k)
GST rate and amount: CGST + SGST, or IGST for another stateRule 46(l)-(m)
Place of supply for inter-state sales; reverse charge yes/noRule 46(n), (p)
Signature of you or your authorised personRule 46(q)

Composition dealers and shops selling only exempt goods issue a bill of supply instead (Rule 49): change the title and remove the tax columns. Full field-by-field notes: GST invoice format.

FAQ

Kirana bill format: questions

What is the format of a kirana shop bill?

Your shop name, address, GSTIN and FSSAI number at the top; invoice number and date; customer details if needed; then one line per item with HSN, MRP, quantity and unit, rate, taxable value and GST; and the CGST, SGST, round off and total at the bottom with a signature.

Do I need to give a bill for every small grocery sale?

Not for a sale under ₹200 to an unregistered buyer who does not ask for one, but you must then issue one consolidated tax invoice for those sales at the end of each day (Section 31(3)(b) and Rule 46). If the customer asks for a bill, you must give it.

Is the FSSAI number compulsory on a grocery bill?

Yes, for food businesses. FSSAI's order of 8 June 2021 asks food businesses to print the 14-digit licence or registration number on receipts, invoices, cash memos and bills; a later order moved enforcement to 1 January 2022.

Can a kirana store without GST registration give a bill?

Yes, but not a tax invoice. An unregistered shop should give a simple cash memo without GSTIN or tax columns and must not collect GST. Our guide on billing without a GST number explains what to print.

Can I make a grocery bill in Excel?

Yes. Download the Excel format on this page, type over the sample rows and the taxable value, GST and total calculate themselves. For more than a few bills a day, billing software is faster because items and rates are saved.

Software for this shop

RichPOS bills by barcode or name, takes decimal quantities for loose goods, sets the GST rate per item, converts box to pieces, keeps udhaar with WhatsApp reminders and prints on 58/80 mm thermal or A4 printers. It has no weighing-scale integration: you type the weight. Billing software for kirana and grocery stores →

Related

Bill formats for other shops

Sources

Summary for shop owners, checked against these sources on 16 October 2026. Rules and rates change; confirm your case with the current text or your CA. Not tax or legal advice.

Tired of filling bills by hand?

RichPOS prints this kind of GST bill in seconds from saved items, on thermal 58/80 mm or A4 printers, and keeps your GST reports ready for your CA.

Free 30-day trial, then ₹99/month for the first 3 months (₹199/month after that) or ₹2,000/year. See pricing