Classes displaying empty (or null) value in bank and credit card reports

Anonymous · ‎May 18, 2020

this is for Quickbooks Desktop Pro 2020 on Windows 10

When I run a report a report for either a bank account or a credit card to display all transactions AND I customize it to ADD the Class field / column, the report works as expected EXCEPT almost every row show the Class field as blank or empty (when they do indeed have a value).

I really need this function to work as expected?

What is the solution and why is the report displaying incorrectly?

Many thanks in advance.

JamesDuanT · ‎May 18, 2020

Hello Roberto Verde,

There are a few things a want to clarify so we can get to the bottom of your concern. What specific report did you pull up and customize? Each report has their own corresponding ways of pulling up data. It depends on the sour of the information such as the fields, columns, or items.

If you pull up the Account QuickReport of a bank account, it should display the classes as long as it is also assigned to the transactions. You can open the transactions on the report you pull up and review if there are classes assigned.

If you're referring to something else, additional details such as screenshots and the name of the reports would be much appreciated.

Anonymous · ‎May 18, 2020

Hi James –

Please review the 45 second video that shows the issue – you can watch the video at this Droplr URL: https://d.pr/v/kQO9Qk)

Let me know if that helps clarify the issue.

R

Anonymous · ‎May 19, 2020

HI James –

This is my second reply – I have sent you a short 45 second video that shows the Quick Report function not displaying the class.

Any help you can provide would be much appreciated.

Catherine_B · ‎May 19, 2020

I do appreciate the video you've attached, Roberto Verde.

The QuickReport will show you the list of transactions. Thus, it doesn't list what's within the transaction line item. If your class tracking is added to each line item, it won't show up. But if your class are added 1 class per transaction, the class will display on the report.

If you still get the same thing after entering the class as a whole transaction and not on the line item, we can verify and rebuild your data. This reference will walk you through it: Verify and Rebuild Data in QuickBooks Desktop.

You can check out these articles on how to customize more on your company and financial reports.

I'm here if you need anything else. Take care!

Anonymous · ‎May 19, 2020

Catherine,

How do I add a class to a check or a credit card entry without doing it the way shown in the video?

Best,

R

Anonymous · ‎May 19, 2020

Hi Catherine,

I have tried creating test check and credit card entries and see no other way to assign a class except at the line item level (there is no other place to assign an account either).

Am I missing something? Is there a way to assign a class and account to the entire transaction? At this point I have the QBD preferences set to require a class for each entry.

Please advise.

R

RenjolynC · ‎May 19, 2020

Thanks for getting back to us, R.

Assigning a class to an entire check or bill is currently unavailable in QuickBooks Pro. You will need to select the class on each line item when creating the transaction.

You'll want to run a Transaction Detail by Account to see the classes by following these steps:

Go to Reports > Accountant & Taxes > Transaction Detail by Account.
Choose the Date you want to view.
Click the Customize Report button and search for Class in the Column field.
Select Class and click OK.

You might also want to upgrade your subscription if you’d like to take advantage of this feature. Go to this link for more details: https://quickbooks.intuit.com/desktop/

Please feel free to add a comment if you have any additional questions or other concerns. Take care and stay safe.

Anonymous · ‎May 19, 2020

What will upgrading my version of Quickbooks do?

And how does it relate to this issue?

thanks!

GlinetteC · ‎May 19, 2020

Hi Roberto Verde.

Let me provide you additional insights about using the class tracking feature in QuickBooks Desktop. You have the option to assign a class to Accounts, Items, and Names in QBDT depending on your preferences. Here's how:

From the Edit menu, choose Preferences on the drop-down.
Select Accounting from the left pane, then choose Company Preferences tab.
Under the CLASS section, put a checkmark to Use class tracking for transaction.
Check the box beside Assign classes to, and then select on the drop-down menu.
Click OK.

For more details, you can check out this article: How to use class tracking in QuickBooks.

You can also read this link on how to filter, sort, or total reports by class in QBDT for reference.

As for upgrading QBDT, you'll have the option to add classes by batch if you're using the QuickBooks Desktop Accountant and QuickBooks Desktop Enterprise Solutions versions.

Feel free to tag me in a comment below if you need anything else.

Anonymous · ‎May 25, 2020

These are the options that I have in Quickbooks Desktop Pro 2020 (see screenshot below):

I find you post helpful, but something feels amiss. Why is this basic concept of classes essentially "crippled" in the pro version? What I am trying to do seems like the "most basic" use case of classes and yet it is essentially unsupported.

I am relatively new to the product and perhaps there is an alternate solution to run reports where it will:

always display the class name next to "non-split" entries (bonus if it can handle splits) AND
use class as a filter to only show totals for Accounts based on on the class

If I cannot do this easily, and it requires purchasing a more expensive version, then something seems really wrong. I am a one man-shop running a small family business. I would really expect the product to let me use classes in a "straight forward" manner that did not require an up-sell to a version primarily used by accountants, dedicated CFO-types or accounting departments.

Please advise.

Many thanks again for your detailed reply.

RenjolynC · ‎May 25, 2020

Hello again, Roberto Verde.

While we're unable to show the class on a split transaction in the Account QuickReport, you'll want to export the data to Excel. Then, manually edit the information.

Here's how:

Go to Lists > Chart of Accounts.
Right-click on the account you want to view, and select QuickReport.
Click the Customize Report button and add the Class column.
Choose the Date and select the Excel drop-down located at the top.
Select Create New Worksheet.
In the Send Report to Excel, select Create new worksheet or Create a comma separated values (.csv) file.
Hit the Export button.

I've got this article for reference: Export reports as Excel workbooks in QuickBooks Desktop.

You can also memorize a report by following the instructions in this link: Create, access and modify memorized reports

If you have more questions or other concerns, please let us know and we will get back to you the soonest. Thanks.

Anonymous · ‎May 27, 2020

Hi and thanks again for the replies.

I sorta feel that even though I am getting some great responses, I am not really getting an answer.

My thoughts are as follows:

QB Desktop Pro 2020 supports classes out of the box
In the Preferences, there is an ability to make classes "required" during data entry and to have the program "nag" you not to forget
I "departed" using a spreadsheet solution of the past 25 years to use QB Desktop to not have to hack my way to solutions
Since QB Desktop is built on top of relational database and has a built in reporting suite, I just expected things to "work out of the box"

Which really leads me to complete frustration when I ask the following and can't get a clear answer from the Intuit folks:

since the data is all in a relational database, how hard is it to just have this work since (A) the quick report function (for any account) allows you to add the class category?
if this does work on some versions of QB Desktop, why not all versions?
if I don't want to export data and just use the reporting suite built in, what can I do to (A) find transactions that are missing classes, (B) do totals of accounts but only the part of an account that belong to a specific class and (C) why does the class function appear to be so software crippled AND is what is the point of including it and have the preference pane function to make it required if the "most basic" reports can not take advantage of it?

I do want to stress that I really appreciate all the people's time who have responded. I guess I am just shocked that this simple use case has gotten responses like (A) buy a more expensive version of the software and (B) use another tool to do more work (when the existing tool has a built in reporting suite). IMHO, this points to a problem and it would be great if this could be directed to the product and enhancement team at Intuit!

Best,

R

DianeDew · ‎June 25, 2020

(I typed in my whole reply and signed in but I don't see my reply. Forgive me if it shows up twice.)

I am having the exact same issue. We uses classes for everything and I'm used to being able to see it on transaction reports.

Roberto - I did discover a workaround that seems to give me what I need. Run the report Transaction Detail by Account (under Accountant). Then add 2 filters:

1. Transaction Type = Credit Card

2. Account = Expense & Other Expense Accounts

The classes show up on the expense transactions. I hope this is helpful to you.

Anonymous · ‎September 01, 2020

@DianeDew

This seems to be a GREAT work around! Thx for posting.

Just wish the Intuit team could figure this stuff out instead of sending me on wild goose chases or trying to up-sell me to products I don't need.

aaag · ‎March 04, 2021

Man! and it does not work with one credit card account; you have to do then all, sort them out copy and paste into another spreadsheet then sort by class and total up. Thanks for asking and keeping it up until you got what seems to be as good of an answer as there is.

Topics

Training

Community

Resources

Classes displaying empty (or null) value in bank and credit card reports