When a bank recon is out of balance there a few things that you may check that could cause it to be out of balance:

1.    Compare your Cash Book Details Report against your Bank statement

•    Ensure that all transactions are showing on both.

2.    Open Item Corruption

•    Run the Data Integrity ‘Verify Data Only’ and check for Open Item Corruption.

3.    Correct Cash Book Entries

•    Check that the Cash Book transactions have been processed in the correct Cash Book i.e. correct Bank Account.

    4.    Out of Period Processing

•    Check if there are any transactions that have been processed in an incorrect period.

    5.    Journal Entries

•    Check if there are any transactions that have been processed to the Bank Account in a journal as these will not reflect on the Bank Recon.

    6.    Closing Balance on Bank Recon

•    Check if the closing balance entered is correct.

    7.    Duplicate Reference Numbers

•    Check if there are any transactions that have been processed a reference number that has already been used. These transactions will have consolidated and you will have to reverse the transaction.

8.          Cashbook transfer processed in one cashbook

•    If a cashbook transfer was processed in one cashbook and updated then that transaction will only reflect on the one particular cashbook’s Bank Recon.  What we need to do to correct this is reverse the transaction and use the Cashbook Transfer Assistant to process the transaction correctly.