From time to time databases in general – and QuickBooks data files specifically – can become corrupted. Reasons for database corruption vary, but can include power surges, spikes, and outages.
Oftentimes QuickBooks data files display tell-tale signs of data file corruption; examples include an out-of-balance trial balance; accounts receivable detail or accounts payable detail not agreeing to general ledger amounts; and net income per the income statement not agreeing with net income per the balance sheet.
Whatever the reason for corruption, it can often be detected early by running the Verify Data Utility.
To run Verify Data Utility:
This utility executes tests against the data file, verifying the integrity of the database.
From the File menu, choose Utilities, and then choose Verify Data from the submenu.
If data file corruption is detected, QuickBooks displays a message indicating that the file is corrupted and recommending that you run the Rebuild Data Utility.
Note that when running the Verify Data process, the file should be in single-user mode. Further, because the chances of successfully rebuilding the data file are increased if data file corruption is detected relatively soon after it first appears, it is recommended that the Verify Data process be completed.