Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
We switched over from Quickbooks Desktop to Quickbooks Online not too long ago. In Quickbooks Online I was trying to find a report that matched one from the desktop version "Sales by Item Summary" which can a list of the products and services with the quantity sold, the amount made from it, the cost of the good sold, and finally the "Gross Margin" or profit we made. We use this report to calculate commission based off the profit made from each item and add a filter of sales rep as well as only A/R paid.
Is there anything like this on Online? Its a very important report that we need to run for proper payroll. Is there anyway to create a custom report ourselves if not?
Yes, there is, @BriU.
I appreciate you for switching to QuickBooks Online (QBO) to manage your inventories. I'll help you find a report that shows the information you want to gather.
We can run the Sales by Product/Service Summary report. This report displays the total sales for each product and service. It also includes the quantity, amount, % of sales, average price, cost of goods sold, and Gross Margin.
Here's how:
Alternatively, we have other reports that you can utilize to see and manage your inventory in QBO. Kindly refer to this article that explains what you can see when you run the specific report: Use reports to see your sales and inventory status. Also, you'll want to customize or personalize the format of each report to show the exact details you need.
With regards to creating your own custom report, you can generate one if you're subscribed to our QBO Advanced. Please see this article for the detailed steps: Create custom reports in QuickBooks Online Advanced.
Just in case you want to memorize the report you've customized, feel free to check out this article for the detailed steps and information: Memorize Reports.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here