BankIt Intelligence Setup
The BankIt Intelligence Rule consists of the following components.
| 1 | Description | Which is defined by the Description dropdown. |
| 2 | Parameter | each category has different parameters. |
| 3 | GL Account | The GL Account that this rule will use when creating the cash book. |
| 4 | Debit Description | The Debit Description will be used when the statement amount is positive. |
E.g. Payment received from …
| 5 | Credit Description | The Credit Description will be used when the statement amount is negative. |
E.g. Payment made to …
| 6 | Region | |
| 6.1 | No Action | No Region will be retrieved and written into the cash book line. |
| 6.2 | Use Defaults |
The Default Region will be retrieved from the GL Account, Debtor or Creditor and written into the cash book line. |
| 6.3 | Apply |
A specific region can be selected from the dropdown for this rule and written into the cash book line. |
| 7 | Division |
|
| 7.1 | No Action |
No Division will be retrieved and written into the cash book line. |
| 7.2 | Use Defaults |
The Default Division will be retrieved from the GL Account, Debtor or Creditor and written into the cash book line. |
| 7.3 | Apply |
A specific division can be selected from the dropdown for this rule and written into the cash book line. |
| 8 | Project |
|
| 8.1 | No Action |
No Project will be retrieved and written into the cash book line. |
| 8.2 | Apply |
A specific project can be selected from the dropdown for this rule and written into the cash book line. |
| 9 | Apply |
The rules can be switch on and off be either ticking or unticking the apply tick box. |
.png)
There are 6 categories of intelligence rules.
1. Test All Debtors – There can only be one occurrence of this rule.
The system will not allow another one to be created. This is a System rule and cannot be deleted.
Parameters – All.
| GL Account | Typically Debtors Control Account. |
| Debit Description | Payment Receive From (special characters in the description. |
The following code will be replaced by [C] debtor code, [N] debtor name, [CN] code and name.
| Credit Description | Payment Reversed To (special characters in the description. |
| Region | Only No Action or Use Defaults is applicable. |
| Division | Only No Action or Use Defaults is applicable. |
| Project | Only No Action or Apply. Select a specific Project from the dropdown. |
| Apply | Switch On or Off |
How the rule is applied: Each statement line is tested for the various debtor code.
Each statement line is tested for the debtor name. Each individual word in the debtor name is tested against the words in the statement line.
At least two word must match and no word less than three characters is tested.
2.Test All Creditors – There can only be one occurrence of this rule.
The system will not allow another one to be created.
This is a System rule and cannot be deleted.
Parameters – All.
| GL Account | Typically Creditors Control Account. |
| Debit Description | Made Payment To (special characters in the description. |
The following code will be replaced by [C] creditor code, [N] creditor name, [CN] code and name.
Credit Description – Payment Reversed To (special characters in the description.
Region – Only No Action or Use Defaults is applicable.
Division – Only No Action or Use Defaults is applicable.
Project – Only No Action or Apply. Select a specific Project from the dropdown.
Apply – Switch On or Off
How the rule is applied: Each statement line is tested for the various creditor code.
Each statement line is tested for the creditor name.
Each individual word in the creditor name is tested against the words in the statement line.
At least two word must match and no word less than three characters is tested.
3. Compare Words in a line – Test accuracy and weight %.
This rule can be created with difference parameters as many times as necessary.
Parameters – Any words that may appear in the statement line.
The words do not have to be in any specific order as each word is individually tested.
GL Account – Any GL Account that would apply to the bank statement transaction.
Debit Description – Payment from
Credit Description – Payment to.
Region – All options are available for use.
Division – All options are available for use.
Project – Only No Action or Apply. Select a specific Project from the dropdown.
Apply – Switch On or Off
How the rule is applied : Each individual word in the parameters is tested against the words in the statement line.
At least two word must match and no word less than three characters is tested.
4. Test First X characters and what to search for.
This rule can be created with difference parameters as many times as necessary.
Parameters – 7||Vodacom. The parameter must consist of 3 components, a number representing the number of characters that are to be search for in the statement line.
2 vertical line (pipes) which are used as the separator between the number and the actual word or words.
The last component is the word or words that are to be tested for.
If the word component is more than one word then the words must be as would be expected to be found in the statement line.
GL Account - Any GL Account that would apply to the bank statement transaction.
If either the Debtors Control Account or the Creditors Control Account is used then the process will attempt to find the debtors or creditor name in the statement line.
If the debtor or creditor is not found then this rule will be skipped as unsuccessful.
Debit Description – Payment from
Credit Description – Payment to.
Region – All options are available for use.
Division – All options are available for use.
Project – Only No Action or Apply. Select a specific Project from the dropdown.
Apply – Switch On or Off
How the rule is applied : E.g. 7||Vodacom The process takes the word part of the parameter and attempts to find it in the first (in this case) 7 characters of the statement line.
Spaces between words also count as characters.
5. Test Last X characters and what to search for.
This rule can be created with difference parameters as many times as necessary.
Parameters – 8||& Petrol.
The parameter must consist of 3 components, a number representing the number of characters that are to be search for in the statement line.
2 vertical line (pipes) which are used as the separator between the number and the actual word or words.
The last component is the word or words that are to be tested for.
If the word component is more than one word then the words must be as would be expected to be found in the statement line.
GL Account - Any GL Account that would apply to the bank statement transaction.
If either the Debtors Control Account or the Creditors Control Account is used then the process will attempt to find the debtors or creditor name in the statement line.
If the debtor or creditor is not found then this rule will be skipped as unsuccessful.
Debit Description – Payment from
Credit Description – Payment to.
Region – All options are available for use.
Division – All options are available for use.
Project – Only No Action or Apply. Select a specific Project from the dropdown.
Apply – Switch On or Off
How the rule is applied : E.g. 8||& Petrol The process takes the word part of the parameter and attempts to find it in the last (in this case) 8 characters of the statement line.
Spaces between words also count as characters.
6. Test In Line for words and phrases. This rule can be created with difference parameters as many times as necessary.
Parameters – Any word or words (phrase) that could appear in the statement line, typically words that would appear together.
GL Account - Any GL Account that would apply to the bank statement transaction.
If either the Debtors Control Account or the Creditors Control Account is used then the process will attempt to find the debtors or creditor name in the statement line.
If the debtor or creditor is not found then this rule will be skipped as unsuccessful.
Debit Description – Payment from
Credit Description – Payment to.
Region – All options are available for use.
Division – All options are available for use.
Project – Only No Action or Apply. Select a specific Project from the dropdown.
Apply – Switch On or Off
How the rule is applied: The process takes the word or words and attempts to find it in the statement line.
BankIt Rules Maintenance (Adding or Editing)
| Rule Type | |
| Parameter | |
| GL Account | |
| Debit Description | |
| Credit Description | |
| Select Region | |
| Select Division | |
| Select Project | |
| Apply Tick | |
| System Rule | |
| Run Last |