On this page, you will find information about the option to change the matching parameters
Introduction
The Bank Reconciliation Suite App provides support to match transactions based on document numbers and parameters. This 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
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 the solution will only select the expected transaction and from here the user has to decide what should be done with the difference.