Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 27, 2022
Question

Accounts Payable report by vendor by class

  • July 27, 2022
  • 3 replies
  • 62 views

How do I make a report to see accounts payable by vendor by class?

3 replies

Level 8
July 27, 2022

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! 

Berl SpitAuthor
July 29, 2022

 

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.




Adrian_A
Level 8
July 29, 2022

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.