How do you make a report that does sales for the year broken down by City, State, zip

Thank you for posting your first concern in our forum, @Denise61000. I'll help you with pulling up your sales report for the year broken down by City, State, and Zip code.

At this time, you can run the Sales by Location Detail report to see your sales performance of all linked localities. You can group it by Location to generate the amounts per place. Here's how:

1. Click on Reports at the left pane, then look for Sales by Location Detail.
2. Filter the Dates.
3. Select Location under Group by.
4. Tap on Run report to refresh the page.

However, it only defaults to the data you've entered on the Location field when tracking your sales.

I can see your interest in getting the breakdown of your sales by city, state, and zip. For now, you can also open the Customer Contact List to get this information. 

1. Select Customer Contact List from the Reports tab.
2. Go to the small gear icon.
3. Add the information you need (city, state, zip).
4. Click on Run report.

Once done, export both reports to Excel. Then, customize the data from there manually.

I'm adding these resources for more hints while running your sales reports with our system:

• Run reports in QuickBooks Online
• Customize reports in QuickBooks Online

Additionally, you may save the current customization settings of your report for future use. You can read through the resources from this article as your guide: Memorize reports in QuickBooks Online.

I'm always here to extend my help if you have follow-up questions while managing your sales data in QBO. Just leave a comment below. Have a great day ahead!