انتقل إلى المحتوى / Skip to content
Articles · Inventory management

Inventory accuracy: use cycle counts to investigate stock differences

When the system shows ten units but the team finds four, a stock adjustment corrects today’s number without explaining the difference. Cycle counting becomes useful when a physical count leads to a movement review and a measurable preventive action.

Edited by Abdelhamed Mohamed · Updated:

Select products by risk

Start with high-value, fast-moving or repeatedly discrepant products. Include products customers cannot find even though the system shows stock. Spread counting across the week rather than leaving everything for a long, exhausting count.

Keep the sample rules stable: product selection, timing and treatment of movements during the count. Replacing difficult products with easier ones can make an accuracy metric improve without improving stock control.

Fix the comparison time and unit of measure

Count shelves, backrooms and secondary displays. Confirm that the count and system use the same unit: piece, case or multipack. A case of 12 pieces can produce a misleading difference if it is counted as one system unit.

Define the balance time and document sales, receipts and transfers during counting. Have another person recount material differences before approving an adjustment. A first-count error is not evidence of shrinkage.

Review movements before changing the balance

Check actual received quantities and posting time, then examine transfers, returns, recorded waste, sales units and barcodes. Use approved adjustment authority and record a specific reason.

For example, the system shows 18 pieces and the store has 12. If six pieces went to another branch but the transfer is still unposted, correct the transfer document. A direct stock adjustment could conceal the outstanding document and create another difference when it posts later.

Prevent the repeat

Classify causes into receiving, transfers, sales, waste, product data or unexplained differences requiring investigation. Assign an owner and a checkable action to repeated causes. Do not attribute differences to theft or a particular employee without evidence.

Recount a sample of the same products after the correction. Separate known waste from unexplained shrinkage. Better records improve replenishment decisions, but shelf availability still needs direct observation.

Quantity differences and value differences

In an illustrative sample, ten units are missing from a product costing $1 each and one unit is missing from a product costing $100. The first has the larger unit difference, while the second has the larger value impact. Track record accuracy and differences at cost separately.

Review absolute variance values alongside the net adjustment. A $100 overage and a $100 shortage net to zero, but still represent inaccurate records. Preserve positive and negative signs in each product record.

Maintain an investigation record

Use the template for balance time, physical count, recount, cause, document and action. Account for movements during counting. Keep unexplained differences open rather than selecting a convenient reason merely to finish the report.

At the follow-up count, use the same product, location and unit. If the issue returns, first check whether the agreed action actually happened, then investigate the next cause. Approval of a balance adjustment does not demonstrate that the cause has disappeared.

Actions to start today

  1. Select a weekly risk-based sample.
  2. Fix the balance time and counting unit.
  3. Independently recount material differences.
  4. Review documents before adjustments.
  5. Check whether the cause recurs.

Counted-product record accuracy

Products matching physical stock ÷ products counted × 100

If 46 of 50 products match exactly, accuracy is 92%. This measures product records, not the proportion of inventory value that is correct. Track the value of differences separately.

A reusable tracking template

Download the CSV and open it in Excel or your spreadsheet application. Use the template columns, replace any illustrative rows with your store data and add a row per case. Keep sensitive customer and employee information out of shared logs.

Download the tracking template CSV
Preview template columns and example
Illustrative example — replace with your data
DateProductCount unitSystem balancePhysical countRecountUnit varianceUnit costDocumentCauseActionOwnerFollow-up date
Illustrative exampleProduct APiece181212-65Outstanding transferTransfer not postedReview and authorise documentStock ownerOne week later

Apply the guide with Retail with Abdelhamed tools

About this guide and its references

This practical guide is edited by Retail with Abdelhamed. Examples are illustrative, not verified results from named stores. Check your data and company policy before applying it; general guidance does not replace the requirements of your local authority.

GS1 Global Traceability Standard — Further reading on product traceability, events and data, not a source for the illustrative figures.

Report a correction or a reference that needs updating