Sales report - By contact location
It's unfathomable to me that it is not possible to do something as simple as output sales by state or by province or by country or by city. These are discreet fields in Xero and we ought to be able to filter a sales or P&L report to just include sales for some regions or to summarize by state or country. Right now all I can do is export all transactions and run everything through excel, which is not the way this should work. Thanks.
Hi team, while not a fully fledged report you may find Smart Lists within a contact useful at present.
From Contacts you can set up and get a list of customers that meet certain rules that you've set up - such as 'Location' is and setting this to one or more locations your customers are based.
-
Emily Marston commented
We have a non-sales tax service. We travel to various states to perform this service on-site. I need to run a report of revenue by state for annual state filings.
-
Katie Quinn commented
Even though I moved to NYS 10 years ago I still have pay state income tax to California because I set up my business there. I need to be able to report how much of my income was generated by CA each year at tax time. It would be incredibly simple to add in a feature that can let me filter/search for CA invoices by year or quarter. Please build this feature!
-
Lori Butler commented
We absolutely need a report of specific income accounts by city, state, and country. Just today our CFO asked for this report. Furthermore, State field should default to USPS standard two characters. Allowing users to type in full names, two letter codes, or any other abbreviation also creates huge issues with reporting.