Stock reconciliation: make the system match the shelf

Key takeaways

Stock reconciliation compares what your system says you hold with what is physically there, investigates the differences and corrects the records. Cycle counting, counting a small set of products every day or week, keeps records accurate without a full stocktake. The counting is physical, but the matching, investigating and correcting are repetitive desk work.

• Count a few products often instead of everything once.
• Count fast sellers and high-value items most.
• Investigate every variance above a threshold.
• Fix the cause: receiving, picking or returns.

What is stock reconciliation?

Stock reconciliation is the check that recorded stock levels agree with physical stock, followed by investigation and correction of any differences. Without it, online shops oversell, reorders are wrong and the accounts value stock incorrectly. Cycle counting spreads the work through the year.

• How UK SMEs can use outsourcing to handle repetitive tasks
• Order processing outsourcing for manufacturers and brands

How does a cycle counting routine work?

Split products into groups by value and sales speed. Count the fastest sellers and highest-value items most often, such as weekly, and slow, low-value items quarterly. Compare counts with the system, investigate differences above an agreed threshold, correct records and log the cause.

• Group A, fast or high value: count weekly.
• Group B, medium: count monthly.
• Group C, slow and low value: count quarterly.
• Variances over threshold investigated within 48 hours.

• The 80/20 rule in business: find the work that matters
• Backorder management: keep customers informed, not chasing

What do stock errors cost?

In an illustrative example, an online seller with 2% of orders affected by stock errors on 3,000 orders a month has 60 problem orders: oversells to refund, delays, and customer contacts. These are example figures. Cycle counting and variance investigation usually cost far less than the contacts and refunds they prevent.

• Refund processing: fast, fair and correctly recorded
• 'Where is my order?' queries: handle them at scale

Which parts can a remote team do?

The physical count must happen on site, but a remote team can schedule counts, compare results with the system, investigate variances by checking receipts, picks and returns, propose corrections and report causes. Approving write-offs should stay with a named manager.

• Marketplace listing management: Amazon, eBay and Etsy
• Rule-based vs judgement tasks: what to hand over

What does this look like in practice?

A pattern we see: most variances trace to one step, often goods received but not booked in. Fixing that step reduces variances more than counting more often.

• See client work
• BPO Solutions for UK businesses

Stock reconciliation checklist

Run the routine with these points.

• Products grouped by value and speed.
• Count schedule per group.
• Variance threshold agreed.
• Causes logged for every correction.
• Write-offs approved by a manager.

• Fixed asset register: keep it current all year

Next step

Send us your SKU count and how stock is checked today. We will suggest a cycle count routine and say plainly what a remote team could handle.