As soon as the Data Integrity Check process is
completed, the Data Integrity Check Report will be printed to either the
screen, printer, file, fax or e-mail as set or selected on the Default Output field in the
Setup - System Parameters - Company Info (Options
tab) menu option. The Data Integrity Check
report consists of the following 6 basic sections:
-
System Info - Memory in your System (e.g. 64 Mb, 128 Mb, 256,
Mb, etc.).
-
Files - A 2 digit numeric number is automatically allocated
to each of the files in the set of books. The Files are .DB files, which are
Database files (See Structure of TurboCASH). The size of
each file is indicated in Kb, etc. It also displays the number of records,
contained in each file. For example, the Data integrity Check report reflects
38 records for the Accounts.DB file, it indicates that there are 38 Accounts
in the Set of Books.
-
Periods - The number of Accounting periods as specified in the Setup - System Parameters - Reporting Dates menu option will be listed. The description of the periods are also
displayed as selected or specified in this menu option. Period 00 indicates
Opening Balances and Periods 01 to 13 indicates Last Year Periods. Periods 14
to 26 indicates This Year Periods.
This will list the Accounting Periods and the Debit Totals and Credit Totals and Balances for each period for up 2 Financial Years (This Year and Last Year). If there are any balances (the Debit and Credit Totals for an Accounting period does not balance), it indicates that the data may be corrupt for the specific accounting period in which the Balance is displayed.
-
Count Account Number - This specify the number of Account
master files created for each Account Type (General Ledger, Debtors,
Creditors, Bank and Tax Accounts) in the Edit - Accounts menu option. The
number of Accounts for Debtors indicates the number of Debtor Accounts in the
Debtors ledger and the number of Accounts for Creditors indicates the number
of Creditor Accounts in the Creditors ledger.
-
Control Accounts Check - This will indicate the balances
for the Full Amount, Control Account and the Outstanding Amount for the
Debtors and Creditors. These 3 Amounts must be in balance and must balance
with the Debtors Control Account or the Creditors Control Account in the
Balance Sheet or
Trial Balance.
-
Unposted Batches / Documents - This will only be displayed if
there are any batches or journals which have not yet been posted to the ledger and /or
documents, which have not yet been updated to the ledger.
![]()
taken from the