01
The Instructions Sheet
Four things to read first, eight steps and what the workbook does not do.
Bakery and Sweet Shop Bill Format in Excel, with GST and Your FSSAI Number (2026)
A counter that sells sweets by the kilo, cakes by the piece and a cold drink on the side is billing three GST rates at once, and every bill has to carry your 14-digit FSSAI number. This free Excel looks each item up in your own price list, works the GST out of your prices and gives the bill the right title. Updated November 2026.
- Your FSSAI number printed on every bill, as FSSAI requires
- Each item at its own rate: 5%, nil or 40%, from your price list
- An invoice-cum-bill of supply when parathas and cake share a bill
No spam. Instant download link to your
email.
Petpooja presents
Bakery and Sweet Shop Bill
For counters that sell by the kilo and the piece
5%
GST on cakes, sweets and namkeen · Excel
2026
What's Inside
Five sheets from your price list to a bill the customer keeps
02
The Item List
Your price list for up to 60 items, with HSN, GST rate and unit. Twelve common items come filled in, each with the entry its rate comes from.
03
The Bill
Up to 12 lines picked from the Item List, by the kilo or the piece, with the GST taken out of your prices, a summary by rate, round off and the amount in words.
04
The Check List and Notes
Below the print area: the FSSAI number, GSTIN and bill number checked, items not in your list caught, and a note when a bill needs a different title.
05
The Bill Rules
Thirteen provisions from FSSAI, the CGST Act and Rules, two rate notifications and a CBIC circular, quoted or summarised.
06
The Example Bill
Kaju katli, namkeen, a cake, pastries, parathas and two soft drinks for a walk-in customer: ₹3,520 on one invoice-cum-bill of supply.
Do all of this automatically with Petpooja Invoice
Petpooja Invoice connects to your weighing scale, works out GST on every invoice and keeps batch and expiry against each item, so a kilo of barfi is billed at the right weight and the right rate.
Explore Petpooja Invoice
Why This Matters
What a sweet shop's bill has to carry
Every bill a food business gives out has to carry its 14-digit FSSAI licence or registration number. The FSSAI order names mithai shops among the businesses whose number customers could not see, and it has been enforced since 1 January 2022.
Then the GST. Cakes, biscuits, rusks, sweets, namkeen, chocolates and ice cream have all been at 5% since 22 September 2025. Parathas and pizza bases are nil, and sweetened fizzy drinks are 40%. Our list of GST rates on sweets and festive food covers 33 items.
Nil and taxed items would normally need a tax invoice and a bill of supply. For a walk-in customer, Rule 46A lets one "invoice-cum-bill of supply" cover both. For walk-in sales under ₹200, you need not give a bill unless the customer wants one, but the sales go into a consolidated bill at the end of the day. Our cash memo format has that day-end sheet.
This workbook keeps your rates in one price list, so the person at the counter picks the item and the bill gets the HSN, the rate and the title right.
Sample Preview
What each sheet gives you
Here's a preview of what you'll get inside, sheet by sheet, in the order they open.
Instructions: Four things to read first, the sheets, eight steps and what the workbook does not do.
Item List: Item, HSN, GST rate, sold by, price per unit including GST, and where the rate comes from.
Bill: Shop details and FSSAI number, customer, item, sold by, HSN, quantity, price, GST rate, taxable value, GST, amount, a GST summary by rate, round off and the amount in words.
Check list and notes: FSSAI number, GSTIN, bill number and date, items not in the list, missing quantities, and notes on the bill's title, 40% items and sales under ₹200.
Bill Rules: Thirteen provisions, quoted or summarised, and what each means for your bill.
Example Bill: Bill SSB/26-27/1042: Rupees Three Thousand Five Hundred Twenty Only, with 5%, 40% and nil items on one invoice-cum-bill of supply.
... all 5 sheets in one Excel file, with the formulas locked and the input
cells in yellow.
Key Stats
Three numbers on every counter bill
14 digits
Your FSSAI licence or registration number, which goes on every cash receipt, cash memo and bill you give out.
Source: FSSAI orders of 8-Jun-2021 and 30-Sep-2021, read 02-Nov-20265% on most of the counter
Cakes, pastries, biscuits, rusks, sweets, namkeen, chocolates and ice cream, from 22 September 2025.
Source: Notification 9/2025-Central Tax (Rate), Schedule I entries 116, 123, 124, 141, 142 and 143, read 02-Nov-2026₹200
Below this, a walk-in customer who does not want a bill need not get one, as long as the sale goes into a consolidated bill at the end of the day.
Source: CGST Act, section 31(3)(b), and Rule 46, read 02-Nov-2026
Common Mistakes
7 Billing Mistakes Sweet Shops and Bakeries Make
01
Leaving the FSSAI number off the bill
FSSAI requires the 14-digit number on every bill and cash memo. The Bill prints it, and its check list flags a missing or wrong number before you print.
02
Charging cakes and biscuits at 18%
Cakes, pastries and biscuits moved to 5% on 22 September 2025. Our post on new GST rates on food lists what changed. A billing setting from before then is out of date.
03
Taxing parathas and pizza bases
Paratha, parotta, other Indian breads and pizza bread are nil under the exemption notification in force from 22 September 2025. Check they are not still taxed on your bills.
04
Putting a soft drink at 5%
Sweetened or flavoured aerated drinks are at 40%. Keep them on their own line with their own rate, which the Item List does.
05
Calling a mixed bill a tax invoice
A walk-in bill with nil and taxed items can be one invoice-cum-bill of supply under Rule 46A. A bill of only nil items is a bill of supply.
06
Billing counter sales as restaurant service
For ice cream parlours, CBIC said selling already made goods without cooking is a supply of goods, not restaurant service (Circular 164/20/2021). In our reading the same holds for ready sweets sold across the counter. If you also serve food to eat in, ask your accountant how to bill that part.
07
Weighing the box with the sweets
Weigh the sweets before they go in the box, or take the box's weight off. Our sweet box checklist covers packing, labels and dates.
Comparison
A Bill Book vs This Workbook
| Aspect | A printed bill book | With this workbook |
|---|---|---|
| FSSAI number | Often missing | Printed on every bill, checked for 14 digits |
| GST rate | One rate for everything, or an old one | Each item's rate from your price list |
| GST in the price | Worked out by hand | Taken out of your prices under Rule 35 |
| Parathas and cake together | Called a tax invoice | Titled invoice-cum-bill of supply |
| Sold by weight | Rounded to the kilo | Quantities to the gram, 1.25 for 1.25 kg |
| Composition dealers | Same bill, with tax | Prints as a bill of supply, with no GST |
Swipe the table sideways to see the full comparison.
A counter bill that gets the rate and the FSSAI number right
Download the free bakery and sweet shop bill format and see every bill checked before it prints.
FAQ
Frequently asked questions
What should a bakery or sweet shop bill include?
Under Rule 46 of the CGST Rules, among other things: your name, address and GSTIN, a bill number and date, the HSN code, description, quantity, taxable value, the rate and amount of GST, and a signature. As a food business you add your 14-digit FSSAI number, which a customer can look up on FSSAI's portal, as our guide to checking an FSSAI licence explains. This page is general guidance, not legal or tax advice.
What is the GST rate on sweets, cakes and namkeen?
5% for each, from 22 September 2025: sweets (sweetmeats), cakes, pastries, biscuits, rusks, namkeen, chocolates and ice cream are all in Schedule I of Notification 9/2025-Central Tax (Rate). Parathas and pizza bases are nil, and sweetened aerated drinks are 40%. Check anything else with our HSN code finder.
Do I have to give a bill for every small sale?
Not for a walk-in sale under ₹200 where the customer does not ask for one. Section 31(3)(b) of the CGST Act and Rule 46 then require a consolidated invoice for those sales at the close of each day. Our cash memo format has a day-end sheet for it.
Can parathas and cake go on the same bill?
Yes, for a customer who is not registered. Rule 46A allows a single invoice-cum-bill of supply for taxable and exempt goods sold to an unregistered person. For a registered customer, give a tax invoice for the taxable items and a bill of supply for the exempt ones.
Is a sweet shop's sale a restaurant service?
On CBIC's reasoning, selling ready-made sweets and bakes across the counter is a sale of goods. For ice cream parlours, its Circular 164/20/2021 said that selling already made goods, without cooking, is a supply of goods and not a service. If you also cook and serve food to eat in, that part can be restaurant service; ask your accountant.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement Petpooja helps Indian businesses run better, every day.
From the scale to the bill in the customer's hand
Petpooja Invoice connects to your weighing scale and works out GST on every invoice. Our reverse GST calculator shows the tax inside any price. Every item's HSN code decides its rate. Ask for a walkthrough of Petpooja Invoice.
Book a Free Demo
Call: +91-92279 80766