cancel
Showing results for 
Search instead for 
Did you mean: 
kssimon
Level 1

Missing Class on Vendor Reports

On QB Desktop- I need to run a report showing all the bills paid by date and with classes.

 

I get to the "Bills for All Vendors" report (via the vendor button at the top)

I filter on "This Fiscal Year"

I get the report I need, but it does not include "Class"

I click on Customize Report

Select "Class" under column

Click "OK"

It adds the "Class" column to the report (which is what I need) BUT almost all of the classes are blank even though the Class is specified in the bill (and if I drill into the expense line detail from the Trial Balance, the classes ARE there.)

 

Any idea why they won't appear in this report?  

 

Solved
Best answer October 09, 2020

Best Answers
MadelynC
QuickBooks Team

Missing Class on Vendor Reports

You can run the Custom Transaction Detail Report instead, @kssimon.


Allow me to share first why there are transactions with classes that aren’t showing on the report. If the class is on the header of the Bill event, then it will show up. However, once the class is located on the line item of the Bill, it will not normally display on the reports.


There are three types of reports, the summary, the list and the detail. If you need the one that covers all information of the event, then you’ll need the details report. 


Running Custom Transaction Detail report has the ability to show the list of the vendor you have on a specific period, paid date, amounts and the class. I’ll show how:

 

  1. Go to the Reports menu, then Custom Reports.
  2. Select Transaction Detail.
    Capture.PNG
  3. Click Customize Report
    Capture 1.PNG
  4. Filter to Bill and select Class under Column.
    Capture 2.PNG
    Capture 3.PNG
  5. Select OK.
    Capture.PNG


You might want to check this article about customizing vendor reports in QuickBooks. This helps you modify some information based on your business needs.


If you want the same settings or customization to be available for future use, you can create memorized reports. QuickBooks will let you save it, so you do not have to go through the customization process again.


We’ll be here whenever you need help. Just visit us here, and I’ll make sure it will be taken care of. Keep safe.

View solution in original post

3 Comments
Nick_M
QuickBooks Team

Missing Class on Vendor Reports

Hey there, kssimon. 

 

Thanks for dropping by the Community. The Bills for all vendors report may not be supposed to pull that data, hence why it's showing blank. If you try running a transaction list by vendor filtered to only show bills. Doing this will give you exactly what you need. 

 

If you have any other questions, feel free to post here anytime. Thank you and have a nice afternoon. 

kssimon
Level 1

Missing Class on Vendor Reports

Thanks for the help, but that didn't work.  Tell me if I did this wrong:

 

Transaction List by Vendor

Filtered to only show Bills

Added the "Class" column

Ran the report

 

The Class column continues to be empty for most (but not all) of the lines on the report.  Even though the transactions ARE classed (which I can find by drilling into the expense account detail).

 

Any other suggestions?  What I want is a list of vendors, with the bill amounts, and the class.

MadelynC
QuickBooks Team

Missing Class on Vendor Reports

You can run the Custom Transaction Detail Report instead, @kssimon.


Allow me to share first why there are transactions with classes that aren’t showing on the report. If the class is on the header of the Bill event, then it will show up. However, once the class is located on the line item of the Bill, it will not normally display on the reports.


There are three types of reports, the summary, the list and the detail. If you need the one that covers all information of the event, then you’ll need the details report. 


Running Custom Transaction Detail report has the ability to show the list of the vendor you have on a specific period, paid date, amounts and the class. I’ll show how:

 

  1. Go to the Reports menu, then Custom Reports.
  2. Select Transaction Detail.
    Capture.PNG
  3. Click Customize Report
    Capture 1.PNG
  4. Filter to Bill and select Class under Column.
    Capture 2.PNG
    Capture 3.PNG
  5. Select OK.
    Capture.PNG


You might want to check this article about customizing vendor reports in QuickBooks. This helps you modify some information based on your business needs.


If you want the same settings or customization to be available for future use, you can create memorized reports. QuickBooks will let you save it, so you do not have to go through the customization process again.


We’ll be here whenever you need help. Just visit us here, and I’ll make sure it will be taken care of. Keep safe.

View solution in original post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up