Reports export to excel flat with no grouping

Hello there, Mary. The Group by option can only be shown on reports that can be grouped, such as Detail reports. For example, a balance sheet and Profit and loss (P&L) statements are already organized into sections because they summarize data by accounts.

Please know that the Group by option is specifically available for Transaction Detail account reports. These reports are designed to display transaction data at the line-item level, allowing for complex, multi-layered grouping that summary reports cannot provide.

For more information, you can check out this article: Customize your reports with a modern view.

Please let us know if you require any additional assistance with this matter. We'll be around to help. 

Thanks for the response. Although the grouping on reports (P&L, Balance Sheet) that were exported to excel was available with in QBO, it was also a feature of reports that were exported to Excel. The grouping on exported reports is no longer an option as it had been in previous periods, periods as recent as March 2026. This seems to be a casualty of reporting change to "Modern" reporting. 

I have reached out to support of multiple occasions, and the agents, including advanced agent support, are unaware or unable to provide a solution or timeline if the grouping will be restored. 

I have implemented manual workarounds in order to preserve the consistency of reporting structure to my Board of Directors. It is frustrating that there is now a need to allocate precious time to manual formatting tasks because of developer changes to the product. 

@Mary Carter CMA I can certainly see how much extra work this manual reformatting adds to your plate, especially when you need to keep things consistent for your Board of Directors. Our goal is to make sure your reporting is efficient, and it’s clear the current flat data export is getting in the way of that.

I’ve shared your case with our Next Level Help team to ensure this gets the specialized attention it deserves. They’ll be digging into your QuickBooks support history and your comments here in the Community to get the full picture of what’s happening with your account groupings. You can expect one of our experts to reach out to you within 1-2 business days to discuss the next steps.