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.
   
   
   
   
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.
   
   
   
   
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.

@Answersformemaybe 

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

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.

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

& 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)