Skip to main content
All CollectionsReports
Bank Reconciliation Report
Bank Reconciliation Report

How to use the Bank Reconciliation Report in AccountsPrep.

AutoEntry Support Team avatar
Written by AutoEntry Support Team
Updated yesterday

There are two ways to access a Bank Reconciliation report.

  1. In AccountsPrep, click Banks.

  2. 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'

Bank Reconciliation report showing 'Bank is not 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.

Did this answer your question?