Tracking and Managing Inventory for QuickBooks Online Commerce

QuickBooks Online users who sell through connected commerce channels need a clear picture of how stock levels move — and how each movement hits the books. QuickBooks Online’s built-in inventory tracking for commerce aims to handle both the quantity side and the accounting side, but the mechanics are not always obvious, especially around what triggers a change and which accounts are affected.

Turning On Inventory Tracking for Commerce

Before anything else, two settings need to be enabled. Under Settings, users navigate to Account and settings, then the Sales tab. In the Products and services section, there are two switches that matter: Track inventory quantity on hand and Track inventory for sales channels. Both must be turned on and saved for commerce inventory to function.

This feature set is available to QuickBooks Online users working with connected sales channels. Users who do not use Commerce can still manually track inventory in QuickBooks Online Plus and QuickBooks Online Advanced.

What Inventory Records Track

Once enabled, QuickBooks tracks several layers of product data. Each inventory item can include a product name, variants (such as size or color), and SKUs. The system maintains both a Quantity on Hand figure — the physical stock you currently hold — and an Available figure, which reflects what can still be sold after accounting for open sales orders.

How Sales and Returns Affect Stock

The inventory engine responds automatically to transaction activity:

• Sales orders: When a sales order is created, the Quantity on Hand is reduced immediately, reserving that stock for the order.
• Returns: When a return is processed, the returned units are added back to both Quantity on Hand and Available, making that stock sellable again.

This means stock levels shift in real time as orders flow in and returns come back, without requiring manual quantity edits for each transaction.

The Accounting Behind Inventory Movements

Every change in inventory quantity has a corresponding accounting impact. QuickBooks posts these automatically based on the type of movement:

When inventory decreases due to product sales, the inventory asset account is reduced and the cost of goods sold account is increased. The amount posted equals the number of units sold multiplied by the cost per item.

When inventory decreases due to adjustments or physical counts, the inventory account is reduced and either the cost of goods sold account or an inventory shrinkage and adjustment account is increased.

When inventory increases due to a purchase order, the inventory asset value goes up by the number of units received times the cost per unit. The cash balance is decreased by the same amount, or accounts payable is increased if the purchase is on credit.

When inventory increases due to a return, the inventory account goes up and the cost of goods sold account is decreased, reversing the original sale’s cost impact.

When inventory increases due to adjustments or counts, the inventory account is increased and the cost of goods sold or an inventory shrinkage and adjustment account is affected.

Adding and Editing Products

New inventory items are created from the Products and services list, found under the Sales and Get Paid section of the All apps menu. Users select New, then fill out the product name, quantity details, and both sales and purchasing information before saving.

Editing an existing item works the same way — find the item, select Edit, make changes, and save.

Restocking Low or Out-of-Stock Items

QuickBooks sends notifications when items run low or go out of stock. Users can click that notification to instantly filter the product list down to only those items needing attention. From there, the standard workflow is to create a purchase order to replenish stock from a supplier.

Manual Quantity Adjustments and Physical Counts

When actual stock does not match what QuickBooks shows — whether from damage, loss, miscounts, or other discrepancies — users can perform a manual quantity adjustment. From the product list, selecting the Edit dropdown on an item reveals the Adjust quantity option. Multiple products can be selected and adjusted at once.

Each adjustment requires a reason selected from a dropdown menu. Users enter the newly counted quantity for each affected item. Custom adjustment reasons can be created by choosing Add new from the dropdown, naming the reason, and mapping it to a specific inventory adjustment account. Existing reasons can also be edited, and changes to a reason are applied retroactively to past transactions that used it.

What to Watch For

The key thing QuickBooks Online Commerce users should understand is that inventory tracking here is transaction-driven. Sales orders, returns, purchase orders, and manual adjustments each carry specific accounting consequences that flow through to the inventory asset and cost of goods sold accounts automatically. Knowing which transaction type causes which movement — and which accounts are debited or credited — helps users reconcile their inventory value against their financial statements and spot discrepancies before they compound.

For users running into file-level data issues — whether in Desktop or after migrating to or from Online — the inventory setup itself is rarely the culprit, but corrupted or migrated data can produce quantity and valuation errors that no amount of settings adjustment will fix.