Automated counterparty identification
Last updated
Last updated
When new transaction data is imported, the system will automatically attempt to identify the counterparty based on the account information in the transaction. If you’ve already provided account details in the Counterparty Management section, this process typically requires no further action.
However, there are specific scenarios where the default system rules may not correctly identify the counterparty:
Non-Unique Account to Counterparty Mapping: In some cases, multiple counterparties might be using the same account for transactions.
Transactions Without Account Information: When importing transaction data via business data, the original data may lack explicit account information.
To address these scenarios, you can create custom Counterparty Identification Rules:
Identifying Counterparties via Identification Code in Memo:
Please remind the counterparty to include the identification code in the memo field when making the transaction.
Assign a unique identification code to each counterparty in the Counterparty Management section (you can bulk import these using a CSV file if they are already managed in your business system).
Create custom rules that extract and use the identification code from the memo to accurately identify the counterparty.
Identifying Counterparties via Account Information in Memo:
If the memo field in the original business data contains account information, you can set up custom rules to extract the account details from the memo and use them to identify the counterparty.
Managing Rules in Automation - Identify Counterparty:
Default System Rules:
The system comes with pre-configured rules that identify counterparties based on account information. If no match is found, the transaction is marked as an “unnamed counterparty.”
System rules cannot be modified but can be enabled or disabled as needed.
Custom Rules:
You can add multiple custom rules to handle transactions under different circumstances.
Setting Rule Conditions:
Define conditions based on Platform Type, Platform, Account, and Datetime to filter which transactions a rule should apply to. This allows you to manage transactions from different data sources with specific rules.
Alternatively, you may choose to apply a rule without setting any conditions.
Defining Actions:
You can specify whether to identify counterparties based on the account or identification code.
If using account-based identification, provide a regular expression to extract the account information from the memo field.
If using identification code-based identification, provide a regular expression and specify the identification code key in the system’s counterparty records.
You can also set whether the match should be case-sensitive.
Execution of Rules:
For each transaction, the system will attempt to identify the counterparty by executing the rules in order of priority.
Once a rule successfully identifies a counterparty, no further rules will be applied to that transaction.
When new transactions are received, the system will automatically execute the counterparty identification rules for those transactions.
If you need to re-identify counterparties for all transactions, you can click on "Manually execute all rules" in the list.
Adjusting Rule Priority:
You can adjust the priority of rules by dragging them into the desired order in the rule list.
Rules at the top of the list have the highest priority, with priority decreasing down the list.