Let me provide some steps for sorting your invoices by city to figure out your tax calculations.
First, let's make sure the Track Location setting is turned on. This is to ensure you're able to track your transactions by state in your report. Also, this enables you to specify the location every time you create a transaction like an invoice, sales receipt, etc. Here's how we can do this:
Go to Settings, then choose Account and Settings.
Select Advanced.
Click the Edit icon in the Categories section.
Turn on Track locations.
Click Save, then Done.
After this, we can go ahead and run the Sales by Location Detail report. Here's how:
Go to Reports on the left side menu.
Type Sales by Location Detail in the search box.
Pick a Report period, Group by Location, and Accounting method.
Hit Run Report to display the desired info for this report.
Let me know how it went and if you have further questions on customizing reports or other QuickBooks-related concerns. This thread is always open. Stay safe!
Thank you very much! I appreciate you taking the time to let us know that my colleague's solution was able to assist you. I also commend you for following the suggestions and utilizing all of your resources to arrive at the solution you have now.
As always, the Community is brimming with professionals who are knowledgeable in every aspect of QuickBooks, so please don't hesitate to contact us here if you have any questions. We're always happy to assist you on your way to victory. I wish you and your company continued success!
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.