Posted QuickBooks Software, Software - Third Party Programs on Sunday, July 31st, 2005.
QuickBooks Data File Repair Instructions
Working for the IT department in a private accounting firm it is inevitable that a large number of our clients use and will continue to use QuickBooks accounting software. It is an inexpensive and well-marketed program that many bookkeepers already know. Unfortunately, Intuit provides poor technical support, has a badly-designed, proprietary database format, and there is little free support since Intuit has encouraged pay-to-play 3rd-party support. This article is a start at expanding the free, online support information available for the program.
The custom database format used in Intuit’s QuickBooks .QBW files isn’t very resilient and often results in the need to rebuild database files and then recover the data lost during recovery. The custom data format means that only the simple tools built in to QuickBooks (QB) can be used in the rebuild and recovery process, so fixing damaged QB files is tedious but not very complicated.
The lack of resilience of the .QBW data format makes determining the cause of corruption difficult. In fact, many files are damaged long before errors are finally reported by the QB program. Using QuickBooks in a multi-user, networked environment often results in errors when one or another client computer disconnects. Because QB doesn’t perform a full scan of the database unless the Verify or Rebuild utilities are run, no error messages are reported until the damaged data is accessed by the program. It isn’t worth tracking file usage closely enough to determine who or when integrity problems occur.
Check to Determine if File is Corrupt:
Following the appearance of an error message that indicates data problems, first run the Verify utility to determine if problems exist with the file or if the error was due to network or drive problems. To run Verify pull down the File menu > click on “Close Company/Logoff” and then pull down the File menu again > click Utilities > click “Verify Data” and then select the correct .QBW file from the computer or server drives. After a file is selected the utility will run and report on the data integrity of the file. If there are any problems with the data QB will report “Data has lost integrity”. Continue on to the steps outlined below to repair data. QB will report “QuickBooks detected no problems with your data” if the data are not corrupt. In this case, other problems on the network, PCs, or servers involved may have caused the error.
If Corrupt, Prepare for Rebuild:
In the event the Verify utility does report integrity issues with the .QBW file in question, the following steps outline methods to prepare a file for the Rebuild utility, to run the Rebuild utility, and then to manually restore transactions from rebuild log files.
Preparation Steps:
Accounts: Pull down the “Lists” menu > select “Chart of Accounts” > Confirm that active and inactive accounts are being displayed. Depending on the version of QB, confirming which accounts are displayed is done from the Chart of Accounts screen. Depending on the version of QB being used: A) by clicking the “Show All” or “Include Inactive” checkbox at the bottom (next to the “Reports” button), or B) by clicking the “Account” button at bottom-left > select either “Show Inactive Accounts” or “Show All Accounts”. Finally, click on the “Account” menu at button again > select “Re-sort Lists” > click “OK” at the prompt.
Items: Pull down the “Lists” menu > select “Item List” > repeat the steps from accounts, above, to show all accounts and then re-sort the lists.
Customer Names: Pull down the “Banking” menu > select “Write Checks” > open the checking name list by clicking in the “Pay to the Order of” field > press “Ctrl” and “L” to open the list > repeat the steps from accounts, above, to show all accounts and then re-sort the lists.
Rebuild and Reverify Steps:
Rebuild the file by selecting the “File” menu > “Utilities” > and then “Rebuild Data”. The utility will first prompt to backup the QB file unless one was just run. Run the backup and, then click “OK” on the next dialog confirming a rebuild of the data file. Again, this step should only be performed on a local (C:\) copy of the .QBW file, as a networked file is likely to be corrupted in the event of a connection failure.
Before running the Verify tool again, rename the QuickBooks log file. This file, always named QBWIN.LOG, can be found by searching or by looking in the installation folder for QB (usually C:\Program Files\Intuit\QuickBooks ##\, where ## is the version year) and there is one of them for each version/year of QB installed on a computer. I prefer to keep the file name and just add a date, such as QBWIN-2008-02-29.LOG. Now rerun the Verify utility via the “File” menu > click on “Close Company/Logoff” and then pull down the File menu again > click Utilities > click “Verify Data” and then select the correct .QBW file from the computer or server drives.
Correcting Continuing Errors or Missing Data:
Open the new QBWIN.LOG file, created by the Verify utility after renaming the old one. Programs like WordPad or Notepad, included for free in Windows, are much better than using Word which may reformat the text. Any errors found in QuickBooks will be listed in this file. Any items that contain the word “CHECKPOINT” can be ignored. Scan other items in the file to identify any QB transactions that were picked up by Rebuild. Those items include some combination of Amount, Date, Document Number, or Transaction Type.
Once the transations with errors have been identified open the QB file and go to the “Edit” menu > “Find” > “Advanced” button. In the Advanced Search use the Amount, Date, Document Type, and Transaction Type to find individual transactions in the QB file. Manually delete each transaction from the log file and reenter. Once all the transactions found in QBWIN.LOG have been reentered close the file and rerun the Verify utility. Odds are that there will be no more problems after a manual repair. If there are any more problems found then restart these instructions at the Rebuild step, a second run has never failed to repair a QuickBooks file for me.