This article discusses the sync details between QuickBooks Commerce's Stock Adjustment and Xero's Stock Adjustment. On QuickBooks Commerce, the Stock Adjustment feature is primarily intended to be used to absorb the stock. This includes products you might not have paid for that were a gift from a supplier or damaged stock that you can no longer sell.
✅ We recommend creating stock adjustments for:
- Damaged goods or shrinkage
- Goods that are given for promotion
- Differences in Stock levels from stock take
❌We do not recommend creating stock adjustments for:
- Manufacturing products (Bill of Materials)
- Managing WIP goods
- Entering in stock for new products. We recommend creating a Purchase Order instead.
- Recognizing returns on orders. You can mark returns within an order itself.
Stock adjustments are consolidated and sent daily to Xero at the time that you prefer. Refer to Sync Timing for more information on how to set this up.
The stock adjustment will affect two of the ledger accounts in your Xero account:
- Stock on Hand
- Inventory Adjustment ledger account
Inventory Adjustment ledger account is chosen based on the reason for stock adjustment so you can track the amount of inventory adjustment you made for shrinkage or promotion in Xero.
Learn how to set up the inventory adjustment ledger account for Xero, here.
If you make a positive stock adjustment, your Xero account should reflect:
- The debit for Stock on Hand
- Credit for the chosen Inventory Adjustment ledger account
If you make a negative stock adjustment, your Xero account should reflect:
- Credit for Stock on Hand
- The debit for the chosen Inventory Adjustment ledger account
Stock adjustments can be found in your Xero account via, Business > Bills To Pay.
It will include a Stock on Hand adjustment and a Cost of Goods Sold line item.
