The count is over, the list is in your hand, and there are discrepancies in some products. The decision made at this point determines the quality of the next count.
The easiest way is to cut an adjustment slip and equalize the system to the physical state. This is an approach that ends the count but teaches nothing.
In this article, we explained the analysis that needs to be done before closing the gap, the recording method, and the habits that prevent repetition.
Table of Contents
Analysis first, correction later
The moment an adjustment slip is cut, the discrepancy disappears. The system and the physical state are equalized, and no data is left to look back on.
That is why the order is important: investigate the cause first, then record it. Half a day spent on analysis saves days in subsequent counts.
The most useful tool during analysis is the statement of account. Movements from the last known correct point to today are examined; we explained the method in the stock statement article.
Six reasons for the discrepancy
1. Unrecorded movement. An outflow or inflow has not been entered into the system. This is the most common reason and the easiest to prevent.
2. Duplicate record. The same document has been processed twice. The discrepancy appears in the reverse direction in this case.
3. Wrong product. Two similar products have been mixed up. In this case, there is a surplus on one card and a deficit on the other; both should be examined together.
4. Unit error. Boxes and pieces have been confused. The discrepancy usually appears as multiples of the box contents; see the unit definitions article.
5. Wastage and spoilage. The product has been broken, spoiled, or rendered unusable. This is not a recording error, but a real loss.
6. Incorrect count. The counter made a mistake. Making a second count for large discrepancies is standard practice.
Classifying the discrepancy
You do not have to tie every discrepancy to a cause; however, large discrepancies need to be classified.
A practical distinction is this: record-induced discrepancies and physical losses. The former is related to process correction, and the latter to security and storage conditions.
Wastage and spoilage are a separate category and should be tracked as a cost. This item reaches serious dimensions in retail; we covered it in the wastage and spoilage tracking article.
Waste in food and production can be a normal part of the manufacturing process. In this case, it is not a discrepancy, but a planned loss; kitchen waste tracking you can check out the article.
Recording method
The discrepancy is recorded with an adjustment slip. Writing the reason on the slip provides an opportunity for later analysis.
The reason field should consist of selectable categories instead of free text. Fixed values such as "Waste", "counting error", or "missing record" generate reportable data.
The adjustment slip is entered using the same screen logic as other stock slips; standard document entry thanks to this, the team does not have to learn a separate screen.
Work with your financial advisor for the accounting equivalent; how the discrepancy record is evaluated is important from a tax perspective.
Tolerance and approval threshold
Having every discrepancy go to a manager for approval slows down operations. Allowing every discrepancy to be closed freely eliminates control.
The balance is established with a tolerance threshold. Discrepancies below a certain amount or value are closed by the operator; those above fall to approval.
The threshold should be determined based on product value. Tolerance is kept tight for high-value products.
Who can approve at which threshold authorization determines. The person counting should be prevented from approving their own discrepancy.
Preventing recurrence
If the same product gives a discrepancy in every count, the problem is not in the count, but in the process. Three checks usually reveal the problem.
First, look at which documents created the movements of that product. If there is an undocumented exit, the source has been found.
Second, check barcode and unit definitions. Incorrect multiplier definition produces regular discrepancies; barcode management see the article.
Third, increase the counting frequency. The discrepancy remains small in a product counted monthly and its cause can be found; warehouse counting we explained the partial counting order in the article.
Discrepancy records in the stock module are kept attached to the slip; thus, periodic comparison becomes possible.
Cost impact of the discrepancy
Count discrepancy is spoken of in terms of quantity, but its impact is on the amount. A quantity discrepancy of one hundred units is insignificant in a cheap product, but a serious loss in an expensive one.
Therefore, discrepancy reports should be read on both a quantity and value basis. In some businesses, five percent of discrepancies account for eighty percent of the losses.
Stock that turns up missing is a direct loss. Stock that turns up in excess indicates that a past revenue was not recorded or a cost was miscalculated; that is also a problem.
The trend of the discrepancy rate over time is more meaningful than a single period's figure. If the rate is dropping, it means the process is improving.
In retail, this rate can also be compared with industry benchmarks; waste and loss tracking we covered this topic in the article.
A culture that does not hide the discrepancy
The biggest obstacle to the proper management of count discrepancies is not technical, but cultural. When a discrepancy turns into a tool for blame, it starts to get hidden.
A hidden discrepancy is the worst-case scenario; because both the problem continues and the data gets corrupted. When the person counting writes a product they see as missing as complete saying "it's around here somewhere", the discrepancy doubles in the next count.
Therefore, the variance should be treated as process feedback rather than a personal failure. The goal is to find the cause, not the culprit.
A practical approach is to highlight the person who explains the cause rather than the person who found the variance. This encourages the team to investigate.
Segregation of duties also supports this culture; when the person counting and the person approving are different, no one is left under pressure alone.Authorization page.
Frequently asked questions
What is an acceptable variance rate?
It varies by industry and product type. What matters is not the absolute rate, but the trend of the rate over time.
Is surplus stock also considered a variance?
Yes, and it is usually as important as a shortage. A surplus is a sign of an unrecorded receipt or incorrect product segregation.
Can a correction slip be reversed?
It depends on authorization. The transaction can be tracked in the audit log; audit trail see the article.
How are transfer-related variances separated?
When the acceptance step is made mandatory, these variances are caught at the time of transfer; transfer slip see the article.
A count variance is not an indicator of failure, but feedback given to you by the process. Businesses that record the cause encounter fewer variances in the next count.
By talking to the EQLEM team you can set up your count and variance management workflow.