Looking for a Report that shows sales by customer zip code or city for my local city business license gross receipts?

My city wants gross receipts for sales with the city. I have sales from other cities and counties and would like to exclude those from the gross amount so they are accurate.