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 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:
Go to the Lists menu and choose Item List.
Select New from the Item menu.
Use the Type drop-down list and select Discount.
Add a name for the item. If you need multiple discounts, you can use this method but create a different name for each.
Include any additional information if necessary, and choose an account.
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.