Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowOur business is really growing and I need to keep track of each sale by state so I am in compliance with the remote seller rules by state. Everything I can find says I go to customer detail and select a column for state/province. I can't find that option anywhere.
You can enable and use the location tracking feature to get the information you need, @accounting639.
Since the option to run a sales report by state in QuickBooks Online (QBO) is currently unavailable, you can use the Track locations feature as a workaround. This will allow you to track transactions by state in your reports by specifying the location each time you create a transaction, such as an invoice or sales receipt.
Before we begin, let's ensure the Track Locations setting is enabled. Once location tracking is enabled, you need to create a list of all the states where you do business. Here’s how to do that:
1. Navigate to the Gear icon and select All lists.
2. Click on Locations.
3. Click New and enter the name of a state (e.g., "California", "New York"). Then, click Save.
4. Repeat this process for each state you need to track.
For all new sales, ensure to select the correct state from the Location drop-down menu on the sales receipt or invoice.
For past transactions, you'll need to manually edit each sale to add a location, which will allow it to appear in your report.
After assigning locations to your transactions, you can run the Sales by Location Summary report to view sales by all the states you've set up. By clicking on the amount, you'll be redirected to the Sales by Location Details, where you can see a breakdown of each transaction by state.
Since the report you want is currently unavailable in QBO, I recommend providing your feedback directly to our product developers to express your need for this feature. Here’s how you can submit your feedback:
If you have any additional questions, please feel free to revisit this thread.
I have spent over 20 hours since August with customer service trying to get this report or get them to fix the broken State Nexus screens. This work around if it works is helpful but absolutely ridiculous for accounting software in 2025.
Thank you for detailing this hack.
Hopefully Quickbooks developers work on fixing the bugs before they break anything else with another new menu system!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here