cancel
Showing results for 
Search instead for 
Did you mean: 
2robertc
Level 4

Removing Totals for P&L BY CLASS Report

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

Solved
Best answer February 03, 2020

Best Answers
Mark_R
QuickBooks Team

Removing Totals for P&L BY CLASS Report

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:

 

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

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

4 Comments 4
Kendra H
QuickBooks Team

Removing Totals for P&L BY CLASS Report

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:

  1. Click on the Reports option on the left menu.
  2. Open the Profit and Loss by Class report.
  3. At the top of your report, use the basic filters to adjust things like report dates.
  4. 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
Level 4

Removing Totals for P&L BY CLASS Report

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

Mark_R
QuickBooks Team

Removing Totals for P&L BY CLASS Report

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:

 

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

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
Level 4

Removing Totals for P&L BY CLASS Report

Thanks for the suggestion.

Need to get in touch?

Contact us