n-How to Adjust Inventory in QuickBooks Online (the Qty Adjustment Tool, Step by Step)
Go to + New, then Inventory qty adjustment under the Other column. Pick the adjustment date and an adjustment account, then for each item enter either the actual quantity on hand or the change in quantity. QuickBooks recalculates the dollar value automatically using average cost and updates Inventory Asset to match, which a plain journal entry can't do on its own.
The full walkthrough
1. Open Inventory Qty Adjustment. Click + New, then Inventory qty adjustment under the Other column. This is the only tool that keeps quantity and dollar value moving together correctly; a journal entry can change the Inventory Asset balance, but it has no idea what the actual item count is.
2. Set the adjustment date. This matters the same way it does for any other transaction affecting your financials: a count done today but dated into last month throws off that period's numbers.
3. Pick an adjustment account. Usually an expense account, something like Inventory Shrinkage, is where the gain or loss from the adjustment posts. It's separate from Inventory Asset itself, which only reflects the item's actual value on hand.
4. Find each item and enter the quantity you actually counted. QuickBooks shows the current on-hand quantity next to the field; type in what the physical count found, and it calculates the difference itself rather than you having to work out the delta by hand.
5. Let QuickBooks value the change, or override it if you know better. By default, it values the adjustment using the item's average cost. If a specific batch was bought or damaged at a different cost, you can override the value on that line directly.
6. Repeat for every item in the count, then save. One adjustment can cover every item counted in a single session, which beats entering a separate adjustment for each item one at a time.
Where a once-a-year count stops being enough
An annual physical count catches big discrepancies, but it also means shrinkage, damage, and miscounts sit unnoticed in your books for up to a year before anyone corrects them. By the time the count happens, nobody remembers why a specific item was off, just that it was.
Businesses that count more often, weekly cycle counts on fast-moving items instead of one big annual count, catch problems while they're still small and traceable. The limiting factor is almost never willingness to count more often; it's the time it takes to actually do it and then key the results into QuickBooks correctly.
What we've built on top of QuickBooks inventory adjustments
Counts synced straight from a warehouse scan
A cycle count done with a barcode scanner or a warehouse system feeds the quantities straight into a QuickBooks adjustment, instead of someone retyping a printed count sheet line by line.
Variance flagged before it posts
When a count comes in far off from what QuickBooks expects, it gets flagged for a person to double-check before the adjustment saves, instead of a miscount quietly becoming the new official number.
How does your inventory actually get counted today?
A spreadsheet, a scanner, a once-a-year count on a clipboard: tell us the real process and we'll tell you where the manual re-entry can stop.
Still keying inventory counts into QuickBooks by hand?
Tell us how counts actually happen in your business, how often, with what tool, and we'll tell you whether the numbers can land in QuickBooks without someone retyping them. Inventory counts are one example of manual re-entry; there's almost always at least one more hiding somewhere else in the business.
Let's talk