Running a physical inventory count
Written in the order you hit it, not the order the menu is in. Most of the work is the week before — on the day itself there are three actions and they repeat until the site is done.
Everything below is easier to read with a finished count in front of you. The demonstration portal holds two finished counts, one at each of two sites — around 2,400 parts, 722 bin locations, several thousand counts between them, ten operators — with the gaps left in on purpose, because the reports worth having are the ones that tell you what was missed. Nothing in it can be changed.
The week before
Two files and two lists. Do this early — not because it takes long, but because it is where you find out the part numbers in your system and the labels on your racks disagree.
Portal · Parts tab
Export a part list from whatever you run, save it as CSV, and pick the layout that matches its columns. The portal previews what it read before anything is saved, so a file with the columns in the wrong order is caught on screen rather than halfway through a count.
| Layout | Columns, in this order |
|---|---|
| Barcode and description | barcode,description |
| Part number, barcode, description | number,barcode,description |
| … with unit of measure | number,barcode,description,uom |
| … with serials per unit | number,barcode,description,uom,serials |
| Part number, description, bin | number,description,bin |
| Part number, barcode, description, bin | number,barcode,description,bin |
| QuickBooks Online Product/Service List | the .xlsx as it downloads — the portal finds the columns by their headings |
Portal · Sites tab, then Bin Locations
A site is a location, not a building. Reno DC is one site whether it is one shed or five, with a mezzanine and a yard. Everything standing on it shares one set of bin locations and is counted as one thing, because that is how a crew works it: one gate, one stocktake, one day.
A site has a short code an operator types at sign-in and a longer name for you to read on reports. Bin locations belong to one site — A1 at Reno is a different shelf from A1 at Memphis, and the portal keeps them apart. A few thousand locations on one site is ordinary; ten thousand is fine.
| File | Columns |
|---|---|
| Bin locations | code,description — the description is optional |
Portal · Users tab
One page per site, for the wall by the door: the company name, the site code and every operator name, each as a barcode. Nobody types anything at sign-in — they scan the three and key their PIN. PINs are never printed, on this sheet or anywhere else.
The day
Portal · Stocktakes tab
A count is one counting event at one site. It can stay open for a week and still be one count. An operator cannot start one — you create it and activate it here, and the scanner checks what is running every time somebody taps Stocktake.
On the floor
Three actions, then the next one. That is the whole job and it does not change all day.
Portal · Reports tab
This is the part that changes how a count day goes, and it is worth someone sitting on it rather than counting.
Send somebody back for a recount before they go home, not after. A missed aisle found at 4pm is twenty minutes; the same aisle found on Monday is another count day.
Portal · Stocktakes tab
Closing is deliberate and nothing does it for you. Until it is closed the count is still open at that site, and the portal will not let you clear a company's data while any count is still running.
Portal · Reports tab → Export CSV
Every report is on screen, printable, and exportable — the same columns in all three, so what you export cannot quietly differ from what you read.
mm/dd/yy.What happens next depends on what you run. QuickBooks Online has its own page, including the screen most people end up on and the button on it that deletes an hour of typing without asking.
The short version
There is a printable count sheet here, free, no account. It is a worse way to count than scanning and we would rather you had it than tallied on the back of a pick slip.
Counts are priced one at a time, not by the year — see what a count costs. If you want to walk through your own part list before committing, say hello and we will look at it with you.