Preventing Inventory Tracking Errors

The system shows 40 items, but there are 33 on the shelf. Or vice versa: the system says zero, yet boxes are sitting in the warehouse.

At this point, the software is usually the first thing to be suspected. Almost never is it the software. The discrepancy stems from a transaction that wasn't recorded or was recorded in the wrong order.

What changes inventory?

A major part of the confusion comes from not knowing which document actually affects inventory. The golden rule: the document that physically moves the goods changes the inventory.

• Purchase invoice / incoming dispatch note: Inventory increases.
• Sales invoice / delivery note: Inventory decreases.
• Order: Does not change inventory. An order is a statement of intent; the goods haven't moved yet.
• Collection / payment: Has nothing to do with inventory, only concerns money.

The answer to the complaint "I entered the order but the inventory didn't drop" is right here. It shouldn't drop.

Five sources of count discrepancies

• Opening inventory not entered. Still the most frequent cause. The program starts from scratch, and inventory drops into negative numbers on the first sale.
• Both the dispatch note and the invoice processed. The goods left once, but inventory was deducted twice. Decide from the start which document will affect inventory.
• Wrong warehouse selected. If you operate with multiple warehouses, the goods were deducted from another warehouse. The total looks correct, but the distribution is wrong.
• The same product opened as two cards. The same product with a different barcode creates two separate inventory balances.
• Off-the-record movements. Items given as samples, broken, or taken by staff. They physically left but were tied to no documents.

Negative inventory is not an error, it's a warning

Don't panic when you see negative inventory in the system; it is giving you a piece of information: a sale was recorded for this product, but the incoming entry wasn't.

It is almost always one of two reasons. Either the opening inventory wasn't entered, or the purchase invoice hasn't been processed yet. Instead of ignoring the negative balance, find its source; that same product will likely generate the same problem every month.

Establishing discipline: four rules

1. Start with a count. Do not make estimates when migrating to the program; count the warehouse and enter the actual quantity.
2. De-duplicate product cards. A single card based on the barcode or stock code. Prevent the same product from being opened a second time.
3. Clarify the document sequence. Do you issue a dispatch note and then an invoice, or an invoice directly? Follow the same workflow across your team.
4. Record off-the-record exits too. Samples, wastage, breakage — make sure they are all tied to a record. An unrecorded exit appears as a "loss" during the next count.

How often should you count inventory?

Instead of counting the entire warehouse once a year, counting 20-30 high-turnover products once a month is much more effective. Discrepancies are caught while they are small, making it easier to find the source.

A discrepancy of 200 units found six months later is no longer explainable; it is simply accepted.

Frequently asked questions

I sell services, do I need to keep inventory?

No. Service cards do not generate inventory movements. That's why it is important to define products and services as separate card types.

I have multiple warehouses, how do I manage them?

You need to define each warehouse separately and select the correct warehouse for every transaction. Also, record transfers between warehouses, otherwise one warehouse will appear negative and the other excessive.

I run an e-commerce business, how does inventory sync with marketplaces?

Inventory drops when marketplace orders are converted into invoices. We covered this workflow in the converting marketplace orders to invoices article; check out the e-commerce accounting article for common mistakes.

I can't delete the warehouse, why?

A warehouse with inventory movements cannot be deleted to preserve the integrity of past records. You can make it inactive if you are not using it.

Inventory tracking is not a software feature, but a team habit. When everyone issues the same document in the same sequence, the counts will match up.

By opening a free account on Qolay.App, you can enter your inventory cards and opening quantities today.