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

Sales Rep Commission Report

I need to create a report from which I can pay commissions to outside sales reps. Currently we receive down-payments on projects, and pay commission on that amount; then later when invoice is paid in full, we issue a 2nd commission payment. I'd prefer to keep this method but since down payments don't get applied to invoices until much later, I am suspicious I may need to give up this method and only pay commission once invoice is paid in full.

 

Making it more complex, certain invoice line-items receive 10% commission, others 8%, others 7%, and a few receive 0 commission. Also we don't pay commission on invoices that have aged beyond 90 days. 

 

I've tried a few custom reports, but haven't gotten all my requirements met.

 

5 Comments 5
MarsStephanieL
QuickBooks Team

Sales Rep Commission Report

Hi there, @Answersformemaybe.

 

You can set the report to Cash basis before customizing it. I'll show you the steps on how to customize your report to see the commissions applied in the invoices. 

 

  1. Go to the Reports menu, then go to Sales.
  2. Click Sales by Rep Detail.
  3. Select Customize Report, then choose Cash basis under the Display tab.

    customize sales report.jpg

  4. Go to the Filters tab.
  5. In the Search Filters field, enter and select Transaction type.
  6. Under Transaction Type, select Invoice, then click OK.

    customize sales report1.jpg

  7. Change the To and From dates, then click Refresh

 

I also, added this article that might come in handy to personalize your report: Customize reports in QuickBooks Desktop.

 

For future reference, you can also memorize the report so that you'll not go to the same process again, here's an article to help you through the process: Create, access and modify memorized reports.

 

I'll be here if you need anything in QuickBooks. Just comment below by clicking the Reply button. Stay safe out there.

Fiat Lux - ASIA
Level 15

Sales Rep Commission Report

@Answersformemaybe 

As another option, consider having a sales commission app to handle more features and integrate it with your QBD.

POWE
Level 2

Sales Rep Commission Report

Does quickbooks have a feature to calculate vendor commissions?     Now I have to produce the sales by rep report and turn it into an excel sheet and calculate from there.    I am looking for an easier way to produce.

pacteamgroup1
Level 1

Sales Rep Commission Report

Can you advise 3rd party integrations that work well for commission reporting with QBD??

AccountingIsFun
Level 1

Sales Rep Commission Report

& then what do you do with all that data?  I have every line item from the invoice.  I can throw it into a pivot table but I cant get the columns I need (city, State, Zip)

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

Need to get in touch?

Contact us