Retail & hospitality operations

Retail Inventory Discrepancy Investigation: Six Steps from Difference to Closed Case

Domagoj Rade Co-founder
Store employee comparing a shelf label with a multipack of sparkling water in a supermarket aisle

The recount is done and it holds: the system shows 45 packs of sparkling water, the shelf holds 21, and nobody changed a number on purpose. Adjusting the record to 21 closes the line but not the question, and the same gap will come back. A retail inventory discrepancy investigation finds the record, the step or the place that caused the difference before anyone corrects it.

This guide starts where a cycle count ends, with a difference that survived the recount. A store team can work through six steps: write the case down, read the pattern, check the product, unit and place, rebuild the timeline, correct the right record and close the case. It also covers who approves what, and when a difference is not worth a case.

The store team investigates and follows up. Stock quantities stay in your inventory system, and anything that points to theft or fraud goes to whoever owns that topic in your company. The routine builds on our retail cycle count process and sits inside our wider guide to retail operations.

What a retail inventory discrepancy investigation covers

An inventory discrepancy is a difference between the quantity your system shows and the quantity physically in the store, and it stays after a recount. It is a symptom. The cause is one of four things: a record that was entered wrongly or not at all, a step that was skipped, a product or unit that was mixed up, or stock that is elsewhere or truly gone.

Not every difference needs a case. Open one when the difference is outside the tolerance you set for the count, when its value is above a limit you agree with finance, when the same product has been off before, or when the system shows negative stock. Everything else is adjusted with the matching reason and goes back on the next count list.

The value tells you how much effort is fair:

Value of a difference = (counted quantity − system quantity) × unit cost

A gap of 24 packs at $3 each is a $72 shortfall, enough to justify an hour of checking. One cheap item that is off by a single unit is not, unless it keeps coming back.

Two roles run the case. The investigator, usually the shift lead or an inventory coordinator, builds it. The approver, usually the store manager, signs off the correction. In a small store one person may hold both roles, but the person who made an entry should not approve its correction.

Step 1: Write the case down

Capture the facts before anyone starts searching: the product and variant, the unit, the location, the time of the count, the system quantity at that time, both counts, who counted, and what moved recently. Give the case one reference and keep every note, photo and export under it.

Photograph the shelf, the shelf label and the stock below it before anything is moved. A photo with the label in the frame shows later what was there when you counted.

Store employee photographing a shelf label and a lower shelf of sparkling water multipacks with a smartphone

Give the case a due date. An open case with no date waits behind the daily work while the evidence goes stale: deliveries are put away, sales cover the gap and the paperwork is filed.

Step 2: Read the pattern before you chase a cause

Look at the shape of the difference before you look anything up. Direction comes first. If the shelf holds fewer units than the record, stock left without a record or entered the record too many times. If the shelf holds more, stock arrived without a record or left the record without leaving the shelf.

These are the usual causes of an inventory discrepancy in a store, grouped by the pattern that gives them away.

The gap equals one delivery, one case or one transfer

A gap that matches a single event usually comes from a single entry: a delivery posted twice or not at all, a transfer sent but never received, or a case entered as one unit. Find that event first.

One product is short and a look-alike is over

Equal and opposite gaps on look-alike products, such as two flavors or two sizes at the same price, usually mean the wrong variant was scanned at the checkout, picked or received. Count the whole family together before you adjust either line.

Many products are off by a little

Small gaps across one bay or one delivery day point to a skipped step more than to a single mistake: returns that were not posted, units of measure that were mixed up, or stock used in the store without a record. Ask what the affected products have in common.

The same product is off count after count

A product that keeps coming back points to its identity or its place: two barcodes for one item, a product with two homes, or a shelf label on the wrong shelf. Fix that before you correct the quantity again.

The gaps cluster in one store, day or shift

When differences bunch up in one store, on one weekday or on one shift, compare how that team does the step that touches stock: receiving, returns, transfers or closing the day. The pattern points to a routine, not to a person.

A pattern gives you a first suspect, not a verdict. Steps 3 and 4 test it against evidence.

Step 3: Check the product, the unit and the place

Some differences are not lost stock at all. The units are on the shelf under a different record, or in a different place.

Compare the barcode or SKU on the shelf label with the item record, and check look-alike variants one by one. Shopify’s adjustment history is kept per variant and cannot show all variants at once, so each flavor, size or color needs its own check.

Check the unit of measure. A single item, a pack and a case are different counts, and a gap that equals a pack or case size is a strong hint that one step used the wrong one. Bundles and recipes add a twist: Square’s inventory documentation says stock movements of bundles, stock conversions and recipes generate adjustments for the composed item and its stockable components, so selling a bundle can move the stock of what is inside it.

Store employee comparing two look-alike multipacks of sparkling water with different colored bands

Then search again, this time with someone who did not count. Look beyond the shelf: backstock, displays, the returns area, the hold area and other aisles. Our retail stockroom organization guide shows how to give every storage position an address, and our retail damaged goods procedure covers the hold shelf.

Two kinds of stock are legitimately not on the shelf. Stock on the way to the store is not there yet, and Shopify shows it in a separate Incoming column until the transfer is marked as received. Stock reserved for special orders or layaways is not ready to sell, and Lightspeed’s help says to leave it out of counts.

If the product turns up, the case may end here: move it back, and correct the label or the location record so it stays there.

Step 4: Rebuild the timeline from the records

Start from the last moment the record and the shelf agreed, such as the last count or a clean delivery. List every movement since then: deliveries, sales, returns, transfers, damage and manual adjustments. Build two running totals: what the record shows after each event, and what the paperwork says should be on the shelf. The first line where the two totals split is the suspect.

Your system’s history supplies most of the lines. Shopify’s adjustment history shows the date, the activity and who or what made each change: a staff member, an app or a sales channel. It covers the last 180 days of one product or variant. Lightspeed Retail (R-Series) has an item history that logs sales, refunds, transfers, purchase orders, reservations, manual adjustments and counts, and says the rollout is in progress and may not be on every account. Square’s stock adjustment history shows who made each adjustment, what it cost and which locations were affected; its help article lists it for Plus and Premium subscribers. If your system keeps no history, the paper has to carry the case.

Store employee checking a printed delivery note at a stockroom office desk

The paper is the check. Use the signed delivery note, the transfer sheet, the return slips and the sales report, not the system, to work out what should be on the shelf. Our retail goods receiving checklist covers what to record at the door, and our retail stock transfer process covers both ends of a transfer.

Here is an invented example, not typical results. A grocery store counts lemon sparkling water on Monday, Nov 2, 2026. The record shows 45 packs, the shelf holds 21 and the recount agrees.

Date What happened Record Should be
Mon, Oct 26 Last count 18 18
Tue, Oct 27 Delivery of 24 posted 42 42
Tue, Oct 27 Delivery posted again 66 42
Wed, Oct 28 Sales, 8 packs 58 34
Fri, Oct 30 Transfer out, 3 packs 55 31
Sat, Oct 31 Sales, 10 packs 45 21
Mon, Nov 2 Count: 21 on the shelf 45 21

The two totals agree through the first delivery entry, split at the second one and stay 24 apart from then on, exactly the size of the delivery. The shelf was right and the delivery was posted twice. The sales and the transfer are cleared as causes, because both totals moved by the same amount each time.

A duplicate delivery entry hits every line on that delivery, so check the other products on it before you close this case.

Step 5: Correct the record that was wrong

Fix the cause, not the number. If a transaction was missing, duplicated or entered in the wrong unit, correct that transaction and the quantity follows. Lightspeed’s help gives an example for negative inventory: if items were sold but never received on an incoming purchase order, receiving them on that order corrects the quantity. In the example above, the approver reverses the second delivery entry, and no count adjustment is made because the count was right.

If stock really left or changed, adjust the quantity with the reason that matches what you found. Shopify’s adjustment reasons are Correction, Count, Received, Return restock, Damaged, Theft or loss and Promotion or donation, and Square’s predefined reasons include internal use and samples. Use a general correction only when no cause was found. A damaged item logged as a correction disappears into the count differences, and the pattern is lost.

One named approver reviews the evidence before the change is posted, and the investigator does not approve their own correction. Set the levels with your finance lead: for example, the store manager approves small differences, the area manager approves larger ones, and inventory control or finance sees anything unexplained above a set value. Some systems cannot reverse an adjustment, and Lightspeed says reconciling an inventory count cannot be undone, so read the case again before you post.

If the evidence points to theft or fraud, stop at the facts. Hand the case to whoever owns loss prevention or HR under your company’s policy, and do not question or accuse anyone yourself. Our guide to retail shrinkage prevention covers what to record when something goes missing and who should read it.

Step 6: Close the case and look for repeats

A case is closed when the next person can see what happened and what changed. Check these before you close it:

  • A cause is named from a short list: a wrong entry, a skipped step, a mixed-up product or unit, stock found elsewhere, a real loss, or unexplained.

  • The right record is corrected, with the matching reason and the approver’s name.

  • Evidence is attached: the count sheet, the history entries, the paperwork and the photos.

  • Related lines are checked, such as other products on the same delivery or the look-alike product.

  • The prevention step has an owner and a date, or the case says why none is needed.

  • The next count date for this product or bay is set.

Keep the list of causes short and use it every time. An unexplained case is allowed, but it should say what was checked.

Once a week, spend ten minutes on the closed and open cases. Count cases by cause. A cause that repeats is a process problem, so change the step that failed, for example by checking for an existing entry before a delivery is posted. Our corrective action report template is built for that kind of follow-up.

Track how many closed cases ended with a named cause:

Explained share = (cases closed with a named cause ÷ cases closed) × 100

If 18 of 24 closed cases have a named cause, the explained share is 75%. A low share means too many cases end without a reason, so look at how early the evidence is collected. Check every open case against its due date as well, and ask what is blocking it. Use the numbers to find the stores and areas that need help, not to rank people. Before any case is opened, our guide to retail inventory accuracy shows how to measure how many records are off and by how much.

Run investigations across many stores

Every store can run these six steps. The hard part is seeing, from the area manager’s phone or from head office, which cases are open, who owns them and which have stalled. Differences found in a count end up in chat threads, notes and spreadsheets.

Bitreport task management can turn each case into a task with an owner and a due date, ask for a photo of the shelf label or the delivery note as evidence, and let a reviewer mark up the photo and send it back with a note until it shows what is needed. On store visits, an audit item can check that open cases have an owner and a date, and a failed item creates a corrective task.

Bitreport is not an inventory system or a scanner-based count tool, and it does not post stock adjustments, so the history and the correction stay in your inventory system. To see how recurring checks and photo proof look across locations, book a Bitreport demo.

Frequently asked questions

What is an inventory discrepancy in retail?

An inventory discrepancy is a difference between the quantity your system shows and the quantity physically in the store, and it stays after a recount. It is a symptom. The cause is one of four things: a record that was entered wrongly or not at all, a step that was skipped, a product or unit that was mixed up, or stock that is elsewhere or truly gone.

When should a store open an inventory discrepancy case?

Open one when the difference is outside the tolerance you set for the count, when its value is above a limit you agree with finance, when the same product has been off before, or when the system shows negative stock. Everything else is adjusted with the matching reason and goes back on the next count list.

How do you find the cause of an inventory discrepancy?

Start from the last moment the record and the shelf agreed, such as the last count or a clean delivery. List every movement since then: deliveries, sales, returns, transfers, damage and manual adjustments. Build two running totals: what the record shows after each event, and what the paperwork says should be on the shelf. The first line where the two totals split is the suspect.

Who should approve an inventory correction?

One named approver reviews the evidence before the change is posted, and the investigator does not approve their own correction. Set the levels with your finance lead: for example, the store manager approves small differences, the area manager approves larger ones, and inventory control or finance sees anything unexplained above a set value.

Take control of your operations, before chaos takes control of you.

This field is for validation purposes and should be left unchanged.