My case was simple. I needed sales by state. Below workaround took me a couple of minutes. I hope it helps someone. This is for Quick Books online.

1. I exported "Sales by Customer" Summary from the Reports

2. I then exported "Customers" by using the export icon.

3. Customer export gave me access to the State field

4. Sales by Customer gave me the Sales numbers for that customer

5. I did vLookup by Customer Name to get Sales and States in one excel sheet

6. I used Pivot table to get total by state. I just needed the total by state so it worked.

I followed ReyJohn_D's instructions, but when I run the Sales by Location Detail Report ALL sales show as  "Not Specified" nothing shows by state. Apparently there is another step?

I want to ensure your transactions will show as Specified in the report, LEM1.

Thank you for following my colleague's instructions. I have workarounds to ensure your transactions will fall into the specific state in the Sales by Location Detail report. This way, you can review them at any time. 

Make sure that the transactions are labeled to the specific state. This way, it will be categorized as Specified. To check this, follow the steps below: 

1. Go to the Sales tab and select Customers or Invoices. 
2. Click the transactions one at a time. 
3. Review if there is an assigned location. If there isn't, I'd suggest picking a specific state. 

After confirming, ensure that the Location field in the report is filtered to All or Specified. Just click the Customize button on the upper right corner and verify the setting. See the sample screenshot below for your reference: 

If the issue persists, you may want to run the Location Quick Report as a workaround.

Perform as follows:

1. Go to the Gear icon and select All lists. 
2. Choose Locations. 
3. Locate the specific state and click Run report. 
4. Customize the settings again. 

Further, check out these articles below on how to add fields on your sales forms and memorize reports in QuickBooks: 

• How to add custom fields to sales forms and purchase orders
• Memorize reports in QuickBooks Online

Let me know if you have any additional questions about running your reports in QuickBooks. I'd be happy to help you further. Take care always, LEM1.

I'm getting the same thing. Apparently, QBO has decided that neither Texas nor Ohio are states.  

To the powers that be:  given the draconian new sales tax reporting requirements for remote sales, by not allowing companies to easily keep track of sales by state, you're pretty much leaving an enormous Achilles heel for any halfway decent software, a basic understanding of compliance needs and some interest in client needs to swoop in and steal away your customers. 

I realize that there's nothing you (as support) can do and I realize neither development nor management care.  I'm shouting into the wind. 

Am getting my first client using Xero soon; wonder if they're any better....

Bingo!  Thanks :)

This should be a simple report. You see the field when you edit a customer called state. Make a report that shows all my customers with the same state that I choose from a drop down. 

Done.

Your suggestion is brilliant, @EmergencyLighting.

You can directly submit feedback to our software engineers to raise your suggestion. They may consider adding this to our future product updates.

Here are a few steps to submit feedback:

1. Click the Gear icon.
2. Below the Profile section, select Feedback.
3. Enter your suggestion then click Next.

Consider clicking this link if you want to be in the loop of our product updates: QuickBooks Blog.

If you require any additional suggestions about the Sales report, don't hesitate to reach out to us again. Thank you, and have a great day!

This is really helpful!

I need a report that will allow me to group states into sales territories. Any thoughts? 

Greetings, @HLaJoye. 

Welcome to the Community! Allow me to give you some insight to help you out. 

Once you enable and use the Territory feature in the settings, QuickBooks will let you generate the Sales by Territory Detail report. 

You can customize this report, here's how: 

1. Click Customize at the upper-right corner.
2. In the Filter section, tick the Territory box.
3. Select all Territory you need.
4. Make sure to set the correct dates.
5. Then, hit Run report.

It's that easy! 

This should do the trick. If you have any other questions, don't hesitate to ask. Have a great day! 

I am fairly new to QBO and sometimes I just want to give up.  I come from Peachtree/Sage and trying to get a report for reporting tax is so hard.  I have tried all that you have listed concerning running a report for a specific period for a certain State and it is just not working.  I am using QBO Advanced.  If anyone can lend a hand in what I might be doing wrong, I certainly would appreciate it.  Vandy

Hi Vlouden,

We want to help you with your concern about the sales report. However, we need more information about it to provide the correct resolution and to get this sorted out promptly.

Can you share more details about the help you need with the suggested report? We need more info about why it's not working on your end. If you could provide some screenshots, it would also greatly help.

In the meantime, you can check this article for additional guidance on personalizing reports in QuickBooks: Customize reports in QuickBooks Online.

Please know that you're always welcome to post questions in this space. Have a great day ahead. 

This worked for me. Thank you for the suggestion.