Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
2robertc
February 3, 2020
Solved

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

Mark_RAnswer
Moderator
February 3, 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:

 

  1. In your QuickBooks Desktop, go to the Reports menu.
  2. Select Company & Financial, then choose Profit and Loss by Class.
  3. In the report, click the Excel drop-down, then select Create New Worksheet.
  4. In the Send Report to Excel window, click Export.
  5. In your MS Excel, highlight the Total column.
  6. 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 in thread

4 replies

Kendra H
February 3, 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:

  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!

 

 

 

 

 

 

 

2robertcAuthor
February 3, 2020

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

Mark_RModeratorAnswer
Moderator
February 3, 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:

 

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

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement