On this page, you will find information about the option to change the matching parameters

1 Introduction
2 Standard logic
3 Custom logic
- 3.1 Adding a custom matching parameter
- 3.2 Adding the Netsuite document number parameter

Introduction

The Bank Reconciliation Suite App provides support to match transactions based on document numbers and parameters. The bank Reconciliation uses a default logic that only includes the standard Netsuite transaction ids. The bank reconciliation allows the user to change the default logic to custom logic where the system will match based on predefined fields by the user.

Standard logic

The matching algorithm can be activated on the bank account configuration by enabling one of the following checkboxes

MATCH OPEN ON DOCUMENT NUMBER OR PARAMETERS
MATCH CLOSED ON DOCUMENT NUMBER/PARAMETERS

The logic that is used when enabled is that the Bank Reconciliation Suite App searches inside the description and potential additionally added columns if it can find a match based on the default Netsuite transaction id. The description is split by the solution based on the delimiters. The default Netsuite transaction ID’s are:

Open Transactions:

Sales order number
Customer invoice number
Customer credit number
Bill number
Vendor credit number

Closed Transactions

Customer refund number
Customer payment number
Bill payment number
Journal number
Deposit number
Vendor pre-payments
Cash sales

We search in your Netsuite suite in the preset data range if we can find a fully matching transaction id and if this is the case and the transaction id is unique the solution will preselect this transaction on the bank statement line. If the amounts are fully equal the solution will also auto process the transaction after save. If there is a difference in the amounts the solution will only select the expected transaction and from here the user has to decide what should be done with the difference.

Custom logic

To alter the matching parameters navigate to SETUP->BANK RECONCILIATION->BANK ACCOUNT CONFIGURATION. Open here one bank account configuration and scroll to the bottom of the page and click on the subtab “Additional Parameters & Fields” and then on the subtab “Bank Statement Matching Parameter”.

If there are no records present in the list then it means the Bank Reconciliation is using only the default transactions ids from Netsuite. When there are records present it will mean the matching on document number and parameters will only use these fields for matching. Multiple fields are allowed.

Adding a custom matching parameter

To create a custom matching simply click on the grey button labeled “New Bank Statement Matching Parameter”. A new screen will open that provides the option to set a custom field on which the solution will start matching. In the field “Transaction field” type the custom field you would like to match on. In this example, we have a custom field named “PSP Reference”. When you select the needed field the solution will automatically populate the “Transaction field id”. When this is set correctly press the blue button labeled “Save”.

After saving the system will take you back to the bank account configuration and the section “Bank Statement Matching Parameter” should now hold the newly created record.

Adding the Netsuite document number parameter

If you also still want to match on default Netsuite document numbers and parameters you must add this matching parameter also. To do this click again on the grey button labeled “New Bank Statement Matching Parameter”. In the newly opened screen enter the following value in the field labeled “Transaction field id”: tranid and do not enter anything in the field labeled “Transaction field”. When this is set correctly press the blue button labeled “Save”.