Skip to main content
A
Anita11_2
December 11, 2018
Solved

Profit Percentage for Inventory Items

  • December 11, 2018
  • 4 replies
  • 0 views

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.

    Best answer by qbteachmt

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

    Please see my attachments.

    4 replies

    qbteachmt
    qbteachmtAnswer
    December 11, 2018

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

    Please see my attachments.

    A
    Anita11_2Author
    December 11, 2018
    Thank you for pointing me in the right direction.
    A
    Anonymous
    December 11, 2018

    Reports > Sales > "Sales by Item Summary"

    M
    marg1
    August 12, 2019

    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?

    A
    Alessandra_B
    August 13, 2019

    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.

    P
    pacificposition
    January 5, 2021

    I'd like to further view margin based on the vendor, not just item.  I haven't been able to customize this report to sort by vendor.  Is this possible?

    JoesemM
    JoesemM
    January 6, 2021

    Hello there, @pacificposition.

     

    Yes, it's possible. Just pull up the Expenses by Vendor Summary report. This will show the company's total purchases per vendor. Let me guide you how:

     

    1. Go to the Reports menu.
    2. Under Company and Financial click Expenses by Vendor Summary.
    3. Select the date range that you want the report to show.
    4. Click the Customize Report and filter the necessary details.

     

    You might also want to read this article to learn more on how to customize reports: Customize Reports in QuickBooks Desktop. 

     

    You can also memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use.

     

    To learn more about how QuickBooks generates the reports, you can check out this article: Understand reports.

     

    Let me know if you have any other concerns or questions while working in QuickBooks. I’m always ready to help you. Have a good one.

    P
    pacificposition
    January 6, 2021

    I don't believe that shows the gross margin for the sold products, only what it cost me to purchase.  The thread is for profit percentage for inventory items, or margin on the items, not just the cost.  Will your suggestion give me cost, price, and margin percentage?

    @JoesemM wrote:

    Hello there, @pacificposition.

     

    Yes, it's possible. Just pull up the Expenses by Vendor Summary report. This will show the company's total purchases per vendor. Let me guide you how:

     

    1. Go to the Reports menu.
    2. Under Company and Financial click Expenses by Vendor Summary.
    3. Select the date range that you want the report to show.
    4. Click the Customize Report and filter the necessary details.

     

    You might also want to read this article to learn more on how to customize reports: Customize Reports in QuickBooks Desktop. 

     

    You can also memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use.

     

    To learn more about how QuickBooks generates the reports, you can check out this article: Understand reports.

     

    Let me know if you have any other concerns or questions while working in QuickBooks. I’m always ready to help you. Have a good one.

     

    Terms & ConditionsAccessibility statement