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" under the "Financial" section.
Select the date range (by default, it shows the current year to date) and billing type you want on the report. Billing types include Billed, Collected, and Outstanding.
You can then export an Excel sheet, CSV file, or print the report from the "Export" button.