The Set Options window is opened by selecting the Options button on the Unreconciled Transactions tab in the Automated Bank Reconciliation window.

The Options Window enables you to define simple automatic reconciliation matching rules. It also gives you access to import formats and matching templates.

By default, Automatic Reconciliation will always match on the value of a transaction. You must ensure that a value is set for Date Tolerance.

Date Tolerance - Entering a date tolerance allows transactions from your bank statement to be reconciled with the outstanding payments and receipts in Dimensions within the date range you specify. Enter the number of days required, which must be '1' or more (default is '0').

Value Tolerance - You 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 your Value Tolerance is 25p, then an imported transaction for 20p does not match to a Dimensions transaction for -5p.

Match on Reference - You can optionally set this matching rule, if required. If set, the transaction reference number on your bank statement will need to match that on outstanding payments and receipts in Access Accounts for a match to be made automatically.

For examples see ABR Examples

Click on this button to open the Import Formats window. Here you are able to set up new and edit existing import formats. Import formats are files designed to help download a bank statement to the Automated Bank Reconciliation window. Import formats reside in the ABR folder under Extras in Dimensions. The files have a file extension of ABR.

As various banks distribute their data in differing formats, it may be necessary to fine tune some import formats using a text editor in order to successfully import a bank statement into the Automated Bank Reconciliation window. It is expected that your Access Consultant will create and, if necessary, edit the appropriate import formats for your site. Should you need any assistance, please contact your Access Consultant.

For examples see ABR Examples

Click on this button to open the Templates window. Complex rules can be set by using matching templates. It is expected that your Access Consultant will set these matching rules for you, if required. If matching templates are set, then users carrying out automated reconciliation will be prompted to select a template before matching.

Of particular note is the option 'Create Transaction if no match'. If this option is selected, when the matching template is run, transactions which exist on the statement but not within Dimensions are auto created based on a set of rules and functions. It is expected that your Access Consultant will set these rules for you, if required.

Include all previously unallocated transactions - Tick this checkbox if you need to override your search criteria. For example where a cheque from an earlier date has been cashed on this bank statement. By ticking this box, Access Accounts will search through all outstanding transactions to try to match to the statement. Be aware however that this extended search is effected by the Date Tolerance and any other Matching Templates you may be using.

Dimensions stores its values as entered, but the type of transaction affects whether the transaction increases or decreases the balance of an account, e.g. £100.00 PL payment is stored as a positive figure but would decrease the bank account because it is a purchase payment.
​
Because Bank Statements can state values in different ways (e.g. 2-columns where one is for CR another for DR; 2-columns where one is for all values another indicating CR or DR; 1-column where values appear as positive and negative values; etc ) it is unlikely that simple matching template formulas would work in all occasions. Please contact your Access Consultant for further information and advice.