Gillia
Try Gillia Capabilities Point of sale Inventory Online store Bookings CRM & loyalty Quotes & invoicing Use cases Use cases Pricing Integrations What's new

Inventory variance: how to understand and fix stock discrepancies

Your software says 25 units are in stock, but you count only 22 in the store. Here's how to understand and fix an inventory variance.

Gillia helps you spot and understand stock discrepancies before they pile up.

Create an account
Inventory variance: how to understand and fix stock discrepancies

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.

  1. Recount the productCheck physical stock again. Make sure every area has been checked: shelf, stockroom, display case, prep area or any other possible location.
  2. Check the SKUMake sure the product you counted matches the right SKU, pack size or variant. Two similar items are easy to mix up.
  3. 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.
  4. Adjust theoretical stockOnce the actual quantity is confirmed and the necessary checks are done, adjust the stock record to match physical reality.
  5. 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.

Frequently asked questions about inventory variance

The formula is: stock variance = physical stock − theoretical stock. A negative result means the quantity actually on hand is lower than the recorded quantity. A positive result means it's higher.

Theoretical stock is the quantity your system calculates from recorded movements. Physical stock is the quantity actually on hand at the time of the count.

This can come from an under-recorded receipt, a mishandled return, a movement assigned to the wrong SKU or a counting error.

Regular cycle counts, carefully checked receipts, consistently recording every movement and monitoring items with frequent anomalies all help keep variances from building up.

What if you could spot inventory variances instantly?

Which products have the most inventory variances?

Gillia analyzes your stock data to spot inventory variances and help you understand their causes. Try it free for 14 days, no credit card required.

Try Gillia free