The Instructions Sheet
Four things to read first, eight steps and what the workbook does not do.
The first stock order is one of the largest bills a new kirana pays, and the GST on it depends on more than the item: rice in a labelled bag is 5%, the same rice sold loose is nil. This free Excel lists 70 common items with the rate on each, then works out the cash you need, the GST you can claim back and your margin. Updated November 2026.
Four things to read first, eight steps and what the workbook does not do.
Five questions about your shop, then the order by category, the budget, the GST you pay and can claim back, and a list of what to fix before you buy.
70 items from rice and dal to detergent and agarbatti, each with its pack, GST rate and source, plus 40 blank rows. You enter packs, rates and prices; it works out the rest, line by line.
Fifteen provisions behind the rates and checks: GST rates, loose sales, input tax credit, composition, insecticide and drug licences, tobacco, MRP, carry bags and FSSAI.
A made-up kirana in Jaipur with ₹1,50,000 set aside: 68 lines, ₹1,23,453 cash out and ₹6,410 of GST to claim back.
The same order line by line, including rice sold loose from 25 kg bags and one warning on bread.
Petpooja Invoice scans barcodes at the counter, connects to your weighing scale for loose items, tracks batch and expiry dates, and updates your stock as you bill, so the opening count stays right after the first day.
Explore Petpooja InvoiceMost kirana lists stop at the item names. What they leave out is that the GST on rice, atta, dal, sooji, besan, poha and jaggery depends on how you buy and sell them. Bought pre-packaged and labelled, they are 5%. Sold loose from that bag, the sale is nil: the government's FAQs on pre-packaged goods say a loose sale from a pack "is not a supply of packaged commodity". You still pay your supplier the 5%, and with nothing taxed on the sale you cannot claim it back. The workbook counts it as cost.
Timing matters too. Stock bought before your GST registration is granted can still earn credit under section 18(1) of the CGST Act, if you register on time, declare it in FORM GST ITC-01 within 30 days of becoming eligible, and the invoices are less than a year old. Without the supplier bills, you cannot claim it.
Some lines need a licence before they go on the shelf. Mosquito coils and cockroach sprays are insecticides, which may be sold only under a licence. Medicines generally need a drug licence. A shop selling food needs at least an FSSAI Registration, which our FoSCoS registration guide walks through.
This workbook puts the rate, the credit and the licence check next to each item, so the order you take to your suppliers is one you can pay for and sell. Running the shop after that is covered in our grocery and kirana store operations guide.
Here's a preview of what you'll get inside, sheet by sheet, in the order they open.
GST on rice, atta, dal, sooji, besan and poha: 5% when pre-packaged and labelled, nil when they are not.
Source: Notification 9/2025-Central Tax (Rate), Schedule I, and Notification 10/2025-Central Tax (Rate), read 04-Nov-2026To declare stock held before your GST registration in FORM GST ITC-01, from the date you become eligible for the credit.
Source: CGST Rules, Rule 40(1)(b), read 04-Nov-2026Annual turnover up to which a food retailer needs an FSSAI Registration rather than a State Licence.
Source: FoSCoS Kind of Business table, Retailer row, updated 01-Apr-2026, read 04-Nov-2026Rice bought in a labelled 25 kg bag carries 5%, but sold loose by the kilo it is a nil sale, so that 5% cannot be claimed. Price the loose kilo on the full cost, GST included.
If you register for GST after buying, those bills are how you claim the GST on the stock through FORM GST ITC-01. An invoice more than a year old earns nothing.
Coils, vaporiser refills and cockroach sprays are insecticides. The Insecticides Act lets them be sold only under a licence from the licensing officer your State appoints.
A big first order of perishables is money that spoils in days. The shelf-life columns warn when the packs on order are more than will sell in time.
A packed item cannot be sold above the MRP printed on it. Work your margin from the MRP down, as our product pricing calculator does.
Plastic carry bags under 120 microns have been banned since 31 December 2022, and some States ban plastic carry bags altogether. Buy cloth, paper or compliant bags.
The first count is your opening stock, the baseline for every stock check after it. Our post on inventory mistakes retail stores make covers what goes wrong when it is skipped.
| Aspect | A handwritten list | With this workbook |
|---|---|---|
| The items | Names only | 70 items with pack, GST rate and the entry it comes from |
| Loose or packed | Not asked | The rate follows how you sell it |
| GST you pay | Lost in the total | Shown, with what you can claim back |
| Budget | Added up at the supplier's counter | Totalled by category and checked against the money set aside |
| Margin | Guessed | Worked out per line at your prices, less any GST |
| Licences | Found out later | Insecticides flagged; medicines and tobacco explained |
Swipe the table sideways to see the full comparison.
Download the free kirana opening stock list and see the cost, the GST and the margin before you buy.
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.
Petpooja Invoice keeps billing and stock in one place: barcode scanning at the counter, weighing-scale integration for loose items, and batch and expiry tracking. Our post on POS software for grocery stores explains what to look for. Ask for a walkthrough of Petpooja Invoice.