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

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

I've created some subclasses that roll up to a "total" class. When I run the P&L, the report shows all classes along with the rolled up total, which is too many columns to see in a report. Is there a way to run a report showing just the rolled up class columns? Thanks!

13 Comments 13
AileneA
QuickBooks Team

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Let me help you change the columns on the P & L report, superjack1. 

 

We can modify the P & L report and customize the filter section and select the parent class, not the sublevel. Once you have the perfect set of filters, it will save them automatically in the report. Here's how:  

 

 

  1. Go to Reports.  
  2. Search the P & L report in the search bar. 
  3. Tap the Customize button.
  4. Under Filter, choose the class drop-down menu and select the parent class.  

 

 

Also, you can save this report to keep a hard copy for future use. 

 

I'm still ready to answer any questions you may have with reports in QuickBooks. Just click the Reply button and I'll get back to you as quickly as I can.

superjack1
Level 1

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Hi AileneA!

 

When I select a parent class in the report filter, the resulting report still shows all child classes. See attached for the filter I used. Is there something else I should be doing?

 

Thanks!

RCV
QuickBooks Team
QuickBooks Team

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Thanks for coming back, superjack1.

 

I appreciate you for performing the recommended steps provided by my colleague. In this case, we can run the Profit and Loss by Class report to show the parent class or the classes you want. Let me show you how:

 

  1. Go to Reports on the left menu.
  2. Enter Profit and Loss by Class in the search field.
  3. Click the Customize button.
  4. Under Filter, choose Class.
  5. Tap the Class drop-down and choose the parent's class or classes.
  6. Press Run report

 

Here's an article you can refer to for more details about running reports by class. If the same thing happens, it's possible the browser's cache data is full of frequent access to web pages or is damaged. When this happens, it causes odd behavior when running the report by class. 

 

To better isolate this issue, let's sign in to QuickBooks Online (QBO) using a private or incognito window. This helps us confirm browser-related issues since this mode doesn't use the existing cache data. Let me show you how:

 

  • For Google Chrome browser: Ctrl + Shift + N
  • For Mozilla Firefox browser: Ctrl + Shift + P
  • For Safari browser: Command + Option + P

 

Then, try running the report again. If it works, go back to your regular browser and clear the cache to delete those temporarily stored files and browsing history. Removing this should fix the issue since the overtime collection of data can create corruption. We can also use supported, up-to-date browsers to roll out the possibility of a browser-related issue. 

 

Feel free to visit our Reports page for more insights about managing your company's financial reports. 

 

I'd be happy to hear any updates after performing the steps as I want to ensure this is resolved for you. Also if you have questions about exporting reports, please add a reply below. Take care always. 

superjack1
Level 1

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Hello!

 

I tried the incognito window, and I tried to have a coworker follow the same directions, so it's not my computer. The attached picture shows the resulting headers when I select the parent "G&A" Account. Why does it show both the parent account and the "total" account? My coworker and I were hoping to see just the child accounts rolled up to the parent account, with just the parent account listed.

 

Thanks again!

ZackE
Moderator

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Thanks for following up with the Community, superjack1. I appreciate you providing a screenshot of what you're seeing.

 

You can customize your report to only display classes that you'd prefer to see on it.

 

Here's how:

  1. In the left navigation, go to Reports.
  2. Enter "Profit and Loss by Class" in your Find report by name search field.
  3. Choose Profit and Loss by Class from the drop-down list.
  4. Specify a Report period and customize any other options as necessary.
  5. Click Customize.
  6. Hit your Filter option to display its section.
  7. Tick the Class checkbox, then use it's Drop-Down Menu () and pick which classes you want displayed on your report.
  8. Select Run report.

 

I've also included a few detailed resources about working with reports which may come in handy moving forward:

 

I'll be here to help if there's any questions. Have a lovely day!

superjack1
Level 1

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Hello!

 

I finally figured out how to add multiple screenshots to the actual body of text. I was trying to add them to attachments but could only add one at a time.

 

I have created the below class list to have a few "roll-up" / "parent" accounts. Note that "COGS" has sub accounts "Client Success" and "Operations". These two accounts should roll-up to COGS, and I want to run a report that shows ONLY these parent accounts.


Class List.png

 

Below is how I customized the PnL By Class report. For purposes of this example, I selected only COGS.

Customized Report.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Below is the resulting report. Note that it includes COGS, the two sub accounts, and a "Total COGS". Running the report for all Classes is far too cumbersome. Is there a way to remedy this? I've done all the steps in the prior comments.

Resulting Headers.png

 

Thanks again!

Archie_B
QuickBooks Team

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Thanks for getting back to us, superjack1.

 

My colleagues' suggestions for customizing the filter by class should work. However, if not, I recommend getting in touch with our Support Team so they can investigate and open a ticket to look into this further.

 

Here's how:

 

  1. Log in to your QuickBooks Online company.
  2. Go to Help (?).
  3. Select the Search tab, then click on Contact Us.
  4. Choose a way to connect:
  • Start a chat with a live support.
  • Get a callback from the next available support.

 

I've added this link for more details: QuickBooks Online Support.

 

I'm also adding this article for your future reference in running common custom reports in QuickBooks Online.

 

If you have any additional queries or worries, feel free to comment below. I'll be here to check. Have a great day!

Jackolla
Level 1

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

I've been trying to do this for a long time and I still cant do it. When we make recommendations, you guys have to start listening! I'm getting nowhere with QBO improvements. Please find a fix to leave out sub classes in our reports.

JamaicaA
QuickBooks Team

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Hi there, @Jackolla

 

I understand the inconvenience of going back and forth in this forum for the implementation of your recommendation. Know that we aim to serve you best by improving our QuickBooks products.

 

When running a Profit and Loss report by Class, it will show all the classes associated with the items. The option to select a specific sub-class to display the information is unavailable. You may consider sending a suggestion again to trigger this idea. Rest assured that they will review the feedback and consider it for future updates depending on the number of users' requests.

 

Here's how:

 

  1. Go to the Gear icon.
  2. Under the Profile column, select Feedback.
  3. Share your suggestion, then click Next.

 

Visit this website to track your suggestions. Our blog will also update you with recent events and developments.

 

To learn more about utilizing classes in the program, check out these guides:

 

 

These resources will guide you through personalizing reports and saving their current customization:

 

 

These instructions should help you submit feedback regarding the product limitation of the Profit and Loss report by class. I can provide what else you can do with this report. Just post an additional comment here.

Christina2024
Level 1

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Thank you for the info on how to run the report for different classes. My problem is the Header of the P&L of the individual class does not have the class info, actually there is no place showing the Class info in the P&L. This makes me very hard to tell which class the report is for when I run P&L report for each of the 10 classes. Could you please advise how I can make the Class name shown on the report? 

AileneA
QuickBooks Team

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Hello, Christina2024. 

 

I understand the importance of having the option to view the information in the header of the report of individual classes when running a P&L report. Unfortunately, this feature is not available in QuickBooks Online. Our team is continuously working towards improving our services and adding more features for our users. Please share your Feedback with our Product Engineering team, which will help us enhance our products and services. Your valuable Feedback is highly appreciated.
 

To submit Feedback for QuickBooks Online, here's how: 

 

  1. Go to the Gear icon and select Feedback.
  2. Provide your product suggestion.
  3. Click on Next to submit Feedback.
      

I recommend utilizing our website's tracking system to ensure your suggestions are correctly tracked. By doing so, you can easily monitor the status of your suggestions and receive updates on any progress or changes made.

 

On the other hand, I'm adding this material for more tips about personalizing your reports: Customize reports in QuickBooks Online.

 

Your patience is highly appreciated as we work to enhance our functionalities. Thank you, and have a great day!

aspiess
Level 1

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

I am trying to run. budget vs actual but have many classes. One that has no sub-classes, one that has 10 sub-classes. I want to run the report to show just the two parent classes.

 

When I select just the class I want (and not all the sub-classes), all the sub-classes still shows up on the report.

 

How can I create a report with just the two classes?

ZackE
Moderator

Is there a way to customize the P&L report to show Class at the roll up level, not the sublevel?

Thanks for joining this thread, aspiess. I appreciate your detailed information.

 

You should be able to run a report for only parent classes and exclude their sub-class data. Initially, you'll need to create a new budget and subdivide it by classes, if you haven't yet.

 

Here's how:
 

  1. Use the Gear icon, go to Budgeting, then click Create budget.
  2. For your Budget format, choose Subdivided.
  3. From the Subdivide by drop-down list, pick Class.
  4. Fill out the rest of your options and hit Next.
  5. Enter any other necessary details, then select Save.

    classes.gif

 

After creating the appropriate budget, you'll be able to pull it up its Budget vs. Actuals report, then customize it to filter by your relevant parent classes:
 

  1. From the Budget vs. Actuals report, click Customize.
  2. Expand your Filter section and tick the Class checkbox.
  3. Specify which class(es) you want to filter by.
  4. Select Run report.

    BvAreport.gif

 

I've also included a couple detailed resources about working with budgets and classes which may come in handy moving forward: 
 

 

Please don't hesitate to send a reply if there's any additional questions. Have an awesome Wednesday!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us