Physical inventory count for QuickBooks Online
QuickBooks Online can’t add up a count. Its inventory adjustment takes one line per part and refuses the same part twice — so a part sitting in two places has to be totalled by hand before it goes in. That’s the job, and it happens before QuickBooks ever sees a number. Here is exactly how, what comes out, and what we don’t do.
The gap
On Plus and Advanced, with inventory tracking turned on. Every item has a quantity, and your balance sheet depends on it being right.
Inventory → Adjust inventory. One line per product, a New Quantity typed against each. Scan a SKU into it if you like — a scanner is a keyboard. What it won’t take is the same part twice: “Duplicate variant found — the same variant is added more than once in this stock adjustment transaction.” How that screen actually behaves — including the button that clears it without asking → Which report to export, and the exact columns it needs → Setting a scanner up to key a whole count into it →
A scanner can type into it, because a scanner is a keyboard. What QuickBooks Online has none of is a way to count with one: no scan mode, no running total, no device support, nothing that works at the rack. Barcode scanning proper is a QuickBooks Desktop and Enterprise feature, and Intuit’s own mobile scanner app only works with Enterprise.
QuickBooks will give you a Physical Inventory Worksheet — product, description, quantity on hand, and a blank column headed Physical Count. Export it to Excel and that column holds a drawn underscore, not a cell. It goes to the shelf with a pen and comes back to a keyboard. For two hundred items that’s an afternoon; for two thousand across forty bins with six people counting, it’s a week and a stack of paper.
That's the whole problem. QuickBooks Online is perfectly good at holding the number. It gives you nothing to get the number.
QuickBooks Online will print you a Physical Inventory Worksheet. This is it, unedited, straight out of a QuickBooks company:
| Product/Service | Memo/Description | Category | Preferred vendor name | Quantity on hand | Physical Count |
|---|---|---|---|---|---|
| Pump | Fountain Pump | 25 | __________ | ||
| Rock Fountain | Rock Fountain | 2 | __________ | ||
| Sprinkler Heads | Sprinkler Heads | 25 | __________ | ||
| Sprinkler Pipes | Sprinkler Pipes | 31 | __________ |
The Physical Count column is a blank line to write on. That is not us being unkind about QuickBooks — it is the report as Intuit ships it, and for a business with forty items it is a perfectly reasonable answer. Print it, walk round with a pen, type the numbers back in.
It stops being reasonable somewhere around two thousand items, forty bins and six people counting on a Saturday night. At that point the blank line is the problem, and a scanner is the answer.
How a count runs
QuickBooks has two reports that matter, and each is right for a different half of the job. Stocktakes Online reads both directly — it finds the columns by their headings, so nothing needs rearranging, deleting or saving as CSV.
Reports → Product/Service List
Reports → Inventory Status
| QuickBooks column | Becomes | Why |
|---|---|---|
| Product/Service full name | Part number | The identity QuickBooks matches on when the count goes back in, so it has to survive the round trip exactly as written. |
| SKU | Barcode | What the scanner reads. QuickBooks has no barcode field, so the SKU is it. |
| Memo/Description | Description | What the counter sees on the scanner when the item comes up. |
| Qty on Hand | Expected quantity | From the Inventory Status report, on the day. This is the number every variance is measured against. |
Your SKUs are probably empty, and that is the real job. Almost nobody fills them in, because until now there was no reason to. Put whatever is already printed on the shelf label in there — a manufacturer barcode, your own part code, anything that scans.
The portal tells you exactly which items have no SKU and names them, rather than quietly loading the ones that do. It is a once-only piece of work, and it is far better done in November than discovered on count night.
Export the quantities on the day, not in advance. Expected stock is a photograph of your accounts at one moment. Count against a photograph taken last month and every variance is wrong by whatever moved in between — and wrong in the worst way, because the number looks authoritative.
The portal says how old the file is when you load it, and warns you outright once it is more than a week old.
Bin locations
QuickBooks Online has no bin locations. Not switched off, not on a higher plan — the idea does not exist. Every item is one number, wherever it physically sits.
That is not a gap in this integration, and it is not a criticism of QuickBooks. No small-business accounting package tracks bin locations. MYOB AccountRight does not either — we use it ourselves and it has no concept of them. Nor does Xero. It is the difference between an accounting system and a warehouse: your accounts have always cared how many, and never where.
So the bin list is the one file that comes from you rather than from your accounts — and it is the file that decides whether your count can ever be called finished.
QuickBooks Online does have something called "Locations" — under Settings, Advanced, Categories. It is a branch or a store, tagged on a transaction. It holds no quantities and cannot tell you what is on which shelf, so it is not a bin. If you run more than one, it maps to a site in Stocktakes Online, not to a location within one.
QuickBooks Enterprise is the exception. With Advanced Inventory it has real inventory sites and real bins, and those map across one for one.
There are three honest answers, and the right setup is different for each.
Common in parts businesses and distribution. Nothing to invent: two columns, the location code and a description, and you are done. QuickBooks is not involved and does not need to be.
Aisle A, the mezzanine, the cold room, the yard. The job is making the list, not extracting it — an hour with a label printer before the count, and it pays for itself the first time somebody asks whether the far corner was done.
Then use one bin, named after the site, and scan everything into it. Less useful, and still worth having — see below.
You keep every count attributed — who scanned it, on which device, at what moment, and whether it was recounted or withdrawn. You keep the live portal, the totals, and a clean file at the end. For a single room that is a real count, properly evidenced, and far better than a printed sheet and a pen.
What you lose is the question that ends a count: which places nobody went to. With bins, the portal tells you that eleven locations were never scanned, and you send someone back before the crew goes home. With one bin, everything has been "visited" by definition, and the only way to know a shelf was missed is that the numbers look wrong afterwards — which is exactly when it is too late and too expensive to check.
So: one bin is a fair place to start, and worth revisiting before the second count. Most people who do it once want locations the next time, and they always want them for the same reason.
A location scheme does not need to be clever. It needs to be short, readable across an aisle, and impossible to mistake for a part number.
| Scheme | Looks like | Right when |
|---|---|---|
| Aisle · bay · level | A-03-02 | Racking in rows. The default, and the one to choose if you are unsure. |
| Zone · number | COLD-04 | Areas rather than racks — a cold room, a yard, a mezzanine. |
| Room only | WAREHOUSE | One space, one bin. The starting point described above. |
None of this is required to count. It is required to know you have finished, which is a different thing and the one people wish they had thought about afterwards.
Be clear about this
Intuit opened an API in 2025 that lets an app post an inventory quantity adjustment directly into QuickBooks Online. We have not built against it. When we do, this page will say so and will say when.
There is a reason beyond not having got to it. A count should pass a person before it reaches the ledger. The gap between counting a shelf and getting back to a desk is an hour, and in that hour stock sells. Whatever a count is worth at the rack, somebody should look at the variance before it is posted — handing you the file puts a person exactly there.
There is a second question we will settle before building anything: whether that API takes the counted total or the difference. Those are opposite conventions and the wrong one writes rubbish into a ledger — a difference worked out at the shelf is already stale by the time it posts. We have not confirmed which it is, so we are not going to tell you.
Until then the handover is a file, and we would rather tell you that on the page than in an email after you've paid. What you get is a clean CSV with the part number and the counted quantity, dated for the count, and help getting it into the layout your import tool wants.
If that sounds like a limitation, weigh it against the alternative, which is typing two thousand numbers into a web form on a Sunday.
What comes out
| Site Name | Bin Location | Part Number | Barcode | Part Description | Count | User Name | Date | Time | Withdrawn |
|---|---|---|---|---|---|---|---|---|---|
| Warehouse 2 | C-02-01 | 0363-5556 | ="0363555664340" | Filter, oil, spin-on | 40 | Sam | 12/31/2026 | 10:42:15 | |
| Warehouse 2 | A-03-02 | 4402-118 | ="0112345678907" | Bearing, 6204-2RS | 24 | Maria | 12/31/2026 | 10:41:52 | |
| Warehouse 2 | A-03-02 | 4402-118 | ="0112345678907" | Bearing, 6204-2RS | 22 | Maria | 12/31/2026 | 10:39:10 | Y |
That last row is a withdrawn count — a recount replaced it. It leaves every total immediately but the record stays, so an auditor can see a figure was changed and by whom. QuickBooks Online's adjustment screen keeps nothing like it.
QuickBooks Online has no bins, so for the import the counts are summed per item. The bin detail stays in Stocktakes Online, which is where you want it anyway — it's what tells you a shelf was missed.
Enterprise
Enterprise with Advanced Inventory has sites and bins of its own, and a Cycle Count feature that goes out to Excel and back. That maps to how Stocktakes Online already thinks — site, bin, part, count — so nothing has to be summed away.
Our export carries Site Name and Bin Location as separate columns, which is what an Enterprise import needs. Tell us you're on Enterprise and we'll work through the layout with you.
Intuit also ships a scanner app for Enterprise that does cycle counts on a Zebra TC21 or TC26. If you are on Enterprise Platinum or Diamond and it suits you, use it — it's included in what you already pay. Stocktakes Online is for everyone else, and for anyone who wants the count to run on the scanners they already own.
Questions
In the narrow sense, yes — a scanner is a keyboard, so scanning a SKU into the product box works and QuickBooks finds the part. What it won’t do is count. You still type a quantity on every line, the same part twice is refused outright, and after the quantity the keyboard cannot get you back to the next line without a mouse. Anything claiming to scan a count into QuickBooks Online is scanning into its own system first and sending the numbers across — which is what we do too. We’d rather say so plainly.
Plus or Advanced, with inventory tracking turned on. Simple Start and Essentials don't track quantity on hand, so there's nothing to count against. Enterprise works too — see above.
As a file. You export from Stocktakes Online, then import through whatever spreadsheet import tool you use with QuickBooks. We don't post it for you, and we don't pretend to.
QuickBooks Online doesn't have them. Load them into Stocktakes Online anyway — the counts get summed per item for the import, and the bin detail stays in the reports, where it tells you which shelves nobody visited. That's the report that ends a count.
Not if you have Zebra Android scanners on Android 5.1 or newer. Tell us the model number and we'll tell you whether we've run it — and if we haven't, we'll say so. If you don't have any, Zebra’s own reseller locator will find you one, and we'll spec the right model first at no charge.
They will — that's the entire point of counting. Stocktakes Online shows you what was counted, by whom, in which bin, and which items and bins nobody scanned at all. Reconcile before you import, not after.
Per count, not per year. From US$69 for a count, with no subscription. Most businesses doing a year-end count pay once a year. Full pricing.
Most American businesses count in the last week of December, for a December 31 close. Load your items and test your scanners in November — not on the day. The single most common reason a count night goes badly is a scanner nobody checked.
Contact
Tell us the date, how many scanners, and which QuickBooks you're on. You'll get a set-up call the week before. Counting at year-end? Book by mid-December.