How to Collapse/Expand Reports in QuickBooks

Every version of QuickBooks software comes well-endowed with pre-set reports.  But better still, are the tools that allow the user to easily customize these basic reports to suit their individual needs.



For example, call up a standard Profit & Loss Statement.  As you will see, each account with activity in the period is listed individually.  Now, while this format may be preferred by accountants, it could be an overwhelming amount of detail for a high level review with management.

By using the Collapse and Expand button located on the report toolbar, the data can easily be reduced to a summary presentation listing only subtotal accounts.  From this view, it is more obvious which areas have the largest impact on results and bear closer scrutiny.  Once you have identified a subtotal to address, simply press Expand to reveal the underlying accounts.  When your discussion has concluded, Collapse again to move on to the next area for review.

Looking For More?


Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 260-5250 or
find out more here.


When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting


When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics