MarCat

Physical stock count in a supermarket: counting section by section so shelf and system agree

How to run a physical stock count in a supermarket without closing: count sheets, a section plan, recounts, and correcting the system with a reason.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 18 November 2026

The system says 24 packets of a 1 kg salt. The shelf has 19. The store room has a carton of 12 nobody remembered. So the real number is 31, and the system was wrong in the other direction.

Every supermarket drifts. Goods arrive before the bill is entered, a pack is returned without an entry, a cashier scans one flavour three times for three different flavours. The only way to know the real stock is to go and count it. This guide is about doing that count well: section by section, with a plan, so the numbers you put back into the system are ones you can trust.

Full count or section count

Full count Section count (cycle count)
What Every item in the store, at one time One section, aisle or category at a time
How often Once or twice a year, often at year end Every week, rotating through the store
Store open? Easier closed, or overnight Yes, count before opening or in a quiet hour
Good for A clean starting point, year-end books Catching drift early, fixing causes while fresh

Most stores do best with both: a section every week so that nothing gets too far out, and a full count when the books need it.

Before the count

  1. Pick the section and write down its edges. "Aisle 3, both sides, plus the matching shelf in the store room." Goods for one section are often in two places.
  2. Enter every pending supplier bill for items in that section. A carton received but not entered will show up as "extra" stock and confuse the count.
  3. Enter every pending return, from customers and to suppliers.
  4. Tidy the shelf. Bring forward packs from the back, put stray items back in their own section. Count what is in the section, not what belongs elsewhere.
  5. Print or export a count sheet for that section: item name, barcode, size, MRP, and an empty column for the count. Do not print the system quantity on the sheet. People count better when they are not trying to reach a number.

The count sheet

A made-up example for a small section:

Item Barcode Size MRP Shelf Store room Total counted
Salt 8901234567890 1 kg ₹28 19 12 31
Salt 8901234567906 500 g ₹15 34 0 34
Sugar, loose (store code) per kg ₹48/kg 22.5 kg 50 kg 72.5 kg
Sugar 8901234567913 1 kg pack ₹55 16 24 40
Jaggery 8901234567920 1 kg ₹80 9 0 9

Two rules on the sheet:

  • Same item, two MRPs: count each MRP on its own line. Old and new packs are often separate stock in the system, so count them separately.
  • Loose items in the selling unit. Weigh open bags and bins and write kg. A sealed 1 kg pack and loose sugar by the kg are usually two different items in the list. Count them separately.

During the count

  1. Stop billing and receiving for that section while it is counted. If a customer wants an item from it, note it and bill it after.
  2. Two people per section: one counts, one writes. Counting aloud catches mistakes.
  3. Count shelf and store room for each item before moving to the next.
  4. Scan, do not read. If you are entering counts straight into a phone or PC, scan each pack's barcode. Reading names off a shelf is how flavours get mixed up.

After the count: compare, recount, then correct

Now put the counted numbers next to the system numbers.

Item System Counted Difference
Salt 1 kg 24 31 +7
Salt 500 g 34 34 0
Sugar, loose 75 kg 72.5 kg -2.5 kg
Sugar 1 kg pack 40 40 0
Jaggery 1 kg 15 9 -6

Then work down the list:

  1. Recount every line with a difference, with a different person. Many differences are counting mistakes and disappear here.
  2. Look for the cause before correcting. Salt +7: was a purchase bill entered for fewer cartons than arrived? Jaggery -6: a supplier return that left the store without an entry, or sales scanned as another item?
  3. Correct the system with a reason on every line: "count 19 Nov, purchase bill short-entered", "count 19 Nov, wastage". A correction without a reason teaches you nothing next time.
  4. Small loose-item differences are normal. A little sugar is lost to spillage and rounding at the scale. Decide a small tolerance for loose items, and look into only what is bigger.

If the same items keep showing differences week after week, the cause is a habit, not the count. The negative stock guide walks through the six usual causes and how to fix each at the root.

A weekly rotation

Split the store into sections and count one each week. A made-up plan for a mid-size store:

Week Section
1 Staples: atta, rice, dal, sugar, oil
2 Packaged foods: biscuits, namkeen, noodles
3 Personal care
4 Home care: detergents, cleaners
5 Beverages and dairy
6 Loose items and repacked goods

Count the sections with the most money in them, or the most trouble, more often. An ABC analysis tells you which items those are.

From our counter

We think the weekly section count matters more than the yearly full count. A full count fixes the numbers once. A section count, done every week by the same people, teaches the store where its numbers go wrong: which supplier's bills get entered late, which shelf mixes up flavours, which loose bin loses weight. By the time the yearly count comes, most of the store is already clean, and the count is a check, not a rescue.

The other thing we would say to any owner: do not hide the system number from yourself, only from the counters. Look at the difference after the count. That is where the useful information is.

Where software helps

Software cannot count the shelf for you. What it can do is make the count quicker and the result useful: print or export the item list for one section, keep each MRP as its own stock line, move stock the moment a bill or purchase is saved so there is less drift to find, and show stock movement so you know which items to count first.

How MarCat handles it

We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. This is what MarCat does here:

  • Stock moves on its own. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.
  • Two MRPs, two stock lines. When an MRP changes and you keep both prices, old and new stock each have their own count.
  • Your data is yours. You can export your item list whenever you want, for count sheets or anything else.

If you want to see how stock looks on a real store's system, message us on WhatsApp at +91 96787 65518.

Questions

How often should a supermarket count its stock?
A full count once or twice a year, and a small section every week. Weekly section counts catch problems while they are still small, and the full count becomes faster because most sections are already clean.
Do I have to close the store to count stock?
Not for a section count. Count one section before opening or in a quiet hour, and do not bill or receive goods for that section while it is being counted. A full count is easier on a closed day or overnight.
What do I do when the count does not match the system?
Recount first, with a different person. If the difference stays, look for the cause, such as a supplier bill not entered or a return not entered, before you correct the number. Then correct it with a written reason.
Should loose items be counted by weight?
Yes. Weigh open bags and bins and write the weight in the same unit the item is sold in, such as kg. Count sealed packs of the same item separately, because they are usually a different item in the list.