Home » All Posts » Broken Database Links In Your QuickBooks Data File – Part 3

Broken Database Links In Your QuickBooks Data File – Part 3

Fixing Data Damage in QuickBooks Company Files to Prevent QuickBooks Crashing

How to Locate and correct damaged data and transactions in your QuickBooks data file.

From time to time, QuickBooks data files become damaged or corrupted, which could cause QuickBooks to crash when opening or working in the company file. We know from experience how terrifying this can be! But don’t panic…

How To Fix Damaged Data In Your QuickBooks Company File

  • Did you get the “Data Has Lost Integrity” message after 2 rebuilds?
  • Are you a “brave and techy” type of person?

How to locate and correct damaged transactions in your QuickBooks data fileIf so, you could potentially find (and fix) damaged transactions by performing the steps shown below.

NOTE: Unless you’re VERY experienced in this area, you should ALWAYS make a backup of your QuickBooks data file before you start on this project. You don’t want to venture into these underlying database files without a “fallback” card in your pocket.

The extra few minutes you spend to create a backup could turn into a terrific investment!

Using the QBWIN.LOG to locate, view and fix data damage in your QuickBooks data file

  1. Press Ctrl+1, then Ctrl+2. This will take you to a window called Tech Help.
  2. How to access your QuickBooks QBWIN.LOGClick on the Open File tab.
  3. In the middle of the window, you will see a list of files. Highlight the line that ends with QBWIN.LOG.
    (You may need to move the bottom arrow to the right to be able to see the file names at the end of the paths.)
  4. Double-click on that file or click the Open File button.
  5. The document you will see is in Wordpad. This will likely be a long document because it records and adds a new section each time that:
    • Your QuickBooks program crashes.
    • Each time you verify your file, and
    • Each time you rebuild your file.
  6. Go to the end of the file to see the results of your file verification and the results of your rebuild.
    • Drag the button on the right side of the window to the bottom of the window.
    • Review the Verify log and Rebuild log sections.
    • Damaged transactions in the Verify log section will be marked as Error transactions.
  7. If you find damaged transactions that were not fixed in the prior rebuild process, you can attempt to correct the original transactions (see below).
  8. If that doesn’t work, you may decide to delete and re-enter them (see below).

How to (potentially) fix data damage in your QuickBooks Desktop company file: correct original transactions 

  • View the log and note (or screenshot) all of the primary data about each “error transaction,” including:
    1. Transaction type.
    2. Transaction number.
    3. Date.
    4. Document number.
    5. Amount, and
    6. Name.
  • Go back to your company file. Use the Find feature in QuickBooks to locate and view each of the original transactions in your QuickBooks data file.
  • “Re-post” the transactions by making a simple change on each transaction, such as entering a letter or phrase into the memo. (This MAY take care of the problem.)
  • After making these changes, re-run the verification process to see if it has resolved the issue(s),
  • If it hasn’t resolved the problem, you may need to delete and re-enter the problem transactions. But be sure to read the following before doing this!
    (Advice: It may be a good idea to consult with us, another experienced Certified Advanced QuickBooks ProAdvisor, or Intuit tech support before proceeding further.)

Deleting and re-entering “Error Transactions” (damaged data and transactions) + critical follow-up steps

If you DO decide that you want to delete and re-enter the damaged transaction, there are additional steps to follow:

  1. Fixing Data Damage in QuickBooks Company FilesDoes a damaged transaction affect a balance sheet account that is regularly reconciled (e.g., checking, credit card, “pass-through,” loan account, etc.)? If so, find the transaction in your report details or the account register.
  2. Does it have a “cleared” indicator (checkmark)? If so, create a note to re-reconcile the new transaction after you re-enter it.
  3. For any reconciled accounts, note the existing cleared amount. (You’ll need to re-enter that amount if you need to re-reconcile as part of step #7.)
  4. Enter the transaction a second time using all of the same information as the original. (Be especially careful to use the original date!)
  5. Confirm that the new transaction is correct.
  6. Go back to the original damaged transaction and delete it.
  7. If the transaction needs to be re-cleared, go into the reconciliation screen and clear it.

Repeat these seven steps for all remaining error transactions

Frequently Asked Questions About QuickBooks Data File Repair

What causes QuickBooks Data Damage?

QuickBooks data files can be corrupted via

  • Improper system shutdown.
  • Hardware issues.
  • Software issues.
  • Network connection errors.
  • Malware or virus attacks.
  • Large file sizes.

How long does it take to rebuild a QuickBooks data file?

The process of rebuilding a corrupted QuickBooks data file can take a few moments for a small data file and up to several hours for large or heavily damaged files. During this time, don’t perform any QuickBooks operations. Why? It could cause irretrievable damage to your data file.

Related QuickBooks Data File Repair Articles:

What our customers say about Diane Gilson and Info Plus Accounting:

⭐⭐⭐⭐⭐ From the Intuit FindAProAdvisor website:
“Diane has provided incredible insight to the processes we created. She gave critical guidance that assisted our CPA as well as our procurement and accounting team. Diane would receive a rating of 5+++++++. Tremendous asset to our company.”

See More Customer and Client Comments

About Info Plus Accounting

At Info Plus, we offer a wide range of affordable workshops and training specific to job costing using software such as QuickBooks® desktop and Excel. We love teaching and coaching, so if you’re ready to learn, we’re here for you.

Learn more about job cost training for QuickBooks

You can sign up for any of our workshops or training tutorials and learn what you need to know 24/7. If you’d like to learn more about the training, please send an email or call. We’ll be happy to explain how it works so you can decide if it would be a good fit for you and your business.

We look forward to hearing from you and learning more about how we can help…