Entering a physical count in QuickBooks Online
It is called Clear all lines, it sits next to a button you have to press all the time, and there is no confirmation and no undo. Meanwhile the X in the corner of the same screen stops and asks whether you really want to leave without saving. Here is what we found, how to protect yourself, and how to get a count in without typing it at all.
The thing to know before you start
Inventory → Adjust inventory gives you a grid. You enter a product, a new quantity, and QuickBooks works out the change. Underneath the grid are two buttons, side by side, the same size and the same shade of gray.
| # | Product | SKU | On hand | New qty | Change |
|---|---|---|---|---|---|
| 1 | Sprinkler Pipes | SP-001 | 31 | 28 | −3 |
| 2 | Rock Fountain | RKFTN | 2 | 4 | +2 |
| 3 | Pump | PUMP1 | 23 | 20 | −3 |
| 4 | Sprinkler Heads | 051452784012 | 23 | 26 | +3 |
Before. Four lines entered. On a real count this is twenty minutes in, or two hours.
| # | Product | SKU | On hand | New qty | Change |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 |
After. One press. No dialog appeared in between, and Ctrl+Z brings nothing back.
Why it is worse than it sounds
Click the X in the top right corner instead, and QuickBooks stops you:
Both actions throw away exactly the same unsaved work. Closing the window asks. The button that empties it in place does not.
The grid opens with only a couple of blank rows, so entering a real count means clicking Add lines over and over. Clear all lines is immediately beside it, the same size, the same color. One adds a row. The other discards the afternoon.
Tab forward from the last row and, once there is no blank row below, focus walks out of the grid and lands on Clear all lines. It sits there quietly. Whatever key you press next that activates a button — Enter, Space — fires it.
QuickBooks Online has no import for a physical count or for an inventory adjustment. Its Physical Inventory Worksheet is a report you print, not a file you send back. So the work sitting unsaved on that screen is genuinely hand-typed, and genuinely gone.
Sent on September 28, 2026, with the steps above, both routes to the button, and the Cancel dialog beside it for comparison. It is their screen and their call — we would rather tell them than score a point, and we would rather tell you than let you find out.
Working around it
Press Add lines until there are more empty rows than lines you are about to enter. Now the bottom of the grid is never the next thing your cursor meets, and the button never enters the tab path at all. This is the whole fix, and it costs five seconds.
Each adjustment is its own transaction, and a part can only appear once in any of them anyway — so splitting one count across several adjustments costs you nothing and caps what a single mistake can destroy. One adjustment per bin or per sheet matches the paper you are working from.
New Qty is pre-filled with the quantity on hand and highlighted, so what you type replaces it. Type before the highlight lands and your number joins the old one instead: 23 on hand, a count of 4, and the box holds 234. The quantity looks plausible. The Change column says +211, and that is what catches it.
When the product resolves, QuickBooks fills in its name, its SKU and its description across the row. Reading the description back against your sheet is a better check than re-reading the code you just typed, because it is the one field you did not enter yourself.
The faster way
The product box takes keyboard input, and a barcode scanner is a keyboard. Give it a printed sheet where every line the count disagreed about is one barcode carrying the SKU and the counted quantity together, and a rule in the scanner does the rest: send the SKU, commit it, move to the quantity, send the number.
One trigger pull per line, under a second each. A fifty-line sheet is a couple of minutes instead of the better part of an hour, and the two things people actually get wrong — the part number and the quantity — are never typed at all.
The ~ is how the scanner knows this is a count sheet and not a carton label. Without it the same rule fires on any barcode anywhere, injecting Enters and Tabs into whatever screen happens to be open. A character no real barcode starts with cannot collide with anything.
An adjustment sets an absolute quantity, so QuickBooks refuses the same part twice — “Duplicate variant found.” A part found in three bins has to be one number before it goes anywhere near this screen. Our reports do that adding up, because our scanners recorded where each count came from.
A part the accounts expect that nobody counted is not the same as a part that has gone. Those print without a barcode and with the reason next to them, because sending a blind zero would turn an open question into a figure in the ledger.
A corded scanner of the sort that sits on a desk, set up with its own configuration tool. No add-on, no API connection, no app approval, nothing running between your accounts and anybody else. The sheet is a PDF and the scanner is a keyboard.
Being straight about it
So read the above knowing where it comes from. Everything on this page about the adjustment screen was tested rather than looked up, and it is all reproducible by anybody with a QuickBooks login, a keyboard and ten minutes — that is deliberate, because a claim you cannot check is worth nothing.
If you are counting a hundred parts once a year, none of this needs us: print our free count sheet, count with a pen, key it in carefully, and open your blank rows first. That is genuinely the right tool for that job.
It stops being the right tool at about the point where somebody is typing for an afternoon. That is where the counts want to arrive already totaled, already reconciled against what the accounts expected, and ready to go in as one barcode a line.