QuickBooks files will naturally grow over time. If not managed correctly, this growth can cause issues with performance such as slowness, freezing, or crashing.
Note that the different editions of QuickBooks are optimized to support different size company files. The following is a guideline only:
- Pro : 10mb – 50mb
- Premier: 50mb – 300mb
- Enterprise Solutions: 300mb and up
Here are some tips to decrease the size of your QuickBooks file:
- Run the Rebuild Utility
by opening your file in single-user mode as the Admin user and go to File>Utilities>Rebuild. Verify your file after you rebuild it by selecting File>Utilities>Verify. If the verify utility finds additional problems, run the rebuild utility again.
- Compress Your File
by creating a portable company file and then restoring it to help compress your file. Login to your file and go to File>Create Copy and then select to create a portable company file. Log out of your file and move the file an archive folder. You'll then want to open QuickBooks and select to restore the portable company file you created. Once restored, you'll want to work in this version going forward.
- Run the Clean Up Data Utility
To use this utility select File>Utilities>Clean Up Company Data. This will reduce your file by about 20% and will replace detailed transactions with monthly general journal entries for the period you condense.