MarCat

Negative stock in billing software: why it happens and how to fix it at the root

Your software says -12 packs of a biscuit that is sitting on the shelf. The common reasons stock goes negative in a supermarket, and how to fix each one for good.

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

You open your stock report and see it: a biscuit at -12, a shampoo at -3, loose sugar at -18.5 kg. Yet the biscuits are on the shelf. Nothing is actually missing.

If it keeps happening, look at how purchases reach your stock and inventory management software, not only at the counter.

Negative stock means your software has recorded more going out than coming in. It is almost never a sign of theft. It is a sign that your records are in the wrong order or have a mistake in them. And it matters, because a wrong stock number makes everything built on it wrong: reorder, margin, dead stock, the count at year end.

The tempting fix is to correct the number to zero and move on. Do not. Find the cause first, or it will be back next week.

Cause 1: Sold before the purchase was entered

This is the most common one. The supplier delivers on Tuesday morning. The goods go on the shelf by noon and start selling. The supplier bill sits on the desk until Thursday. For two days, the software sees sales but no purchase.

Fix at the root:

  • No goods on the shelf without an entry. Make it a rule: the purchase is entered before the carton is opened, or at least the same day.
  • If the bill is late, enter from the delivery challan and match it to the bill when it comes.
  • One person owns purchase entry each day, so it is never "someone else's job".

Cause 2: Bought in one unit, sold in another

You buy soap in cases of 72 and sell by the piece. If the purchase is entered as "1 case" but the item's unit is pieces, the software adds 1 piece. Sell 10 pieces and you are at -9.

Loose items show the same problem: a 30 kg bag of dal entered as "1".

Fix at the root:

  • Enter purchases in the selling unit. One case of 72 soaps is 72 pcs. One 30 kg bag is 30 kg.
  • Check the conversion on the first purchase of every new item, then it is right every time after.

Cause 3: The wrong variant was scanned or picked

Two flavours of the same chips. Two sizes of the same oil. The cashier scans one pack and types quantity 3 for a mixed basket. One variant goes negative, the other gains phantom stock.

Fix at the root:

  • Scan every pack, not one pack times three, when the packs are not exactly the same.
  • Check that similar variants have different barcodes in your item list. If two variants share a barcode, that is a separate problem to fix.
  • Look for pairs. When one variant is negative, check its sister item. If it shows extra stock, you have found your cause.

Cause 4: Duplicate items

The same product exists twice in your item list, maybe from an old import or a rushed new entry. Purchases go into one, sales come out of the other. One climbs, the other sinks below zero.

Fix at the root:

  • Search the item list by barcode and by name for the negative item. If two entries come up, merge them into one and add their stock together.
  • Before creating a new item, always search first.

Cause 5: Returns not entered

A customer returns a pack and the cashier puts it back on the shelf without a return entry. Or damaged stock goes back to a supplier with no purchase return entered. Either way, the shelf and the software stop agreeing.

Fix at the root:

  • Every customer return is entered at the counter, at the time.
  • Every purchase return to a supplier is entered when the goods leave, not when the credit note arrives.

Cause 6: Opening stock was wrong

If you moved software or started fresh without a proper count, some items started with a guess. A low guess shows up later as negative stock.

Fix at the root:

  • Count those items and correct them once, with a note of why.
  • Then watch them for a month. If they go negative again, the cause is one of the five above, not the opening stock.

A weekly 15-minute routine

Step What to do
1 Pull the list of items with stock below zero
2 For each, check: is there a supplier bill not yet entered?
3 Check the unit on the last purchase entry
4 Look for a sister variant or duplicate with extra stock
5 Only then count the shelf and correct, with a reason noted

Go top-down: the most negative items and the fastest sellers first. Most weeks, the list gets shorter as the root causes are fixed. If the same items keep appearing, the problem is a habit at the counter or the receiving desk, not the software.

Why "correct to zero" is not enough

When you only correct the number:

  • Your margin report is wrong. Sales were recorded without the matching purchase cost.
  • Your purchase history is wrong. Reorder decisions based on it will be off.
  • The mistake repeats. Whatever caused it is still happening.

A correction is the last step, not the 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. Keeping shelf and system in step is a daily job in any supermarket. This is what MarCat does:

  • Stock moves on its own. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.
  • Purchase entry the way bills arrive. Purchase entry follows how a supplier bill actually comes in, with vendor records and outstanding balances in the same system.
  • One stock across counters. Multiple counters bill at the same time and share one view of stock.

If negative stock keeps showing up in your reports and you want to see how MarCat handles stock, message us on WhatsApp at +91 96787 65518.

Questions

What does negative stock mean?
Your software has recorded more sales of an item than it has recorded purchases and opening stock. The shelf is usually fine; the records are out of order or wrong.
What is the most common cause of negative stock in a supermarket?
Selling goods before the supplier bill is entered. The stock is physically in the store, but the software does not know it arrived yet.
Should I just correct negative stock to zero?
Not before finding the cause. If you only correct the number, the same mistake will push it negative again next week, and your purchase and margin reports stay wrong.
Does MarCat move stock automatically?
Yes. In MarCat, every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.