cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
SteelBuildingGal
Level 1

Our earnings are Commission, but we would like to track sales as well

Our business is a brokerage and we earn a commission based on what we sell and to which company we sell for. Even though our income is solely based on the commission, we'd love to be able to track the amount of sales (and how much sales we generate for various companies) as well. 
We've toyed with the "tracking by class/location" but again, the income for our Quickbooks is only the commission we earn, not the total price of the sale so we'd only be tracking our income for each company we sell for.

 

Is there something else I'm missing? Or am I going to have to manually enter each sale into a spreadsheet and have formulas that calculate all of the extra information?

2 Comments 2
Rea_M
Moderator

Our earnings are Commission, but we would like to track sales as well

Hello there, @SteelBuildingGal.

 

Let me share some insights about recording commissions and guide you on ways to track sales in QuickBooks Online (QBO), so you can manage your earnings accordingly.

 

For the time being, there isn't a calculation feature for sales commission in QBO. However, you can track your sales by employee, sales rep, etc., using the class and location tracking features.

 

Since you've already activated both class and location tracking features, you're on the right track. All you have to do next is to create your list. Here's how:

 

  1. Go to Settings ⚙ and select All Lists.
  2. Select Classes or Locations.
  3. Click New. Give this class/location a name.
  4. To add a sub-class, select Is a sub-class and select the main class. You can nest up to five classes.
  5. Select Save or Save and close.

 

You can refer to these articles for the complete guide:

 

 

Once you're done, add your salespeople as either a Class or a Location to enable you to track their sales individually. When you enter transactions, make sure to select the salesperson and the Class and/or Location info. 

 

You can run sales reports by class or location or the Profit and Loss reports by Class or Location to find out how much each salesperson sold. 

 

For complete details on tracking sales in QBO, you can visit this article: Track sales commissions in QuickBooks Online.

 

Also, you may want to check out one of our Help pages as your reference to guide you in managing your business growth and transactions in QBO: QuickBooks Learn and Support. It includes help articles, Community discussions with other users, and video tutorials, to name a few.

 

Comment below if you have other concerns about tracking sales commissions in QBO. I'll gladly help. Take care, and I wish you continued success, @SteelBuildingGal.

SteelBuildingGal
Level 1

Our earnings are Commission, but we would like to track sales as well

So that doesn't actually answer my question.

 

All of our company's income is solely commission earned from the sales of products through companies we represent. So our "sales" is only the percentage of commission we've actually taken in.

 

If I were to record the entire Sale, for example a $20,000 order that we only get to keep $3,000 of, then how would I deduct the $17,000 that we never receive and actually only ever goes to the company? In this scenario, we don't ever receive that other $17,000 as it's paid directly to the company by the consumer. We simply receive the $3,000.

 

Recording the entire sale seems like that would throw off my entire accounting system.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us