I’ve talked to a lot of QuickBooks users who have told me their QuickBooks file is too big.
According to several Pro and Premier end users, they were told by different support resources that you should upgrade to QuickBooks Enterprise Edition if your company file size exceeds 150MB.
Whoa, hold on pardner!
Although Enterprise is designed to handle larger database sizes, it’s also several times more expensive than Pro or Premier, both for initial purchase and for annual upgrades. And the support plans cost much more.
I’m not sure where this perceived 150MB limit came from. The underlying database QuickBooks uses has not changed much since the 2006 version; the technical capacity of the database hasn’t changed recently. And most QuickBooks Pro and Premier users we talk to have file sizes of over 150MB.
Nonetheless, there is a point at which your file size gets too big and you notice slowdowns in QuickBooks. Or QuickBooks starts to crash. Whether that point is at 150MB, 300MB or 700MB…you tell me! Is QuickBooks working great for you, or are you starting to experience problems?
If your QBW file is getting too big to perform well, you do have options other than upgrading to Enterprise:
1. Condense/Cleanup your file. There is a built-in utility in QuickBooks that will reduce the file size to some extent. In many (most?) cases, however, the file size change resulting from this method is relatively small, or the command crashes or freezes.
2. Supercondense your file. This process removes old, closed transactions from your file. Optionally, old unused customers and/or items can be removed too. File sizes are typically reduced by 50-80%.
The goal of these methods is to save money by avoiding software upgrades, but at the same time making QuickBooks perform better and with more stability.
By the way, you can check on the size of your company data file by pressing the F2 key in QuickBooks when you have your company open.
How big is your QuickBooks company file? Are you noticing any performance issues?