View Gross Profit Margin on Items Sold in QuickBooks

 In Inventory Management in QuickBooks, Profit Improvement Tips, QuickBooks Enterprise

While your profit and loss/income statement report gives you the gross profit margin for your entire business, what if you prefer to see the gross profit margin by item sold instead?

Fortunately, there is a handy report in QuickBooks (all versions) to provide that very information to you!

Click Reports > Sales > Sales by Item Summary (Desktop) or Reports > Sales by Product/Service Summary (Online), and you’ll get something that looks like this:

Sales by Item Summary report in QuickBooks to see gross profit margin by item

 

Now that you have created the report, note that you can see the gross profit margin by both dollars and %.

This report works great for all inventory parts and assembly items in your QuickBooks.

GROSS PROFIT FOR NON-INVENTORY PARTS IN QUICKBOOKS?

Since QuickBooks does not track an average cost (or FIFO cost if your business is using that QB Enterprise Advanced Inventory option) for non-inventory parts, the above report doesn’t work so well.

However…

You can approach this need a different way to get a similar report. Here’s how:

Click Reports > Custom Reports > Summary (in Desktop)

On the box that appears, be sure to choose Item Detail in the “Display Columns by” as shown below:

Custom summary report to show sales by item in QuickBooks

Once you do that, you get what looks like the traditional profit and loss statement, but you now see all the items you sell across the top.

This will include inventory parts, assemblies, non-inventory parts, services and other charges as well. You can then easily export this report to Excel to focus on just the non-inventory parts as well as quickly add formulas to get your gross profit by item.

Final version of sales by item report in QuickBooks via custom report

 

Of course, this approach only works if you are also using items when you record the purchase of the item when you enter the check, bill or credit card transaction to pay for it (remember, each of these transaction screens has both an “Expenses” and an “Items” tab on them). This is how the cost of the item would appear on the custom summary report above to then allow you to see the gross profit for that item!

Here’s to more profits for your business in the coming weeks!

 

Recent Posts

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Scott

We're not around right now. But you can send us an email and we'll get back to you, asap.