Choose the count boundary before generating the sheet
Define the location, bins, items and inventory state being counted, together with the snapshot time. Decide which movements can pause and which must continue. A warehouse can often isolate one counting zone while other areas keep shipping. The important requirement is a traceable boundary between the quantity in the report and the goods physically included in the count.
Microsoft's inventory counting guidance describes an option to lock items during counting to prevent specified warehouse updates. Check the behavior of your own system and process. A software lock does not prove that nobody physically moved stock, while a physical pause does not necessarily stop integrations from posting transactions.
References: Microsoft: Define inventory counting processes
Bridge each permitted movement to the count time
Record receipts, picks, transfers and returns affecting the counted area between the snapshot and the physical observation. Use event time as well as posting time when the two differ. Identify whether goods in a staging area were included in the original location balance and whether the count team included them physically. Avoid treating a reservation alone as a physical departure.
In a hypothetical bin, the 9:00 snapshot shows 100 units. Before the 9:30 count, staff put away 12 units and remove 18 through documented picks. The expected physical quantity is 94. A count of 94 agrees with the movement-adjusted snapshot; comparing it directly with 100 would invent a six-unit shortage.
Confirm whether the system's comparison report is frozen or already includes those movements. Adding them again to a current balance creates the opposite error. Retain the report timestamp and the adjustment calculation so another reviewer can reproduce the quantity expected at the exact count boundary.
Investigate variances without erasing the first observation
Preserve the initial count, recount and movement evidence. When a difference remains, check unit conversions, nearby bins, unposted receipts and goods already packed for dispatch. Identify whether the issue is physical quantity, timing or a location assignment. Moving units between bins should not become a total stock write-off merely because the first count used the wrong location.
Use a different reviewer for material or unexplained differences where practical. Do not give counters an expected number and ask them to make the count agree. If the area remained too busy to establish reliable movements, schedule a controlled recount rather than posting an unsupported balancing adjustment. Record why the first attempt was unsuitable.
Post the approved difference once and release the area
Have the responsible reviewer approve the actual residual difference and its explanation. Check that a late receipt or shipment will not later recreate the same quantity change. Link the approved adjustment to the count record and retain the original system balance. Finance can then assess the value effect using the appropriate cost records.
After posting, verify the current stock and release any temporary restrictions. Reconcile queued movements that were delayed during the count and confirm they appear once. Review repeated cutoff issues with warehouse staff: a clearer staging rule or faster receipt posting may reduce future discrepancies more effectively than increasing the frequency of counts without changing the movement evidence.
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.