Grouping
Both Statement Bank Ledge transactions can be group BEFORE the match clauses are processed.
Several levels can by used eg.
Group by Date, and then by Transaction Type
or
Group by Date, and then by the first n Characters of the Memo field
The result of the grouping process combines transactions lines for the clause processing step.
Fields which are of type numeric, are summed in the resulting data set.
Text and Date field use the minimum value from the records which are grouped.
eg.
| Transaction Date | Transaction Type | Amount | Description |
| 01/01/2022 | PAY | 100.00 | Payment 0001 |
| 02/01/2022 | PAY | 150.00 | Payment 0002 |
| 02/01/2022 | PAY | 200.00 | Payment 0003 |
| 02/01/2022 | INCOME | 250.00 | Funds received 0001 |
| 03/01/2022 | INCOME | 300.00 | Funds received 0002 |
After Grouping by Date and Transaction Type
| Transaction Date | Transaction Type | Amount | Description |
| 01/01/2022 | PAY | 100.00 | Payment 0001 |
| 02/01/2022 | PAY | 350.00 | Payment 0002 |
| 02/01/2022 | INCOME | 250.00 | Funds received 0001 |
| 03/01/2022 | INCOME | 300.00 | Funds received 0002 |
Notice how the 2 payment lines have been grouped into a single row, the amount field is the sum of the grouped rows, and the 'minimum' description has been used for the resulting rows description
Match Clauses
A match clause consists of a left and right values and a comparison (operator)
eg.
Statement Transaction Date equals Bank Ledge Transaction Date
- The Left value is the Statement Transaction Date
- The comparison is the equals
- The Right Value is the Bank Ledger Transaction Date
this type of clause involving a field from the Statement and the Bank Ledge implies a match between the transactions
Where the clause only consists of a value from Statement or Bank Ledger
eg.
Statement Transaction Type equals '234'
This type of clause implies a filter because only records passing the criteria will be considered.
Filter type clauses can be defined against either dataset
Value Modifiers
The value of a field can be modified before the comparison takes place, the support modifiers depends on the data type of the field selected
| Modifier | Support Field Type | Description |
| Substring | Text |
Extract part of a string Parameter 1: Position within the string to start, the first character is at position 1 Parameter 2: Length of the string to extract Value: Ref:12345 |
Operators
Operators control how the comparison takes place between the left and right values
| Supported Field Type | Operator | Description |
| Text | Equal |
Text equal. eg 'Fred'='Fred' Comparison is case insensitive |
| Text | Starts With |
Text starts with a value eg. 'Ref12345' starts with 'Ref' |
| Text | Ends with |
Text ends with a value eg. 'Ref12345' ends with '12345' |
| Text | Contains |
Text contains a value eg. 'Ref12345' contains '12' |
| Numeric | Equal |
Numerically Equal eg. 12.5 = 12.5 |
| Numeric | Equal With Tolerance Amount |
Numerically Equal with an amount range Tolerance, From: -3 To: 3 |
| Numeric | Equal With Tolerance Percentage |
Numerically Equal with a percentage range Tolerance From and To values indicated the top and bottom of the range as a percentage of the value Tolerance, from: -3% To: 3% 12.12 > 12.5 < 12.87 |
| Numeric | Greater Than |
Numerically Greater than eg. 15 > 12.5 |
| Numeric | Less than |
Numerically Less than eg. 10 < 12.5 |
| Date | Equal |
Date matches (Excluding the Time component) eg. 01/01/2022 = 01/01/2022 |
| Date | Equal with Tolerance Days |
Tolerance From and To values indicated the top and bottom of the range Tolerance, From: -3 To: 3 |
Actions
The actions define what process will take place for a particular outcome from the clauses
The actions are processes from the individual Statement Transactions rows point of view
| Condition | Possible Actions |
| 'On No Match' are performed when the clauses results no matching Bank Ledge record | Do nothing |
| Create Transaction |
| Condition | Possible Actions |
| 'On Single Match' are performed when the clauses result in a single Bank Ledger record (Note: this is AFTER the grouping process so several source rows may have been group together before the comparison) | Do nothing |
| Match |
| Condition | Possible Actions |
| 'On Multiple Matches' are performed when the clauses results in match to multiple Bank Ledger records | Do nothing |
| Take First (In Transaction Date Order) |
Transaction Creation
Where the resulting action is 'Transaction Creation' a new Bank Ledger transaction will be created.
This is useful when you have recurring Bank Statement lines for transactions that have not yet been entered into the finance system. Rather than having users enter the transactions manually,
A Transaction Template <LINK> is used to build the transaction.
When a transaction is created, it is created in the Finance system, posted, and pulled into ABR, then matched to the source Statement Transaction which caused the creation
