We can certainly understand your frustration and desire for a simple report that shows this information. about Why can’t I get any data on this report ‘Sales by Location Detail Report’? It would be a very helpful report.
If you haven’t already, I would STRONGLY recommend you submit feedback for this report to the engineers by clicking the Gear icon and selecting Feedback. This is the best way to get the request directly to the engineers.
That being said, there is another way to create the report without having to export to Excel first if you’re using QuickBooks Online Plus.
While there isn’t any sales report that pulls the address info from the customer profile, QBO Plus has the ability to use Classes and/or Locations. What you could do is create a location or class for each state. Then when you create the sale assign a class or location for the state the customer is in.
Then run a Sales by Customer Detail report. In that report you have the option to group by Class or Location.
I know this isn’t as streamlined as you’d like. Just offering another option.
Learn how to record transactions for rental properties you manage and for your own management… Read More
Learn how a non-taxable reimbursement payroll item can be created in QuickBooks Desktop payroll. In… Read More
Learn how to change your email address, user ID, or password for QuickBooks Online or… Read More
Get help to downgrade your QuickBooks Online plan. in 2020. You can always choose what’s… Read More
Find out what to do if can't sign in to your account for QuickBooks, Payroll,… Read More
Learn how you can help customers if they can't pay for an invoice you send… Read More
Hit the 'Yes' option to get the best experience.