Disclaimer: QBO.support is an independent help resource, published by E-Tech Corporation. We are an Intuit Product Referrals Partner and may earn a commission when you subscribe through our links, at no extra cost to you. We are not endorsed or sponsored by Intuit Inc., and this site is not official Intuit support. “QuickBooks” and “QuickBooks Online” are registered trademarks of Intuit Inc., used for identification and reference purposes only. See our About page.

Inventory Items

Managing inventory in QuickBooks Online

QuickBooks Online offers robust tools for tracking products, cost of goods sold (COGS), and inventory value. To ensure your records remain accurate, it is important to use the correct workflows for setup, reporting, and adjustments.

This guide covers common inventory tasks and how to handle them within the QuickBooks Online interface.

Setting up initial inventory balances

When you begin tracking inventory, you must enter your starting quantities and values correctly to avoid duplicating dollar amounts in your asset accounts.

Do not use journal entries for inventory setup. Journal entries cannot link to specific inventory items, which prevents QuickBooks from accurately tracking quantities and cost layers. Instead, use the dedicated inventory features:

  1. Go to the Settings (gear icon) and select Products and Services.
  2. Select New to create your inventory items.
  3. Enter the Initial quantity on hand and the As of date (the start date you begin tracking).

This process automatically records the value to your Inventory Asset account and the offset to Opening Balance Equity, ensuring your books are balanced from day one.

Expense accounts vs. Cost of Goods Sold (COGS)

It is important to distinguish between standard business expenses and inventory costs.

When you sell an inventory item, QuickBooks automatically calculates the cost based on what you purchased and moves that amount from your Inventory Asset account to your COGS account. The calculation relies on the purchase cost and quantity bought, not just the quantity sold.

Tracking inventory by project or job

To view inventory status associated with specific projects or customers:

  1. Navigate to Reports.
  2. Search for and open the Transaction Detail by Account report (or similar transaction detail reports).
  3. Customize the report to group or subtotal by Customer or Project.
  4. Filter the report to show only inventory items and relevant transaction types (such as purchases and sales).

This allows you to see the flow of inventory items in and out of specific jobs, which may provide more detail than standard stock status reports.

Moving costs from Work in Process (WIP) to Inventory

If you manufacture items and accumulate costs in a WIP asset account, you must move those costs to finished inventory. You can do this using a specialized transaction:

  1. Create a generic vendor (e.g., named “WIP Clearing”).
  2. Ensure your finished inventory items are set up with zero quantity and zero cost initially.
  3. Open the + New menu and select Check (or Expense).
  4. Select the “WIP Clearing” vendor.
  5. In the Item details section (line items), select the finished inventory items, enter the quantities, and enter the total costs.
  6. In the Account section (or the Expenses tab depending on your view), select your WIP asset account and enter the total amount as a negative number.
  7. Save the transaction. The result will be a $0.00 check that clears the balance from your WIP account and updates the inventory value and quantity.

Using custom fields for inventory

You can add custom fields to your inventory items to track additional data, such as serial numbers or bin locations.

  1. Go to Settings and select Products and Services.
  2. Edit an existing inventory item or create a new one.
  3. In the item details, look for the Custom fields section.
  4. Select Add to define new fields or manage existing ones.

If custom fields are not appearing, ensure you are using a supported browser and that your user permissions allow for modifying item lists.

Importing bulk inventory data

For warehouses or businesses needing to add large volumes of inventory items or lines to purchase orders, manual entry is not efficient.

Troubleshooting inventory entry issues

If you are unable to enter or adjust inventory quantities, or if the inventory features are missing:

Still need help? Send us a message

Tell us about your QuickBooks Online question and we'll get back to you by email.