The Verify and Rebuild Data Tool is a built-in feature available with QuickBooks Desktop that help correct fix minor issues with company files. This will provide the most significant reduction in file size. While more effective than the previous, this method takes longer to perform because it requires entry of Opening Balance and Outstanding AP, AR and Banking once complete.Īnother way to prevent data corruption would be to start a new QuickBooks file with Opening Balances. The process creates Journal Entries that summarizes the monthly activity and removes all transaction before a certain date. A corrupt file can also cause issues with other programs that use automatic sync managers to connect to QuickBooks.ĭata corruption can be prevented by taking advantage of the “File Condense” functionality that helps reduce the size of a file. If Net Income, Accounts Receivable, Accounts Payable and other balance sheet balances do not tie in with other reports, a corrupt file is more than likely. If the total Assets do not equal total Liabilities and Equity, this would be a clear indication of possible data corruption. The Balance Sheet provides a peak of what data corruption would look like. Brandon, MB – Septem– When a data file grows larger than acceptable file limits, data cannot be kept in order.