Your software shows 25 units in stock, but you only count 22 in the store. Conversely, some items may be physically present while the theoretical stock considers them sold out.
These differences between the theoretical stock and the stock actually available are inventory variances.
An occasional variance can come from a simple counting error. But when stock variances become frequent or large, they can reveal a problem in sales, receiving, transfers or, more broadly, in the management of stock movements.
What is an inventory variance?
An inventory variance is the difference between the quantity actually counted for a product and the quantity recorded in the management system.
So you are comparing two figures:
Theoretical stock → the quantity that should be available based on recorded movements.
Physical or actual stock → the quantity actually present on the shelf, in the stockroom or in other storage locations.
When the two quantities differ, there is a stock variance. For example:
Theoretical stock: 30 units
Physical stock: 27 units
Variance: −3 units
How do you calculate a stock variance?
The formula is simple:
Stock variance = physical stock − theoretical stock
Let's look at three situations.
Example 1: negative variance
Theoretical stock: 20
Physical stock: 18
18 − 20 = −2
Two units are therefore missing compared with the 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
The theoretical stock matches the stock actually found.
But calculating the variance doesn't, on its own, explain where it comes from.
Why can theoretical stock and actual stock differ?
Theoretical stock is only reliable if every movement is recorded correctly. An error can therefore appear at different stages of a product's life.
An incorrect supplier receipt
A delivery contains 48 units but 50 are recorded in the system. The theoretical stock immediately has two units too many. The error can also come from a partial delivery, a mistyped quantity or a product received under the wrong item reference.
A sale recorded incorrectly
If a product actually leaves the store without the corresponding movement being recorded correctly, physical stock goes down but theoretical stock stays unchanged. The variance builds up gradually.
A customer return handled incorrectly
A returned item can be put back into stock physically without being re-entered in the system. In that case, actual stock becomes higher than theoretical stock. Conversely, a product recorded as returned that ultimately can't be put back on sale can create the opposite effect.
Undeclared 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 the theoretical stock.
A forgotten transfer between stores
In an organization with several points of sale, a transfer that is recorded incorrectly can create stock that is too high in the sending store and too low in the receiving store.
A counting error
The variance can also come from the count itself: a product forgotten in another area, a unit miscounted, a carton treated as a single unit, confusion between two variants.
Positive or negative variance: how to interpret it?
The sign of the variance gives a first indication.
Negative stock variance
Physical stock is lower than theoretical stock. For example, a variance of −5 units means five units that should be there aren't found during the count. You should check sales, breakage, losses, transfers and receipts in particular.
Positive stock variance
Physical stock is higher than theoretical stock. For example, a variance of +4 units means four extra units are present compared with the recorded quantity. An under-recorded receipt, a returned item handled incorrectly or a movement recorded against the wrong item reference can all explain this variance.
A positive variance is therefore not necessarily good news: it also shows that the stock data doesn't match reality.
Why do inventory variances cause problems?
A few units of variance may seem unimportant. Yet theoretical stock is used to make many decisions.
Invisible stockouts
The system shows 8 units when only 2 are really left. The merchant thinks they have enough of a margin and doesn't trigger restocking. The product may then hit a stockout earlier than expected.
Unnecessary supplier orders
The opposite problem exists too. If the system underestimates the quantity actually available, the business may reorder products it already has. This needlessly raises the stock level and ties up cash.
Incorrect product availability
When stock feeds an online store or another sales channel, a variance can also lead to showing a product as available when it no longer really is.
Skewed analyses
Stock data is also used to analyze product turnover, prepare restocking or identify dead stock items. If the starting quantities are wrong, the decisions made from this data can also become less reliable.
How do you fix an inventory variance?
When a variance is detected, your first reaction shouldn't be to change the theoretical quantity right away. It's better to proceed step by step.
- Recount the productCheck the physical stock. Make sure all areas have been checked: shelf, stockroom, display case, preparation area or any other possible location.
- Check the item referenceMake sure the product counted matches the right item reference, the right format or the right variant. Two similar items can easily be confused.
- Review the latest movementsIf the variance is confirmed, look for recent movements: sales, receipts, returns, transfers, breakage, manual corrections. The aim is to determine when the difference may have appeared.
- Correct the theoretical stockOnce the actual quantity is confirmed and the necessary checks have been done, the stock can be adjusted to match physical reality.
- Identify the causeThis step is essential. Correcting −4 brings the stock up to date today. But if the cause isn't identified, the same problem can reappear a few days later.
How do you reduce stock variances?
The goal isn't to prevent every occasional error. It is above all to prevent anomalies from piling up undetected.
Run cycle counts
Rather than waiting for a full inventory, cycle counting lets you check a portion of items regularly. Variances are thus detected earlier, when it is still easier to look for the cause.
Make supplier receipts more reliable
The quantities actually received must be checked before validation. An error created at receiving can stay invisible for several weeks.
Record movements when they happen
Breakage, transfers, returns and adjustments must be recorded regularly. The later a movement is entered, the greater the risk of forgetting it.
Monitor items that often show variances
Not every item needs the same level of control. A product that regularly shows differences between actual and theoretical stock deserves more frequent monitoring. The cause may be the product itself, but also its location, its packaging or its management process.
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 generally deserves a check before correction. The point isn't only to get a correct theoretical stock at a given moment. You also need to understand why it had become wrong.
This distinction is especially important when the same item regularly shows anomalies.
How can Gillia help analyze stock variances?
When stock, sales, receiving and transfer data are centralized, the analysis can go beyond simply noting a variance.
A merchant can, for example, ask Gillia:
“Which products show the most inventory variances?”
The analysis can help identify the items or product families that regularly show anomalies.
The merchant 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 aim is to move from a simple “4 units are missing” to a more useful question: “Why are units regularly missing on this item?”
Variance analysis can thus become a control routine to identify recurring anomalies and focus checks where they are really needed. To place this logic within the whole cycle, see our guide to store inventory management.
A stock variance is above all a signal to understand
An inventory variance shouldn't be seen only as a quantity to correct. It is also an indicator of the quality of inventory management.
An occasional variance can come from a simple mistake. Frequent variances on the same products, suppliers, stores or types of movement, on the other hand, suggest that a process probably deserves to be checked.
The right approach is therefore to:
count → compare → check → correct → understand the cause.
The sooner variances are detected, the easier it is to prevent them from affecting restocking, stockouts, supplier orders and management decisions.
To go further, discover Gillia inventory management: real-time tracking, stock entries by photo and alerts before a stockout.