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 and pick the layout that matches its columns. CSV is the common case; the QuickBooks reports below are read as the .xlsx they download as, with no saving-as in between. 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 building 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 count, 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.
The first two are the same screen with the quantity typed or tapped, and an administrator picks which one an operator gets. The third is not a way of entering a number at all — it is a way of not needing one.
Keypad
Scan the bin location, scan the part, key the quantity. Hold the location and the operator stays in that bay, working through it line by line without re-scanning where they are standing.
Buttons
Not every scanner has number keys. On a touch-only device, typing a quantity means raising the on-screen keyboard — it covers the screen and takes longer than the count it is recording. This puts the quantity on a screen of its own, opening at one. It follows the operator, not the device.
Scan/Increment
Every scan counts one, with no quantity step at all. Four scans of the same part are four records of one, so a mis-scan is a single line to delete rather than a total to work backward from. Type a number and it replaces the count on the scan you just made, without touching the rest.
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 4 p.m. 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/yyyy — 12/31/2026, with the full year, which is what the sample export on the home page shows.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.