Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Is there a way to include a column to show the 'Sales Rep' when pulling a sales report?
Doesn't seem to be any option to add it in the customization.
Solved! Go to Solution.
You're right! They still don't have the "Sales Rep" feature as you want in QBO. Period.
In QBO, they offer few workarounds like using the Custom fields, Customer type, and Classes to track Sales Rep. But the reports are not accurate (even if you try your best).
This also happens to be the top requested feature in QBO since July 2012 and still under review since Jan 2016. That was three years ago and have not seen any new updates yet.
Update 4/10/2019 - the above URL doesn't work anymore. They even closed the Public Feedback Suggestion Board. Maybe they just want to hide/ignore all the feedbacks.
Good day, SashaCooper.
You're right. We can't add a column for "Sales Rep" to the sales reports in QuickBooks Online. This is because this function is only available in QuickBooks Desktop.
If you're using the Class Tracking feature for sales rep tracking, use the Class column instead. Also, you can add a Created by column in the Sales by Customer Detail report. It will tell which invoices were created by a certain user.
Let me know if you need anything else. Have a great day.
"Also, you can add a Created by column in the Sales by Customer Detail report. It will tell which invoices were created by a certain user."
How do you even relate from USER type to SALES REP Invoice report?
You're right! They still don't have the "Sales Rep" feature as you want in QBO. Period.
In QBO, they offer few workarounds like using the Custom fields, Customer type, and Classes to track Sales Rep. But the reports are not accurate (even if you try your best).
This also happens to be the top requested feature in QBO since July 2012 and still under review since Jan 2016. That was three years ago and have not seen any new updates yet.
Update 4/10/2019 - the above URL doesn't work anymore. They even closed the Public Feedback Suggestion Board. Maybe they just want to hide/ignore all the feedbacks.
This was over a year ago. They need to make ground on this. We are in a pandemic and need better online services.
Does anyone know if there is a third party service linked to QBO that can draw these types of reports?
I appreciate your feedback regarding this matter, @AlchemySoundandVision.
While the Sales Rep customization on the reports isn't available, I can help route you to our QuickBooks Online App store to locate the best application you need for your business.
QuickBooks Online offers up many applications that integrate directly. You can check their product features and reviews through this link: https://quickbooks.intuit.com/app/apps/home. Or, you can go directly to your QuickBooks account and tap the Apps menu on the left-side panel.
Once you find the right app, you can always come back here and share your review. In addition, you can visit our QuickBooks Blog to get the latest news and updates about our product and what our developers are working on.
I'll be around if you have other questions or concerns. Take care and have a good one.
I found that I could run the Sales by product / service detail report and customized it to sort by sales rep
I'm looking to run a sales rep report and seen your solution.
but I'm unable to add a filter on the Sales by Product to add the sales rep.
how did you do this please?
Thank you for joining the thread, @mmauck.
I'm here to guide you with the steps on how to add the Sales Rep to your report.
The option to add a sales rep is possible if there's a custom field added on the invoice. For now, you can start by creating one, then record an invoice with the sales rep information before running the Sales by Product/Service Detail report.
Here's how to add a custom field:
Once done, add the details on the Sales Rep field when creating sales transactions.
To display the column on the report, go to the small gear icon, then check the box beside Sales Rep.
For additional references about enhancing custom fields and customizing your form templates, feel free to read the details from these links:
Also, this article gives you more instructions about handling QBO reports: Run reports in QuickBooks Online.
You can always add a post or comment below if you have other QuickBooks questions. I'm here to help. Have a wonderful day ahead!
Angelyn_T's answer only told you how to add the Sales Rep column to your report. In order to filter the report for a specific Sales Rep, you have to click Customize at the top of the report. Then click Filter and find the Sales Rep option at the bottom of the list. Put a check mark in the box and it will add that filter to the top of your Active Filters list. Then add in the exact spelling of the Sales Rep that is used in the field on the Invoices. It's very important that you follow strict naming conventions, because WR will not filter the same as W.R. or Will.
This is what your Customize Screen should look like once you have the Sales Rep filter activated.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here