cancel
Showing results for 
Search instead for 
Did you mean: 
smoorman
Level 1

Can QuickBooks calculate payroll commissions, based on what is invoiced ? to the customer less sales tax? Sammy in Seattle

We are hiring our first commissioned sales person.  I don't want to have to calculate their commissions in an excel spread sheet then convert it to QB as a payroll item.  Can QB do the calculations based on sale or customer? 

Solved
Best answer February 19, 2019

Best Answers
Anonymous
Not applicable

Can QuickBooks calculate payroll commissions, based on what is invoiced ? to the customer less sales tax? Sammy in Seattle

Hey there, @smoorman,

 

Thanks for getting in touch with us today. I can share some insights about setting up a commission only employee in QuickBooks Desktop.

 

At the moment there isn't a way to auto-calculate the commission on your sales transaction and apply them to the employee's paychecks. You can, however, set up a commission item so you can automatically add it in the payroll check.

 

Here's how to create a commission item:

  1. Go to the Lists menu.
  2. Choose Payroll Item List.
  3. Right-click anywhere and click New.
  4. Choose Custom Setup.
  5. Click Next.
  6. Choose Wage in the Payroll item type window.
  7. Click Next.
  8. Select the Commission in the Wages screen. Click Next.
  9. Enter the commission description then click Next.
  10. Choose the Expense account.
  11. Enter the commission rate.
  12. Click Finish.

Once done, you can apply this item in the employee's profile. Here's how:

  1. Click the Employees  menu.
  2. Go to the Employee Center.
  3. Double-click on the employee's name.
  4. On the Payroll Info tab, add the item under Earnings by clicking in the white box under item name and choosing the item from the drop-down list.
  5. Enter the rate in the Rate column.

Once done, you can now pay the employee's commission on his check.

 

When you create the paycheck, you should see the commission item in the Earnings section.  You must enter an amount in the Rate and Quantity columns to get the total commission amount.

 

That should get you on the right track. You can check out this article to know more about the process: Set up commission payroll item and reports

 

Please let me know if you have additional questions about your concern. I'm here to help you anytime, @smoorman.

View solution in original post

4 Comments 4
Anonymous
Not applicable

Can QuickBooks calculate payroll commissions, based on what is invoiced ? to the customer less sales tax? Sammy in Seattle

Hey there, @smoorman,

 

Thanks for getting in touch with us today. I can share some insights about setting up a commission only employee in QuickBooks Desktop.

 

At the moment there isn't a way to auto-calculate the commission on your sales transaction and apply them to the employee's paychecks. You can, however, set up a commission item so you can automatically add it in the payroll check.

 

Here's how to create a commission item:

  1. Go to the Lists menu.
  2. Choose Payroll Item List.
  3. Right-click anywhere and click New.
  4. Choose Custom Setup.
  5. Click Next.
  6. Choose Wage in the Payroll item type window.
  7. Click Next.
  8. Select the Commission in the Wages screen. Click Next.
  9. Enter the commission description then click Next.
  10. Choose the Expense account.
  11. Enter the commission rate.
  12. Click Finish.

Once done, you can apply this item in the employee's profile. Here's how:

  1. Click the Employees  menu.
  2. Go to the Employee Center.
  3. Double-click on the employee's name.
  4. On the Payroll Info tab, add the item under Earnings by clicking in the white box under item name and choosing the item from the drop-down list.
  5. Enter the rate in the Rate column.

Once done, you can now pay the employee's commission on his check.

 

When you create the paycheck, you should see the commission item in the Earnings section.  You must enter an amount in the Rate and Quantity columns to get the total commission amount.

 

That should get you on the right track. You can check out this article to know more about the process: Set up commission payroll item and reports

 

Please let me know if you have additional questions about your concern. I'm here to help you anytime, @smoorman.

smoorman
Level 1

Can QuickBooks calculate payroll commissions, based on what is invoiced ? to the customer less sales tax? Sammy in Seattle

Thank you.  I look forward when the smart people @ QB can add a commission calculating module to the payroll.  Sammy

jjeyesinvoice
Level 1

Can QuickBooks calculate payroll commissions, based on what is invoiced ? to the customer less sales tax? Sammy in Seattle

Can you also share how to do this with Quickbooks Online Payroll?

jenop2
QuickBooks Team

Can QuickBooks calculate payroll commissions, based on what is invoiced ? to the customer less sales tax? Sammy in Seattle

I'd be glad to help and share details about paying commissions in QuickBooks, jjeyesinvoice.

 

Similar to the Desktop version, automatic calculation of commissions is not available in QuickBooks Online Payroll. However, there's a workaround where you can add a commission item. Then, manually calculate the amount before adding it to the employee's paycheck when creating them. 

 

I'll  also share the steps on how you can do it in the online version:  

 

  1. Go to the Payroll menu and proceed to the Employees tab.
  2. Click the name of the employee. 
  3. Scroll-down to the Pay types section, then click Edit.
  4. Look for Commission under the Common pay types section and check the box before it.
  5. Click Save.

 

commission.PNGcomission 2.PNG

 

Once done, a box for Commission will show up in the Preview Payroll window. There is where you can type in the amount so it will added to the employee's paycheck.

 

comission 3.PNG

 

Let me also share this article for additional details: Pay Your Employees a Commission.


Additional guidance and references when running payroll are also provided in these articles: 

 

 

Please don't hesitate to reply to me and let me know if you're able to set up and pay commissions. The Community is always here if you need anything else. 

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

Need to get in touch?

Contact us