Accounts Payable report by vendor by class

Hey, @Berl Spit. 

It's great to see you back in the Community. Let me share some insight into running reports in your QuickBooks Desktop account. 

The best report to use in your case may be the Unpaid Bills Detail report. From there, you'll add the "class" column and sort by class. 

Learn more about this report and the steps through this guide: Filter, sort, or total reports by class. 

Feel free to ask any more questions you may have. I'm always here to lend a helping hand. Take care! 

Thank you for your reply.

I'm trying to add to the Unpaid Bills Detail report the "class" column, and it does not show up its all empty as you can see below.

I know how you can add the Class column on the Unpaid Balance Detail report, Berl Spit.

If you run the Unpaid Balance Detail report and filter it to Class, you will not see the said column. The class is assigned to the targets, and target information is not included in the report.

You can obtain the report you need by changing the filters. Let me guide you with these steps:

1. Delete the Account filter.
2. Delete the Name filter.
3. Keep the Paid Status filter.
4. Add the Transaction Type filter, then from the Transaction Type drop-down, choose Bill.
5. Add the Detail Level filter and set it to All except summary.
6. Select OK.

Now the report shows the target data from the open bills and you can sort the report by Class.

If you want to save the report, you can memorize it. Here's an article as your guide: Create, access and modify memorized reports.

Feel free to get back to this thread whenever my help is needed.