QuickBooks Desktop 2016: Condensing a Large Company File
Learn how to safely condense your QuickBooks Desktop 2016 company file to improve performance. Understand the risks, backup requirements, and alternatives
QuickBooks Desktop 2016 officially reached the end of Intuit's live support and services in May 2019. If you are still running this version, you already know that keeping your company file lean is critical for maintaining day-to-day performance without the option of live technical support. Condensing your data file is one method for managing size, but it is a major maintenance step that requires careful preparation.
What Condensing Actually Does
The condense utility in QuickBooks Desktop 2016 removes unused list items (like old vendors or accounts) and summarizes old, cleared transactions into single monthly journal entries. The primary goal is to shrink the overall file size, which can help prevent performance lag, crashing, or data integrity issues as the file grows.
It is important to understand that condensing is largely an irreversible process. Once those detailed transactions are summarized and removed, you cannot drill down into the individual checks or invoices from past years. Because of this finality, you must approach this tool with caution.
The Mandatory Pre-Condense Archive
Because the condense process permanently alters your historical data, you must create a full archive backup before proceeding.
- Go to File, then select Back Up Company, and choose Create Local Backup.
- Follow the prompts to save a complete
.qbbbackup file to a secure, external location—such as an external hard drive or a dedicated local server. - Name this file clearly (e.g.,
Company_PreCondense_2016_Archive.qbb) and do not overwrite it.
If you ever need to look up the granular details of a transaction that was removed during the condense process, you will have to restore this specific backup file in a separate instance of QuickBooks to view those records.
Running the Condense Utility in 2016
The steps to run the condense utility in QuickBooks Desktop 2016 are identical to the standard process used across most older Pro, Premier, and Enterprise versions.
To begin the process:
- Open your QuickBooks Desktop 2016 company file in Single-User Mode.
- Navigate to File, select Utilities, then click Condense Data.
- The wizard will guide you through your options. You can typically choose to condense all transactions before a specific date, or choose to remove only specific transactions and list items.
- QuickBooks will ask what you want to happen to the condensed data (usually summarizing them into journal entries).
- Read the on-screen warnings carefully. When you are ready, proceed with the condense.
The time it takes to complete depends entirely on your file size and your computer's processing power. It can take anywhere from a few minutes to several hours. Do not interrupt the process or force-close QuickBooks while it is running.
Alternatives to Condensing
Condensing is not always the best or safest first step for a sluggish company file. Before taking that irreversible action, consider these alternatives to improve performance:
- Clean up the Chart of Accounts: Making old accounts inactive is much safer than condensing, though it will not shrink the file size as drastically.
- Run the Verify and Rebuild Utilities: Sometimes sluggishness or size warnings are tied to minor data corruption rather than genuine data volume. Go to File > Utilities > Verify Data and Rebuild Data to clean up list errors.
- Archive Old Files: If you have decades of history, consider making an archive backup of the older years and starting a fresh company file for the current period. If you need to merge or adjust historical data across different periods, downgrading or converting company files between versions or editions can help you manage legacy data without forcing an upgrade.
Maintaining Your 2016 File Long-Term
Living without Intuit's live support means taking a proactive role in your file's health. Keep an eye on your file size (press F2 on your keyboard with the file open to view the file size and list limits). If your file is nearing critical limits and you begin experiencing frequent crashing or lag, running the condense utility with a solid backup in hand is a reliable way to keep your 2016 software running smoothly for years to come.