cancel
Showing results for 
Search instead for 
Did you mean: 
avanzeeland
Level 2

Is there a report that allows to sort by product/service AND shipping address?

I would like to see a history of geographic location where specific products have been sent.
7 Comments 7
LieraMarie_A
QuickBooks Team

Is there a report that allows to sort by product/service AND shipping address?

Glad to see you here, @avanzeeland.


The closest variation of your desired report achievable in QuickBooks Online is the Transaction List by Customer, which can be customized to add the Shipping Address column to show where you sent them.

 

Here's how:

  1. Go to the Reports menu.
  2. Scroll down to the Sales and Customers section.
  3. Select the Transaction List by Customer report.
  4. Click on the Customize button.
  5. Modify the reporting date.
  6. Click Change columns and select the Billing Address checkbox to include the customer's address.
    Capture.JPG
  7. Click Run report.


You can check out this article to see the complete list of available reports for your QuickBooks Online version: Reports included in your QuickBooks Online subscription.

You can also export them to Excel to help give you the flexibility to use them. Simply click the Export icon and select Export to Excel

 

Please let me know if there's anything else that I can help with your reports. I'm always here to assist. Have a wonderful day.

lizk1
Level 1

Is there a report that allows to sort by product/service AND shipping address?

This is helpful, but for some reason the "shipping to" icon does not appear.  How can I add this?

Ryan_M
Moderator

Is there a report that allows to sort by product/service AND shipping address?

Hi @lizk1,

 

I'll walk you through how you can add the Shipping to field in QuickBooks Online (QBO).

 

Follow these steps:

 

  1. Go to the Gear icon.
  2. Select Custom form styles.
  3. Choose the Standard (Master) form style or any other form style you wish to use, then click Edit
  4. Move to the Content tab.
  5. Press the top-most part of the sample invoice on the right side of the page.
  6. Scroll down, look for the Display section, then tick Shipping.
  7. Hit Done.

Additional information on how you can make changes on the form style used in QBO is in this article: Customize invoices, estimates, and sales receipts in QuickBooks Online.

 

In case you want to use custom form styles, you can upload them into QBO. Take a look at this article for the steps: Import custom form styles for invoices or estimates.

 

I'm just around the corner if you need further assistance. Drop a comment below, and I'll get back to you. 

lizk1
Level 1

Is there a report that allows to sort by product/service AND shipping address?

Thank you!

lizk1
Level 1

Is there a report that allows to sort by product/service AND shipping address?

Can this somehow be done on the "Sales by Product/Service Detail" report?  I need the "quantity" and product in my report, but there is not "shipping address" showing in the Rows/Columns "group by" list for this report.  Can I somehow add the shipping address to this report?

 

Thanks so much!

gbudd
Level 1

Is there a report that allows to sort by product/service AND shipping address?

I am also looking for a report details all bills created, with the PO # as well as the ship to location. If this is not something that is available, then a report that can be run that shows all PO's created in a customizable timeframe with the ship to location. This would give me the ability to actually audit invoicing to customers based on the PO's that were created & shipping directly our customers. I have the ability to merge reports but I can't seem to find anything that lists PO # & ship to address.

Please help! 

Heide DC
QuickBooks Team

Is there a report that allows to sort by product/service AND shipping address?

I'm here with an alternative way to pull up a report with the Purchase Order number and the Ship to location, gbudd.

 

Since a single report that shows both the desired information isn't available in QuickBooks Online, we can manually generate both the Transaction List by Vendor and Customer Contact List reports.

 

Here's how:

 

  1. On the left panel, click Reports in the menu.
  2. In Search box, type Transaction List by Vendor, then select Customize in the field.
  3. Set the Report period.
  4. Click the Filter section from the Transaction Type drop-down list, and choose Bill and Purchase Order.
  5. Select Run Report.

For the shipping address to also appear, run the Customer Contact List report and customize it to show the Ship to details.

 

Once the reports are ready, export your reports to Excel from QuickBooks Online then customize the data from there.

 

In addition, you may check this article to be guided on how to record your receipts: Upload your receipts to QuickBooks Online.

 

 Let me know if you have other concerns about customizing your reports in QuickBooks Online. Feel free to comment down below. Stay safe.

Need to get in touch?

Contact us