Create custom matching rules
This page explains how you can set up custom matching rules and how you extend the predefined fields
General Information
With a custom matching rule, you could simply create custom logic that the Bank Reconciliation Suite App will apply on a certain recurring bank statement transaction lines. With this logic, you can predefine values like department, class, and location. The custom matching rules can even be extended with custom fields and segments.
Enable feature
To use the custom matching rule feature you must first enable this feature by navigating to Setup>Company>General Preferences>Custom Preferences>Fast Four Bank Reconciliation.
In this configuration section check the checkbox labeled “USE CUSTOM MATCHING RULES”
Basic Setup
To create a custom matching rule navigate to Setup>Bank Reconciliation Setup->Custom Matching Rules and press the blue button labeled “New Bank Statement Custom Matching Rule”. On the page that opens set the following values:
Name: Provide a descriptive name for the field (this will be visible on the bank statement identifying which rule was applied)
Priority: If you have multiple rules reacting to the same values you can set the priority. The closer to zero the higher the priority
Apply to d/c: Select here when to apply the rule. (Recommend is to limit this option to debit or credit only)
If description: Select here if it contains or is equal
Value (Description): The value the system must search for
If counterparty: Select here if it contains or is equal
Value (Counterparty): The value the system must search for
Set select: When enabled the line will be auto processed after saving the statement
Select in the fields “Set” potential values that you would like to default when all matching criteria were met.
When all the mandatory fields are set press save. The next import or “Run Match” will now apply the newly created custom matching rule
Remark:
The “IF” section can handle only or, so the means that if the description is populated the system won’t use the counterparty. If the description is empty the system will use the counterparty
Extending Fields
If you would like to set additional prefixed data like for example a “profit center” you can extend the available fields under the section Then…
Extending the field is done in three steps:
1) Custom matching rule additional field
To create an additional field setting under the “Then…” section you must navigate to Customization>List, Records & Fields.
Locate here the record type named “Bank Statement Custom Matching Rule” and open it. On the left side, there is a grey button labeled “New Field”. Press this button to start entering the newly needed field.
On the page that opens set the following values:
Label: Provide a descriptive name for the field (this will be visible on the custom matching rule for the users)
Description: Optional, may be entered if required
Type: This should be the type “List/Record”
List/Record: Select here the list from which the user can select values
Store Value: Must be checked
Show In List: Must be checked
Help: Optional, but recommended to guide the user
Additional settings may be set if needed. When all the mandatory fields are set press save.
If you would now navigate to Setup>Bank Reconciliation Setup>Custom Matching Rules>New you should see the newly created field on the page.
2) Bank statement additional field
The next step is creating a custom field on the bank statement transaction line.
To do this navigate to Customisation>List, Records & Fields and locate here the record type named “Bank Statement Transaction” and open it.
On the left side, there is a grey button labeled “New Field”. Press this button to start entering the newly needed field.
On the page that opens set the following values:
Label: Provide a descriptive name for the field (this will be visible on the bank statement)
Description: Optional, may be entered if required
Type: This should be the type “List/Record”
List/Record: Select here the list from which the user can select values
Store Value: Must be unchecked
Show In List: Must be checked
Help: Optional, but recommended to guide the user
Unchecking the “Store Value” checkbox will mean that the values from your custom segment are sourced to the statement on the matched line, however the custom segment column on the bank statement will not be editable anymore, in other words, this column will not be present in edit mode anymore for manual correction (for all lines). Please consider whether you want the custom segment values to be automatically populated via the custom matching rules or you prefer manual intervention on the bank statement.
By default, the new field will be visible at the end of the statement. If you want a specific location then select the location under “Insert Before”. You can’t change this later on.
On the subtab labeled “Sourcing & Filtering” set the following options:
Source list: Custom Match
Source from: select here your created set field from the previous step
When all the mandatory fields are set press save.
3) Copy data to the transaction
To actually copy the data to a transaction we do need to link the data to the transaction with a configuration.
Navigate to Setup>Bank Reconciliation Setup>Bank Account Configuration. Open on this page the bank account configuration that should use this data while creating transactions.
On the bank account configuration page scroll to the bottom and click on the subsection “Additional Parameters & Fields” and then click on the subsection “Bank Statement Additional Fields”. Click here the grey button on the left-hand side labeled “New Bank Statement Additional Fields”.
On the page that opens set the following values:
Label: Provide a descriptive name for the configuration
Bank statement transaction field: Select here your created field from the previous step
Netsuite field: Select here the field where the data must be copied to
Apply to: Select here a specific transaction type, or leave it empty to apply to all transaction types
Body or line level: Select here if the value should be stored on the body or line level
When all the mandatory fields are set press save. The next reconciliation should now store the selected value on the created transactions.