Jen_D
Moderator

Account management

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.