Sign in

Verifying and Rebuilding QB data file

Verify and rebuild your company file
Generally, if your company file is damaged, you want to verify your company file and then rebuild it to correct any data damage. You may need to cycle through the verify-rebuild process more than one to correct all data damage.

The Verify Data utility (Verify) is your primary tool for detecting data damage in your company file. Verify looks at each transaction in your company file and records a message in the Qbwin.log file for any damaged transactions. Verify also detects damaged list items.

While Verify detects many types of data damage, it does not detect all of the damage that might be in your file.
You should run Verify in single user mode.

The Rebuild Data utility (Rebuild) repairs damage in a QuickBooks company file. Rebuild analyzes a company file and attempts to repair or update data found to be in an incorrect state. Run the Verify Data utility if:

You receive error messages when working in QuickBooks
QuickBooks shuts down when you click to save a transaction
Discrepancies appear on reports; that is, invoices or bills that post with a negative value
Deposited payments show up in the Payments to Deposit window
Balance sheet reports are not showing all accounts
Names are missing from lists
Transactions are missing
The company file won't open
Transactions can't be saved
You experience power surges or dropouts, abnormal shutdowns, computer crashes, or "Company file in use, please wait," messages

Note: As part of your company file maintenance routine, be sure you run regular manual backups with full verification and check the Qbwin.log file for error messages.
Run the Rebuild Data utility if:

The message that the Verify Data utility has failed appears
The Verify Data utility returns a b-check error
A QuickBooks Help and Support Knowledge Base article mentions a data rebuild to fix errors
QuickBooks displays payroll forms incorrectly

Note: If it looks like Rebuild froze your computer, move your mouse. If the mouse pointer moves, Rebuild is still working normally
Verify your data:

Close and reopen QuickBooks to create a new Qbwin.log file. Choose Window Close All , so that no company files or QuickBooks windows are open.
Choose File Utilities Verify Data

If you see QuickBooks detected no problems with your data , your data is clean. Click OK .
If you see Your data has lost integrity , your data file is damaged.

Run the Rebuild Data utility to repair the damage. You may need to run Rebuild two or more times to repair all of the damage. Rerun the Verify Data utility after each rebuild to verify that the errors have been corrected.
If your see A data problem prevents QuickBooks from continuing , then your data file has a structural problem.

Run the Rebuild Data utility to repair the damage. Rebuild your data:

Important : If the company file is on a network drive, copy the file to a local computer before attempting to run this utility. Be prepared for this computer to be unavailable for several hours running the Rebuild utility. Never rebuild or update a company data file that is located on a remote drive (for example, by accessing it over your network).

To rebuild the file:

Choose Window Close All
Have more questions? Submit a request