Is there a way to run Profit and Loss reports which only reflect the totals for each category, not to include each sub-account, but reflecting the amounts in totals?

finance@stchrisn · ‎September 13, 2021

I am trying to issue condensed financial statements, without detailing each income and expense item. I feel there should be a simple way to do this. Exporting and modifying in Excel is not the solution.

JenoP · ‎September 13, 2021

I'd be glad to help with your question about running reports, finance@stchrisn.

You can use the collapse feature to hide the sub-totals in the report but still show the correct totals of each category. Here's how:

Go back to your Profit and Loss report.
Go to the left side of each parent account, then click the drop-down or collapse arrow to collapse the section.

Please take note that this will only hide the sub-accounts in the report. The amounts are still part of the parent accounts. You'll need to export it to Excel if you want to completely remove them.

Let me also share these articles that you can use as additional guide and reference when running reports in QBO:

Don't hesitate to ask more questions if ever you need more help with QuickBooks. We'll make sure everything is sorted out.

View solution in original post

JenoP · ‎September 13, 2021

I'd be glad to help with your question about running reports, finance@stchrisn.

You can use the collapse feature to hide the sub-totals in the report but still show the correct totals of each category. Here's how:

Go back to your Profit and Loss report.
Go to the left side of each parent account, then click the drop-down or collapse arrow to collapse the section.

Please take note that this will only hide the sub-accounts in the report. The amounts are still part of the parent accounts. You'll need to export it to Excel if you want to completely remove them.

Let me also share these articles that you can use as additional guide and reference when running reports in QBO:

Don't hesitate to ask more questions if ever you need more help with QuickBooks. We'll make sure everything is sorted out.

JenoP · ‎September 14, 2021

Hi finance@stchrisn,

Hope you’re doing great. I wanted to see how everything is going about customizing your Profit and Loss report. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

Looking forward to your reply. Have a pleasant day ahead!

finance@stchrisn · ‎September 15, 2021

Thanks Jeno! Sorry I didn't get your message until this morning. Yes it works great! Saved me much time and concern. I know there is so much to learn about QB, not enough time to learn it all. I tend to learn as I go, such as this. I appreciate you.

Jim

Yannicw · ‎October 28, 2022

Is there a way to save these settings, in a management report? It seems like it goes back to the default when I tun the management report.

Angelyn_T · ‎October 28, 2022

Hi, @Yannicw. Let me share insights about customizing reports in QuickBooks Online (QBO).

I understand that you need to save the current settings for Management reports. At this time, the system will allow you to save the current settings of your Standard reports only. Despite that, I want you to know that our developers are working nonstop to enhance QuickBooks and deliver the best experiences for all QuickBooks users.

For now, I'd suggest sharing this idea with our product developer team. This way, they'll know how useful this feature is for your business and consider this in future updates.

Here's how:

Sign in to your QBO account.
Go to the Gear icon at the top, then Feedback.
Enter your comments or product suggestions.
Hit Next.

Once done, your valuable suggestion goes to our designated team to help improve your QBO experience. You can track your requests through the QuickBooks Online Feature Requests website.

To learn more about running basic reports in QBO, open this article: Run reports in QuickBooks Online. You also have the option to use them outside of QuickBooks by exporting them to Excel.

If you have other questions about your reports, add a comment below. I'm more than happy to help. Keep safe!

Topics

Training

Community

Resources

Is there a way to run Profit and Loss reports which only reflect the totals for each category, not to include each sub-account, but reflecting the amounts in totals?