Related topics: ABR Overview, Select Statement, Bank File Types, Grouping, Build List, Transaction Search, Options, Auto Reconcile, Manual Reconcile

From the Financials tab, in the Cash Book group, click Auto Bank Reconciliation to open the Automated Bank Reconciliation window.

The Automatic Bank Reconciliation (ABR) Window is comprised of several panes and sections.

This section contains a series of buttons which provide tools and additional functions to assist in reconciliation.

Provides ledger details.

Cash Book Receipts

Cash Book Payments

Cash Book Transfers

Currency Transfers

Sales Ledger Receipts

Sales Ledger Payments

Bulk Receipts

Purchase Ledger Payments

Purchase Ledger Receipts

Purchase Ledger Remittances

Updates the current bank account and flags the Cashbook transactions as being reconciled. On selecting the Update Reconciliation icon, a warning message is displayed.

Clears the current statement.

Deletes the current statement if no reconciliations have been processed. You will receive a warning message if you try to delete a statement with processed reconciliations.

Unreconciles all currently reconciled transactions in the current statement. You must click on the Update Reconciliation icon to ensure the system processes this action. Note that this action does not unmatch transactions. You can unmatch by using the Reconcile panel in the Automated Bank Reconciliation window.

Allows you to keep notes about your reconciliations.

After you have run an automatic bank reconciliation, you are able to save the automated bank reconciliation details at the stage that you left it. On selecting the Save icon, the following message is displayed: Are you sure that you want to save the current reconciliation details? Select 'Yes' to Save or 'No' to Cancel.

Cancels any changes you have made since the last Save. On selecting the Cancel icon, the following message is displayed: WARNING: You will lose the changes you have made if you do not save. Are you sure you wish to continue? Select 'Yes' to lose any changes you have made or 'No' to cancel this action.

When you first open the window, the content of the window is blank except for the default Bank Account indicated in the Bank Account field.

Check that this is the Bank Account that you want to reconcile; if not, click on the Search button and select another account from the list displayed.

The associated Account Currency for the selected bank account is displayed in the Account Currency field.

Bank Account - Displays the default Bank Account nominal code and name, as set in the system defaults. To select another bank account, click on the Find Bank Account button and select another account from the list displayed.

Statement Reference - Enter a new bank statement reference and select a new bank statement, or search for an existing bank statement using the Find Statement button.

Statement Balance - After you have imported a Bank File, you are able to enter the statement balance.

Running Total - Displays the total value of all imported statements for this bank account.

Rec. Date - This defaults to the system date for new statements, but can be edited; defaults to the saved reconciliation date for re-opened statements. When a reconciliation is updated, the reconciliation date is saved.

Account Currency - The associated Account Currency for the selected bank account is displayed in the Account Currency field.

Reconciled Balance - Displays the total of all reconciled balances for this bank account.

Total Reconcile - Displays the total amount reconciled in the current statement.

Rec. Period - This is a read only field that displays the reconciliation year and period, as determined by the financial periods and irrespective of future period posting permissions.

Reconciliation Date and Period default to current System date & period. When the Reconciliation Date is overwritten, it updates the Reconciliation Period. The Reconciliation Date and Period are used to inform the Reconciliation reports available.

User Profile settings, specifically those relating to Future Period posting or Post to Restricted Periods, do not affect the Reconciliation Date or Reconciliation Period.

This section enables you to load a previously downloaded bank statement, and displays the transactions and values contained in the bank statement. Additionally, you are able to export highlighted lines.

Use this button to filter transactions held in the Imported Transactions panel. There are three options:

Current Statement - All - displays current Bank Statement.

Current Statement - Unreconciled - displays Unreconciled transactions in the current bank statement.

All Statements - Unreconciled - displays all Unreconciled transactions in all bank statements that you have saved.

You can highlight transactions in the Imported Transactions panel and export them to a .PRN file. You are then able to copy it to a printer in order to get the output. To open the file you will need to change the file extension, for example, to 'txt'.

This grid holds the details from the Bank File.

Once a transaction has been matched, a 'C' appears in the Rec column, a 'P' is displayed if the transaction is Part-matched

When you highlight a single line in the Imported Transactions Grid, this window shows additional reference details from the Bank Statement.

Debits - This is the sum of all Debits from the loaded Bank File.

Credits - This is the sum of all Credits from the loaded Bank File.

Total - This is the sum of all Debits and Credits from the loaded Bank File.

This section is comprised of two tab-based panes, and a Outstanding to Match field.

This pane displays transactions which have not yet been matched against a bank statement. In the Header of this pane are several buttons:

The main portion of this pane holds the details of the unreconciled transactions which match your criteria, and a checkbox to use when a match has been located on the bank statement.

This pane displays transactions which have been matched to a bank statement.

Found in the Header of this pane, use this if a transaction has been incorrectly matched. The transaction is moved back into the Unreconciled pane.

This field is the sum of all outstanding transactions which have not yet been matched.

Located at the bottom of the Automated Bank Reconciliation Window, this grid shows the specific details for the transaction highlighted in the Unreconciled pane.