Trying to find an easy way to recap exactly what you sold during the last month, quarter or year?
The Sales by Item Summary report in QuickBooks makes it a snap to see that information!
Accessed by clicking Reports (in the menu bar), then Sales, then Sales by Item Summary, a report like this appears:
This report recaps the following information:
- Quantity of an item sold
- Total $ amount of an item sold
- Total $ of item sold as a % of total sales
- Average selling price of an item
- Average Cost of Goods Sold (COGS) and Gross Margin $ and Gross Margin % IF the item is set up in QuickBooks as an Inventory Part or Inventory Assembly item. If the item is set up as anything other than those, it will NOT show COGS or Gross Margin details, since QuickBooks is not tracking that information for those types of items.
NEED A DIFFERENT DATE RANGE THAN THE DEFAULT MONTH-TO-DATE?
Just click the Dates drop-down list in the upper left hand corner of the report and choose the date range you prefer to see. QuickBooks will then refresh the data with these new dates for you.
RELATED POST: How to Run a Sales by Customer Summary Report