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 arrow. 
  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:

sales inventory report

 

 

 

 

 



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. Select Change Columns.
  6. Scroll down the available columns list, select Qty, then Add.
  7. Select OK.
  8. Above the Change Columns button, choose Product/Service from the Group By drop-down menu.
  9. 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