Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello @JP Dmitriy,
Currently, we're unable to break out the address into cities and states. However, you can export your report to Excel and add them manually. Let me guide you how.
- Go to Reports, then type "Transaction List by Customer Report".
- Select the Customize button to filter the report.
- Click the Export icon, then Export to Excel.
- In the Excel spreadsheet, manually add columns for state and city.
- Highlight the title row, and then click Data at the top.
- Choose Filter. See attached screenshot at the bottom.
Please see this article for more information about exporting your reports to Excel from QuickBooks Online. You can also visit our page about reports and accounting for your reference.
I'll be around if you have other questions and concerns. Feel free to swing by anytime. Thanks and have a lovely day ahead.
