Commission Report by Sales Rep, based on Profit Paid

Thank you for your reply. We will gladly take a report that would show the profit for each sale - we can do the calculating ourselves. Might you have a suggestion on how to run a report like that?

Can this be done by invoice rather than by customer?

Thanks for joining this conversation, CranberryRed.

I can share some insights about the reports in QuickBooks Desktop.

Right now, QuickBooks doesn't have a profitability report per invoice. We can only run the Job Profitability Detail and filter it by sales rep. This report shows how much money your company has made to date on the customer or job whose name you entered. The report lists costs and revenues for each item you billed to the customer so you can see which parts of the job were profitable and which parts were not.

Here's how to customize this report:

1. Click Reports at the top.
2. Under Job, Time & Mileage, choose Job Profitability Detail.
3. Select the Customer or Job and click OK.
4. Click the Customize Report button.
5. Under the Filter tab, enter Rep in the Search Filters box.
6. Select the appropriate sales rep.
7. Select OK.

The screenshot below shows these steps as well.

Check out this article for more details about customizing a report: Customize reports in QuickBooks Desktop.
 

Rest assured that we're always working to make QuickBooks exactly what you need for your business.

That should get you on the right track. If you have other questions, I would be happy to answer them. Just post it here as a comment and I'll take a look at it. Enjoy your weekend.