Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHow do I create a commission report including cogs in qb desktop? I have tried customizing some reports, but cogs never appears.
Hi, @JudyC61. I'm glad to help you run a commission report that includes COGS in QuickBooks Desktop (QBDT).
First, make sure to check your item list if you've selected COGS under the account for a specific item. This might be the reason why COGS never appear on the report. To do this, follow the steps below.
After that, you can run the Sales by Rep Detail report to track the commissions. This will show sales income from each sales representative and lists the sales transactions that contributed to each sales total. Ensure to customize the report and filter the account as Cost of Goods Sold. Then, hit Ok.
After customizing the report, I suggest saving the current settings by clicking Save Customization. That way, you won’t have to go through the customization process again in case you need the same information in the future.
You can also bookmark this article for additional resources: Set up commission payroll items and reports. It will guide you on how to track commissions paid to employees.
Let me know in the comment below if you have additional questions about running reports in QuickBooks Desktop. I'll be around to help. Have a good one!
I appreciate the screenshot you've shared, @JudyC61.
Let me share information about how the Cost of Goods Sold (COGS) shows on a report, and help you run a commission report that shows COGS.
QuickBooks uses a concept called 'Sources' and 'Targets' to build transactions and data when running reports. Thus, the Sales by Rep Detail report don't show COGS since it displays the transaction type and targetting the income account.
As an alternative, you can run and customize the COGS QuickReport to pull up a commission report including COGS. Here's how:
Just in case you want to know more about COGS tracking, you can check out this article for more information: Understand inventory assets and cost of goods sold tracking.
Come back to this post if you have other concerns or follow-up questions about running a commission report. I'll be around to provide further assistance.
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