An inventory variance (or stock discrepancy) is the gap between the stock your system records and the stock you actually find. Your software shows 25 units, but you count only 22 in the store. Or the opposite: some items are physically on the shelf while your theoretical stock says they're sold out.
In other words, inventory variances are the differences between theoretical stock and the stock actually on hand.
An occasional variance may just be a counting error. But when stock discrepancies become frequent or large, they can point to a problem with sales, receiving, transfers or, more broadly, with how stock movements are managed.
What is an inventory variance?
An inventory variance is the difference between the quantity actually counted for a product and the quantity recorded in your inventory system.
You're comparing two figures:
Theoretical stock (or book inventory) → the quantity that should be available based on recorded movements.
Physical or actual stock → the quantity actually on the shelf, in the stockroom or in other storage areas.
When the two quantities differ, you have a stock variance. For example:
Theoretical stock: 30 units
Physical stock: 27 units
Variance: −3 units
How do you calculate inventory variance?
The formula is simple:
Stock variance = physical stock − theoretical stock
Here are three scenarios.
Example 1: negative variance
Theoretical stock: 20
Physical stock: 18
18 − 20 = −2
Two units are missing compared with recorded stock.
Example 2: positive variance
Theoretical stock: 20
Physical stock: 23
23 − 20 = +3
The store has three more units than the system shows.
Example 3: no variance
Theoretical stock: 20
Physical stock: 20
20 − 20 = 0
Theoretical stock matches the stock actually counted.
But calculating the variance doesn't tell you where it comes from.
Why do theoretical and actual stock differ?
Theoretical stock is only reliable if every movement is recorded correctly. So errors can creep in at different stages of a product's life cycle.
Supplier receiving errors
A delivery contains 48 units, but 50 are recorded in the system. Theoretical stock immediately shows two units too many. The error can also come from a partial delivery, a typo in the quantity or a product received under the wrong SKU.
Sales recorded incorrectly
If a product leaves the store without the corresponding movement being recorded correctly, physical stock goes down but theoretical stock doesn't change. The variance builds up gradually.
Mishandled customer returns
A returned item may be put back on the shelf without being re-entered in the system. In that case, actual stock ends up higher than theoretical stock. Conversely, a product recorded as returned that can't actually be resold has the opposite effect.
Unrecorded breakage or loss
A broken, damaged or lost product is no longer available for sale. If this outflow isn't recorded, it still shows up in theoretical stock.
Forgotten transfers between stores
In a business with several stores, a transfer recorded incorrectly can leave stock too high in the sending store and too low in the receiving store.
Counting errors
The variance can also come from the count itself: a product left out in another area, a unit miscounted, a case counted as a single unit, two variants mixed up.
Positive vs. negative inventory variance: what does it mean?
The sign of the variance gives you a first clue.
Negative stock variance
Physical stock is lower than theoretical stock. For example, a variance of −5 units means five units that should be there can't be found during the count. Start by checking sales, breakage, losses, transfers and receipts.
Positive stock variance
Physical stock is higher than theoretical stock. For example, a variance of +4 units means you have four more units than the recorded quantity. An under-recorded receipt, a mishandled return or a movement recorded against the wrong SKU can all explain this variance.
So a positive variance isn't necessarily good news: it still shows that your stock data doesn't match reality.
Why do inventory variances matter?
A few units off may not seem like a big deal. But theoretical stock drives many decisions.
Hidden stockouts
The system shows 8 units when only 2 are actually left. The store owner thinks there's enough of a buffer and doesn't restock. The product may then run into a stockout sooner than expected.
Unnecessary supplier orders
The opposite problem exists too. If the system underestimates the quantity actually on hand, the business may reorder products it already has. That needlessly raises stock levels and ties up cash.
Wrong product availability
When stock data feeds an online store or another sales channel, a variance can also lead to showing a product as available when it really isn't anymore.
Skewed analysis
Stock data is also used to analyze inventory turnover, plan restocking or identify dead stock. If the starting quantities are wrong, decisions based on this data become less reliable too.
How do you fix an inventory variance?
When you detect a variance, don't rush to change the theoretical quantity. It's better to work through it step by step.
- Recount the productCheck physical stock again. Make sure every area has been checked: shelf, stockroom, display case, prep area or any other possible location.
- Check the SKUMake sure the product you counted matches the right SKU, pack size or variant. Two similar items are easy to mix up.
- Review recent movementsIf the variance is confirmed, look at recent movements: sales, receipts, returns, transfers, breakage, manual adjustments. The goal is to pin down when the difference may have appeared.
- Adjust theoretical stockOnce the actual quantity is confirmed and the necessary checks are done, adjust the stock record to match physical reality.
- Find the root causeThis step is essential. Correcting a −4 variance brings stock up to date today. But if you don't find the cause, the same problem can come back a few days later.
How do you reduce stock discrepancies?
The goal isn't to prevent every single error. It's mainly to keep anomalies from piling up unnoticed.
Use cycle counting
Rather than waiting for a full physical inventory, cycle counting lets you check a portion of your items regularly. You catch variances earlier, while the cause is still easier to track down.
Tighten up supplier receiving
Check the quantities actually received before approving the receipt. An error made at receiving can go unnoticed for weeks.
Record movements as they happen
Breakage, transfers, returns and adjustments should be recorded promptly. The later a movement is entered, the more likely it is to be forgotten.
Monitor items with frequent variances
Not every item needs the same level of control. A product that regularly shows gaps between actual and theoretical stock deserves more frequent checks. The cause may be the product itself, but also where it's stored, how it's packaged or how it's handled.
Should every variance be corrected automatically?
Not necessarily. An automatic adjustment would immediately make the system match the count, but it could also hide a recurring problem.
A large or unusual variance usually deserves a closer look before you correct it. The point isn't just to get theoretical stock right at a given moment. You also need to understand why it went wrong.
This matters most when the same item keeps showing anomalies.
How can Gillia help you analyze stock discrepancies?
Gillia is an AI agent for independent businesses. When stock, sales, receiving and transfer data are all in one place, the analysis can go beyond simply noting a variance.
A store owner can ask Gillia, for example:
“Which products have the most inventory variances?”
The analysis can help identify the items or product categories that regularly show anomalies.
They can also ask:
“Which movements could explain this stock variance?”
Depending on the data available, Gillia can help link the anomaly to recorded sales, receipts, transfers or other movements.
The goal is to move from a simple “4 units are missing” to a more useful question: “Why do units keep going missing for this item?”
Variance analysis can then become a routine check that identifies recurring anomalies and focuses checks where they're really needed. To see how this fits into the full cycle, read our guide to store inventory management.
A stock discrepancy is a signal worth understanding
An inventory variance shouldn't be seen only as a quantity to correct. It's also an indicator of how well inventory is managed.
An occasional variance may just be a simple mistake. Frequent variances on the same products, suppliers, stores or types of movement, on the other hand, suggest that a process probably needs reviewing.
The right approach is:
Count → compare → check → correct → understand the cause.
The sooner you detect variances, the easier it is to keep them from affecting restocking, stockouts, supplier orders and business decisions.
To learn more, explore Gillia inventory management: real-time tracking, stock entry from a photo and alerts before you run out.