A sweet shop bill that matches the sweets
Sweet shops are busiest exactly when billing is hardest: Diwali, Raksha Bandhan, Holi, Eid, weddings and every family function in between. Customers want half a kilo of kaju katli, a box of assorted sweets for a gift, two kilos of motichoor laddoos for a puja and some namkeen for the road — all weighed, priced per kilo and packed in a hurry. A halwai's bill book fills up fast, and mistakes in weight × rate are easy to make.
This sweet shop bill generator keeps the traditional handwritten mithai bill look and calculates everything for you — weight × rate per kg, boxes by the piece, discount, tax if you charge it, and the total in words. Download a neat bill as a PDF or image for the customer, or print it on a thermal printer at the counter.
What is mithai?
Mithai is the Hindi and Urdu word for traditional Indian sweets — milk-based sweets like peda, barfi, kalakand and rasgulla; gram-flour sweets like besan laddoo and Mysore pak; dry-fruit sweets like kaju katli; and fried sweets like jalebi and imarti. Most are sold loose by weight, so a mithai bill format is built around a rate per kilogram rather than a price per piece.
Sweet shop bill format
The sweet shop templates follow the familiar mithai shop bill format:
- Header: shop name ("Shree Ganesh Mishthan Bhandar"), address, phone, FSSAI number and GSTIN if registered.
- Bill details: cash memo or bill number and date; add the customer's name for orders.
- Items: sweet or namkeen name, weight in kg, rate per kg and amount; boxed items by quantity and price per box.
- Totals: subtotal, festival or bulk discount, GST if registered, total and total in words.
- Footer: "Best before" advice for milk sweets, a thank-you line and signature.
Mithai ka bill kaise banaye
- Template chunein — the cash memo and bill book styles look like a halwai's book.
- Dukaan ka naam aur pata likhein — saved in your browser.
- Mithai ka naam, weight aur rate likhein — for example "Kaju katli, 0.5 kg, ₹1,200 per kg". The amount appears automatically.
- Gift box aur namkeen jodein with Add item.
- Discount ya GST lagayein in Bill settings, if needed.
- Download ya print karein — PDF, PNG or JPG.
Sweet shop bill sample
| Item | Kg / Qty | Rate (₹) | Amount (₹) |
|---|---|---|---|
| Kaju katli | 0.5 kg | 1,200 | 600 |
| Motichoor laddoo | 2 kg | 480 | 960 |
| Milk cake | 0.75 kg | 560 | 420 |
| Assorted gift box (500 g) | 4 boxes | 450 | 1,800 |
| Aloo bhujia | 1 kg | 280 | 280 |
| Subtotal | 4,060 | ||
| Festival discount 5% | − 203 | ||
| Total | 3,857 | ||
Type weights as decimals (0.5, 0.75) and the rate per kg; the tool works out each amount. Rename the "Qty" column to "Kg" if you sell only by weight.
Quick weight reference for the counter
Customers ask for sweets in grams; rates are per kilogram. Type the weight as a decimal of a kilogram and the bill does the rest. For a sweet priced at ₹600 per kg:
| Customer asks for | Type as quantity | Amount (₹) |
|---|---|---|
| 100 g | 0.1 | 60 |
| 250 g (pav kilo) | 0.25 | 150 |
| 500 g (aadha kilo) | 0.5 | 300 |
| 750 g (paune kilo) | 0.75 | 450 |
| 1.25 kg (sava kilo) | 1.25 | 750 |
If the scale shows an odd weight such as 0.540 kg, type it exactly — 0.54 — rather than rounding, so the amount matches what the customer saw on the scale.
Weigh sweets without the box
When sweets are sold by weight, the customer should pay the sweet's rate only for the sweets — not for the cardboard box. Legal metrology officials in several states have acted against shops that weighed sweets together with their boxes. Tare (zero) the scale with the empty box, or show the box as a separate line at its own price. Pre-packed gift boxes are different: they are sold as a pack with a declared net weight and MRP, and the bill should never exceed the MRP.
How long does mithai last? Put it on the bill
One of the questions customers ask most is how long mithai lasts. It varies by type and storage, so as a general guide:
- Milk and chhena sweets — rasgulla, rasmalai, sandesh, kalakand — are the most perishable; keep them refrigerated and eat them within a day or two.
- Khoya sweets — peda, barfi, milk cake — keep a few days, longer in the fridge.
- Dry and gram-flour sweets — besan laddoo, soan papdi, Mysore pak, kaju katli — last longer, often a week or more in an airtight box.
Since October 2020, FSSAI has required sweet shops to display a "best before" date for loose sweets on the tray or container in which they are displayed. Writing the same advice on the bill — "Milk sweets: refrigerate, best before 2 days" — is a helpful extra, especially for gift orders that will be passed on.
GST on sweet shop bills
Most Indian sweets attract 5% GST, and namkeen and bhujia rates were reduced in the September 2025 GST changes; check the current rate for each item with your accountant, as rates are revised from time to time. If your shop also serves food to eat in — a sweet shop with a seating area serving chaat or thalis — those sales may be treated as restaurant service. Small shops below the GST registration limit (₹40 lakh a year for most suppliers of goods) and shops under the composition scheme must not add GST to the bill. Registered shops should print their GSTIN and show CGST and SGST separately.
Sweet shop bill format in Word, Excel or PDF
A sweet shop bill format in Word or Excel needs a computer and careful formulas for weights. During a festival rush, nobody has time for that. Here the sweet shop bill format is ready on a phone: enter weights and rates, and a sweet shop bill format PDF or image is ready to download. Shops that want a sweet shop bill format PDF in Hindi can write sweet names in English letters — "Kaju Katli", "Motichoor Laddoo", "Dhanyavaad" — which suits the handwriting fonts; Devanagari text can be typed too, but it appears in your device's regular font.
Need the bill in Word? Click Word under the bill to download it as a .docx file, at the same A4, A5 or 80 mm thermal size as the PDF. It opens in Microsoft Word and Google Docs. The bill is placed in the file as a picture, so make any changes here and download it again.
Festival and bulk orders
- Corporate Diwali orders: write the company name, the number of boxes, the box contents and the delivery date; enter any advance in Bill settings to show the balance.
- Wedding and puja orders: list each sweet by kilogram and add a line for packing or delivery.
- Return gifts: bill per box and note the box size (250 g, 500 g, 1 kg).
- Bulk discount: add it as a percentage line so it is visible on the bill.
Gift boxes, packing and delivery on the bill
Festival sales are increasingly about gift boxes rather than loose sweets. Bill a gift box by the box, not by weight, and describe it on the line — "Premium dry-fruit box, 500 g (kaju katli, badam barfi, pista roll)". Fancy packing, ribbon or a printed message card can be a separate line or included in the box price; either way, the customer should see it. For deliveries to several addresses — common with corporate orders — write one bill for the whole order with a delivery charge, and attach the list of addresses separately so the bill itself stays readable.
Sweet shop bill format in Excel for festival planning
Before Diwali or Raksha Bandhan, many shops plan production from a list of advance orders, which is why the sweet shop bill format in Excel is a common search. A simple routine works well: make each customer's order bill here, then note the order number, customer phone, delivery date, kilograms of each sweet and balance due in a spreadsheet. Adding up the kilograms per sweet tells the kitchen how much khoya, besan or dry fruit to prepare, and sorting by date gives the delivery schedule. The bill stays the document the customer receives; the sheet stays the kitchen's plan.
Sweet shop bill book or this generator?
A sweet shop bill book with a carbon copy is cheap and familiar, and most halwais keep one at the counter for small cash sales. Its look is part of the shop's identity — the red or blue printed header, the shop's name in bold and the handwritten lines below — which is why the bill book templates here copy that style rather than looking like a computer printout. The weak spots are adding up weights at speed and keeping readable copies for bulk orders. Many shops use the bill book for walk-in customers and this generator for festival orders, corporate customers and anyone who asks for a proper bill on WhatsApp.
Sweet shop bill checklist
Before you hand over or send the bill, a ten-second check catches most mistakes:
- Weight of each sweet without the box.
- Rate per kg on every line.
- Gift boxes billed per box with their size.
- Festival or bulk discount on its own line.
- Best-before advice for milk sweets.
- Advance and balance for wedding and corporate orders.
Related bill types
Bakeries and cake shops should use the bakery bill for cake orders with advance and balance; grocery and namkeen counters can use the grocery bill; and for a plain bill book look, try the cash memo. All bill types are on the handwritten bill generator page.
Fair use
Issue sweet shop bills only for real sales, with the real weights and amounts. Making a bill for sweets that were never bought — for example to claim a festival gift expense — is fraud.