Let me share additional context on how P&L report works, @shirley-soh.
By default, the Profit and Loss report displays all the main and sub-classes. Currently, there isn't a way to remove the sub-class columns. You can continue exporting to Excel and editing outside of QuickBooks Online (QBO) as a workaround in the meantime.
I encourage submitting a feature request through QBO's Feedback section to help improve the software and better meet your business needs. Let me show you how.
- Select the Gear icon at the top.
- Click on Feedback.
- Enter your comments or product suggestions. Then select Next to submit feedback.
I'll add this article as a guide for running a customized report in the future: Memorize reports in QuickBooks Online.
If you need any help running financial reports in QuickBooks, please let us know. We're always here.