cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Profit Percentage for Inventory Items

Is there a report or can someone help me create a custom report to show profit percentage for each line item sold?  I want a report that shows the inventory item, sales price, cost of goods, customer name, invoice # and the profit percentage for each line item.  I have attached the Sales Vs Cost Report I have created in QB but I need to show the percent Profit.  Thanks.

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

Did you simply run the Item Profit reports already in the...

Did you simply run the Item Profit reports already in the program?

Please see my attachments.

5 Comments
Established Community Backer ***

Did you simply run the Item Profit reports already in the...

Did you simply run the Item Profit reports already in the program?

Please see my attachments.

Not applicable

Thank you for pointing me in the right direction.

Thank you for pointing me in the right direction.
Established Community Backer ***

Reports > Sales > "Sales by Item Summary"

Reports > Sales > "Sales by Item Summary"

Not applicable

Re: Profit Percentage for Inventory Items

I have many items that I sell for over the 100% profit margin.  When I run the report it does not go beyond the 100%.  Is there a way to run a report that tells me what is selling at 110 to 200% profit?

QuickBooks Team

Re: Profit Percentage for Inventory Items

Hello @marg1,

 

In QuickBooks, the reports only show a profit margin of 100%. Let me discuss this further.

 

The % of Sales column on reports only show a maximum of 100% per item. This is based on the calculation of QuickBooks by dividing your gross profit by your sales. Then multiply it by 100.

 

In addition, you can still pull up your sales reports to view the % of Sales for your items. You can also pull up the Inventory valuation Summary report.

 

For further information, you can refer to this article: Small Business: How-To Calculate a Gross Profit Margin.

 

Please let me know if you have any other questions or concerns. I'll only be a post away.

Need to get in touch?

Contact us