Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »


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 reoccurring 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 > ERP fast forward Bank Reconciliation. In this configuration section check the checkbox labeled “USE CUSTOM MATCHING RULES”

Basic Setup

To use custom matching, the feature must be enabled under Setup->Company->General Preferences->Custom Preferences->ERP fast forward Bank Reconciliation.

Additionally custom matching rules need to be set up under Setup > Bank Reconciliation Setup > Custom Matching Rules.

To create a new Custom Matching Rule:

  1. Give the rule a name (just for your own reference)

  2. In case there might be multiple rules matching a particular transaction, give the rule a priority. The rule with priority closest to zero will have preference over the others. Decimal numbers are allowed (for example 0.5)

  3. In the field 'Apply To', select one or multiple bank accounts that this rule applies to. Leave blank to apply to all bank accounts.

  4. Set the criteria and fields to set.


The user may for example set a matching rule for Counterparty, to automatically recognize a payment coming from a certain customer. Or when the description contains 'Bank Fees', book the amount to a certain GL account.

  • For each bank statement line all the rules are validated. 

  • If more then one rule applies to a line, all rules are executed. 

  • Custom matching overrides the automatic matching.


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

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.

Bank statement additional field

The next step is creating a custom field on the bank statement transaction line. To do this navigate to CUSTOMIZATION->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

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.

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.

  • No labels