How to Adjust Inventory in QuickBooks Online After a Count Comes Up Short
The shelf holds 38 cases and QuickBooks says 44. Six were crushed in the stockroom, or a sale was never entered, or someone counted one aisle twice. Work out which before you touch the number. A missing sale or purchase gets entered as that transaction. Only stock that's really gone, or really turned up, belongs on an inventory quantity adjustment, and that screen exists only on the plans that track inventory.
Choose + New, then Inventory qty adjustment (listed under Other in some layouts). Set the date and the adjustment account, add each item, and type either the New qty you counted or the Change in qty. Save.
+ New › Inventory qty adjustmentQuickBooks values the change at the item's cost and posts it between Inventory Asset and the adjustment account. Leave the default and that account is Inventory Shrinkage, which QuickBooks creates for you on the first adjustment.
A count correction, field by field
- 1
Rule out a missing transaction first
Run Inventory Valuation Detail for the items that are off, from your last count to today. An unentered bill, an invoice dated wrong or a return nobody recorded explains many gaps, and fixing that transaction is better than adjusting around it.
- 2
Open the adjustment and set the date
+ New › Inventory qty adjustmentUse the date the count was taken, not the date you're typing it in. A count from March 31 entered on April 6 belongs in March.
Watch for: closed books. Once a closing date is set, QuickBooks won't accept an adjustment dated before it. Talk to your accountant before moving the closing date.
- 3
Choose the adjustment account
The default is Inventory Shrinkage, an expense. You can't change the default, but you can pick another account on each adjustment, for example a damaged goods account your accountant set up.
- 4
Add each item and enter the count
QuickBooks shows the quantity it has on hand. Type the counted figure in New qty and it works out the difference, or type the difference itself in Change in qty. One adjustment can hold every item from the same count.
Watch for: found stock. A positive change posts the other way, raising Inventory Asset and reducing the adjustment account. If the extra stock was really a purchase that never got entered, enter the bill instead.
- 5
Add a reference and memo, then save
Put the count date and area in the memo ("Cycle count, aisle 4"). When someone asks next year why an item dropped by six, the answer is on the transaction.
What one shortage adjustment does to the books
Quantity and dollars move together. That's the reason to use this screen at all.
| Inventory Asset before the count (44 × $12) | $528.00 |
|---|---|
| Six cases adjusted out (posts to Inventory Shrinkage as an expense) | − $72.00 |
| Inventory Asset after the adjustment (38 × $12, matching the shelf) | $456.00 |
Made-up figures with one cost per case. QuickBooks Online costs inventory first in, first out, so if those cases came in at different prices, the value taken out follows the oldest costs. The $72 appears on the Profit and Loss in the month of the adjustment.
Quantity adjustment or journal entry for a stock correction?
Inventory qty adjustment
- Changes the item's quantity on hand and its value in one step.
- Shows up on the item's own reports, so the Inventory Valuation Summary still agrees with the Balance Sheet.
- Can't be dated into a closed period.
Journal entry
- Moves money in or out of Inventory Asset without touching any item's count.
- Leaves the item records and the account balance disagreeing until someone reverses it.
- Sometimes used by accountants for year-end entries they've thought through.
A count correction goes on the quantity adjustment. If a journal entry has already hit Inventory Asset, our Inventory Asset guide shows how that throws the reports out.
Counts, values and the P&L after an adjustment
What's the difference between an Inventory Qty Adjustment and a journal entry?
An Inventory Qty Adjustment changes the count of a specific item and the dollars attached to it, together. A journal entry only moves dollars in the account, so the item list and the balance stop agreeing. For a physical count, use the adjustment.
Can I adjust inventory value without changing the quantity?
Not on the quantity adjustment screen; it works on counts and values them at cost. If an item's opening cost was entered wrong, look at its starting value in the product list. A value change on stock you still hold is generally an accounting judgment, so agree the approach with your accountant first.
Why does my inventory show a negative quantity after an adjustment?
Usually because sales were recorded, or dated, before the purchases that covered them, so the count was already heading below zero and your adjustment took it further. Find the missing or misdated bill and fix that, rather than adjusting the negative away.
Does an inventory adjustment affect my profit and loss statement?
Yes, through the adjustment account. A shortage posts as an expense in Inventory Shrinkage (or whichever account you chose), while Inventory Asset on the Balance Sheet falls by the same amount. Found stock does the reverse.
Do I need QuickBooks Online Plus to adjust inventory?
Yes, Plus or Advanced. Inventory tracking isn't part of Simple Start or Essentials, so there are no inventory items there to adjust. Our guide to adding inventory covers turning tracking on.