Introduction

The ZoneReconcile Suite App provides support to match transactions based on document numbers and parameters. ZoneReconcile uses a default logic that only includes the standard NetSuite transaction ids. ZoneReconcile 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 ZoneReconcile SuiteApp 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	Closed Transactions
Sales Order Number	Customer Refund Number
Customer Invoice Number	Customer Payment Number
Customer Credit Number	Bill Payment Number
Bill Number	Journal Number
Vendor Credit 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 > ZoneReconcile > Bank Account Configuration. Open a 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 ZoneReconcile SuiteApp 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”.

zone_rec_bank_statement_matching_parameter_transaction_field.png

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”.

zone_rec_bank_statement_matching_parameter_transaction_field_id.png

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.

zone_rec_bank_statement_matching_parameter_transaction_field_id_example.png