Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I am needing to run a report that is showing Customer Sales by Class that also includes the Customer address on the same report. I've tried to customize multiple reports in Quickbooks online and can't seem to find one with both the customer address, sales and by Class.
Generating a report by class with customer address and sales is interesting, @Bre1208. We can run different reports and then combine them manually to achieve it. I'm here to walk you through the process to ensure you get the data you need.
You're right, no report contains sales and addresses by class together. I can see how that would benefit you and your business. Thus, I recommend sharing this idea with our Product Developers. They will review it and consider it for future updates depending on the number of users' requests.
Here's how:
You'll want to track your suggestion through this website. You can also visit our blog to keep up with recent events and developments.
As a workaround, we can run a Customer Contact List report for the addresses and Sales by Customer Detail or Sales by Class Detail reports for the transactions.
I'm adding these screenshots for your reference:
Once done, merge these reports into one Excel file. See this article for more guidance: Export your reports to Excel from QuickBooks Online.
These resources will help you modify reports and save their current customization to save you time:
It's always my pleasure to help you with other questions about developing reports. Use the Reply button and leave your comment below so that I can assist you further. Take care always.
Thank you for replying JamaicaA,
I actually have figured that part out, however it still requires you to move information from one Excel spreadsheet by individual cell manually into the other excel spreadsheet, so we may we as well just type the info manually anyway. So, this is not what is needed as this is a huge report for us that has to be done every month. Unfortunately, we just moved from Desktop version which pulled this entire report with no problem, but Online seems to be lacking in many areas and this is just one of them.
We're still using desktop and need the class report with customer address included. How did you use to run it and has Quickbooks fixed the online version to run same report?
I appreciate you for joining this thread, @LDFF. Let me share updates about running customer sales with customer address reports in QuickBooks Online (QBO).
For now, generating a customer report by class with the customer address is still unavailable in the online version. Having this feature will specify a particular area of your business and provide you with additional details about your customers.
Nonetheless, QuickBooks Desktop (QBDT) versions contain multiple sales reports where you can apply classes and add customer addresses. One of these is the Sales by Customer Detail report, which you can customize to add particular columns.
Moreover, I suggest sending this suggestion to our product development team. Our product developers are responsible for evaluating and implementing new enhancements, so they would be better equipped to determine the feasibility and benefits of your suggestion for our users:
For the time being, I would suggest generating a Customer Contact List report for the addresses, and Sales by Customer Detail or Sales by Class Detail reports for the transaction for your QBO firm.
It brings me great delight to assist you with any product preference queries you might have. If you require further guidance in navigating through the application, feel free to post them in this forum. Take care!
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