General Information

With a custom matching rule, you could simply create custom logic that the Credit Card Statement SuiteApp will apply to certain recurring credit card 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.

Basic Setup

To create a custom matching rule navigate to Setup > Credit Card Import Setup > Custom Matching Rules and press the blue button labeled “New Credit Card Custom Matching Rule”. On the page that opens set the following values:

It's possible to create a new custom matching rule instantly from the statement by selecting the column and press the plus icon. This will take the user directly to the next step.

• Name: Provide a descriptive name for the field (this will be visible on the credit card statement identifying which rule was applied)
• Apply to: Select here on which credit card account the rule applies. This can be multiple if a rule is general
• If description: You can select “contains” or “is”. “Contains” means a part of the value can be found in the description and “is” means that the value should be fully equal to the description.
• Value (Description): The value the system must search for

In the section “Then” you can set the default values that the custom matching rule should set.

Extending Fields

If you would like to set additional prefixed data like for example a custom segment 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 “Credit Card 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 > Credit Card Import Setup > Credit Custom Matching Rule > New you should see the newly created field on the page.

2) Credit Card Statement Additional Field

The next step is creating a custom field on the credit card statement transaction line.

To do this navigate to Customization > List, Records & Fields and locate here the record type named “Credit Card Transaction CR” 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

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 Rule
• Source from: select here your created set field from the previous step

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 > Credit Card Import Setup > Credit Card Configuration. Open on this page the credit card configuration that should use this data while creating transactions.

On the credit account configuration page scroll to the bottom and click on the subsection “Additional Fields”. Click here the grey button on the left-hand side labeled “New Credit Card Additional Fields”.

On the page that opens set the following values:

• Name: Provide a descriptive name for the configuration
• Credit card transaction field id: Copy here the internal id from the created field
• Transaction field: Select here the field where the data must be copied to
• Transaction field id: This will be automatically populated after selecting the “Transaction field”. When working with a custom segment change the value to the actual internal id from the custom segment.
• 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.

For each credit card statement line all the rules are validated

If more then one rule applies to a line, all rules are executed and if the rules contain overlapping field values, the newest created rule will prevail

Custom matching does not override the automatic matching, if enabled