Cycle Count Variances: How to Fix Inventory Discrepancies

by | Jul 1, 2003 | Physical Inventory – Cycle Counting

Cycle counting is the process of verifying the on-hand quantity of a specific number of stock products every day. In previous articles, I’ve described how to set up and maintain an effective cycle counting program and why this is usually better than a full physical inventory for keeping your perpetual inventory accurate. But verifying on-hand quantities is only half the win. The other benefit is process improvement, including:

  • Making sure that all material movement is properly recorded

  • Ensuring that stock receipts are put away in the proper location

  • Verifying that the right quantity of the right item is shipped or pulled for assembly

  • Preventing shrinkage from theft and mishandling

 

What Counts as a Variance? (Definition & Formula)

Process improvement starts by analyzing significant stock discrepancies. A discrepancy (variance) is the percentage difference between the physical count and the system stock level at the time of the count:

Discrepancy % = Absolute Value of (Quantity Counted – Current Stock Level) ÷ Current Stock Level

Using the absolute value means you investigate when you find significantly more or less than expected.

  • Typical tolerance: 2%–5% (tight for expensive/low-piece items; higher for low-value/bulk items).

  • Example: With a 5% tolerance, any count more than 5% above or below the system level is investigated.

  • Many distributors also investigate when the value difference (count vs. system) exceeds a set dollar threshold.

Note: Most distributors, manufacturers, and retailers use a cycle count tolerance percentage of 2% – 5%. The percentage may vary by item. Inexpensive items that are stocked in bulk quantities should have a higher tolerance percentage than expensive items that normally have few pieces in stock.

This means that any actual count that is more than 5% greater or more than 5% less than the current stock level should be analyzed and investigated:

Many distributors will also investigate discrepancies if the difference in monetary value between the stock level and the counted quantity exceeds a certain number of dollars.

 

Common Causes of Cycle Count Variances (and How to Fix Them)

Investigating cycle count discrepancies can uncover procedural mistakes made in your warehouse, including:

  • Wrong quantity taken to fill an order.
  • Wrong product taken to fill an order.
  • Products filled from the wrong stocking location.
  • Stock put away in the wrong bin location.
  • Units of measure confused or misrepresented.
  • Data entry errors.
  • Damaged material mixed with good stock.
  • Material movement not properly recorded.

Let’s discuss some of the things that can indicate these specific reasons behind inaccurate stock levels, and actions you can take to improve material-handling policies and prevent future stock discrepancies.

Wrong Quantity Taken to Fill an Order

Indicator: No offsetting quantity of a similar inventory item.

Actions to Take:

  • Review recent transactions. Were pieces counted out, or were sealed cartons shipped?

  • Identify pickers associated with frequent discrepancies.

  • Look for vendor patterns—sealed cartons from a specific supplier not containing the stated quantity.

  • Train on proper measuring/counting for fills.

  • Allow only experienced employees to pick hard-to-count items.

  • Spot check quantities in sealed containers from questionable vendors.

  • Increase cycle count frequency for these items.

Wrong Product Taken to Fill an Order

Indicators:

  • Offsetting quantity of a similar item

  • Offsetting quantity of an unrelated item in a nearby bin

  • Offsetting quantity of a known substitute

Actions to Take:

  • Track how often each picker makes this error.

  • Ensure bins/products are clearly marked.

  • Don’t store very similar items next to each other.

  • If vendor part numbers are long/complicated, add a simple four-character random ID to the description and bin; pickers verify the match.

  • Train on differences between look-alike items.

  • Simplify the process for logging substitutions.

Products Filled from the Wrong Stocking Location (multi-bin systems)

Indicator: Offsetting quantity of the same item appears in another location.

Actions to Take:

  • Enforce pulling from the primary bin.

  • Replenish the primary from bulk storage more frequently so pickers aren’t tempted to grab from the wrong spot.

Stock Put Away in the Wrong Bin Location

Indicators:

  • Offsetting quantity appears in another bin containing the item

  • Quantity turns up in a bin assigned to a different product

  • A bin contains stray pieces that belong elsewhere

Actions to Take:

  • Assign your most experienced warehouse staff to receiving, put-away, and pick verification.

  • Have new employees pick under close supervision.

  • Make bin logic clear and well marked.

  • Establish a no-fault area: if someone isn’t sure where something belongs, it goes there; clear it daily.

Unit of Measure (UOM) Confused or Misrepresented

Indicators:

  • Physical count matches the system if expressed in a different UOM

  • Item is purchased in one UOM and issued in another

Actions to Take:

  • Train on purchasing vs. issuing UOM.

  • Add a UOM warning on the bin emphasizing the issuing unit.

Data Entry Errors

Indicator: The actual count agrees with what should be in stock, but the value was entered incorrectly in the system.

Actions to Take:

  • Provide extra training on data entry.

  • Use a check-digit / cross-foot method (sum of sheet lines must match sum of entries).

  • Record material movement with barcode readers to eliminate manual entry.

Damaged Material Mixed with Good Stock

Indicator: Quantity is correct, but some/all of it is not usable.

Actions to Take:

  • Make it simple to segregate and label damaged goods.

  • Reinforce the importance of properly identifying and accounting for damage.

Material Movement Not Properly Recorded

Indicator: No clear reason for missing stock.

Actions to Take:

  • Document procedures and paperwork for every type of movement.

  • Ask employees to list all the ways material could leave without being recorded; then simplify the required transactions.

  • Conduct a security review of the warehouse.

  • Enforce an unbreakable rule: nothing leaves without proper paperwork; violations trigger immediate consequences.

 

When to Investigate (Tolerance & Dollar Thresholds)

  • Investigate any variance beyond your percentage tolerance (e.g., 2%–5%).

  • Investigate any variance exceeding your dollar threshold, even if the percentage is small.

  • Tighten tolerances for A-items or high-value SKUs; loosen for cheap bulk items.

 

Turn Variances into Process Improvements

It’s impossible to achieve effective inventory management without accurate stock levels in your system. Cycle counting keeps quantities aligned with reality, but long-term accuracy requires acting on what variances reveal. Investigate, document the cause, correct the process, and the same discrepancies stop showing up.