Understanding the Three Kinds of Quickbooks Data Problems

1. Lurking data problems. In these situations, everything looks OK to the user in their daily use of QuickBooks. They can enter bills, run reports, do payroll, and backup their company without incident.

But there is a hidden data corruption problem lurking in their database. It won’t be uncovered until a process is attempted that systematically accesses their whole file; in particular, when they try to upgrade to a newer version. That’s when it fails — when QuickBooks basically touches every piece of data in the file.

Running verify and rebuild can detect many of these kinds of problems in the file. When rebuild cannot fix the corruption, most of the time the file can still be repaired.

2. Function-specific data problems. In this scenario, there is one part of QuickBooks that fails, and it fails every time you try it. For example, there was some data we repaired recently where if you accessed one particular invoice, QuickBooks would crash. (It turned out to be a problem with an “inventory loop” in the data and there would have been other ways to crash the file, but the user hadn’t encountered them).

Some people think that they can limp by in this scenario and they basically try not to provoke QuickBooks into crashing; they avoid the problem area. That is living a bit dangerously, I think. Better to either restore a backup made prior to the problem occurring (sometimes difficult to do) or else get the data repaired.

3. In-your-face data problems. These are obvious. You cannot open your file. Or you open it and as soon as you try to enter any kind of new transaction, it errors out and closes the program. Or your customer or vendor list simply vanishes.

This situation usually results in a crisis if there are no good current backups available. And this often (it seems) happens at the worst possible time — when payroll is supposed to be run, for example. Nothing like a bunch of employees coming by your desk to pick up non-existent paychecks to get your adrenaline going!

If you have a good current backup in that situation, you can restore it and go on with your business.

For more information on how our Certified QuickBooks Advisors can help – call (416) 803-5638

Share this

Latest Insights

Recent posts from our blog

How to plan for seasonal variances in your cash flow

Have you noticed unexpected seasonal variances in your company’s cash flow? If your business is seasonally-based (a lawn care or snow removal company, for example), it’s normal for your cash flow to vary depending on the time of year. Unfortunately, many companies who shouldn’t be affected by the seasons still experience peaks and valleys in […]

Organizational growth and restructuring: Is your business ready to take the next steps?

Are you planning to take your business to the next level? Before you start growing your company, you need to ensure that your organizational structure is prepped for this major shift. Don’t just jump in head first – make sure you follow our key prep tips to keep your growth sustainable and successful.   3 […]

Do you have a file you need to send to us? Would you like to make a payement?