On this page, you will find information about the option to change the matching parameters
| Table of Contents |
|---|
Introduction
The Bank Reconciliation Suite App provides support to match transactions based on document numbers and parameters. This 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
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”.
