Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi There...
Is there an easy way I can generate a list of my customers from last year and the percentage of the year's sales that each one represents?
Thanks!
Ben
Solved! Go to Solution.
I'll make sure to help you today, @BenF.
We can pull up and customize the Sales by Customer Summary Report so we can add the (%) percentage column.
Let me show you how you can do it:
Here's an article you can read for more details: Customize reports in QuickBooks Online.
Please let me know if I can be of any help. Have a good one and stay safe!
Hello @BenF,
In QuickBooks Online, you can pull up and customize one of your sales report to compare your customer's sales in percentage. Let me show you how.
In addition, here's an article you can read to learn more about how you can customize your report: How to get the most out of your financial reports?
Lastly, I've also included this reference helpful for the steps in saving the customization you made with your report: How to memorize a report?
If you have any follow clarifications with this or other concerns with QuickBooks navigation and task entry, please let me know in the comments below. I'll be here to lend a hand
Wouldn't that create a report comparing this year's sale to last year's as a percentage of change? What I was asking about was to display each customers total sales for the year, and the percentage of that year's sales it represents. So, for example, if total sales was 1 million, and one customer did $200k, it would list that customer as having been 20% of the year's sales...
I hope that's clear. I don't think that's what you're showing me here..
-Ben
As another option, consider having a CRM app and/or a BI app to integrate with your QBO.
So you're saying it can't be done with QB?
Ben
I'll make sure to help you today, @BenF.
We can pull up and customize the Sales by Customer Summary Report so we can add the (%) percentage column.
Let me show you how you can do it:
Here's an article you can read for more details: Customize reports in QuickBooks Online.
Please let me know if I can be of any help. Have a good one and 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