The warehouse says “it’s there,” sales promises that number, the truck is two short — that is not too few counts. The book mixed promised-not-shipped, shipped-not-posted, and borrowed stock that never entered the system. To match, split the number first: on-hand, reserved, in transit, unavailable. Then outbound writes the book. People do not go back and edit a cell.
| SKU / bin | What the book says | What the shelf counts | Match |
|---|---|---|---|
| A-1042 / WH1-A3 | On-hand 80, reserved 6, available 74 | Pallet 80, 6 already tagged to ship | Match |
| B-2201 / WH1-B1 | On-hand 12, available 12 | Shelf 9; 3 lent to a store, no transfer | Gap: off-book lend |
| C-009 / WH2 | On-hand 40 | Shelf 40, but 15 loaded with no outbound | Gap: outbound lag |
| D-3310 / In transit | PO in transit 200, received not QC’d 200 | Dock hold, not put away | Match (not ATP) |
| A-1042 / WH2 | On-hand 0 | 8 in a corner, last year’s count gain never posted | Gap: off-book qty |
Ban two things first: promising on negative stock, and off-book qty
Take an order below available and the book goes negative. Leave goods in a corner without inbound and counts never match. Split ATP from on-hand: sales sees available; the warehouse sees on-hand and reserved. Excel mashes those columns into one number and collapses at scale. See Excel inventory breaks once volume grows.
Outbound writes the book, or a count is theater
Many companies count carefully at month-end and shout daytime outbound in the group. A count proves “tonight’s number is right,” not “every outbound this month was right.” Why group intake and shipping miss batches is in The risk of taking orders and shipping from WeChat groups. Wholesale multi-warehouse multi-price needs inventory on one line. See How wholesalers and distributors should string inventory together. For now, close inbound, sales outbound, and count on the main warehouse.
Batch, expiry, and damaged stock are dimensions — not a note
“Ship the old lot first” in a note never enters FIFO. Expiry, serial, and quarantine are stock dimensions, not cell comments. When a customer asks the batch on a truck, the system traces outbound back to inbound, and the audit paper stands. See What the system does when you reconcile, audit, or a customer asks for a document.
Barcodes and bin labels are accelerators, not a phase-one prerequisite
You can do this without barcodes first: outbound must pick bin and qty; a count must leave a gap reason. A barcode makes the scan fast and accurate. It does not stop “load first, document later.” Reverse the order and you buy a pile of guns; stock still drifts. If order-to-cash qty still disagrees, even a matching count will blow up A/R. See From order to cash: how a system cuts one more fight. When someone is out, unfinished counts and unposted outbound must reassign, or the match drifts again in the handover week. See Why operations do not fall apart when people leave.
Matching the books shortens reconciliation and cuts mis-ships — visible efficiency. See The efficiency a business system can make visible. When DaXi Technology builds inventory, we walk receive-lock-ship-count by warehouse first, then barcodes and multi-org. If you already have packaged software whose fields cannot hold lends and split shipments, compare When SaaS does not match how the floor actually works. To design around your bins and batch rules, go to Business systems service page and say which row is off today.