If you use inventory tracking, you may notice multiple lines for the same item on the Sales by Product/Service Detail report.
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.
If you don't want to see this level of detail and would like to just see the items listed as they appear on your invoices, use the steps below to customize the report.
Select Reports from the left menu.
Select Run report.
The report will now only show one entry for the sale of your inventory item as it does on your invoice:
If you need to see your quantity on hand for a certain date:
If you need a report that totals your inventory valuation: