Cartix Prime Sign in

Stock taking in a retail shop: how to count stock without closing

Updated · 6 min read

For kirana, supermarket, bakery and medical store owners who know their stock figures are off but cannot shut the shop for a day to count. This guide shows how to count in small parts while billing continues, how to handle sales during the count, and what to do with the differences you find.

Stock taking without closing: the short answer

Do not count the whole shop at once. Count one area or category at a time, a little every day or every week, while billing continues. This is called cycle counting. Over a month or a quarter, every shelf gets counted, and you never close the shutter.

The trick is to handle sales during the count correctly. Either pause billing for that one category for 15–30 minutes, or count first and let the software work out what was sold while you counted. Both methods are below.

Why the computer stock and the shelf do not match

Every shop has a gap between the stock in the software and the stock on the shelf. Before blaming staff, know the usual causes:

CauseExampleHow to spot it
Wrong item billedCashier bills "Surf Excel 1kg" for a 500 g packOne item short, a similar item over by the same amount
Unit mistakesLoose sugar entered as pieces, or a case of 12 entered as 1Large odd variances, often negative stock
Purchase not enteredGoods arrived, bill kept asideShelf has more than the system
Wastage and expiryBread, milk, vegetables, broken eggsRegular small shortages in fresh items
Free items and own useScheme freebies, items taken homeShortages never written down
Weighing lossLoose dal sold slightly over weightSteady shortage in loose items
TheftSmall, costly items: chocolates, razors, cosmeticsRepeated shortage in the same items

In most shops, billing and entry mistakes explain more of the gap than theft. Fix those first. Then what remains is easier to see.

Cycle counting: count by area or category

Split the shop into counting zones. Use the way your shelves are already arranged:

  • Zone 1: rice, atta, dal, sugar, oil (staples)
  • Zone 2: biscuits, snacks, chocolates
  • Zone 3: soaps, detergents, personal care
  • Zone 4: dairy, bread, frozen
  • Zone 5: godown and back stock

Then decide how often each zone is counted. A simple rule:

Type of itemHow often to count
Costly or often stolen (cosmetics, chocolates, baby food, razors)Every week
Fast movers (oil, rice, sugar, milk)Every 2 weeks
Fresh items (bread, dairy, vegetables)Check daily for expiry, count weekly
Everything elseOnce a month or once a quarter
Whole shop, including godownOnce a year, before 31 March

A small kirana with 1,500 items can count about 50–75 items a day and cover the whole shop in a month. A supermarket can give one staff member two hours every morning before the rush.

Counting sheets or phone scanning

Printed counting sheets list each item in the zone with a blank column for the count. They are cheap and work without any device. But someone must type the numbers in later, and a hidden extra row can go missing.

Scanning with a phone or scanner is faster and avoids typing mistakes. Scan the barcode, enter the quantity, move on. Loose items and items without a barcode are found by name.

Counting sheetPhone scanning
CostPaperA phone you already have
SpeedSlower; typing laterFaster; counts go straight in
MistakesReading handwriting, skipped rowsWrong barcode if items are mixed
Items not in the systemWritten on the sheetMust be added first

Whichever you use, do not show the counter the system quantity before counting. A person who sees "24" tends to find 24. Count blind, then compare.

Who should count

Ideally, the person who counts a zone is not the person who looks after it. The staff member who stocks the biscuit shelf knows it best, but may also be the one who made the entry mistakes. Pair people: one counts, one writes or scans. Rotate zones between staff every few months.

The owner should count the costly zone personally now and then, without notice. It keeps everyone careful, and it shows the owner what counting really involves.

Handling sales during the count

This is where most counts go wrong. A packet sold while you are counting the shelf is either counted twice or not at all. Choose one method and stick to it.

Method 1: freeze the zone

Tell the counter staff that zone 2 is being counted. For the next 20 minutes, any biscuit or snack the customer brings is kept aside on a tray and billed after the count is saved. This is simple and works well for small zones in quiet hours.

Method 2: count while selling

Note the time the count starts. Count normally while billing continues. When you save the count, the software compares your count with the stock at the start time, and adjusts for anything sold after that. Without software that does this, use Method 1.

Two more rules

  • Do not count a zone while goods for it are being unloaded. Enter the purchase first, then count.
  • Count the shelf and the back stock for an item in the same session. Otherwise the same packet can move from back to front and be counted twice.

Variance: what to do with the differences

Variance is the counted quantity minus the system quantity. A negative variance means stock is missing. A positive one means you have more than the system says.

  1. Recount anything big. If the difference is more than a few pieces or more than a few hundred rupees, count again, ideally by a different person.
  2. Look for a matching pair. If one item is short by 6 and a similar item is over by 6, it is a billing mix-up, not a loss.
  3. Check units. A variance of exactly 12 or 24 often means a case was entered as a piece.
  4. Check purchases. A positive variance often means a supplier bill was not entered.
  5. Give a reason to each adjustment: wastage, expiry, damage, theft, billing error, unit error. Over months, these reasons show where the money is going.

Measure variance in rupees, not only in pieces. Ten missing packets of salt matter less than one missing perfume.

If you are GST-registered, note that input tax credit cannot be kept on goods that are lost, stolen, destroyed or written off, under section 17(5)(h) of the CGST Act. So write-offs from your stock count may need an ITC reversal. Ask your CA how to show this in your returns.

Public shrinkage benchmarks for Indian kirana stores are not reliable, so do not chase an industry number. Track your own shortage as a percentage of sales each month, and aim to bring it down.

Step-by-step plan

  1. Prepare the item list. Fix duplicate items, wrong units and missing barcodes first. A count is only as good as the item master.
  2. Enter all pending purchase bills and returns. Do not start with a backlog.
  3. Make the zone list and a calendar: which zone on which day.
  4. Pick a quiet time, such as 9 to 11 in the morning, not the evening rush.
  5. Tell the counter which zone is being counted and which method you are using.
  6. Count blind, shelf and back stock together, by barcode or by name.
  7. Save the count and review the variance list the same day.
  8. Recount big differences, then post the adjustments with reasons.
  9. Fix the cause: correct a unit, add a missing barcode, train a cashier, move costly items closer to the counter.
  10. Repeat with the next zone. Review the month's shortage in rupees on the first of each month.

Do one full count of the whole shop and godown before the end of the financial year, so your closing stock for the accounts is real. That count is also your fresh start for the year.

Doing this in Cartix Prime

Stock count (stock taking) is on the Silver plan and above. Items are found the same way as at the counter: scan the barcode, type the item code or the first letters of the name. Silver also has stock health reports and an activity log that shows who did what, which helps when you trace a variance back to a bill or a purchase entry. Silver costs ₹4,999 a year for 1 computer and 1 phone, or ₹1,099 for phone only, before 18% GST. See inventory management software.

Questions people ask

Can I do stock taking without closing my shop?

Yes. Count one category or area at a time while billing continues. Either hold sales of that category for 15–30 minutes while you count, or use software that adjusts for items sold after the count started.

How often should a kirana shop count stock?

Costly and often-stolen items every week, fast movers every two weeks, the rest monthly or quarterly. Do one full count of the shop and godown once a year, before 31 March, for your closing stock.

What is stock variance?

Variance is the difference between what you counted and what the system shows. A negative variance means stock is missing; a positive one usually means a purchase was not entered or a similar item was billed by mistake.

Why is my stock negative in the billing software?

Usually because a purchase bill was not entered, opening stock was skipped, the wrong unit was used, or a similar item was billed instead. Fix the cause, then correct the stock with a count.

Do I need to reverse GST credit on stolen or expired goods?

Section 17(5)(h) of the CGST Act blocks input tax credit on goods lost, stolen, destroyed or written off. A registered shop may need to reverse credit on such write-offs. Ask your CA how to report it.

Sources

  1. CGST Act, 2017, section 17: apportionment of credit and blocked credits (text)
  2. CBIC: GST frequently asked questions

This guide explains the rules in plain words; it is not legal or tax advice. Rules change: check with your CA for your business.

Bill faster, with less to remember.

7 days of Silver free. No card needed. From ₹599 a year after that.