There are two ways to access a Bank Reconciliation report.
In AccountsPrep, click Banks.
On the dropdown, click Bank Reconciliation, then click the relevant bank account.
On the dropdown, click Bank Accounts, then next to the relevant bank account, click the cog icon, then click Bank Reconciliation.
'Bank isn’t Reconciled'
📎NOTE: 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, it should replicate the transactions in the bank statement exactly.
You can access the Bank Statement report from the Bank Reconciliation Report by clicking the figure shown below:
Why does this message show?
There are unmatched transfers in the bank account
You’ll get this warning message in the Bank Reconciliation Report if this is the
Note: There are currently unmatches transfers of xxxx.xx in this account. You won’t be allowed to close the period while these remain unmatched. It may also cause problems reconciling the account.
In this case, you need to match transfers with the other bank statement data.
Some bank statement data is still unposted on the account
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, similar to this.
Exporting
Click Export to Excel to export the on-screen results to Excel.