10 QuickBooks issues and how to resolve them When something goes wrong with QuickBooks, the consequences can be pretty dire. Luckily, many common problems are easy to fix -- once you know about them.
Summary: The blog defines the reasons that lead to QuickBooks corruption and data damage as well as describes the procedure to Rebuild QuickBooks data file using built-in Rebuild Data utility. It also suggests an alternate QuickBooks recovery solution for recover QBW file in case of higher damage. QuickBooks, accounting software built for medium and small sized business sectors is error free and user-centric application. Two most popular built-in utilities being offered by the application are Verify Data and Rebuild Data. The former identifies most commonly occurred data issues while the latter resolves data integrity issues found by Verify Data utility. The most common reasons for using the are when severe errors appear while you use QuickBooks desktop and any discrepancies found on reports such as the bills or invoices being a post with negative values.
Other reasons that call upon the need to rebuild QuickBooks data file are: • Deposited payments are displayed in the Payments to Deposit section • When balance sheet reports do not display all accounts • When data checkups are run to ensure that the file is error free • Transactions are missing or displayed inaccurately in the window • When names found missing from the lists Procedure to Rebuild QuickBooks Data File Documents The process to rebuild QuickBooks data file is quite simple and straight forward. • Open QuickBooks and then click on File. • Click on Utilities and then select Rebuild Data. • If the application displays a warning message for backing up the file, click on OK. • The application will then display Rebuild has completed, click OK. • Then run Verify Data to check for the remaining data damage. • If the application displays ‘QuickBooks is not responding’ message, move the mouse indicator and wait for the data rebuild process to complete.
• If the verify operation fails to accomplish successfully, attempt to repeat the process till the application verifies the file for persisting messages. Even though there are several procedures available to rebuild QuickBooks data file, yet you can reduce the corruption risk by implementing some manual techniques. Specify File Volume to Reduce Corruption Risk The overall size of QuickBooks file largely contributes to corruption, but it is not always necessary that only large files turn corrupt. It can be said that larger the volume of the file, greater the risk of corruption. Thus, it is recommended to constantly monitor the size of the file and keep it under control.
Monitor and Reduce Database Fragments The number of database fragments can be monitored in the Product Information window. Best control surface for mac. If the database has 10 or more database fragments, you can follow the given procedure to reduce the fragments.
• Resort List: In the list menu, use Resort List option. Re-sorting the list through list headers will not put the same re-organization effect on the file. Note: Some lists may not show Resort List selection • Rebuild File: After re-sorting the company file, you can use QuickBooks data file rebuild utility by following the procedure mentioned in the initial section of the blog. Rebuild Quickbooks Data file data utility can also be used to repair the risks of corruption.
• Create Portable Company File: One of the most preferred ways to reduce database fragments is creating a portable Company file and then restore the Portable Company file to re-index the database. • Run Windows Defragmentation Utility: The fragmentation level of the hard drive can affect the fragmentation level of the accounting application database; therefore, you can now run Windows defragmentation utility on the hard drive where the application file is stored. General Network Issues & Maintenance In a multi-user environment, incorrectly configured routers can affect the QuickBooks performance thus increasing the risk of corruption. If the network interruption is caused due to incorrect configuration of the Server or malfunctioning of the hardware components, the QuickBooks data file may turn corrupt.