Condensing a Large QuickBooks Desktop 2019 Company File
Learn how to safely condense a large company file in QuickBooks Desktop 2019 after its May 2022 sunset. Understand the risks, backups, and alternatives.
QuickBooks Desktop 2019 officially reached the end of its supported lifecycle on May 31, 2022. While the software continues to function normally for offline accounting, your company file will naturally continue to grow as years pass. If your file has become too large and sluggish, condensing it is a common troubleshooting step. Because this process permanently alters your data, it is important to understand exactly how it works and how to execute it safely in an unsupported environment.
What Condensing Actually Does
The Condense Data utility reduces the overall size of your company file by removing transactions that fall outside a date range you specify. QuickBooks summarizes those removed transactions into single, condensed journal entries. This keeps your historical account balances intact but strips away the individual transaction details (like specific invoices, bills, or payments) from that period.
It is crucial to understand that condensing is generally irreversible. Once those individual transactions are removed and summarized, you cannot "un-condense" the file to get that granular data back.
The Mandatory Pre-Condense Backup
Because the condense process permanently deletes transaction details, creating a full backup beforehand is an absolute requirement—not a suggestion.
Before starting the utility, go to File, select Back Up, and choose Create a local backup. Ensure that the resulting .qbb backup file is saved to a secure, separate location, such as an external hard drive or a dedicated offline drive. If you ever need to audit the detailed transactions that were removed, you will open this backup file to view them.
Running the Condense Utility
The steps to condense a file are identical across QuickBooks Desktop versions, so the process in 2019 is the same as in other years:
- Click File in the top menu bar.
- Navigate to Utilities, then select Condense Data.
- The wizard will open. Choose the option to condense transactions before a specific date.
- Enter the cutoff date. Everything before this date will be summarized and removed.
- Follow the on-screen prompts to select how you want condensed inventory and list data handled.
- When prompted, ensure you check the box to create a backup before condensing.
- Allow the utility to run. Depending on the size of your file, this can take anywhere from a few minutes to several hours. Do not interrupt the process.
Alternatives to Condensing
Condensing is an aggressive measure that strips your file of historical detail. Before taking that step, consider these safer alternatives to improve performance:
Build a new file from scratch: If your file spans a decade or more, the safest way to preserve your history while speeding up performance is to keep your current file as an archive. Create a brand-new company file, enter your current balances as an opening trial balance, and use the new file moving forward.
Targeted file repair: Sometimes, file bloat and sluggishness are caused by internal list damage or a corrupted transaction log rather than legitimate data growth. Running the standard Verify and Rebuild utilities can often resolve these structural issues. For severe cases, a targeted QuickBooks file repair can clean up internal list damage and reduce file size without forcing you to delete your historical transactions.
A Safer Path Forward
If you decide against condensing but still need to reduce the file size for better performance, your best next step is to run the built-in Verify and Rebuild utilities to clear out hidden data errors, and then evaluate if the performance lag persists.