18 Nov Data Integrity Overview
Data Integrity Overview
We often receive inquiries from accountants and tax preparers as they receive their clients QuickBooks files. Most are looking for some suggestions on how to approach looking at the file to judge the accuracy and overall health of the file. By far the most common error is not checking the data integrity of the file.
What is data integrity?
QuickBooks is a complex system of inter-related transactions. For example, a purchase order is not a posting transaction. It is, however, then linked to a bill in the Accounts Payable Register to update the general ledger. This bill is then paid though pay bills and will appear in the check register. The bank reconciliation function is then performed and the bill payment is marked as cleared. It is quite apparent how an unstable operating environment, fluctuations in the power supply, and incorrect computer procedures (especially not closing QuickBooks before closing Windows or turning off the computer) can contribute to problems with the data.