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

Quickbooks classes and subclasses

I must be missing something because classes and subclasses don't seem to work like I thought they would. I expected QB reporting to be able to rollup the subclass totals when reporting at the class level, but it seems to treat classes and subclasses as totally separate classifications, i.e. when I ask for a report by class, it only includes the amounts for entries that were at the class level only and not the subclass levels defined under it. If that is the case, I'm not sure what benefit subclasses provide. Insight requested and appreciated. 

17 Comments 17
Highlighted
QuickBooks Team

Quickbooks classes and subclasses

Greetings, @tinaward.

 

Allow me to provide with some information on how you can include classes and sub-classes in generating your reports.

 

With QuickBooks Desktop, you have the ability to customize and filter your reports by class and sub-class.

 

Here's  how to view your PL report by sub-class:

  1. Click Reports.
  2. Choose Company and Financial.
  3. Select he Profit & Loss by Class report.
  4. Click the green arrow to run report.
  5. Choose Customize Report.
  6. Go to the Filters tab.
    1. From the Filter list, select Class.
    2. Choose Multiple Classes.
    3. Put a check mark on the Subclasses you want in the report. 
      • Example: 1C, 2C, and 3C.
    4. Hit Ok.
  7. Click Refresh

That should do it! Please don't hesitate to click the Reply button if you have other questions about customizing your reports in QuickBooks Desktop. I'm always here to help.

Highlighted
Anonymous
Not applicable

Quickbooks classes and subclasses

Unfortunately there isn't a way to roll up classes to the parent class on reports.

Highlighted
Community Champion

Quickbooks classes and subclasses

Allow me. As long as you are not trying to filter for specific classes, where picking just the parent excludes the subs, you can and will see all classes of all levels in a P&L by Class. Every subclass across in columns followed by its parent and a separate total column for that group. I know because I have over 100 sub classes of probably a dozen top level classes. The key is....don't filter....until after you export to excel.

Highlighted
Level 15

Quickbooks classes and subclasses


@tinaward wrote:

I must be missing something because classes and subclasses don't seem to work like I thought they would. I expected QB reporting to be able to rollup the subclass totals when reporting at the class level, but it seems to treat classes and subclasses as totally separate classifications, i.e. when I ask for a report by class, it only includes the amounts for entries that were at the class level only and not the subclass levels defined under it. If that is the case, I'm not sure what benefit subclasses provide. Insight requested and appreciated. 


in desktop, go to the lists menu>class list, highlight the parent and use the report button for a quick report

 

all sub classes of that parent will report, with totals

 

In QB when you have a parent, item, account, class, you do not post to it, only post to the subs

Highlighted
Level 1

Quickbooks classes and subclasses

how do you make a balance adjustment to your subclass?  Move funds from one subclass to another.

Highlighted
Level 1

Quickbooks classes and subclasses

Following...

 

I recently realized that in attempting to create adjusting journal entries (ie reallocate expenses from one class to another, transfer funds, etc), this creates unbalanced classes on the balance sheet. Transactions created as forms (ie check, bill, bill payment etc) do not create this issue, only journal entries with multiple classes.

Highlighted
Moderator

Quickbooks classes and subclasses

Hello there, SB4207.

 

Good to see you both in the Community. Allow me to help share some insight about moving funds from one subclass to another.

 

You can transfer the balance of one subclass to another by updating the transaction to change the class used. You can use the Transaction Detail report to find and edit the transactions easily. Let me show you how: 

  1. From the Reports menu, select Custom Reports.
  2. Choose Transaction Detail.
  3. Select the correct Date.
  4. Click OK or Refresh.
  5. Double-click the transaction. 
  6. In the CLASS column, click the drop-down and select the correct subclass.  
  7. Click Save & Close.

Capture1.PNG

I've attached a blog about class for additional reference: Use Class Tracking in QuickBooks.

 

These steps should correct the balance per class in your QuickBooks.

 

Please keep in touch if you have any other questions about classes, or about QuickBooks. I'm here to lend a hand. Have a great day ahead. 

Highlighted
Level 2

Quickbooks classes and subclasses

Users should have the ability to exclude sub-classes from a report and simply see the totals for the parent class. Having the ability to do sub-class reporting is great. However, not having the ability to roll up the sub-classes in QB is a real drag. I know that i can export a report to excel and then hide the 35 sub-classes that I don't want to see but I shouldn't have to do that. During report filtering, if I choose to select multiple classes and then I select a parent class without selecting any of its sub-classes, QB reporting should be smart enough to know that i only want to display the parent class and I do not want to show the corresponding sub-class detail. What say you Intuit?
Highlighted
QuickBooks Team

Quickbooks classes and subclasses

Hello there, @toom212121.

 

I understand how this feature is useful to your business and other users. Rest assured that we've forwarded this to our product engineers so this may be considered in the future.


I'll pass this along to our product developers team to let them know of your business needs. The Feedback board is frequently reviewed by our product developers for ideas to implement in the future.

 

I have included this link in case you have  other questions about QuickBooks: Reports.

 

Don't hesitate to drop your comment below if you have any other questions. Have a nice day!

 

Highlighted
Level 2

Quickbooks classes and subclasses

 

Thanks for the quick reply but I already know how the multiple filtering currently works. I am looking for it to change.

 

You stated: "since the subclass is excluded, it won't be included in the total amount of the parent class."

 

I am asking if Intuit would be open to changing the way the program works. When selecting "multiple classes", if a parent class is selected program without any child classes then WE would all like the report to include data from the sub-class transactions but only display the parent class totals in the report. 

 

Can you at least forward the concept to development for consideration?

 

 

 

 

 

Highlighted
QuickBooks Team

Quickbooks classes and subclasses

I'll take note of your suggestion, toom212121.

 

We're always open for feedback. Intuit strives hard to make QuickBooks fit to everyone's business needs.

 

I can forward this to our developers to let them know how you'd like the filter option works.

 

You can also read this article about customizing reports in QuickBooks Desktop.

 

You know where to go if you need anything else. Have a great day!

Highlighted
Level 1

Quickbooks classes and subclasses

I have to jump in here and say that this feature in quickbooks online does not work how it should and needs to be modified.  There is zero benefit to subclasses. All engineering needs to do is run a class report in Quickbooks desktop (which works the way it should) and run a class report in quickbooks online and can see the deficiencies. I should be able to see class levels

 

Program

sub program sub program subprogram

 

This is an unfortunate error in reporting for QB online making subclasses virtually useless. 

Highlighted
Level 1

Quickbooks classes and subclasses

Is there any update on this? I'm in the same boat - utilizing quickbooks online and would like to run a statement of activity report by class, but I don't want to include all of the subclasses. I just want the report to show totals for each of the parent classes. It appears it's not pulling in any subclass information when I filter just by parent classes. What a programming miss. 

Highlighted
QuickBooks Team

Quickbooks classes and subclasses

Hello there, kmcgrady.

 

We currently don't have any updates about the report. However, the request has been submitted to our engineers.

 

Customizing the Statement of Activity by Class report to only display the parent class is the available workaround. 

 

You'll want to visit our blog by clicking on this link: https://quickbooks.intuit.com/blog/whats-new/. This is where you can see the newly added features in QuickBooks Online.  
 

I'm also including this article for more details: Reports included in your QuickBooks Online subscription.

 

Please let us know if you have any other suggestions. We're here to help you some more. 

Highlighted
Level 1

Quickbooks classes and subclasses

I, too, would like the classes to be able to expand and collapse like the income and expenses do.  We don't always need to see granular detail!  Exporting to Excel and hiding the sub-class columns appears to be the only current option.

 

Thank you for forwarding this onto the developers.

 

Dana Oxford

Highlighted
Level 1

Quickbooks classes and subclasses

There is a way which may or may not be useful:

Run the custom report, I chose summary.  Click on customize and change the display columns by to income statement, and change the display rows by column to class.  This switches the columns & rows on the format.  Now on the report select collapse and you will see your classes in rows and can click on them to see sub classes if you want and the income statement accounts are displayed across the top.  

I am using this for items that have classes assigned to them so it works as I further filtered accounts to include only sales, COS and returns.  

It's not great as when i add the qty column to the report display it wont give me the parent quantity total and I still have to click to see the sub classes totals.  

 

Hope this helps

Highlighted
Level 1

Quickbooks classes and subclasses

Just to let everyone know. I use QB 2012 and the class subclass problem was there at that time!. Hey Intuit, it shouldn't take this long to make a simple change like this. Allow a report  by major class,by checking the class, not subclass . Sue

Need to get in touch?

Contact us