Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Group accounts on reports in Microsoft Excel with Auto Outline

The Collapse/Expand button on summary reports such as the Balance Sheet Report only collapses sub-accounts under a parent account. More flexibility can be obtained by Exporting the Report to Microsoft Excel with the advanced feature, Auto Outline. Once the report is exported to Excel with Auto Outline chosen, Entire sections of the report may be selectively collapsed/expanded.

Note: Also referred to as rolling up accounts or roll up accounts.

Detailed instructions
  1. Run a Standard Balance Sheet report by choosing Company & Financial from the Reports menu, then choose Balance Sheet Standard.
  2. Click the Export button at the top of the report.
  3. Click on the Advanced tab.
    Note: For QuickBooks 2014 and later, click Excel button at the top and choose the required option and click on Advanced button
  4. Select Auto Outline (allows collapsing and expanding)
  5. Click the Export button.
  6. Use the Plus and Minus buttons to the left of the worksheet to selectively collapse and expand accounts.
  7. Alternatively, you may also click the Level buttons above the outlining section to collapse or expand all accounts at that outline level.
  Collapse or Expand Selectively Collapse or Expand by Level
KB ID# HOW13347
10/23/2016 10:56:23 AM
QYPPRDQBKSWS07 9138 Pro 2017 e9f306