To ensure that the Cashbook data balance and do not contain any invalid information, you can run an integrity check. Cashbook has two types of Integrity Checks:
Database - makes sure all keys are valid and compresses the database.
Data - makes sure that all batches, Cashbook and transactions balance.
The Data Integrity Check will use the balances in the CBBANK Table fields: 'BALOPENING', 'BALCURRENT', 'BALBANK', as well as the transactions in the Cashbook Transaction tables to calculate the:
(Opening Balance + the amounts of the transactions in the Transaction tables =) Closing Balance.
(Closing Balance - the amounts of the unreconciled transactions =) Bank Balance.
i.e. The Data Integrity will have changed the balances to the correct balance as per the transactions contained in the database.
If the data integrity did not detect any errors then the balances are correct as per the formula explained above.
If you do not agree with the balances then you have to check the balances in the CBBANK table or you have to find the transactions which should not be in the transaction file.
You can also check in the database, there might be a transaction with a rogue date.
A rogue date is an incorrect date like a date for the year 1900.
Check the DATE, PERIOD and FISCYR fields for the entries in the CBTRHD table to ensure the values are correct.