How can i run a report of all international sales for the year?

Hello there, @AliN.

I'm here to help you run the specific report to view your international sales for the year.

If you're using location tracking to record the sales, we can run and customize the Sales by Location Detail report. This report shows your sales grouped by location. And it also includes the total unit and sales amounts for each location.

Here's how:

1. Go to the Reports menu.
2. Scroll down to the Sales and Customers section.
3. Select Sales by Location Detail.
4. Click the Customize button to choose the details you'd like to see.
5. Ensure to include Location and Class in the Columns.
6. Click Run Report.

If you're not using the feature, let's pull up the Sales by Customer Detail report. Doing so can help you filter the name of the customer that is not in the US. Otherwise, filter it by Tax Name to determine the location.

1. Go to the Reports menu.
2. Enter Sales by Customer Detail in the Search field and then click to open.
3. Click Customize.
4. On the Rows/Column section, you can select the Tax Name.
5. From the Filter column, you can select the name of the customer.
6. Once you're done, click on Run report.

To learn more about how you can focus on specific details of the reports that fit your specific needs, you can check out this article: Popular custom reports in QuickBooks Online.

You may want to consider memorizing the reports in QuickBooks Online. Doing so helps you save the current customize settings for easy access in the future.

The Community Team is always around if you need anything else. Have a great day!

Can location tracking be retroactive? If we turn it on now does it take information based on customers in countries we have already sold to?

Hello, @AliN.

Once you turn on the Location tracking feature, you'd have to create a list of possible locations and add it to QuickBooks. This is not a retroactive feature.

Here's how you can add a location in QuickBooks:

1. Go to the Gear icon.
2. Select All Lists.
3. Choose Locations.
4. Click the New button.
5. Enter the location then choose and customize the following options, if needed.
   • Is sub-location
   • This location has a different title for sales forms.
   • This location has a different company name when communicating with customers.
   • This location has a different address where customers contact me or send payments.
   • This location has a different email address for communicating with customers.
   • This location has a different phone number where customers phone me.
6. Select Save.

You can refer to this article to learn more about setting up the location tracking feature: Customize sales forms by location.

Also, I'm adding this blog links that you can as a reference in maximizing the use of class and location tracking in QuickBooks:

• Using Classes and Locations in QuickBooks Online
• How to set up and use location tracking.
• How to set up and use class and location tracking.

Feel free to click the Reply button below if you have any other concerns about Location Tracking. I'm always here to help you out. 

Thank you we are just looking for all non USA sales report. So all we care about is other countries so sub location etc. doesn't seem to reflect what we are looking for. Based on what I'm reading this all has to do with Source "Location" meaning Office locations and or what eCommerce or brick and motor store sales came from.

We are NOT looking for these kinds of locals, only country based. QuickBooks Online already has all of our customers information, how do we go about listing sales by country? 

What is the easiest way to configure for this? 

Hi there, AliN. 

Thanks for the post. As long as you follow the steps provided by my colleague and add the sub locations in other countries, you'll be able to filter by location on most of your reports. For further information on how to customize your reports, feel free to check out this link: Customize Report.

If you have any other questions, feel free to post below at any time. 

It is still not possible.

The QBO team could just add a filter for customer country into the customer sales reports, and that would help already.

Hi Mark,

I was just looking into this myself and saw that you came to the same conclusion. What I ended up doing is using the Sales by Customer Detail report, adding the Tax Code column and exporting to Excel where I sorted on that column. That is assuming you are taxing domestic customers only which is our case. Wouldn't have had to export if I could group by that column, or as you've mentioned, if the country could be added in the report, but it did the trick for me.

Hope this helps!

Hi lvledoux

Thanks for the idea, but it doesn't work (easily) in the cases I am looking at:

1. We want to see the amount of sales for each country, so the suggested report would only work to see local or international sales unless I add a different tax code for each country.
2. The BC PST sales tax report in QBO is incorrect, and I need the Canadian sales for it, and there are customers who order from Canada, but shipping is international and this would be the same tax code as exports - Zero-Rated. I guess I could add another tax code, but we do have a different workaround right now.
3. Some insurance companies want Canadian, USA and international sales reported separately for some specific policies. Again - this could work with different tax codes.

...but why do they make us use workarounds? Is it really so unreasonable that a company like QuickBooks with so many clients implements a way to see sales by country? Sigh.