Report that shows gross margin per sale

Thank you this is helpful.  Is there a way to make an advanced report that would have all this information so I would not have to export and merge the two reports?

Thank you!

You're most welcome, @Oasis2. I'm glad to know that the steps provided by my colleague help achieve your goal. So now I'm here to discuss further info about doing an advance report to show all the details you need.

In QuickBooks Desktop (QBDT), you can only have a report that contains sales transaction data along with COGS and the gross margin for each item by exporting and modifying them using Excel. The option to combine them within the program is unavailable. 

To request the addition of this feature, I highly recommend sending feedback to our product developers. This will help them review the details and be considered in future updates. Here's how:

1. In your QBDT account, select the Help tab.
2. Next, choose Send Feedback Online and click Product Suggestion.
3. Select a Type of Feedback and Product Area (optional) from your available drop-down menus.
4. Enter the details of the product request.
5. Once done, click Send Feedback.

Then, I encourage you to visit our Product Updates webpage to keep you updated with the latest news about your QBDT program.

If you have additional questions or other concerns about managing your reports in QBDT, feel free to leave a reply below. I'm always around to lend a hand. Have a good one and take care. 

Thank you for the feedback, I just wanted to make sure I understand your reply correctly.  We pay extra for the advanced reporting function in order to make custom reports.  Are you telling me that we can not compile a custom report in the advanced reporting function that provides this data?  Thank you!

Welcome back to this thread, @Oasis2. Thank you for providing additional details of your concern. Allow me to chime in and further guide you in creating custom reports using the advanced reporting in QuickBooks Desktop (QBDT).

Currently, the option to create a custom report to include details from two different report is unavailable. You want to consider manually changing the data by exporting it to Excel.

On the other hand, I recommend reaching out to our Technical support team to determine additional options you can take to create a custom report with the data you need. 

For future reference, you might want to have an organized overview of your company data by combining reports in QBDT. Feel free to open this article for the detailed instructions: Combine reports from multiple company files.

I'd love to know updates on how the process goes. Don't hesitate to post here again if you have further concerns creating custom reports. I'm always ready to assist. Keep safe and have a good day. 

@DivinaMercy_N  

The OP's question was "Are you telling me that we can not compile a custom report in the advanced reporting function that provides this data?"

Your pat-answer post did not answer the question.  What is the answer to the question?