Produce a bank reconciliation report
The Bank Reconciliation Report in the reporting suite shows the unreconciled items as at a particular date.
- Go to Modules, then select myReports.
- Select Bank Reconciliation Report from Extra Reports.
- The company and location for the report are automatically selected. Select the required bank account from the Select the Bank Account list.
- The as at date defaults to today's date. If you want to change the as at date, select the calendar icon next to Select the as at date.
- If you want to include documents posted in the register period, select an option from Include Register?.
- When you have selected the criteria for the report, select View Report.

- The Bank Reconciliation Report appears. To print of save a copy of the report, select either the Print icon, or select the Save icon and select an option from the list. The report has the following sections:
- Open Items in Bank - displays unreconciled items showing in the bank statement as at the date specified.
- Open Items in Books - displays unreconciled documents posted to the bank nominal (cash book).
- The Summary contains the following detail lines:
- Actual Balance at bank - displays the balance of the statement.
- Total for open items in bank - displays the total of unreconciled statement items.
- Total for open items in books - displays the total of unreconciled cash book items.
- Calculated balance in books - shows the total statement balance plus or minus the value of the open bank reconciliation items.
- Actual balance in books - displays the balance of Bank nominal code.
If the Bank Reconciliation does not agree line in the Summary shows a difference it is due to the dates of some of the reconciled items. For help resolving the issues, go to Bank Reconciliation does not agree Message.
Bank reconciliation does not agree message
If the Bank reconciliation does not agree line of the Summary appears in red, showing a difference, such as (792.19), the most common reason is that the dates on the items that have been reconciled.
A breakdown of the items causing the imbalance appear in Imbalance details. You can use these details, with these steps to balance the Bank Reconciliation Report.
- Go to Banks, select Bank Statements, then Select a bank account.
- Select the Bank Statement that contains the imbalanced item from the list. If the items have been reconciled, a green Select icon appears in the Reconciled column.
- Select the reconciled transaction, then select VIEW RECONCILIATION.

- The View Reconciliation window opens. If the document date is later than the as-at date on the Bank Reconciliation Report, unreconcile and amend the original document. For more information, go to Unreconciling Transactions and Editing Existing Documents.