đŚ Inventory Management: This article is for accounts with Inventory Management turned on. To learn what it does and how to turn it on, see About Inventory Management.
Method's QTY in stock and QuickBooks Online's Quantity on hand (QOH) stay matched only when every stock change follows one path. A step outside it changes one system but not the other, and the numbers drift apart.
â ď¸ Note: Neither system warns you when the numbers drift apart. Check them regularly, for example at month-end.
The recommended path
Ship or receive in Method. On a Sales Order, use Ship â Ship All or Ship Partially. On a Purchase Order, use Receive Fully or Receive Partially. This changes QTY in stock.
Create the Invoice or Bill from that order with Convert to â Invoice or Convert to â Bill. It doesn't happen by itself, so do it for every shipment and receipt.
Let it sync. QuickBooks changes its quantity by the same amount.
For any other change to your stock, such as damage, loss or a stock count, make a Stock Adjustment in Method. It changes both systems. See Make a Stock Adjustment.
Rule of thumb
Only shipping, receiving, transferring, reverting and Stock Adjustments change Method's stock. Of those, only Stock Adjustments change QuickBooks' quantity too.
Invoices, Bills, Sales Receipts, Credit Memos, Item Receipts, Expenses and checks change only QuickBooks' quantity, whichever system you create or edit them in.
What causes a mismatch
If you⌠| What happens | Do this instead |
Ship or receive an order but don't invoice or bill it | Method's stock changes. QuickBooks' quantity doesn't. | Use Convert to â Invoice or Convert to â Bill on the order. |
Create an Invoice or Bill any other way | For example, by hand, from a QuickBooks order, by duplicating one or from an Estimate. QuickBooks' quantity changes but Method's stock doesn't, and the same shipment or receipt can be invoiced or billed twice. | Always invoice and bill from the order with Convert to. |
Edit a quantity, remove a line, or delete an Invoice or Bill | QuickBooks' quantity changes. Method's stock stays where the shipment or receipt left it. | If the shipment or receipt was wrong, delete the Invoice or Bill and revert it. Then ship or receive again, and create a new Invoice or Bill from the order. See Fix inventory mistakes. |
Create a Sales Receipt for inventory items | QuickBooks' quantity goes down. Method's stock doesn't. | Use a Sales Order, ship it, then create the Invoice from it. |
Receive items on a Purchase Order in QuickBooks | QuickBooks' quantity goes up. Method's stock doesn't, and that Purchase Order can no longer create a Bill. | Create the Purchase Order in Method and receive it there. |
Record an Expense or check for inventory items in QuickBooks | QuickBooks' quantity goes up. Method's stock doesn't. | Create a Purchase Order in Method, receive it, then create the Bill from it. |
Record a return with a Credit Memo in QuickBooks | QuickBooks' quantity goes up. Method still shows the items as shipped. | If the shipment isn't invoiced yet, revert it with the reason Return to Sender (RTS) instead. |
Change an item's quantity, or make an Inventory Adjustment, in QuickBooks | QuickBooks' quantity changes. Method's stock doesn't. | Make a Stock Adjustment in Method. It updates QuickBooks too. |
Check for a mismatch
On the Items List, compare QTY in stock with Accounting QTY on hand for each item. If you use several locations, QTY in stock on the Items List is already the total across all of them. Where the two differ:
Check that every shipment is invoiced. On each Sales Order, the Items ready to invoice view of the shipped items table lists what isn't.
Check that every receipt is billed. On each Purchase Order, the Billable column of the received items table shows Ready to bill for what isn't.
If a Stock Adjustment didn't sync, QuickBooks' quantity stays different by that amount. See How Inventory Management works with QuickBooks Online.
For the usual causes and what to do, see Inventory quantities explained.
