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.

Reply to message

View discussion in a popup

Replying to:
FateCandylaneT
QuickBooks Team

Reply to message

You can run the Sales by Customer Detail report to specify data by City, AlarmCompany.

 

Since location tracking is enabled in your company file, it's best to ensure you're recording the specific City when creating your sales transactions. This way, it'll be easier for you to track your overall entries.

 

For now, you can run the Sales by Customer Detail report and customize the columns to show sales by City. To do this:

 

  1. In your QuickBooks Online account, go to Reports and enter  Sales by Customer Detail from the search panel.
  2. Click on the Switch to Classic View icon, and select Customize.
  3. From the Rows and Columns, click Change Columns and enable the Location option.
  4. Then, Run report.

 

 

In addition, you may run the Custom Contact List report to validate the specific location based on customer City. Then, modify the report to include the Billing City option.



 

Also, here's an article to help you save all the customizations made on your reports: Create, access, and modify memorized reports.

 

Reply to this thread for any additional queries.

Need to get in touch?

Contact us