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

Sales by rep

How the heck do I run a "Sales by rep" report in QB online?  Can't believe how difficult this is to find....

Solved
Best answer May 10, 2021

Best Answers
JoesemM
Moderator

Sales by rep

Let's make this easier for you, @shar1972. I'm here to help and provide some options on how to track sales reps in QuickBooks Online (QBO). 

 

Sales by Rep report is only available in the QuickBooks Desktop version (QBDT). To find it in QuickBooks Online, you can use the custom fields and add Sales Rep in the column as a workaround. Then run the Sales by Customer Detail Report, and filter Sales by Rep. Since this is just a text field so you will need to assign a sales rep every time you create an invoice or sales receipt.

 

Here's how:

 

  1. Go to the Gear icon.
  2. Select List then Custom fields.Capture.PNG
  3. Enter Sales Rep in the name column.
  4. Put a checkmark in the All sale forms.
  5. Tap the Print on the form.
  6. Click Save.

Capture.PNG

Then manually, enter the Sales Rep when creating transactions.

Capture.PNG

Once everything is recorded, you can now pull up the Sales by Customer Detail report. 

 

  1. Go to Reports in the left pane.
  2. Select Customer Detail Report.
  3. Fill in the correct date range
  4. Click Customize.
  5. In the Rows/Columns.
  6. Put a checkmark on the Sales Rep box.
  7. Expand the Filter section.
  8. Put a checkmark on the Sales Rep box.
  9. Click Run report.

Capture.PNGCapture.PNGCapture.PNGCapture.PNG

You can check this article to learn more about customizing your reports: Customize reports in QuickBooks Online.

 

Also, you can explore all available options for making QuickBooks Online (QBO) work like your business needs.

 

QBO does offer the support of thousands of various third-party applications for any functionality you may need. To see if there's an app that can help you accomplish this, head to the Intuit App Center. Then, type a keyword like in the search bar.

 

In case you need tips and related articles in the future about the "How Do I" steps in QuickBooks Online, visit our QuickBooks Community help website for reference.

 

Please leave a comment below if you have any other questions or concerns, and I'll get back to you right away. I'm always happy to help.

View solution in original post

8 Comments 8
JoesemM
Moderator

Sales by rep

Let's make this easier for you, @shar1972. I'm here to help and provide some options on how to track sales reps in QuickBooks Online (QBO). 

 

Sales by Rep report is only available in the QuickBooks Desktop version (QBDT). To find it in QuickBooks Online, you can use the custom fields and add Sales Rep in the column as a workaround. Then run the Sales by Customer Detail Report, and filter Sales by Rep. Since this is just a text field so you will need to assign a sales rep every time you create an invoice or sales receipt.

 

Here's how:

 

  1. Go to the Gear icon.
  2. Select List then Custom fields.Capture.PNG
  3. Enter Sales Rep in the name column.
  4. Put a checkmark in the All sale forms.
  5. Tap the Print on the form.
  6. Click Save.

Capture.PNG

Then manually, enter the Sales Rep when creating transactions.

Capture.PNG

Once everything is recorded, you can now pull up the Sales by Customer Detail report. 

 

  1. Go to Reports in the left pane.
  2. Select Customer Detail Report.
  3. Fill in the correct date range
  4. Click Customize.
  5. In the Rows/Columns.
  6. Put a checkmark on the Sales Rep box.
  7. Expand the Filter section.
  8. Put a checkmark on the Sales Rep box.
  9. Click Run report.

Capture.PNGCapture.PNGCapture.PNGCapture.PNG

You can check this article to learn more about customizing your reports: Customize reports in QuickBooks Online.

 

Also, you can explore all available options for making QuickBooks Online (QBO) work like your business needs.

 

QBO does offer the support of thousands of various third-party applications for any functionality you may need. To see if there's an app that can help you accomplish this, head to the Intuit App Center. Then, type a keyword like in the search bar.

 

In case you need tips and related articles in the future about the "How Do I" steps in QuickBooks Online, visit our QuickBooks Community help website for reference.

 

Please leave a comment below if you have any other questions or concerns, and I'll get back to you right away. I'm always happy to help.

konstantincra
Level 1

Sales by rep

Make sure you spell the sales rep name exactly the same way every time, even if you add space in the end it's not going to be on the report one you filtered. You will have two reports for the same sales rep. One will be, for example, "John" and the other "John ". 

Bickford
Level 1

Sales by rep

Is QBO not designed for large volume business?  I can not enter a sales rep manually into every invoice! I need to be able to import my customers with their assigned reps, and assign a rep automatically.  


@konstantincra wrote:

Make sure you spell the sales rep name exactly the same way every time, even if you add space in the end it's not going to be on the report one you filtered. You will have two reports for the same sales rep. One will be, for example, "John" and the other "John ". 


 

MadelynC
Moderator

Sales by rep

I’m glad to share some information with you, @Bickford.


I recognize how convenient it's for users to assign Sales Rep automatically to transactions. At this moment, you need to assign them manually every time you create an invoice or sales receipt.


You may consider using a third-party app to achieve it. QuickBooks offers several tools, which are located in our Apps center. You can also go to your Apps menu to check which app works best for you. Here are the steps to do it:

  1. Select the Apps menu from your left navigation pane.
  2. Enter a keyword in the Search field.
  3. Select and open the app. You can read reviews or feedback from other users to help you decide further.


You can visit this reference if you need help managing your company's income and customers in QuickBooks: Sales and customers. It includes steps to customize forms and processing payments.


We’ll be here anytime to help if you need further assistance with your transactions. Just tap the Reply button below. Take care!

Isis_Rz
Level 1

Sales by rep

Please make this feature available in the Quickbooks online version too!

New User JO
Level 2

Sales by rep

Doesn't this option require you to enter the sales rep on each invoice? Why can't you set up the sales rep name at the project or customer level and have the invoice automatically populate the sales rep field?

LeizylM
QuickBooks Team

Sales by rep

I understand that you want to assign a Sales Rep automatically to transactions in QuickBooks Online (QBO), JO. 

 

As I have checked and replicated here on my end, the option to automatically assign a Sales Rep to an invoice is unavailable. At this time, you'll need to add this manually every time you create a transaction in QBO. 

 

I can see how the functionality would be beneficial to your business. I'd recommend sending this feature request directly to our Product Development team. This helps improve your experience and the features of the program.

 

Here's how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.
    Capture.PNG

 

You can also track feature requests through the Customer Feedback for QuickBooks Online website.

 

I'm always here in the Community if you need more help with sales reps. Just post a reply below to notify me of your response. Take care always. 

shawn36
Level 1

Sales by rep

its majorly cumbersome and it also doesn't handle split slaes between two reps please make your product work for your clients.

Need to get in touch?

Contact us