If you use inventory tracking in QuickBooks Online, you may be confused when looking at your Sales by Product/Service Detail report. Rather than list the sales of the items as they appear on your invoices, the report shows the same item several times. This is because QuickBooks Online is tracking the movement of that item through the appropriate accounts, such as Cost of Goods Sold and the Inventory Asset account.

Note: Inventory tracking is only available in QuickBooks Online Plus.

Inventory report detail

If you're not concerned with seeing this level of detail and would like to just see the items listed as they appear on your invoices, follow these steps to customize the report.

  1. Select Reports from the left menu.
  2. Enter Sales by Product/Service Detail in the search bar.
  3. Select Customize.
  4. In the Filter section, select All Income Accounts from the Distribution Account drop-down.
  5. Select Run Report

The report will now only show one entry for the sale of your inventory item as it does on your invoice:

User-added image
For more information on how inventory tracking and cost accounting works in QuickBooks Online, see:

If you need to see your quantity on hand for a certain date:

  1. Select Reports from the left menu.
  2. Enter Balance Sheet in the search bar.
  3. Select the link for the Total for Inventory Asset (or whatever account you are using for the inventory item).
  4. On the report that comes up, select Customize.
  5. In the Rows/Columns section, choose Product/Service from the Group By drop-down.
  6. Select Qty from the available columns list.
  7. Select Run Report.

If you need a report that totals your inventory valuation:

  1. Select Reports from the left menu.
  2. Enter Inventory Valuation Summary in the search bar.
  3. Run the report.
4977