We need a report showing every transaction by the city.
In the Admin Console
Click "Reports" > "Reconcile Reports" > "Document Summary Listing"
Select the "Report Level" > "State by City". This will show you all city transactions.