How to Conduct a Clean Stock Count
COUNT CONTROL DECISION
Choose the count boundary before printing a sheet
A count is reliable only when the team knows which locations and item states are included, how movements are controlled, which quantities are hidden from counters and who can approve a variance.
01 – SCOPE
Define the stock population
List warehouses, bins, consignment, quarantine, returns, work in progress and goods in transit before the count starts.
02 – CUT-OFF
Control stock movements
Stop, isolate or log receipts, picks, transfers and adjustments so every movement belongs clearly before or after the count.
03 – EXPLAIN
Investigate differences
Recount material variances and trace movements before posting an adjustment that hides the cause.
Run a pilot count on one contained location
Test the instructions, count sheet, movement log, recount threshold and reconciliation on one aisle or stock room before the full event.
A clean stock count is a controlled comparison between physical units and the system record at a defined cut-off time. The count is not clean merely because the final adjustment makes the totals agree. It is clean when the scope, movements, count evidence, recounts, approvals and resulting entries can explain why the difference existed.
Use the inventory systems service when recurring variances point to receiving, transfers, fulfilment or item-data problems. The barcode readiness checklist helps assess scanning, while physical and online stock synchronisation covers channel timing.
1. Define scope and ownership
Create a location register before creating count sheets. Include normal storage, receiving, dispatch, returns, damaged stock, quality hold, consignment, third-party storage, production areas and inter-warehouse transit. Decide whether work in progress and customer-owned stock are in scope and label them physically. Assign a count leader, area owners, counters, recount team, system recorder and final approver.
| Count object | Control question | Evidence |
|---|---|---|
| Location | Is every physical storage area represented once? | Signed location register |
| Item | Is the correct SKU, variant and unit being counted? | Blind count line or scan |
| Movement | Did it occur before or after cut-off? | Numbered movement log |
| Variance | Was it recounted and investigated? | Reason and supporting transaction |
| Adjustment | Was quantity and value approved? | Posted journal or count document |
2. Clean obvious conditions before count day
Housekeeping is not manipulation when it clarifies identity and location without changing unexplained quantities. Label bins, separate damaged and returned items, complete approved transfers, resolve duplicate labels and move loose units into countable containers. Do not post broad pre-count corrections merely to reduce expected variance. Every correction still needs a source and approval.
3. Set a movement cut-off
The strongest option is to pause receiving, picking, production consumption, dispatch and transfers for the count window. If operations cannot stop, create controlled zones and a numbered movement log. Mark items received but not yet posted, picked but not dispatched, or transferred but not received. Record the last document number before the count and the first number afterward so finance can test cut-off.
4. Use blind counts where practical
A blind count hides the expected quantity from the counter. This reduces the tendency to search until the system number is found. The sheet or device should show location, item code, description, unit and tracking details, but leave counted quantity empty. Microsoft documents physical inventory recordings that can distribute work to multiple employees and prevent an item from being recorded twice; the same control can be reproduced in simpler tools.
- Count from location to item, not from a report to wherever the item might be.
- Use two people for high-value, controlled or difficult-to-measure stock.
- Record zero explicitly instead of leaving a line blank.
- Count sealed packs only when the pack quantity and integrity are verified.
- Keep opened packs, alternate units and partial quantities separate.
- Sign or identify the counter and time for every completed area.
5. Recount by risk, not convenience
Set recount rules before seeing the results. Triggers may include high value, controlled items, large absolute quantity, large percentage variance, unexpected zeroes or a repeated problem item. The recount team should be independent where practical and should not simply copy the first number. If the recount differs again, inspect item identity, unit conversion, nearby bins and recent movements.
6. Investigate before adjusting
| Variance pattern | Likely checks |
|---|---|
| One item short and similar item over | Misidentification, variant or unit error |
| Sending location short, receiving location over | Unposted or incomplete transfer |
| Many items differ in one zone | Missed bin, duplicate count or movement during count |
| System higher than physical | Unposted issue, damage, theft, dispatch or consumption |
| Physical higher than system | Unposted receipt, return, production output or prior over-adjustment |
Use reason codes only after tracing the likely event. A vague ‘stock count adjustment’ should not become the largest reason in the warehouse. Link the adjustment to the count reference and keep the original count, recount and investigation evidence.
7. Reconcile quantity and value
After approved adjustments post, rerun on-hand and inventory value reports. Confirm the count document is complete, all temporary movement logs are posted, quarantine and transit balances make sense, and the inventory control account reconciles according to the accounting system. Xero describes physical counting as a valid starting method for smaller businesses, but increased range or multiple locations may justify a more continuous system.
Worked count example
A distributor counts one locked cage while normal operations continue elsewhere. It freezes movements into the cage, records the last issue number, prints blind lines and assigns two counters. A twelve-unit shortage triggers an independent recount. The team finds one sealed carton in a returns area and a six-unit issue that was picked before cut-off but posted afterward. Only the remaining difference is adjusted with an approved reason. The count improves the record and identifies a returns-location control gap.
After-action review
Report count completion, total adjustments by reason, high-risk variances, repeated problem SKUs and unresolved items. Convert causes into process actions for receiving, put-away, picking, transfers, returns, production or master data. Schedule cycle counts for high-risk locations instead of waiting for the next annual count; Odoo and Microsoft both document more frequent counting approaches for selected items or locations.
Sources checked
- Microsoft Learn: Count, adjust and reclassify inventory
- Odoo: Cycle counts
- Xero South Africa: Inventory management
Reviewed by
Mitrend Digital editorial team
2026-07-17
Evidence used for this page
Reviewed against current Microsoft Business Central physical-inventory guidance, Odoo cycle-count documentation and Xero South Africa inventory guidance. Includes an original count-control plan and variance workflow.
Turn the guide into a practical next step
This resource provides general implementation guidance. Verify platform settings, tax, legal, payment and operational requirements against the current business context before making a live change.