Android AppDownloadStart free trial
FeaturesWhat's new NewIndustriesClothing & garment shopsMobile & electronics shopsMobile repair shopsKirana & grocery storesFootwear & shoe shopsCosmetics & beauty storesStationery & gift shopsMedical stores & chemistsHardware & sanitary shopsSweet shops & bakeriesSaree & dress material shopsElectrical & lighting shopsFurniture shopsAuto parts & spares shopsBoutiquesCCTV & security shopsImitation jewellery shopsRice & grain shopsSalons & parloursSports goods shopsBag & luggage shopsHome appliances & gas stovesPrinting pressesGST billing softwareAll shop types →PricingCompareBlogContactAbout us Android AppDownload appsLog inStart free 30-day trial

Free Dukaan Business Kit: GST bill format + shop registers in one Excel file

Updated · free, no login

Get a free Excel kit made for your type of shop: a GST bill format with your shop name, a stock register with reorder alert, an udhaar khata, a daily cash book, a GST purchase register, an item-wise daily profit report and the HSN and GST rate list. It downloads at once; the first sheet tells you how to use each one.

FreeWhatsApp number to downloadExcel + Google SheetsYour shop name on it

How to use it

  1. Choose your shop type. Pick kirana, clothing, medical, mobile, hardware or another type. The kit carries the GST bill format with the columns that shop needs (MRP, size and colour, batch and expiry, IMEI and so on).
  2. Add your shop name. Optional. It is printed at the top of the bill format and every register.
  3. Download the kit. Enter your name and WhatsApp number once. The Excel file is made in your browser and saves to your Downloads folder at once.
  4. Start with the first sheet. Open it in Excel or Google Sheets. The "Shuru karein" sheet says when to use each sheet and gives a 10-minute daily routine. Fill the white cells; the blue cells calculate themselves.

What is inside the kit

SheetWhat it doesUse it
Shuru kareinWhen to use each sheet and a 10-minute daily routineOnce, at the start
Bill formatGST tax invoice for your shop type with your shop name; CGST + SGST or IGST and totals calculate themselvesEvery sale
Stock registerOpening, in, out and closing stock; REORDER in red at your reorder level; stock valueWeekly
Udhaar entries + Customer duesEvery credit bill and payment, running balance per customer, days overdueSame day as the udhaar
Cash bookCash in and out by category, running balance to tally with the drawerDaily
GST purchasesSupplier GSTIN, invoice, HSN, CGST / SGST / IGST, total input tax creditEvery purchase bill; match with GSTR-2B monthly
Daily salesItem-wise sale value, cost, profit and margin %; a loss line turns redDaily
HSN and GST rates + Sources170+ shop items with HSN code and GST rate from 22 Sep 2025, and the notification for eachWhen you add an item

Shop types in the kit

Kirana and grocery (with MRP and FSSAI number), clothing (size and colour), medical store (batch, expiry, drug licence), mobile and accessories, electronics, footwear, hardware and sanitary, stationery and books, cosmetics, sweets and namkeen, auto parts, and a general retail format for any other shop. You can preview each bill format first on the bill formats page.

Roz ka 10 minute hisaab (daily routine)

  1. Dukaan kholte hi cash book mein opening cash likhiye.
  2. Har bill ka number ek series mein rakhiye (jaise INV/26-27/001), koi number skip na ho.
  3. Udhaar diya ya payment aayi to usi waqt udhaar sheet mein likhiye.
  4. Shaam ko cash book ka balance drawer ke cash se milaiye; farak ho to usi din dhoondhiye.
  5. Hafte mein ek baar stock register ka REORDER column dekhiye.
  6. Mahine ke ant mein purchase register ko GSTR-2B se milaakar hi ITC lijiye.

GST rates and bill rules here are general information, not tax advice. Confirm your items' HSN and rate with your CA. Guides: dukaan ka hisaab: daily cash book, how to recover udhaar and input tax credit for retail shops.

Questions

Is the Dukaan Business Kit really free?

Yes. You enter your name, WhatsApp number and shop type once, and the Excel file downloads straight away. There is nothing to pay and no account to make.

What is inside the kit?

One Excel workbook with 10 sheets: a how-to sheet, the GST bill format for your shop type, a stock register with reorder alert, an udhaar khata with a customer dues sheet, a daily cash book, a GST purchase register, an item-wise daily sales and profit report, and the HSN code and GST rate list with its sources.

Kit mein kya kya milta hai?

Ek Excel file: aapki dukaan ke type ka GST bill format (aapke naam ke saath), stock register, udhaar khata, roz ki cash book, GST purchase register, item-wise daily sales aur profit report, aur 170+ items ki HSN aur GST rate list. Pehli sheet mein har sheet ka use aur roz ka 10 minute hisaab likha hai.

Can I use the bill format as my GST invoice?

Yes, for your own shop: put in your shop name, address and GSTIN and keep the invoice numbers in one series. It has the Rule 46 fields of a tax invoice. A composition dealer should title it BILL OF SUPPLY and remove the tax columns (Rule 49). The sample GST rates are for the layout only, so check your own items' rates with your CA.

Does it work on a mobile phone?

Yes. The file opens in the Excel or Google Sheets app on Android and iPhone, and the formulas keep working. Typing many rows is easier on a computer.

Will I get calls or messages after downloading?

You may get one thank-you message on WhatsApp from RichBills, and our team may call or message you about billing for your shop, as the consent box says. If you do not want more messages, tell us on WhatsApp and we will stop.

What is the difference between this kit and the free Excel templates page?

The Excel templates page lets you pick one register at a time. The kit puts the bill format for your shop type, all five registers and the HSN list in one file with your shop name, plus a how-to sheet.

When should a shop move from Excel to billing software?

When you write the same sale twice (once on the bill, again in the stock register) or the udhaar list gets long. In billing software the bill itself updates stock and dues. RichBills has a free 30-day trial; 30 din free, phir ₹99/month pehle 3 mahine, phir ₹199/month ya ₹1,999/saal.

Related

Excel mein do baar likhna band karo

In RichBills the bill itself updates stock and the customer's udhaar, and GST bills and reports come from the same sales. Billing, barcode stock, purchases, udhaar, GST reports and WhatsApp bill sharing are in every plan.

Start free trialAsk on WhatsAppBook free demo

30 din free, phir ₹99/month pehle 3 mahine, phir ₹199/month ya ₹1,999/saal.

Related tools (free, no sign-up)

Har din ka billing, stock aur udhaar ek jagah: Start RichBills free trial 30 days free, no card. All free tools