Skip to main content
L
LaurieDeCarlo
February 10, 2021
Solved

Class field is blank, but it isn't

  • February 10, 2021
  • 4 replies
  • 0 views

I am using the CLASS field to categorize transactions in Quickbooks Desktop 2021.  When I generate a Transaction Detail report, filtering (and sorting) by class, almost half of the report shows empty (blank) class fields (they are not class specific - it's any class).  They are categorized at the end as Unclassified.  If I then look at each individual record that shows a blank class field, I verify that the field is NOT blank.  Can anyone explain why this is happening?  I'm completely stumped.

    Best answer by RenjolynC

    Thanks for coming back here, LaurieDeCarlo.

     

    The screenshot above looks a little different on the Class section because that option is only available on QuickBooks Desktop Enterprise. With regard to your current situation, we can perform the Verify and Rebuild Data since your report shows empty classes. You might have a damaged company file and this will help fix the issue.

     

    Before doing so, please make sure to update your QuickBooks Desktop to the latest release. Then, back up your QuickBooks Desktop company file.

     

    Once done, follow the instructions in this article: Verify and Rebuild Data in QuickBooks Desktop.

     

    Please let me know how it goes on your end. I'm determined to get this fixed for you. 

    4 replies

    R
    Rea_M
    February 10, 2021

    Hello there, @LaurieDeCarlo.

     

    The class data that'll be displayed on the Transaction Detail report will depend on how you set up your company preferences. You have the option to assign a class to Accounts, Items, and Names in QuickBooks Desktop (QBDT). With this, let's check your class tracking preferences. This way, you're able to identify why some transactions show empty class fields on the report.

    1. Go to the Edit menu.
    2. Choose Preferences.
    3. Select Accounting from the left menu.
    4. Choose the Company Preferences tab.
    5. Under the CLASS section, put a checkmark to Use class tracking for transaction.
    6. Check the box beside Assign classes to, and then select options (Accounts, Item, or Names) you'll be assigning class into your reports.

     

    I've attached a screenshot below that shows the last four steps.

     

    To learn more about this, you can refer to this article: How to use class tracking in QuickBooks.

     

    Also, here's an article that'll further guide you in filtering and sorting class transactions through reports by class in QBDT: Categorize data by class. It includes topics about unclassified transactions and reports showing subclasses only, to name a few.

     

    Let me know in the comments below if you have other concerns about customizing reports and managing class transactions in QBDT. I'm just around to help. Take care always.

    L
    LaurieDeCarloAuthor
    February 10, 2021

    Hi Rea, thanks so much for your response.  I set up classes when i configured my company file in QB. I have attached a screenshot here.  Mine looks a little different than yours in that I don't get to choose where to assign classes.   I'm completely stumped and don't know where to go next.  Any help is appreciated!

    Thank you!

    RenjolynC
    RenjolynCAnswer
    February 10, 2021

    Thanks for coming back here, LaurieDeCarlo.

     

    The screenshot above looks a little different on the Class section because that option is only available on QuickBooks Desktop Enterprise. With regard to your current situation, we can perform the Verify and Rebuild Data since your report shows empty classes. You might have a damaged company file and this will help fix the issue.

     

    Before doing so, please make sure to update your QuickBooks Desktop to the latest release. Then, back up your QuickBooks Desktop company file.

     

    Once done, follow the instructions in this article: Verify and Rebuild Data in QuickBooks Desktop.

     

    Please let me know how it goes on your end. I'm determined to get this fixed for you. 

    J
    jnichol
    May 2, 2022

    We have had the same problem for years and nobody has been able to help us. For example, If i am viewing a credit card account. More than half the transactions have a blank class field when I pull a report. However, we have classes turned on and require a class for each transaction, we audit it monthly so I know for certain each transaction does in face have a class. When you click into a transaction you can see the class is there, it just doesn't show on reports. It's a real pain in the....

    Ann_McD
    Ann_McD
    June 23, 2022

    I am using an item list in a current asset account to track purchases for a real estate flip (i'll move the total over to COGS after the sale). If I run a general ledger report or pretty much any transaction report, the class field is blank even though it's populated in the transactions. I can see class if I run a purchases by item detail, but that doesn't help me for expenses that are not from the item list. I also tried categorizing using Customer:Job, but my item purchases don't show at all under Customer:Job - I'm assuming it's because I'm using an asset account. 

     

    All I want to do is have some way to categorize transactions, whether expense or item list purchase, by property. My item list contains about 70 items so I don't want to create subaccounts for each property. Can anybody help?

    AlcaeusF
    AlcaeusF
    June 23, 2022

    Hi @Ann_McD,

     

    Thank you for taking the time to reach out to us here in the Community about running reports. I can provide clarification about the class field showing blank information in QuickBooks Desktop.

     

    The reports in the program display data based on a set of instructions called Report Set. The information shown on reports will depend on the source (source account, source name, source memo and source amount, etc.) and target (target accounts, target names, target memos, target amounts, etc.).

     

    Since a class or location tracks the transaction, It does not report where or how the transactions originated. The source will not be reportable.

     

    I have an article here that'll help you generate reports and at the same time maximize the report filters. For more information and available reports, you can visit this link: Understand reports.

     

    You can also take your reports out of QuickBooks to customize data further. I've attached an article you can use as a guide to the process in QuickBooks: Export reports as Excel workbooks in QuickBooks Desktop.

     

    I'm always available whenever you need further assistance with running reports in the Desktop version. Let me know by clicking the Reply option below. Take care.

    R
    Rgrinberger
    November 9, 2022

    I found two ways to work around this. In my case I was trying to get report of credit card account transactions with class:

    1. You can run a report in 2 parts: Open find and choose the following filters:

              Account: AmEx 71000 include split detail yes

              Date filter if needed

              Detail level all except summary

    Click find and then report. This report will include all credit card charge transactions but will not include check payments to the credit card. Also, because you are only seeing the split of each transaction, the debits and credits are reversed.

    Change filter on find to include split detail no

    Click find and then report. This report will show all check payments to the credit card. You can combine these two report to get all activity on the card


    2. If you run the balance sheet by class report, you can look for this credit card account and see a balance of all transactions for each class. If you double click you can see all the transactions for each class. 

    Terms & ConditionsAccessibility statement