I use the "Sales Tax Liability" report under Vendor (Vendores/Sales Tax/Sales Tax Liability). Enter the period you want sales by state for and the left column the total. I collapse the report to get just the summary not all the jurisdictions within the state.
I could not find a report or anyway to get the information I needed for Sales by State either. SO.... what I did was create a "sales tax item" for each state. I tried it for the first month in January2019 and it worked. Then for each invoice/sales receipt I entered the appropriate sales tax item for the state invoice was shipped to, I also have an "out of country" sales tax item for foreign sales (we sell worldwide). I generated my sales tax report, it is now very long. However, it worked and my report shows monthly sales for the different tax locations in my state, (which I need to fill out my monthly sales tax report,) it shows total sales for different states, (which I will use if we every have to send sales tax to different states, we don't at this time), and it shows total sales for all foreign countries. I export that report into EXCEL to add things up and get totals, such as all different tax locations and a total for All States. The sales tax report is now long and cumbersome, and it took a while to create a "sales tax item" for every state, but it worked and my sales tax report gives me "Sales broken down by State." Hope this helps.
Hello there, JM_hollings.
I appreciate the steps you've shared as an alternative for creating a report that will show the total Invoice Sales broken down by State.
The workaround will definitely help other posters that may have the same problem. Please know that the Community is a one stop shop for help about QuickBooks.
Allow me to add this link to get more information for a certain topics you'd like to know more about: QuickBooks Resource Center.
Please know that you're always welcome to post any questions you may have or want to share your insights and practices using the product. I'd be glad to assist you further.
Just playing with the Sale>Sales by Customer Detail report. My issue is I have customers with a single billing address but locations in multiple states. I tried adding the Name State field and sorting by that column, but that only uses the billing address state.
Looking further, I found there is a Ship to State field. You cannot currently sort by this field, but at least you can export to Excel and sort it there.
Hope this helps. Using the Windows desktop Enterprise Solutions version of QB.