cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Explorer *

Custom P&L: how can I show only the "parent account" full total? If I don't select the sub-accounts too, then nothing shows in the P&L. I know this can be done in desktop

I see that someone else had a question about how to list the sub-account activity totals in a footnote, so it appears they were able to run a P&L with ONLY "parent accounts" showing on the report. This makes a nice streamlined report for management with clutter of all the sub-accounts showing on the page. But if I only select the "parent" account -- nothing shows on the P&L at all--in other words, that parent account isn't a true total of its sub-accounts, it's just a name

Solved
Best answer 10-19-2018

Accepted Solutions
Not applicable

Hi evelynsov, We have good news for you! Since the QuickB...

Hi evelynsov,

We have good news for you!

Since the QuickBooks Online v1602 update, we now have Redesigned Reports. Just turn it on and you'll experience a new and easier navigation of the reports including the ability to Collapse or Expand. You will be able to expand parent accounts showing the totals for all the sub-accounts.

To turn on Redesigned Reports: 

  1. Go to the Gear icon in the upper right corner.
  2. Click QuickBooks Labs under Settings.
  3. Scroll to find Redesigned Reports. (The button to the right will show that it's Off)
  4. Click the button to turn it On(A pop-up will appear with the words "Redesigned Reports undefined activated")
  5. Click Done in the lower right corner.

When you open the Profit and Loss Report, you'll now see little triangles to the left of parent accounts' names. Click on a little triangle to collapse or expand an account group. 

Please feel free to reach out again if you have other questions. We're here to help.

View solution in original post

18 Comments
Not applicable

Hi evelynsov, We have good news for you! Since the QuickB...

Hi evelynsov,

We have good news for you!

Since the QuickBooks Online v1602 update, we now have Redesigned Reports. Just turn it on and you'll experience a new and easier navigation of the reports including the ability to Collapse or Expand. You will be able to expand parent accounts showing the totals for all the sub-accounts.

To turn on Redesigned Reports: 

  1. Go to the Gear icon in the upper right corner.
  2. Click QuickBooks Labs under Settings.
  3. Scroll to find Redesigned Reports. (The button to the right will show that it's Off)
  4. Click the button to turn it On(A pop-up will appear with the words "Redesigned Reports undefined activated")
  5. Click Done in the lower right corner.

When you open the Profit and Loss Report, you'll now see little triangles to the left of parent accounts' names. Click on a little triangle to collapse or expand an account group. 

Please feel free to reach out again if you have other questions. We're here to help.

View solution in original post

Super Explorer *

Thank you, and thank you to QBO team for adding this valu...

Thank you, and thank you to QBO team for adding this valuable feature I'm sure many will appreciate!
Not applicable

I'm so happy to hear from you @evelynsov! I'm glad this h...

I'm so happy to hear from you @evelynsov! I'm glad this helped you. Have a great weekend ahead!
Not applicable

Re: Hi evelynsov, We have good news for you! Since the QuickB...

I do not have that option on my labs menu

Content Leader

Re: Hi evelynsov, We have good news for you! Since the QuickB...

You've come to the right place, @AlySeif.

 

I have great news to share, the Redesigned Reports mentioned above are now live and available to all US QuickBooks customers. If you'd like to print or organize your Profit and Loss report so that only the parent accounts are displayed, follow these simple steps:

 

  1. From QuickBooks Online, navigate to the Reports tab.
  2. In the Business overview section, select the Profit and Loss report.
  3. Within the report, to the left of each parent account, click the Dropdown (▼) arrow to collapse the section.

I'm including a short video that shows this process:

 

 

This will make it so you can expand or collapse sections of sub-accounts at will. Once the report has the desired look, feel free to print or export as needed. Please don't hesitate to follow up with me here if there's anything else I can do to help you succeed. Thanks for coming to the Community, wishing you a wonderful week ahead.

Not applicable

Re: Hi evelynsov, We have good news for you! Since the QuickB...

This is a great feature, but is there a way to save it as a setting or do we have to collapse the categories each time. It would be really helpful if there was an option to print a P&L without subcategories without having to collapse each time. Also, when I try to download the collapsed version to Excel, it shows all categories. Is there a way to download the collapsed version to Excel without it reverting back?

Content Leader

Re: Hi evelynsov, We have good news for you! Since the QuickB...

Hi there, @whitneyericajenkins.

 

Thanks for the additional suggestions on this report matter. At this time, there's no way to save the Profit and Loss in its collapsed form or export it to Excel without them expanding again. I can see how this feature would be helpful to give you a quick summary of your company's profitability for a given period, so I'm sending a formal product request up to the Development Team. All it takes is a voice from a user like yourself to make the change in QuickBooks we all want to see.

 

In the meantime, I have a suggestion that may help you get this report in Excel format. Since the fully collapsed Profit and Loss report is bare bones with very little information, consider copying the content manually and pasting it in whichever spreadsheet software you'd like. I'll guide you through this process below:
 

  1. From QuickBooks Online, navigate to the Reports tab and select Profit and Loss under Business Overview.
  2. Within the report, to the left of each parent account, click the Dropdown (▼) arrow to collapse the section.
  3. Left-click the space to the left of the top-right account, and drag your mouse to the space right of the bottom-right amount.
  4. Once the data is highlighted, right-click it and select Copy.
  5. Open your spreadsheet software and paste the information beginning in the top-left cell of your desired range.

Here's a quick video of this export method:

 

 

All-in-all, this process may take even less time than using the Export button for such a small set of information. You can even create an Excel template to serve as a header or form for the collapsed Profit and Loss data you paste inside. Alternatively, the company/report name and dates can be copied and pasted inside the same way. Check out our guide on report exporting to learn more.

 

These tips will have you exporting the Profit and Loss to Excel like a pro in no time. Please feel free to get in touch with me here if there's anything else I can do for you. Thanks for reaching out, wishing you a safe and productive day.

 

 

Not applicable

Re: Hi evelynsov, We have good news for you! Since the QuickB...

Hi - how do I get the redesigned reports for my QBO Plus? It doesn't show up as an option in my QB Labs. I don't see where I would find the QBO v1602 update that is referenced in this email string. My problem is that not all of our sub accounts are showing under the parent account in Budget v Actuals report. The subs have the same account type as the parent. What else am I missing? I thought maybe I need the redesigned reports upgrade, but can't find them. 

Moderator

Re: Hi evelynsov, We have good news for you! Since the QuickB...

Hey there, @c-ucc.

 

Thank you for reaching out the QuickBooks Community. Let's get this straightened out so you can see your sub-accounts in your report.

 

Have you tried using a different browser? Performance issues in QuickBooks are resolved by doing basic troubleshooting steps. Let's start by opening a private browser to start a new session.

 

Here's how to open a private window in different browsers:

 

  • Google Chrome: press Ctrl + Shift + N.
  • Mozilla Firefox: press Ctrl + Shift + P.
  • Internet Explorer: press Ctrl + Shift + P.
  • Safari: press Command + Shift + N.

If you're able to see your sub-accounts using your private browser, let's go back to your regular browser and clear its cache.

 

This will get everything nice and organized in your QBO account once again. Have a great rest of your day!

Established Community Backer ***

Re: Hi evelynsov, We have good news for you! Since the QuickB...

"Since the QuickBooks Online v1602 update, we now have Redesigned Reports. Just turn it on and you'll experience a new and easier navigation of the reports including the ability to Collapse or Expand."

 

I have been using QBO for 3 years and there has always been the option to collapse or expand.

 

And what is the QuickBooks Online v1602 update? I have never seen an option to turn on an "update". It just happens by itself. Yes there is the labs section, but I would not call that an "update"

Community Contributor *

Re: Hi evelynsov, We have good news for you! Since the QuickB...

I am not able to find this in QuickBooks Labs. I logged in as both a user and as the accountant. Does it still exist? Is there another way to navigate to it?

Moderator

Re: Hi evelynsov, We have good news for you! Since the QuickB...

Hello Megan,

 

The Redesigned Reports function has been removed from QuickBooks Labs. Because this function is already live and available within your QuickBooks Online interface.

 

When you pull up your reports, you should be able to Collapse or Expand the details. You can refer to the screenshot below to see my example.

 

You can always get back to me if you need anything else.

Capture.PNG

Established Community Backer ***

Re: Hi evelynsov, We have good news for you! Since the QuickB...


@JamesDuanT wrote:

Hello Megan,

 

The Redesigned Reports function has been removed from QuickBooks Labs. Because this function is already live and available within your QuickBooks Online interface.

 

When you pull up your reports, you should be able to Collapse or Expand the details. You can refer to the screenshot below to see my example.

 

 


I have been using QBO for 3 years and there has always been the option to collapse or expand.

 

What "Redesigned Reports" are you referring to?

 

The "Redesigned Reports" version in 2018 did not implement collapse or expand.   It was just cosmetic changes (and in my opinion harder to work with, as you have to constantly scroll down)

Not applicable

Re: Hi evelynsov, We have good news for you! Since the QuickB...

I have a question about the 'parent' accounts on my profit and loss.  We have a Sales account, which shows on the profit and loss.  Then we have many sub-accounts under sales.  Is there a way to get the totals for the sub-accounts to show on the profit and loss under the income?

Thanks!

Deb

QuickBooks Team

Re: Hi evelynsov, We have good news for you! Since the QuickB...

Hello there, @deb1171.

 

I'd be glad to help share information about running the Profit and Loss report in QuickBooks Online (QBO).

 

Yes, when running the Profit and Loss report in QBO, the report will show the total amount on each accounts selected when creating transactions including the sub-accounts.

 

I've attached these screenshots for additional reference.

i1 accounts1.PNG

i1 report1.PNG

 

In addition, for more information about running and customizing the Profit and Loss report, you may check this article: How to customize your Profit and Loss report.

 

 You may also check our help articles for your reference in the future: Help articles for QBO.

 

Our doors are always open here on the Community page, stay posted if you have any other questions about reports in QBO. I'll be always here to help you!

Not applicable

It is really unfortunate the even the Advanced Version of QBO only provides an ALL or NOTHING on the Collapse functionality. At a minimum, users should be able to select from at least one other Collapse Level AND if users take the time to manually Collapse, they should be able to save as a Custom Report AND be able to Export in the Custom Report format. I see this as a MAJOR weakness of QBO, especially for what you are paying for the Advanced version of the product.


@MichaelDL wrote:

Hi there, @whitneyericajenkins.

 

Thanks for the additional suggestions on this report matter. At this time, there's no way to save the Profit and Loss in its collapsed form or export it to Excel without them expanding again. I can see how this feature would be helpful to give you a quick summary of your company's profitability for a given period, so I'm sending a formal product request up to the Development Team. All it takes is a voice from a user like yourself to make the change in QuickBooks we all want to see.

 

In the meantime, I have a suggestion that may help you get this report in Excel format. Since the fully collapsed Profit and Loss report is bare bones with very little information, consider copying the content manually and pasting it in whichever spreadsheet software you'd like. I'll guide you through this process below:
 

  1. From QuickBooks Online, navigate to the Reports tab and select Profit and Loss under Business Overview.
  2. Within the report, to the left of each parent account, click the Dropdown (▼) arrow to collapse the section.
  3. Left-click the space to the left of the top-right account, and drag your mouse to the space right of the bottom-right amount.
  4. Once the data is highlighted, right-click it and select Copy.
  5. Open your spreadsheet software and paste the information beginning in the top-left cell of your desired range.

Here's a quick video of this export method:

 

 

All-in-all, this process may take even less time than using the Export button for such a small set of information. You can even create an Excel template to serve as a header or form for the collapsed Profit and Loss data you paste inside. Alternatively, the company/report name and dates can be copied and pasted inside the same way. Check out our guide on report exporting to learn more.

 

These tips will have you exporting the Profit and Loss to Excel like a pro in no time. Please feel free to get in touch with me here if there's anything else I can do for you. Thanks for reaching out, wishing you a safe and productive day.

 

 


 

Established Member

Re: Custom P&L: how can I show only the "parent account" full total? If I don't select the sub-accounts too, then nothing shows in the P&L. I know this can be done in desktop

A related question to the new collapse question:

 

Why can't we select a collapse at any sub account level except the lowest?

If it were possible, we could selectively determine at which of the 3-4 sub account levels we want the data to appear in detail.

 

Thanks.

QuickBooks Team

Re: Custom P&L: how can I show only the "parent account" full total? If I don't select the su...

Thanks for joining this thread, RetiredLF.

 

It's a good thing that you're able to point this out. At this moment, QuickBooks Online Profit and Loss reports is designed to only have the all or nothing collapse option. In the meantime, you can make use of the suggestion 

 

I appreciate you for sharing your thoughts on how you'd like to customize this function. We are always open for suggestions that will help improve the product functions. Together with my colleague MichaelDL, allow me to pass through this suggestion to our developers for feature request.

 

For now, I encourage you to visit our QuickBooks Blog. From there, we share recent happenings and future developments and the latest news about QuickBooks and what our Product Care Team is working on.

 

You can always visit the Community page if you have questions in the future and I'd be glad to help you all the way.

Need to get in touch?

Contact us