Solved

Missing Class on Vendor Reports

Forum|Forum|5 years ago
October 9, 2020
1 reply
0 views

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?

QuickBooks Desktop

Best answer by MadelynC

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:

Go to the Reports menu, then Custom Reports.
Select Transaction Detail.
Click Customize Report
Filter to Bill and select Class under Column.
Select OK.

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.

N

Nick_M

Level 4

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.

K

kssimonAuthor

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.

M

MadelynC

Answer

Moderator

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:

Go to the Reports menu, then Custom Reports.
Select Transaction Detail.
Click Customize Report
Filter to Bill and select Class under Column.
Select OK.

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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded