Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Jen_D
Moderator

Reply to message

It's great seeing you here in the QuickBooks community, @Genesa.

 

I can definitely help you get a report with the shipping state and classes. For this we need to get two sets of reports to get the data you need.

 

To get the report to display classes alongside the transactions, use a Transaction Detail by Account report. Here's how to use it:

 

  1. Go to the Reports menu and find Transaction Detail by Account.
  2. Click the Customize icon on the report and go to the Filter section.
  3. Select the name on the Customer drop-down or Invoice for the Transaction Type.
  4. Mark the Class filter.
  5. Update the Report period and the Accounting method.
  6. Lastly, click on Run report.
  7. (Optional) You can use the Save customization option, so you don't need to redo it when pulling up the same report. Saved customizations are then moved to the Custom reports section.

To add the addresses, use a Transaction List by Customer report. Here's how to customize it:

 

  1. Go to the Reports menu again and choose Transaction List by Customer.
  2. Click the little gear on the report, then Show More.
  3. Mark the addresses you want to see when you run the report.
  4. Click on the header to exit out from the filter.

 

 

Then you can export these reports using the export icon found beside the report gear icon. From the worksheet, combine the information using the transaction numbers manually.

 

I've attached a few resources to guide you with QuickBooks reports:

 

 

Comment down below if you have other questions or clarifications about running sales reports. I'm always here to provide additional assistance with QuickBooks. Have a great week ahead. Take care.

Need to get in touch?

Contact us