I’m talking to people every day who are concerned about the size of their QuickBooks company data file. (Press F2 in QuickBooks to see how big your file is).
Some people are concerned because their file is bigger than they expect, or bigger than any other data file they work with, and that makes them nervous about possible future problems.
Others are concerned because their big file has made QuickBooks slow to use.
Others are unhappy with their file because it is becoming unstable — crashing or freezing up a lot.
Sometimes users are told by others that their file is too big. Word is going around that 150MB is the maximum usable size for QuickBooks Pro or QuickBooks Premier files. (That’s not really so. There are lots of people we talk to who have files bigger than that who are operating QuickBooks without any problems at all).
Here are some examples of file sizes we’ve heard of in the last couple of weeks:
1GB. Enterprise 11, slow performance
340MB. Pro 2011, slow performance
1.2GB. Enterprise 9, instability
400MB. Pro 2010, slow performance
1.4GB. Enterprise 10, slow performance
3.4GB. Enterprise 11, slow performance
750MB. Pro 2011, slow performance
All of these are great candidates for supercondensing, where we remove old closed transactions from the file, reducing file size by as much as 80%.
Sometimes, if the accounting is all messed up as well as the file’s being big, it’s better to just create a new company file in QuickBooks, pull in current names, plug in beginning balances, and go forward that way.
Anybody have a data file over 3.5GB? That’s about as big as we are seeing these days.