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.