Defining the Reconciliation rule set
The transactions that appear in each section of the window are determined by the two reconciliation accounts defined for the reconciliation profile.
It is important that you understand which set of transactions appear in which part of the window in order to define the rule set conditions correctly.
When you define a condition statement for the Reconciliation Manager function, the two Values that appear on the condition statement refer to data items in the different sets of transactions. Value 1 refers to a data item on the set of transactions that appears in the top part of the Reconciliation Manager window (which is referred to as window 1). Value 2 refers to a data item in the set of transactions displayed in the bottom part of the Reconciliation Manager window (which is referred to as window 2).
For example:
Transactions in the two sets of transactions are to be matched on invoice number and base value. However, in the first set of transactions the invoice number is stored in the Transaction Reference data item and in the second set of transactions it is held in the Transaction Description.
The following rule set condition would be defined to match the transactions on these fields. It would set the Allocation Marker to Matched on these transactions if the matching criteria is met:
| Command | Value 1 (Txs for Reconciliation A/c 1 - window 1) | Operator | Value 2 (Txs for Reconciliation A/c 2 - window 2) |
| IF | Transaction_Reference | = | Transaction_Description |
| IF | Financial Amount | = | Financial Amount |
| MATCH |