A customer is waiting for a carton of milk, your records say there's stock left, and your cashier has checked the shelf twice without finding one. If you're wondering how to track missing stock in a shop, start by confirming the count, then trace the records before deciding what happened.
That gap between your records and what's physically there is a stock discrepancy. Don't rush to blame anyone or change the balance just to make it match.
By the end of this guide, you'll know how to recheck the stock, calculate what's missing, review the relevant records and investigate calmly. You'll also know when to adjust your figures and what evidence to keep.
How do you track missing stock in a shop?
While the customer waits, ask someone to check the storeroom, returns area and other display positions. An empty shelf doesn't prove the goods have left your shop.
To track the difference, follow this order:
- Recount the item across those spaces, keeping cartons, packs and single units separate.
- Find the last reliable balance, such as a checked stock count.
- Trace every movement since that point: deliveries, sales, returns, transfers, damage and items set aside.
- Write down what explains the difference and what remains unexplained before adjusting your records.
Keep your stock discrepancy investigation narrow: one product, one location and a clear period, such as the time since your last confirmed count. You're checking what happened, not deciding who's at fault.
Don't accuse staff or change the balance just to make the figures agree. Start with the missing item and gather its movement records for that period.
How do you check whether the stock count is wrong?
Two similar-looking packs sit beside each other, but only one matches the missing item. Recount the exact product, checking its size, colour, strength or pack size rather than trusting a familiar label.
Count the shelf, storeroom and goods set aside for customers separately, then total them. Include damaged or expired goods in your physical check, but list them apart from sellable stock so they don't inflate what's available to sell.
Use one counting unit throughout. For example, two packs containing 12 units each plus five loose units equal 29 units, not seven. Make sure your records use that same unit before comparing.
Write down the count time. Record any sales, deliveries or transfers during the count so your physical total and recorded balance share the same cutoff.
Kraota's stock counts, inventory per location, and units and pack conversions help you keep the item, branch and counting unit consistent. They support the check, but you still need to confirm what's physically there.
Next, use that checked count to work out the gap.
How do you work out how much stock is missing?
You've counted 22 units, but is that actually short? First, calculate what should be there, then subtract your physical count.
Start from the last reliable count, using it as your opening stock. Keep the same product, location, counting unit and cutoff time throughout. Don't mix one branch's deliveries with another branch's sales.
Formula: Expected stock = opening stock + goods received + transfers in + customer returns put back into stock − sales − transfers out − supplier returns − recorded write-offs.
Example: You started with 30 units, received 12, sold 15 and recorded two damaged units as a write-off:
30 + 12 − 15 − 2 = 25 expected units.
A physical count of 22 sellable units means three units need explaining. Keep the two written-off damaged units listed separately if they're still on the premises. Don't subtract damage again if it's already included as a stock adjustment.
Use a small investigation table to keep your stock reconciliation focused:
| Product | Expected quantity | Counted quantity | Difference | Evidence to check |
|---|---|---|---|---|
| Example: bottled lotion | 25 units | 22 units | 3 units short | Sales records, delivery receipt, damage adjustment |
Kraota's sales records, goods receipts, stock transfers and adjustments can help you reconstruct this balance. They give you records to check, not an automatic explanation for the gap.
With the shortage written down, check the supporting records before treating those three units as lost.
Which records should you check for missing stock?
Start with sales and returns. A customer may have collected an order from WhatsApp while the sale is still waiting in your notebook. Compare receipts and sales records with notebook entries and WhatsApp orders awaiting entry.
For each refund, ask: did the goods actually return to the shop? A payment reversal alone isn't proof that an item came back. LedgerGurus lists refunds and giveaway products among the leads worth checking when investigating stock discrepancies.
Use this cause-and-evidence table to guide your checks:
| Possible cause | Evidence to check |
|---|---|
| Sale not entered or return recorded incorrectly | Receipt, sales entry, WhatsApp order and confirmation of goods returned |
| Supplier delivery recorded incorrectly | Purchase order, supplier delivery note and goods receipt |
| Branch transfer not fully recorded | Dispatch record and receiving branch's confirmation |
| Samples, giveaways, personal use, damage or expiry | Dated record showing product, quantity, reason and who authorised it |
Compare supplier paperwork with what physically arrived. Check for short deliveries, mixed-up products and purchases entered before the goods reached your shop.
In Kraota, sales records, returns and refunds help you trace customer transactions. Purchase orders and goods receipts help you compare what you ordered with what arrived, while branch transfers help you trace stock sent elsewhere.
For other unrecorded stock movements, ask for supporting records. "We used some" needs a product, quantity and date before it explains the gap.
How do you investigate a stock gap without blaming staff?
You're at the shelf with your cashier, looking at a gap neither of you can explain. Start with a neutral question: "What happened to this product between the last count and today?" Speak with the people who received, sold or moved it, rather than assuming the person on duty caused the shortage.
Review available audit history alongside receipts, stock records, sales records and transfer paperwork. Kraota's audit history can support this investigation, but a recorded action isn't proof of why goods are missing. An entry showing an adjustment tells you something was changed, not necessarily what happened to the goods.
Keep a short investigation note with:
- Confirmed explanations, with supporting records.
- Unresolved questions, including who can help clarify them.
- Evidence checked, so you don't keep repeating the same checks.
Don't label every unexplained difference as theft. If a pattern repeats, manually compare the affected products, locations and periods, then investigate what those cases share.
For access control, Kraota's team roles and permissions let a cashier sell without seeing profit. That limits access, but it doesn't establish what caused a stock gap.
When should you adjust stock after finding a discrepancy?
The shelf still has a gap, but don't rush to change the balance on your screen. Finish the recount and check the available evidence first. A stock adjustment corrects the recorded balance; it doesn't explain the original gap.
Before making a change, document the old balance, physical count, difference, date and explanation in your investigation log. If the cause remains unknown, write "cause unknown" and note what you checked. Don't invent a reason just to close the investigation.
Kraota supports stock adjustments and audit history. Keep your investigation log separately, and preserve the original receipts, count sheets and transfer records. If correcting a transaction already fixes the balance, don't enter the same loss again as an adjustment.
Then choose a process change that matches the finding: check deliveries before recording goods receipts, or record branch transfers when goods move, not later from memory.
Where should you start with a missing-stock check today?
Pick one product whose shelf count doesn't match your records. Recount it, including stock in the back room, and write down the count time.
Find its last reliable balance, then list every movement from that point to your recount. Check sales, deliveries, returns, transfers and adjustments. Mark each possible explanation confirmed or still unresolved, based on the evidence.
Copy this checklist into your notebook or spreadsheet:
- Product:
- Location:
- Counting unit, such as piece or carton:
- Last reliable balance and date:
- Movements since that balance:
- Physical count and count time:
- Difference between expected and physical stock:
- Evidence checked:
- Next action and person responsible:
Software won't explain every loss, but it can keep the records you need together.
Start Kraota's 14-day free trial to keep stock counts, sales records, adjustments and audit history in one place.



