cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
d-laxman
Level 2

Can I deduct a commission from a supplier bill for the same supplier who is a customer as well

I sell items for a number of different suppliers.

For this service I charge a commission for each item sold.

How do I handle paying:

(a) supplier for the sale minus my commission

(b) myself the commission which includes VAT, I need to show the net amount as my sales revenue ( excluding VAT)

Thanks

Solved
Best answer May 11, 2019

Accepted Solutions
KhimG
QuickBooks Team

Can I deduct a commission from a supplier bill for the same supplier who is a customer as well

Greetings, @d-laxman.


It’s my pleasure to help record these transactions in QuickBooks.


First, you need to set up a service item called “Commission earned” with Commission Income as posting Income and Expense account. Here’s how:

  1. Go to the Gear icon and select Products and Services.
  2. Click the green New button.
  3. Choose Service.
  4. Type in Commission earned on the Name field.
  5. Enter other necessary information.
  6. Place a check mark next to I purchase this product/service from a supplier.
  7. On the Income account and Expense account drop-down, select Commission Income.
  8. Hit Save and close.

Right after, create a bill from the invoice sent by the supplier together with your sales commission. Let me show you how:

  1. Go to the Plus icon and select Bill.
  2. Select the supplier from the list.
  3. On the Item Details section, select the product you received from the supplier in the first Product/Service line item.
  4. Enter Amount and VAT.
  5. Choose Commission Earned on the second line item and enter the commission amount and VAT.
  6. Hit Save and close.

Posting a negative value on the bill using the commission service item will show your sales income on the P&L report. 

 

Once done, pay the bill to record the exact amount to be collected by the supplier. See how to enter and pay bills for more information.


You may also check out the following articles for reference: 

That should get you pointed in the right direction. 


Keep me updated on how that goes for you. I’m always here to keep helping. Have a good one!
 

View solution in original post

2 REPLIES 2
KhimG
QuickBooks Team

Can I deduct a commission from a supplier bill for the same supplier who is a customer as well

Greetings, @d-laxman.


It’s my pleasure to help record these transactions in QuickBooks.


First, you need to set up a service item called “Commission earned” with Commission Income as posting Income and Expense account. Here’s how:

  1. Go to the Gear icon and select Products and Services.
  2. Click the green New button.
  3. Choose Service.
  4. Type in Commission earned on the Name field.
  5. Enter other necessary information.
  6. Place a check mark next to I purchase this product/service from a supplier.
  7. On the Income account and Expense account drop-down, select Commission Income.
  8. Hit Save and close.

Right after, create a bill from the invoice sent by the supplier together with your sales commission. Let me show you how:

  1. Go to the Plus icon and select Bill.
  2. Select the supplier from the list.
  3. On the Item Details section, select the product you received from the supplier in the first Product/Service line item.
  4. Enter Amount and VAT.
  5. Choose Commission Earned on the second line item and enter the commission amount and VAT.
  6. Hit Save and close.

Posting a negative value on the bill using the commission service item will show your sales income on the P&L report. 

 

Once done, pay the bill to record the exact amount to be collected by the supplier. See how to enter and pay bills for more information.


You may also check out the following articles for reference: 

That should get you pointed in the right direction. 


Keep me updated on how that goes for you. I’m always here to keep helping. Have a good one!
 

d-laxman
Level 2

Can I deduct a commission from a supplier bill for the same supplier who is a customer as well

Hi KhimG

 

Many thanks for your help and suggestions which pointed me in the right direction as to what I needed to do.

 

As I already had a Sales Commission set up in COA. I changed this from "I sell this product" to "I purchase this product".

 

This now lets me create a bill set up as inc of VAT when in Category detail I can create a line entry for the supplier showing full amount received for their sold item with Zero VAT then on next line enter our sales commission, a -ve amount with VAT.

 

This seems to solve the problem as the commission net of VAT is in the Sales commission account, the vat element is in the VAT account and the supplier element will be the amount we pay and will be matched from online feed from the bank when the payment has been made by us.

 

I hope this works the way I believe its should.

 

Thanks again for your help.

D-laxman

The bill now shows

Need to get in touch?

Contact us