FateCandylaneT
QuickBooks Team

Account management

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.