Hello there, @Ned2,
Thanks for joining QuickBooks Community. I can help customize your sales report.
QuickBooks Online allows you to customize and manage sales report but it depends on how you track to your in and out of state customers. If you tracked your customers by class or customer type, see the steps below to get the information you need.
1. On the Dashboard, select Reports.
2. From the Sales and Customers section, select Sales by Customer Detail.
3. In the Rows/column section under the Report period, select a Group by type.
4. Click Run report.
That should get you pointed in the right direction.
For further reference, please read this article about how to customize reports.
I wish you and your business continued success. Let me know how it goes or if you're referring to something else by posting a comment.
Thanks for the fast response, however with the instructions you had given me, i do not have the option to choose the customers by states. I can check the different products they have bought or how they paid but not their location.
Thanks for coming back to the Community, Ned2.
We don't have a report that can be grouped by customer's address. However, we can customize the forms by location, so we can easily track the sales transactions by state (available in QuickBooks Online Plus). I'm glad to show you how.
First, let's turn on location tracking.
Next, add a custom location or state.
Once done, open the sales transactions and add the state in the Location box.
Lastly, let's run the Sale by Customer Detail report and group it by location. Please follow the steps I've laid out below:
Please know that the "Not Specified" section includes the transactions that we haven't added a state or location.
The steps above should help you track the sales transactions by state.
Let me know if these steps work for you. I’ll be right here to assist if you have any questions. Best regards.
Let me jump in and share some information about this.
The class and location tracking features are only available in QuickBooks Online Plus. That's why you're unable to see the Categories section in the Advanced tab.
And I've got two options for you. You can upgrade your subscription or follow this workaround to pull up the report.
First, customize your invoice template and add the location/state. Here's how:
Then, manually enter the customer's location when creating an invoice.
Lastly, include the custom field when running the sales report. Here's how to do it:
You can export the report to Excel to get the total amount of every location.
Feel free to read this article for details: How to customize reports.
This article will help you for future reference: Track sales commissions in QuickBooks Online.
If you have other concerns, please don't hesitate to swing by.