Are you having trouble with corrupted data in your QuickBooks file? Maybe you're seeing a balance sheet out of balance, sporadic crashes of QuickBooks, or other erratic behavior that could be a symptom of potential trouble ahead?
I wanted to get some additional insights on this topic, so I connected with Shannon Tucker, an expert on the subject of corrupted QuickBooks data files (and how to fix them!). Shannon is the President of AccountingUsers, Inc, and
has consulted in thousands of accounting database cases over the last 20
He was gracious enough to provide some additional insights posted below that I hope you find helpful...
non-techie terms, what does it mean when a QuickBooks data file “gets
means that either part of the file has gotten internally scrambled to some
degree, or it doesn't make accounting sense anymore -- things don't add up
right. The first case is much more common than the second.
What do you see as the leading causes of data corruption?
Sunspots! No, I think that the four most common causes of data corruption in
QuickBooks files are 1) network connection glitches, 2) power glitches that
affect computers or network components that don't have battery backups, 3) hard
drive problems and 4) bugs in QuickBooks.
there anything that can be done to prevent corruption from occurring?
Usually the users themselves don't do anything to cause data problems, unless
they pull the plug on the computer while QuickBooks is open or something like
that. The best defense for preventing data corruption is to have a very stable
computing environment for QuickBooks to run in. That includes:
* Relatively new, fast, professional-grade servers and
* Solid, fast, wired networking (for multi-user situations)
using matching network components (not a mix-n-match approach)
* Battery backups (uninterruptible power supplies) on your
server, every workstation, and every network component
* Professional, updated versions of Windows on every workstation
(not home editions)
* Versions of Windows and QuickBooks that are contemporary
with one another (not trying to run QuickBooks 2007 under Windows 8, for
* Keeping QuickBooks file sizes reasonable. If the file gets too big, then it takes longer for QuickBooks
to update it in real time, and the chances greatly increase that corruption
How can corruption be fixed?
Sometimes the built in Rebuild command in QuickBooks can fix a corrupted file.
Otherwise, QuickBooks files can often be repaired by consulting firms like
ours. You upload a copy of the damaged file, we repair or reconstruct the
damaged sections in the file, test it thoroughly, and return it to you by
download link. Pretty easy and non-technical from the user's vantage
So there you have some additional insight on the topic of QuickBooks data corruption. It goes without saying that it is critical to have a solid, reliable backup strategy in place for your QuickBooks and all other critical business data as well just in case you encounter a situation where your QuickBooks data becomes unstable.
NEED HELP WITH A CORRUPTED QUICKBOOKS DATA FILE?
While Intuit does offer a service can try to help with problems like these, I can't recommend it. In many cases, they can have your data file for 3-5 business days while trying to fix the problem - there is no guarantee that your file will be returned in any specific timeframe. While they have it, you can't enter any new transactions into the file - all you can do is lookup things.
Shannon's firm specializes in fixing and rebuilding corrupted QuickBooks data files and they offer overnight turnaround on them. Contact him for more details on his services. He and his team have helped countless clients of mine fix their QuickBooks problems and get them back in business.