We repair a lot of corrupted QuickBooks files. Naturally, people are often interested in the cause of the problem and what can be done to prevent it from happening again.

We don’t have a magic bullet for preventing re-corruption because the causes of data corruption are so varied and are oftentimes unknown.

But if my QuickBooks data file got corrupted, here are the things I would do to to minimize the likelihood of it happening again:

  • IT audit. A lot of times, IT problems cause QuickBooks data crashes. Unless I have an in-house full-time IT pro, I would bring in an outside IT pro to evaluate and bulletproof my network IT, including not only the server, but every workstation, every network component, internet access (which every QB workstation needs), and electrical power.
  • Security audit. This is really a component of an IT audit, but it merits special mention. I would evaluate for malware on every computer. I would also exclude the QuickBooks program and data folders from real-time scans so that QuickBooks can operate without impediment.
  • Consider streamlining the file. If your file is so big (or the lists are so big) that the file is sluggish, that should be addressed. A sluggish file is vulnerable to data corruption. The options to remedy this would be to try the built-in Condense command on a copy of your file (if your edition has the Condense command), or to create a new file and bring over selective information into it, or to get your file supercondensed.
  • Turn on Automatic Updates for both QuickBooks and Windows. If you don’t want to encounter bugs in QuickBooks, you probably want to be using the update that has the least bugs. And that would be the most current update, since Intuit – like every software developer – is constantly fixing bugs in their code. Some consultants recommend only updating Quickbooks once an update has been out there for awhile and has proved itself stable. But that means enduring known bugs that have already been fixed out of fear of unknown new bugs that may not exist. On balance, I want the latest stuff. Same philosophy for Windows updates. The only exception I would make to this strategy is if you are using a 3rd party app with Quickbooks that  might be susceptible to interruption under an untested new QuickBooks update.

There is one kind of data corruption that for some users seems currently unfixable: Balance sheet errors. We don’t know how to keep that from happening or from re-happening. Rebuild Data can usually fix a balance sheet problem, and we can fix it when Rebuild data cannot. But it seems like the problem pops up again – the balance sheet goes out of balance again – once the repaired file starts gets used again. It’s a repeat offender problem. Why? We don’t know. But we’ve talked to a lot of people over the last few months who have experienced this.

If my data got corrupted more than once in a fairly short period of time (e.g. corrupted twice in a month, say), I would do one further thing. I’d make full-verified backups almost constantly. Then if/when the data gets corrupted again, I can restore a very current backup that is quite likely to be undamaged (unless verify doesn’t detect the problem…a possibility, but what can you do?)

How often to make verified backups? Think about the maximum hours or days of rekeying you can comfortably do. So, as an example, are you OK with your team rekeying 8 hours of data? Then make a verified backup every 8 hours. If that sounds too painful, then make a verified backup every 4 hours, or every 2 hours. Identify your rekey pain threshold, and set up a verify/backup schedule accordingly.

That’s no fun, I know! But until you get a good track record for awhile of operating without any new data corruption, that’s what I’d do. Once you get to the point where you feel that things have stabilized, you can relax the protocol some.

RELATED: What Damages QuickBooks Data?

7 thoughts on “My File Got Corrupted and Repaired. How Can I Keep It from Getting Damaged Again?

  1. Since there are so many grammatical errors in your article, you might want to have someone, if you’re not able to pick up on them yourself, review and edit your articles.

    • Hi Susan,

      I appreciate your comment. I want good grammar in my posts! So I let an associate of mine who is more accomplished in English grammar than me take a look. She did not find grammar errors per se, but she did think that perhaps I was a little too liberal in my use of commas. So I removed four commas. She also found one sentence where the word “you” should have been, but wasn’t. I guess that’s more of a typo than a grammatical error, but I fixed that too.

      So how’s that? Please advise of any other errors you see. I like to learn! Thanks for your comment.

  2. Pingback: QuickBooks Data Corruption…and Options « QuickBooks and Your Business

  3. Pingback: DO: Verify Often. DON’T: Rebuild Often « QuickBooks and Your Business

  4. I too have the problem with the balance sheet going out of balance. Funny thing about the problem is it is only out of balance if you run the Standard Balance Sheet report. If I run the balance sheet to compare to the previous year, everything is balanced.
    We have had this looked at by a QuickBooks certified proadvisor (CPA), working directly with QuickBooks support. They finally gave up and advised sending the file in for repair; which I never did because of the expense and likely hood of it recurring again. Do others have the same issue with being in balance when compared to previous years?

  5. I am having the same thing happen to two of my Enterprise 18.0 R6 files. Both large, older databases, that are out of balance when I pull up a standard balance sheet.


Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> 


This site uses Akismet to reduce spam. Learn how your comment data is processed.