cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
bkobow
Level 2

Commissions

We are needing to pay our sales staff commissions off our invoices.  We have invoices that may have several discount lines that need to be deducted from the product price first and then the commission percentage would apply.  We also have to give different percentage of commissions for the different brands that are offered as well.   We currently are dumping a report into Excel to calculate, and would love to get away from manual errors.

 

Thank you!

3 Comments 3
SashaMC
Moderator

Commissions

Thank you for reaching out to the QuickBooks Community, 

bkobow. Currently, there isn't a way for QuickBooks to add a commission percentage to the total and have it calculate it automatically. Although you can add many discounts, you would still need the commission's calculation to be done manually. Here's how to add discounts to invoices in the QuickBooks Desktop:

  1. Go to the Lists menu and choose Item List.
  2. Select New from the Item menu.
  3. Use the Type drop-down list and select Discount.
  4. Add a name for the item. If you need multiple discounts, you can use this method but create a different name for each.
  5. Include any additional information if necessary, and choose an account.
  6. Click OK to create the item.

As seen in the example below, this how the item will be displayed on the invoice. Please note that the discount would be applied to the line item above it. However, if you would like it to calculate the total, a subtotal item would need to be created. The instructions are the same, by going to the List menu, select New, but instead choose Subtotal from the Type drop-down. This is how the subtotal would appear.

Please let me know if you have any questions or need any further help. My team and I will do our best to assist you. Take care, and have a lovely day.

bkobow
Level 2

Commissions

Thank you for the information.  We do have the discounts working correctly just needing to figure a better way to do commissions vs manual. 

 

We need to take the $2.38 give it a 5% and 3% discount,   $2.19  then give our % commission on that. $.04 per bag times the total shipped (350) would be $14.00.  

 

 

Fiat Lux - ASIA
Level 15

Commissions

@bkobow 

Consider having a sales commission app to help you and integrate it with your QBD.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us