GL trial balance and Cash management not balancing
The value of the GL trial balance for our main bank account and its associated clearing account does not reconcile to the total value of the bank statement balance together with the value from the transactions available for reconciliation report.
The GL trial balance is showing an excess debit value which may mean that not all receipts are showing on the available for reconciliation report from Cash Management
We have found 4 transactions with a status of Confirmed that do not show in the reconciliation report; why would this happen and could there be any other occurrences like this?
We have checked for journals posted in error on to the GL and that the bank statement value is up to date.