Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
beverlybonnema-g
Level 1

IN THE REPORTS SELECTION, HOW DO I GET THE FULL SHIP TO ADDRESS, INCLUDING CITY, TO SHOW UP ON REPORTS?

I need to create a "Sales by City" report to capture the revenue by city.  The ship to address in the reports, omits the actual city.  I cannot use the report by ZIP CODE because some cities near me have the same zip code but income tax must be paid to actual city not zip code
3 Comments 3
ShangY
QuickBooks Team

IN THE REPORTS SELECTION, HOW DO I GET THE FULL SHIP TO ADDRESS, INCLUDING CITY, TO SHOW UP ON REPORTS?

Thank you for joining the thread, Beverly.

The option to run sales for a specific city report is unavailable. However, you can utilize the Location Tracking feature to make it easier to identify which city the sales are coming from.

 

After using the location tracking option, you can generate the Transaction List by Customer report and have it customized to show the address and other information you need. I'll gladly write down the steps to get you going:

 

  1. On the left panel, go to the Reports tab.
  2. In the search bar, enter Transaction List by Customer.
  3. Click the Customize button.
  4. Go to the Change column section and then add the details you need.
  5. In the Filter section, click the Dropdown arrow to choose a specific account in the Account field.
  6. In the Location field, click the Dropdown arrow to select a city.
  7. Once done, click Run report button.

 

In addition, I've included this article to help you save the current customization settings: Memorize reports in QuickBooks Online

 

If you have further clarification or concerns on how to run sales report in QuickBooks, feel free to leave a reply below. I'm here to help you. Have a good one.

beverlybonnema-g
Level 1

IN THE REPORTS SELECTION, HOW DO I GET THE FULL SHIP TO ADDRESS, INCLUDING CITY, TO SHOW UP ON REPORTS?

The LOCATION TRACKING option is not available in the advanced settings in the gear.

Candice C
QuickBooks Team

IN THE REPORTS SELECTION, HOW DO I GET THE FULL SHIP TO ADDRESS, INCLUDING CITY, TO SHOW UP ON REPORTS?

Hey there, @beverlybonnema-g

 

Thanks for chiming back on this thread. 

 

What QuickBooks Online version do you currently have? 

 

If you don't have QuickBooks Online Plus or Advanced, this could be way you're not seeing the option. If you do, let's try clearing your browser's history to help eliminate any errors or glitches in the system. 

 

Please, keep me updated and provide as many details as you can so we can determine what the next steps are for you business. I'll be right around the corner, when you're ready! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us