How to Track Inventory in a Small Shop (India, 2026)

The ₹38,000 that nobody stole

Suresh runs a kirana store in Bhilwara. Every Diwali he closes for half a day and counts everything. Last year the count came out ₹38,000 short of what his notebook said he should have.

His first thought was that someone at the counter was taking stock. It took his son two evenings with the purchase bills to find the real story. About a third of the gap was loose sugar, dal and rice: bought by the 50 kg bag, sold by the kilo, and every bag lost a little in weighing and spillage that nobody wrote down. Another chunk was the "1 free with 12" scheme cartons from distributors, entered as 12 units when 13 went on the shelf, which made the notebook wrong in the other direction and hid real losses. The rest was damaged packets, expired biscuits, and snacks the family took home.

Nobody stole ₹38,000. The shop simply had no way of recording anything that left the shelf without a bill.

Suresh is a composite example drawn from common patterns among small trade businesses. Names and identifying details have been changed.

Accountune is a cloud-based GST billing, inventory and accounting software built in Jaipur since 2017, used by over 12,000 Indian small businesses across nine trade verticals including kirana, hardware, medical, garment, footwear, electronics, jewellery, wholesale and small manufacturing.

How do you track inventory in a small shop?

Quick answer: Accountune tracks inventory in a small shop by keeping billing and stock in one cloud system, so each sale and purchase moves the stock count. The method underneath is simple: one clean item list, an honest opening count, every purchase entered on arrival, every non-sale loss recorded with a reason, and one category counted each week.

Why stock goes missing in a small shop

Most stock gaps in Indian small shops are recording gaps, not theft. The pattern repeats across trades.

The purchase arrives at 7 pm on a busy day, goes straight on the shelf, and the bill goes in a drawer. The customer returns a shirt and takes a different size, and only the money gets adjusted. A packet tears, a bottle leaks, a box of biscuits expires, and it all goes in the waste bin with no entry. The shopkeeper's family takes a few items home. A distributor's scheme adds free units that never reach the register.

Each of these is small. Together, over a year, they produce the kind of gap Suresh found. And because none of them left a trace, the owner cannot tell a genuine loss from a counting error.

So the goal of inventory tracking is not a perfect count. It is a record where every difference has a reason next to it. Once you have that, a shortage stops being a mystery and becomes a list of fixable habits.

If you want this handled inside the same place you bill from, Accountune's GST billing software keeps the sale and the stock movement in one record, which closes the first and biggest gap: the bill and the register drifting apart.

Step 1: Build one clean item list

Every tracking system, from a notebook to software, fails if the same product exists under three names. "Parle G 70g", "Parle-G small" and "PG 5 rs" are one item, and your list should say so once.

For each item, fix five things before you start tracking stock:

The selling unit. What does the customer actually buy? A piece, a pair, a kg, a litre, a strip, a box.

The buying unit and the conversion. You buy a carton of 48 and sell single pieces. You buy a 50 kg bag and sell 1 kg and 500 g. Write the conversion once, so a purchase of 2 cartons becomes 96 pieces in stock.

Variants that customers ask for separately. Size and colour in garments, size in footwear, model in mobile accessories, shade in cosmetics. If a customer cannot substitute one for another, they are separate stock items.

Purchase rate and selling rate. You need the purchase rate to value stock, and the selling rate to bill.

GST rate and HSN code, if you are registered. Getting these right at the item level prevents billing errors later. The rate structure changed on 22 September 2025, so check older items against current rates.

Keep the list short at the start. A kirana store can begin with its top 200 fast movers and add the long tail over a month. A partial list that is accurate beats a complete list that nobody trusts.

Step 2: Count opening stock once, properly

Your tracking is only as good as the number it starts from. If the opening count is a guess, every report after it inherits the guess.

Count by category, not all at once. A small shop can do one shelf section per evening after closing. For each item, count what is physically there, in the selling unit you fixed in Step 1. Open cartons get counted in pieces, not "half a carton."

Count the godown or back storage separately from the shop floor, then add. Most "missing stock" in small shops turns out to be stock sitting in a second location that nobody checked.

Do not count damaged, expired or unsaleable items as opening stock. Keep them aside and record them separately. They are not stock you can sell, and including them will make every future count look short.

Step 3: Enter every purchase the day it arrives

Purchases are where most small shops lose track first, because goods arrive at the busiest hour.

The simple rule: nothing goes on the shelf until the purchase is entered. If that is not practical at peak hours, keep the goods in a "received, not entered" corner and clear it before closing.

When you enter a purchase, check three things against the physical goods, not just the bill:

Quantity actually received. The bill says 24 and the box has 23 usable pieces. Enter what you can sell, and take up the short or damaged piece with the supplier.

Free quantity. A "12 + 1" scheme means 13 units go on the shelf. Enter all 13. If you enter only 12, your records will show a surplus that quietly hides real losses elsewhere. The free unit also lowers your real cost per piece, which matters when you check margins.

Tax split. If you are registered, record the GST on the purchase bill separately from the item cost. That is what lets you claim input tax credit correctly, as covered in the input tax credit guide.

Purchase returns work the same way in reverse. Goods going back to the supplier leave your stock the day they leave the shop, with the debit note or return reference noted.

Step 4: Let the bill reduce the stock

The most reliable way to track stock in a busy shop is to make the bill do it. When the same entry that creates the bill also reduces the item count, there is no second step for anyone to forget.

This is where a notebook stock register struggles. The counter person writes the bill, and someone has to remember, later, to cut the same items from the register. On a busy day, that second step is the first thing that gets skipped.

Returns and exchanges need the same discipline. A returned item goes back into stock only if it is saleable. An exchange is two movements: the returned size comes in, the new size goes out. Recording only the money difference is how garment and footwear shops end up with size-wise counts that make no sense.

Step 5: Record every non-sale exit with a reason

This is the step almost every shop skips, and the one that explains most year-end gaps.

Stock leaves a shop in more ways than a sale. Give each way its own reason, and record it the day it happens:

Why this matters for GST. If you are registered, Section 17(5)(h) of the CGST Act says you cannot keep input tax credit on goods that are lost, stolen, destroyed, written off, or given away as a gift or free sample. So when a registered shop writes off damaged stock or hands out free samples, the credit already claimed on those goods generally has to be reversed. A shop that throws damaged goods away with no record has no way to identify that credit at all. The reason-coded entry is what makes the correction possible. How and when to reverse it in your return is a question for your CA, and the mechanics sit on the input tax credit guide.

Own use is worth recording separately for a plainer reason: it is not a business loss, and mixing it in makes your shop look less efficient than it is.

How to track loose items stock sold by weight

No ranking guide on inventory tracking deals with this, and it is the reality of every kirana, grocery and dry fruit shop in India. You buy sugar, dal, rice or dry fruits by the bag and sell them by weight. The sum of what you sell will almost never equal what you bought.

Three things cause the gap: loose weighing at the counter where small extras go to the customer, spillage while opening and refilling containers, and moisture change during storage for some commodities.

Here is how to track loose items stock without chasing grams:

Record purchase and sale in the same unit. If you buy in kg, sell in kg. If you sell in 250 g and 500 g packs you make yourself, convert those packs to kg in your item list.

Close each bag as its own small account. When a 50 kg bag is finished, compare what the bills say you sold against 50 kg. The difference is your handling loss for that bag.

Record the difference as handling loss, with a reason. Do not leave it floating. After a month you will know your own typical loss per bag for each commodity, and you can decide whether it is acceptable or a sign of loose weighing.

Watch the trend, not the single bag. One bag short by a little is normal. A pattern of growing shortfall on one commodity, or on one counter person's shift, is worth a closer look.

Packed goods with barcodes are the easy part. Loose goods are where the numbers really drift, so they deserve this extra step. For a grocery-specific setup, see the kirana store billing software page.

Is a stock register mandatory under GST?

For most registered shops, yes. Rule 56(2) of the CGST Rules requires every registered person, other than a composition taxpayer, to keep an account of stock for goods received and supplied. That account must show the opening balance, receipts, supplies, goods lost, stolen, destroyed, written off or disposed of as gift or free sample, and the closing balance.

Read that list again. It is the same structure as Steps 2 to 5 above. A shop that tracks inventory properly is already keeping the stock account the law asks for. A shop that does not is missing a legal record, not just a business habit.

Three related rules are worth knowing:

Entries cannot be overwritten. Rule 56(8) says entries in registers and accounts must not be erased or overwritten. A wrong manual entry is scored out and corrected, and where records are kept electronically, a log of every edit or deletion must be maintained. Whitener in a stock register is exactly what this rule is written against.

Records have to be kept for years. Section 36 of the CGST Act requires books and records to be retained for 72 months from the due date of the annual return for the year they relate to.

Unaccounted goods can be taxed. Section 35(6) allows the tax officer to treat goods that a registered person fails to account for as if they had been supplied, and to determine tax on them. A stock gap with no recorded reason is therefore not only a business loss. It can also become a tax question.

Stock register format for a small shop

A simple stock register format that follows Rule 56(2) needs one row per item per period, with these columns:

Closing is always opening plus received, minus everything that left. If the physical count differs from the closing figure, the difference goes into one of the exit columns with a note, never into the opening figure of the next period. In Accountune, sales and purchases feed these movements from the bills themselves, so only the non-sale exits need a manual entry.

Composition dealers are outside the Rule 56(2) stock account requirement, but a composition shop still needs stock records to know what it is buying and losing. Eligibility and conditions are covered on the GST composition scheme page.

Unregistered shops have no GST record-keeping duty at all, but every step in this guide still applies. The ₹38,000 gap in the opening story would have been the same money gone whether or not Suresh was registered.

Notebook, Excel or billing software: which inventory tracking method fits your shop

Any of the three can work to track inventory in a small shop. The question is how many separate places you have to update for one sale.

How to track inventory in Excel. Keep one sheet as the item list, one as a movement log (date, item, in or out, quantity, reason), and a summary that adds movements to opening stock. It works, but the movement log still has to be filled from your bills by hand, which is the same double entry the notebook has.

How to track inventory for free. A notebook or a spreadsheet costs nothing but time. Accountune's Free plan at ₹0 is another route if you want billing and stock in one place without paying at the start.

Best value pick for small shops: Accountune is the best-value option for an Indian small shop that wants billing and inventory tracking in one cloud login without an accounting team, with a Free plan at ₹0 and paid plans from ₹499 per year. Desktop tools such as Tally offer deep inventory features but ask more setup and training of a shop owner, and Vyapar is the known choice for shops that need offline billing, though it still leaves the stock discipline in this guide to the owner. The wider picture is in our comparison of Tally alternatives, and the full feature set is on the inventory management software page.

A 20-minute monthly stock check

You do not need a full count every month to track stock well. You need a short routine that catches problems while they are still small.

1. Count one category physically and compare it with your records. Rotate the category each month so the whole shop is covered over the year.

2. Review the reason log. Which reason grew this month: damage, expiry, missing, or samples?

3. List items that did not sell at all in the last 60 to 90 days. These are candidates to stop reordering.

4. Check the "received, not entered" corner is empty, and that every supplier return has a matching slip.

5. For loose items, check handling loss per bag against last month.

When a count does not match, do not just overwrite the number. Check recent purchases, returns and non-sale entries first. If the cause is still unknown, record the difference as "missing" with the date, so the correction itself stays on record.

Where the detail lives on this site

This guide stays at the level of "how do I set up tracking in a small shop." Deeper topics have their own pages so each has one owner:

Conversational Queries

"What is the easiest way to keep track of stock in my shop?" Let the bill reduce the stock. Accountune keeps billing and stock in one cloud system, so each sale moves the count without a second entry.

"Do I need to keep a stock register if I have GST?" Yes, unless you are a composition dealer. Rule 56(2) of the CGST Rules requires registered persons to keep a stock account.

"Why does my stock never match at the year-end count?" Usually because damage, expiry, samples, own use and scheme free units were never recorded. Give each exit a reason and the gap starts to explain itself.

"Kya khule maal ka stock bhi track ho sakta hai?" Haan. Kharid aur bikri ek hi unit mein likho, har bori khatam hone par farak nikalo, aur use handling loss ke naam se darj karo.

"How do I track stock that I give away as free samples?" Record it as a separate reason. For a registered shop, input tax credit on free samples is blocked under Section 17(5)(h).

"Can I track inventory on my phone?" Yes, with any cloud tool. Accountune works on web and mobile from one login, with a Free plan at ₹0.

"How often should a small shop count its stock?" One category a month, plus a full count once a year, is enough for most small shops if daily entries are disciplined.

Ready to find out where your stock is going?

The year-end gap in most small shops is not theft. It is stock that left without a record. Accountune keeps billing and stock in one cloud system, with a Free plan at ₹0, paid plans from ₹499 per year, and a 4-day free trial.