Spring-Clean Your QuickBooks Company File
There are a lot of clues that indicate trouble with your QuickBooks company file. Is it time for a check-up and tune-up?
After this ridiculously long winter, you’ll probably hear few complaints about things like puddles in the street, summer heat and spring cleaning. Most people are eager to throw open the doors and windows, and attack the dirt that the season left behind, both inside and outside of the house.
It’s not hard to see when your home is dirty. QuickBooks company file errors are harder to detect, but they’re there, including:
- Performance problems
- Inability to execute specific processes, like upgrading
- Occasional program crashes
- Missing data (accounts, names, etc.)
- Refusal to complete transactions, and
- Mistakes in reports.
Call for Help
The best thing you can do if you notice problems like this cropping up in QuickBooks – especially if you’re experiencing multiple ones – is to contact us. We understand the file structure of QuickBooks company data, and we have access to tools that you don’t. We can analyze your file and take steps to correct the problem(s).
One of the reasons QuickBooks files get corrupt is simply because they grow too big. That’s either a sign of your company’s success or of a lack of periodic maintenance that you can do yourself. QuickBooks contains some built-in tools that you can run occasionally to minimize your file size.
One thing you can do on your own is to rid QuickBooks of old, unneeded data. The software contains a Condense Data utility that can do this automatically. But just because QuickBooks offers a tool doesn’t mean that you should use it on your own.
A Risky Utility
The program’s documentation for this utility contains a list of warnings and preparation steps a mile long.
We recommend that you do not use this tool. Same goes for Verify Data and Rebuild Data in the Utilities menu. If you lose a significant amount of company data, you can also lose your company file. It’s happened to numerous businesses.
Instead, start practicing good preventive medicine to keep your QuickBooks company file healthy. Once a month or so, perhaps at the same time you reconcile your bank accounts, do a manual check of your major Lists.
Run the Account Listing report (Lists | Chart of Accounts | Reports | Account Listing). Are all of your bank accounts still active? Do you see accounts that you no longer used or which duplicate each other? Don’t try to “fix” the Chart of Accounts on your own. Let us help.
Figure 3: You might run this report periodically to see if it can be abbreviated.