cancel
Showing results for 
Search instead for 
Did you mean: 
jay80424
Level 1

Job Profitability Report

Hello!

 

I have assigned a sales rep to a job, and I want to pay them a commission as a percentage of the net profit

 

However, When I run the sales report the income is the whole amount, and there is no cost of goods sold.  The invoices have non inventory items, that all have a cost of goods sold attached to them, so I'm confused what to do here.

 

Thanks!

3 Comments 3
KlentB
Moderator

Job Profitability Report

Hi there, jay80424.

 

I can shed a light on that.

 

The cost associated with the sales amount will not show in the report since you're using non-inventory items. Please take note that the Cost of Good Sold account can only be attached to an inventory item or assembly. Normally, COGS is affected when you sell inventory items on invoices or sales receipts.

 

Moving forward, you'll want to make sure to use inventory items when creating sales transactions. This way, all of the costs associated with the items you sell will reflect on your reports. I also recommend reading our Inventory Assets and Cost of Goods Sold Tracking Guide to learn how QuickBooks handles your inventories.

 

Lastly, here's a reference that you can browse to help keep track of your sales and expenses: Customize customer, job, and sales reports in QuickBooks Desktop.

 

Feel welcome to reach out to me again if you have further questions about inventories and reports. I'll always have your back.

jay80424
Level 1

Job Profitability Report

Thanks, Yeah, I don't want to use inventory items, because we don't actually track inventory.

Kind of a bummer it wont run the report like that. Seems very limiting. 

JoesemM
Moderator

Job Profitability Report

I appreciate you for the quick response, @jay80424.

 

Since you don't want to use the inventory items, I'd suggest consulting with your accountant. They can provide other recommendations on how to properly set up the transactions and your reports. If you're not affiliated with one, our Intuit Find-A-ProAdvisor site can help you to find certified professionals in your area.

 

Also, you can look for a third-party app that can integrate with QuickBooks. Let me show you how.

 

  1. In your QuickBooks Desktop, go to the Help menu and select App Center: Find More Business Solutions
  2. In the Apps for QuickBooks Desktop Marketplace window and enter a word in the search field.
  3. Then, select the app from the list.
  4. Click on the View Profile button to see more details about the software.

 

You can also visit our QuickBooks Apps Store page directly.

 

On the other hand, to learn more about running and customizing reports in QBDT, you may check these articles: 

 

 

I'll be around to help if you have any other questions with QuickBooks. Just let me know by leaving a comment below. Have a nice day ahead.

Need to get in touch?

Contact us