How to download a bank reconciliation report or confirmation?

This article covers downloading a bank reconciliation report or enquiry from within the Bank Reconciliation module. Sometimes called a 'reconciliation confirmation' - this is what these reports and enquiries provide. Both give you a record of matched and unmatched items for a specific bank reconciliation, and both can be reached in two ways.

---

Opening the reports and enquiries list from a bank reconciliation

To find the available reports and enquiries for a bank reconciliation, open the reconciliation you want to confirm. Select the 'Analytics' icon in the top right of the screen. A pop-up opens listing the reports and enquiries available for bank reconciliation, split into two groups: reports at the top and enquiries below.

---

Downloading the Bank Reconciliation report

From the pop-up, select 'Bank Reconciliation' in the reports group, then select 'Open' to run it. The report opens as a multi-page document. The first page is a summary showing the reconciliation number, legal entity, bank account and currency, alongside closing balances for the bank statement, cashbook and general ledger reconciliation. The following pages list matched items (transactions that agree between the bank and the cashbook) and unmatched bank items (transactions still outstanding). Use the export option (the Excel icon) to download it.

---

Running the Bank reconciliation summary enquiry

From the same pop-up, select 'Bank reconciliation summary' in the enquiries group, then select 'Open' to run it. This enquiry shows the bank reconciliations summary totals for the opened reconciliation. If you open this from the enquiry screen direct, this will be any open reconciliations in a list.  Each row shows the legal entity, bank account, cashbook end date and statement end date, along with the cashbook closing balance, statement closing balance and any unmatched cashbook or bank statement totals. Use this enquiry to check the reconciled position across multiple reconciliations at a glance, or to confirm the closing balances for one reconciliation without opening the full report. Select the export option to download the results. 

---

Finding reports and enquiries without opening a reconciliation

You can also reach bank reconciliation reports and enquiries without opening a specific reconciliation first. From the main menu, go to Reports or Enquiries. Type 'bank reconciliation' into the search field. This returns the reports and enquiries related to bank reconciliation. Select the one you need, choose the bank reconciliation you want from the dropdown, then run and export it as above.