cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
elizabeth11
Level 2

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

 
8 REPLIES 8
GeorgiaC
QuickBooks Team

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

Hi elizabeth11,

 

 

Are you using location tracking to record the sales against separate countries?

elizabeth11
Level 2

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

Hi, I don't think I have, I always fill in the country in the address section. I will look at this now Thanks
elizabeth11
Level 2

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

I have set up location tracking, and it tracks sales by country according to the revenue but not by product. Is it possible to track product sales by country, and also to tracks sales on bundles by how many are sold not the revenue. Thanks
IamjuViel
QuickBooks Team

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

It's great to hear again from you, @elizabeth11.

 

Yes, you can track product sales by country and sales by each product on bundles. Let me walk you through on how to customize your Sales by Location Detail report.

 

The Sales by Location Detail report displays your sales grouped by location which includes the total unit and sales amounts for each location.

 

To customize and generate this report, 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 Customise button.
  5. Expand the General section.
  6. Choose the date range of transaction that will be included in the report.
  7. In the Rows/Column section, click the Change link.
  8. Ensure to include Location and Class in the Columns.
  9. Click Run Report

Using this report, you'll be able to view your sales either by Location or Product/Services. I've attached a screenshot below for reference.

 

You can also perform the same customisation using the Sales by Product/Service Detail report. To learn more, please refer tho this article: How to customise a report.

 

For additional insights about Location tracking, you may check to this article: Customise sales forms by location.

 

Let me know if you have other questions. I'm just a few clicks away.

elizabeth11
Level 2

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

Thank you for this. I still can't see the bundles. It shows all the items in the bundle. I'd like to just see the bundle name not the components if that makes sense? I buy in stock and assemble them in to a product that I sell and track as a bundle so I want to track the overall product bundle not the components. Is this possible? Thanks
EdwardR
QuickBooks Team

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

Hi Elzabeth,

 

Unfortunately with the current reporting in QuickBooks Online it's not possible to show bundles with in the reports. Whilst this isn't currently possible we are always looking at ways in which we can enhance our customers experience with QuickBooks Online, we do this through feedback from our customers which you can provide on this link here.

 

 

jmliles
Level 1

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

Has this been updated yet?

Rasa-LilaM
QuickBooks Team

Hi, I want to create a report showing my sales of product last year to each country I shipped to for each product. Is this possible ?

Thanks for following on this thread, @jmliles.


For you to see your last year’s sales for products shipped to each country, I still suggest running the report provided by my colleague @IamjuViel. This time will personalize the data based on the period.

 

  1. Go to the Reports menu on the left panel to enter Sales by Location Detail in the search field.
  2. This will show all the complete data of the report.
  3. Tap the Report period drop-down to choose Last Year.
  4. Hit the Customise button to open the Customise report window.
  5. Scroll down to the Rows/Columns section and then click the Change columns link.
  6. Mark the boxes for Location and Class.
  7. Hit the Save button to view the changes.

For future reference, let me share the Customize Reports guide. It provides an overview of saving the tailored report as well as screenshots for visual reference.


Keep in touch if you have any clarifications or other concerns. I’ll pop right back in to help you. Enjoy the rest of the day.

Need to get in touch?

Contact us