Skip to main content

Get 50% OFF QuickBooks for 3 months*

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?
M
Mary Carter CMA
April 15, 2026
Question

Reports export to excel flat with no grouping

  • April 15, 2026
  • 3 replies
  • 34 views

Before the hard switch to the Modern Reporting, reports were exported to excel with the account grouping intact. Since the change reports only export flat with no option to update it. This has impacted the consistency of reporting across periods. Would like to know if the export with grouping will be restored. 

3 replies

J
JoelESQuickBooks Team
QuickBooks Team
April 16, 2026

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. 

M
Mary Carter CMAAuthor
April 16, 2026

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. 

cody_a
cody_aCommunity Manager
Community Manager
April 16, 2026

@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.

U
User1201
New Member
July 9, 2026

Hello - Can we please have an update to this. The auto-grouping of exported excel files for the P&L and balance sheet is absolutely needed back.

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