Removing Totals for P&L BY CLASS Report

2robertc · ‎February 03, 2020

Hi- Is there any way to remove the Totals column in between each of my classes on the P&L BY CLASS Report?

Thanks,

Rob

Mark_R · ‎February 03, 2020

I appreciate you getting back to us, @2robertc.

Removing the Total column in the Profit and Loss by Class report is not possible. But I've got a workaround for you that you may consider.

You can export the report to MS Excel and remove the total column from there. Here's how:

In your QuickBooks Desktop, go to the Reports menu.
Select Company & Financial, then choose Profit and Loss by Class.
In the report, click the Excel drop-down, then select Create New Worksheet.
In the Send Report to Excel window, click Export.
In your MS Excel, highlight the Total column.
Right-click and select Delete.

Here's an article you can read for more details: Export reports as Excel workbooks in QuickBooks Desktop.

You might also want to check out this article to learn more about how to customize reports in QuickBooks Desktop.

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day!

View solution in original post

Kendra H · ‎February 03, 2020

Hi there, @2robertc.

I'd be glad to assist you with customizing your Total column on the Profit and Loss by Class report.

At this time, QuickBooks Online doesn't offer this feature. I'm going to submit feedback to our Product Development Team for them to review and consider soon.

For now, there is a Customize option on your reports that you can use that edits your number format, which accounts appear, and also the header and footer.

Here's how:

Click on the Reports option on the left menu.
Open the Profit and Loss by Class report.
At the top of your report, use the basic filters to adjust things like report dates.
Select Customize to open the customization page for your report.

When you're ready to apply those filters, click on Run Report.

You can also follow our Firm of the Future web page to receive QuickBooks product updates as well.

If you have any more QuickBooks questions, please don't hesitate to reach back out. Happy Monday!

2robertc · ‎February 03, 2020

Hi Kendra- I use QB Desktop. Is the feature available in QB Desktop?

Mark_R · ‎February 03, 2020

I appreciate you getting back to us, @2robertc.

Removing the Total column in the Profit and Loss by Class report is not possible. But I've got a workaround for you that you may consider.

You can export the report to MS Excel and remove the total column from there. Here's how:

In your QuickBooks Desktop, go to the Reports menu.
Select Company & Financial, then choose Profit and Loss by Class.
In the report, click the Excel drop-down, then select Create New Worksheet.
In the Send Report to Excel window, click Export.
In your MS Excel, highlight the Total column.
Right-click and select Delete.

Here's an article you can read for more details: Export reports as Excel workbooks in QuickBooks Desktop.

You might also want to check out this article to learn more about how to customize reports in QuickBooks Desktop.

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day!

2robertc · ‎February 03, 2020

Thanks for the suggestion.

Topics

Training

Community

Resources

Removing Totals for P&L BY CLASS Report