Book to count
What the stock card says against what the book says. The platform reconciles to the count evidence it was given — it cannot see the shelf.
- Location
- Jurong Warehouse
- Blue Ridge Outfitters Pte Ltd
- Counted on
- Jun 30, 2026
- Source
- STOCKCARD
- Method
- Bin card scan + count sheet upload, OCR extract reviewed by d.ruiz
The bin card reads 1,150 and the Excel reads 1,510 — a transposition introduced when the card was keyed in. The Excel was then keyed into Cin7, so the error is in the book twice over and the card is the only surviving original.
Open the break and its proposed journal| SKU | Bin | Book | Counted | Variance | Value | Status |
|---|---|---|---|---|---|---|
BRO-TS-002 Summit Merino Tee | JUR-E30 | 1,510 | 1,150 | -360 | $3,960.00 | Variance |
The platform can only report that the count found none. It does not know whether the goods were stolen, mis-binned or never received. That is an investigation, and it runs in this order:
- 1Check whether the units are in transit to or from this location.
- 2Check other locations via the SKU crosswalk — the same goods under a different code.
- 3Check for unposted receipts or issues sitting in the source system.
- 4Only then propose the write-off, with the evidence attached.
The pattern that produces this break is a physical stock card keyed into Excel, then keyed again into the ERP. Three copies of the truth, an error introduced at every step, and eventually nobody knows which system is right — so everyone trusts the Excel, which is also wrong.
Feed the stock card straight in. The platform becomes the spreadsheet, and there is only one copy left to be wrong.