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 use QB online and would like to run a report that shows sales by customers by month. I saw a report that runs sales by customers which compares 2 months but I'd like to see sales for 12 months. Is there a way I can create such a report?
Thanks.
Solved! Go to Solution.
Yes, there's a way to create the Sales by Customer report that compares your twelve months' worth of sales in QuickBooks Online (QBO), @juma1. I'm here to guide you how.
You can compare two months of your sales when pulling up the Sales by Customer (Summary) report through the Compare another period feature. Then, to acquire such a report that provides your twelve months' worth of sales, you'll have to manually update the Report period and Display columns by fields. Here's how:
I've attached screenshots below for your reference.
After customizing the sales report, you can memorize it to save its current customization setting. For the detailed steps, kindly check out this article: Memorize reports in QuickBooks Online. It also contains information in scheduling and emailing a memorized report and add it to a group.
I'm also adding this article for the complete list of reports available for your QBO version: Reports included in your QuickBooks Online subscription. It includes sections like business overview, sales and customer, and who owes you to name a few.
Please let me know if you have other concerns. I'm just around to help. Take care always.
Yes, there's a way to create the Sales by Customer report that compares your twelve months' worth of sales in QuickBooks Online (QBO), @juma1. I'm here to guide you how.
You can compare two months of your sales when pulling up the Sales by Customer (Summary) report through the Compare another period feature. Then, to acquire such a report that provides your twelve months' worth of sales, you'll have to manually update the Report period and Display columns by fields. Here's how:
I've attached screenshots below for your reference.
After customizing the sales report, you can memorize it to save its current customization setting. For the detailed steps, kindly check out this article: Memorize reports in QuickBooks Online. It also contains information in scheduling and emailing a memorized report and add it to a group.
I'm also adding this article for the complete list of reports available for your QBO version: Reports included in your QuickBooks Online subscription. It includes sections like business overview, sales and customer, and who owes you to name a few.
Please let me know if you have other concerns. I'm just around to help. Take care always.
Perfect, thank you!
What do I do if I do not have the second customization option showing up in Quickbooks to have the report provide monthly column data?
Hello, jgallup.
Let's perform some troubleshooting steps so we can verify if this is related to your browser or not, jgallup.
You can try using a different browser in accessing your QBO account to isolate further the issue. There are times that the browser stores frequently-accessed data, thus causing some errors or unusual behavior.
Let's try logging in to your QuickBooks Online account using a private or a different browser. Here's how:
Once logged in, go back to the report and customize it to double-check if you're able to view the monthly column data. If this works, it means that you need to clear the browser's cache so the system can start fresh. You can also do this task on other supported, up-to-date browsers. Clearing the cache will refresh the system, and you'll be able to work with clean trash.
Please feel free to visit me here in the Community if you have other questions in QuickBooks. Have a great day, and stay safe!
I have the report that shows the Sales by Customer by Month, but it is a single line per customer only.
What I have been unable to find so far, is a way to show the months as columns, then the customers down the left, with each product / line item shown for each customer.
Month 1 Month 2 etc
Customer A
- Line item 1
- Line item 2
- Line item 3
Customer B
- Line item 1
- Line item 2
- Line item 3
Is this possible?
Thank you for joining the thread and sharing the details of your concern about the report you want to pull up and the specific customization you desire. I'll share guidelines that could help you include your desired columns when you export your customized transaction report.
You can run the Sales by Customer Detail report and ensure to select all the columns you wish to include in your report. Then, export the report to Excel. From there, you can modify it to add columns for the months and then the customers down the left, with each product/line item shown for each customer.
You can follow these steps:
I will also leave these articles as a future reference:
Feel free to post here again if you have further questions about report or any QuickBooks-related concerns. We are available 24/7 to lend a hand with each of your queries. Stay safe!
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