cancel
Showing results for 
Search instead for 
Did you mean: 
DCBUS
Level 2

Help Calculating Commission Fees

Hello,

I appreciate the help in setting up commission fees, but I need one more step if possible. Please see image attached. I was helped to figure out fee's and commission on the subtotal. But, my commission needs to be based on the subtotal minus shipping of the $15.22. Is this possible without manually entering the number.

 

Thank you,

DCBUS

Solved
Best answer February 05, 2020

Best Answers
Joshua R
QuickBooks Team

Help Calculating Commission Fees

Let's get you squared away, @DCBUS.

 

Based on how you enter the line items, whatever is appearing on the overall invoice is going to affect the total commission amount.

 

At this time, there isn't a feature available in QuickBooks Desktop for the shipping cost to not affect the amount of commission. I'll certainly submit feedback to our product developers for that to be a possible option in future updates.

 

Thanks for posting in the Community! Reply to this thread if you have any other questions. Have a great one.

View solution in original post

4 Comments 4
Kendra H
QuickBooks Team

Help Calculating Commission Fees

Good morning, @DCBUS.

 

I'll help ensure you're able to match the refund in the bank feed to your supplier credit.

 

You'll have to set up a commission payroll item. If you have different types of commissions that you want to track separately in your reports, use a separate payroll item for each commission type.

 

Here's how to set up a commission item:

  1. Select List and then choose the Payroll Item List.
  2. At the bottom of the Payroll Item List, check the Payroll Item drop-down button, and click New.
  3. Go to Custom Setup and pick Next.
  4. In Payroll item type select Wage, click Next.

  5. From the Wages list, choose Commission, go to Next.

  6. Enter the Item Name which prints on payroll checks and reports, select Next.

  7. Enter an Expense Account, click on Next.

  8. Choose Finish

 

 

To add the commission item to employee records here's how:

  1. From the QuickBooks Desktop menus at the top, click Employees > Employee Center.
  2. Double-click on the employee's name.
  3. Select the Payroll Info tab.
  4. Add the item under Earnings by clicking in the white box under the item name and choosing the item from the drop-down list.
  5. Enter the rate in the rate column.

That should do it. Here is also an article with some additional information about setting up commission items in QuickBooks Desktop as well: Entering Employee Commissions

 

Touch base if me after trying the steps above. Have a safe and productive rest of your week!

 

 

 

 

 

 

DCBUS
Level 2

Help Calculating Commission Fees

Hello,

I appreciate the reply, but I think you may have missed the image I attached. I already have a commission, but I need it on the subtotal less the $15.22.

 

DCBUS

Joshua R
QuickBooks Team

Help Calculating Commission Fees

Let's get you squared away, @DCBUS.

 

Based on how you enter the line items, whatever is appearing on the overall invoice is going to affect the total commission amount.

 

At this time, there isn't a feature available in QuickBooks Desktop for the shipping cost to not affect the amount of commission. I'll certainly submit feedback to our product developers for that to be a possible option in future updates.

 

Thanks for posting in the Community! Reply to this thread if you have any other questions. Have a great one.

Fiat Lux - ASIA
Level 15

Help Calculating Commission Fees

@DCBUS 

Explore a sales commission app to meet your needs and integrate it with your QBO.

https://salescookie.com/?rid=[removed]

 

Hope it helps.

Need to get in touch?

Contact us