TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







VIEW REPORTS
VIEW DATA INTEGRITY CHECK REPORT
  
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:
  1. System Info - Memory in your System (e.g. 64 Mb, 128 Mb, 256, Mb, etc.).

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Name of the report. The location (drive, folder and name of the Set of Books on your system). The memory on your system. File number, name, size, number of records in each file and the status. System date and time. Page number.
File number, name, size, number of records in each file and the status.
File number, name, size, number of records in each file and the status. Name of the report. The location (drive, folder and name of the Set of Books on your system). Periods - Opening Balances and 1 - 13 for Last Year. Debit and Credit Totals must be equal. Balances should reflect a 0. Any other amounts indicates that there may be a possible corruption for the specific accounting period. System date and time. Page number.
Periods - Opening Balances and 1 - 13 for Last Year. Debit and Credit Totals must be equal. Balances should reflect a 0. Any other amounts indicates that there may be a possible corruption for the specific accounting period. Number of accounts created in the Edit - Accounts - General menu option. Number of accounts created in the Edit - Accounts - Debtor menu option. Number of accounts created in the Edit - Accounts - Creditor menu option. Number of accounts created in the Edit - Accounts - Bank menu option. Number of accounts created in the Edit - Accounts - Tax menu option. The count of the accounts in the General Ledger, Debtors Ledger and Creditors Ledger.
The full amount, control amount, and outstanding amount must be in balance and it must be the same as balance of the Debtors Control Account on the Trial Balance. The full amount, control amount, and outstanding amount must be in balance and it must be the same as balance of the Creditors Control Account on the Trial Balance. Any unposted batches and documents will be listed. This section will display the verification of the Debtor and Creditors ledger. Name of the report. The location (drive, folder and name of the Set of Books on your system). System date and time. Page number.


If any differences or corruption is found, you may need do a Data Re-index (Rebuild Database). If the differences or corruption is not yet fixed, you need to Restore the Set of Books from a previous backup.