To generate a Revenue by City Report that shows total revenue by the city for any time frame and either billed or collected, click the "Reports" tab.

Then click "Revenue by City."

Next, select the date range and billing type you want to be shown on the report.

(note: by default, it shows the current year to date)

You can then export an Excel or CSV file or print the report.