Skip to main content
J
JudyC61
March 1, 2023
Question

How do I create a commission report including cogs in qb desktop? I have tried customizing some reports, but cogs never appears.

  • March 1, 2023
  • 1 reply
  • 0 views

How do I create a commission report including cogs in qb desktop? I have tried customizing some reports, but cogs never appears. 

1 reply

Nicole_N
Nicole_N
March 1, 2023

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.

 

  1. Go to the Inventory menu and select Item List.


     
  2. Double-click an item.
  3. From the Edit item window, choose the Cost of Goods Sold under the Account.
  4. Click Ok. 

 

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!

J
JudyC61Author
April 25, 2023

Hi Maryrosen,

 

I have done as you suggested, to no avail. I have included a screenshot.

 

 

 

M
Mark_R
April 25, 2023

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:

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. Find the COGS account and choose QuickReport from the Reports drop-down. You can also click Ctrl + Q on your keyboard to open the QuickReport.
  3. Click Customize Report, then go to the Display section and add the Rep column.
  4. Select OK to refresh the report.

 

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.

Terms & ConditionsAccessibility statement