How to access the bank reconciliation report for a bank account:

From the Bank Accounts main page there are two main ways:

  1. Click the  button to view reports / sections associated with that bank then click 'Bank Reconciliation'

  2. Simply click the reconciled status  button or unreconciled status  button to go straight to the Bank Reconciliation report for that bank

Or there is also a link from the bank's own homepage.

Quick demo of a reconciled and unreconciled Bank Reconciliation report:

Why a Bank Reconciliation report might show 'Bank is not reconciled':

Firstly, just remember that the transactions you add via 'Bank Statement batches' must be exactly as they appear on the bank/financial account statement.

Therefore if you click to view the 'Bank Statement' report, then it should replicate the transactions in the actual bank statement exactly. 

You can access the 'Bank Statement' report from the Bank Rec report by clicking the figure as below:

The main reasons for status tend to be:

1) There are unmatched transfers in this bank account:

  • You will get this warning message in the Bank Rec report if this is the case:
  • In this case you need to match transfers with the other bank statement data - see here for more details

2) Some bank statement data is still unposted on the account (meaning some lines haven't yet been coded to the General Ledger):

  • This will be highlighted to you in pink on the Bank Reconciliation report itself, something like the below: