Customer sales summary reports that are separated by rep

Thanks for the detailed information about your concern, confused_kev.

At this time, no specific report will display all the mentioned columns. Running the Sales by Class and Item Type Report will show combined data for your customers and sales reps.

Here's how:

1. Click on the Reports tab located at the top menu.
2. Scroll down and select Industry Specific.
3. Choose the Manufacturing and Wholesale Reports, then click on Sales by Class and Item Type.
4. In the upper left hand corner, choose the Customize Report button to refine it.
5. For the Rep and Customer columns to show, go to the Display tab.
6. Scroll to the Columns section, then choose Rep by clicking on the Display columns by drop-down.
7. Select Customer by clicking on the Display rows by drop-down.
8. Click on OK.

I'm attaching screenshots to visually guide you.

You’ll have to double-click on the transaction to see specifics and the total amount.

For additional resources, I'm also adding a link with detailed steps on how to personalize reports in QuickBooks Desktop.

The columns for Customers and Reps should show on the report.

Let me know if you run into any issues while following these steps. I’ll be right here if you need more help. Have a good one.

Thank you for the quick response and the report looks great I just have one problem... I need weekly dates to show up so my sales manager can see how customers are ordering recently. For example if they can see Amazon hasn't ordered in 2 weeks we need to call sales person x because that is there account then we can get clarity on the situation. 

So to summarize the report looks great but I need a week to week report so we can see trends are taking place not a report that adds all sales for a given period...

Thanks!

Thanks for clarifying that out for me, @confused_kev.

Allow me to join this conversation and provide some details on how to pull up a sales report with weekly dates.

You have the option to change the show columns section to weekly so you'll be able to see the transactions per week. You can do this by clicking on the drop-down arrow beside Show Columns and choose Week.

Please check out the screenshot below for your visual reference:

This report should give the details that you need.

Feel free to reach back out to me if there's anything else you need. I want to ensure your taken care of. Have a lovely day ahead!

Ok, let me try to explain what I need in a different way... I need a report that shows the Customer sales by week and which sales rep is representing that customer. The first suggestion shows me the customer and rep and your suggestion Betty shows me the customer and the week. Please help me include the customer week to week sales along with a column or someway for us to know which rep is representing that customer.

Thanks

Thank you for your response, anyway we can do that if classes are not set up? I just need a summary report with weekly sales on it and i want to see who the rep is for each customer. We don't have any classes and that can take a while to set up.

Hi there, confused_kev.

Thanks for providing clarifications to your concern. Let me share some additional ways on how we can achieve your preferred report in QuickBooks Desktop.

To be able to have all the information you want, we'll need to run two reports for this. First, let's open the Sales Rep by Summary report. This summarizes your sales income by sales representative. 

Here's how to run the Sales Rep by Summary report:

1. Go to Reports.
2. Click Sales.
3. Choose Sales Rep by Summary.
4. From the Show Columns, choose Week.

Next, let's run the Sales by Customer Summary to show the total sales to each customer and job. We'll just need to filter the Show Columns by Rep. I'd be glad to share the steps below:

1. Go to Reports.
2. Click Sales.
3. Choose Sales by Customer Summary.
4. From the Show Columns, choose Rep.

Also, here's an article to know more about customizing reports in QuickBooks Desktop: Customize reports in QuickBooks Desktop.

If you wish to combine all the information of these reports, you have the option to export them to Microsoft Excel.

For the steps on how to do it, you can check out this article: Export report from QuickBooks Desktop to Microsoft Excel.

There you have it. I'm always around in the Community if you need more help with managing reports. I'd be glad to help.