To use auto-bank reconciliation:
Navigate to the Financials tab.
Look into the Cash Book section of the tab.
Click Auto Bank Reconciliation. The ABR-Messages window is displayed. The top panel in the window documents any matches or conflicts.
Note: For the ABR- Messages to work, reconciliation matching rules have to be defined first under Options. For example, as seen above there is no match because of the date difference. However, after changing the Date Tolerance, a match is identified.Date Tolerance: Entering a date tolerance allows transactions from the bank statement to be reconciled with the outstanding payments and receipts in Dimensions within the date range specified. Enter the number of days required, which must be ’1’ or more (default is ’0’).
Value Tolerance: Are able to apply a value and/or percentage tolerance to ABR so that if there is a variance in the amount of the bank statement to the transactions in Dimensions, the transactions can still be fully reconciled. The Value Tolerance applies to Auto Reconcile only, and not to Manual Reconcile. Where both a value and a percentage tolerance are set, then the lower value is used; signs of matched transactions must match, e.g. if the Value Tolerance is 25p, then an imported transaction for 20p does not match to a Dimensions transaction for -5p.
Match on Reference: Can optionally set this matching rule, if required. If set, the transaction reference number on the bank statement will need to match that on outstanding payments and receipts in Access Accounts for a match to be made automatically.
If there are no reported conflicts then close the window by clicking the icon.
If there are conflicts (the system has found more than one possible match), then this window enables the user to select a match and then reconcile.
Click a transaction in the Conflicting Transactions panel to display possible matching transactions in the Possible Matches panel.
If a match is found in the Possible Matches panel, double-click the relevant transaction. It is automatically reconciled.
View the reconciled transactions in the Imported Transactions panel. A C is entered in the Rec column against reconciled transactions. The C is an abbreviation for a Complete match.
The following choices are available for reconciling a transaction or transactions:
Update Reconciliation: Updates the current bank account and flags the Cashbook transactions as reconciled. On selecting the Update Reconciliation icon, the following message is displayed: Are you sure that you want to process the current reconciliations? Select Yes to Save or No to Cancel.
Save: Saves the automated bank reconciliation details at the stage 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.
Cancel: Cancels any changes made the last Save. Upon 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 made or No to cancel this action.