Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

The Condense data utility

CAUTION: If you are having performance issues, the Condense Data Utility is your last option to try to improve performance. Before you condense:

  1. Troubleshoot for performance.
  2. Troubleshoot for data damage.

NOTE: In QuickBooks 2005 and earlier versions, this utility was named Condense Data. In QuickBooks versions 2006 through 2011, it was named Clean Up Company Data. In QuickBooks 2012 and later versions, the name has been changed back to Condense Data. In this article, we will refer to it only as Condense or as Condense Data.

The Condense Data utility stream lines your company data file by condensing closed transactions into summary journal entries and removing unused list elements. The utility can create a journal entry for each month in the selected period. The summary journal entries affect your accounts in exactly the same way as did the detail transactions.

How to fix

 Let's be clear about one thing: the Condense Utility will not condense all files.


Reports will be incomplete or incorrect






Running the Condense



After the Condense



If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.

KB ID# HOW12161
4/24/2014 8:16:29 AM
QYPPRDQBKSWS06 9102 Pro 2013 757299