Bank Statement Matching Parameter
Use this feature only if you have specific requirements for which fields should be used for matching, such as matching based on payment reference number, PO number or multiple matching fields.
- In the sublist for Custom Matching Parameters you can list the NetSuite fields that contain values for matching. The match value in the bank file should be in one of the three Description columns.
- In Transaction Field, select the field in which the value should appear
- In Transaction Field ID the Script ID will appear automatically after selecting a field. You may also simply type in the script ID of the field from the Record Browser instead of selecting a field.
- If you use this feature, only the fields in this list will be used for matching. If matching on Document Number is required, add 'tranid' to the list of fields.
Bank Statement Additional Fields:
To use this feature, first enable it under Setup > Company > General Preferences > Custom Preferences > ZoneReconcile > Use Additional Fields. Additional fields may be useful when there is additional information in the csv bank statement that you wish to record on the payment transactions. You may enter as many as you want. This only works for fields of type Transaction Body Fields.
- In CSV Column, enter the column that holds the value that you want to place on the payment transaction (please note the most left column of a csv is column 0
- In NetSuite Field, select the field in which the value should appear
- In the NetSuite Field ID field the Script ID will appear automatically after selecting a field. You may also simply type in the script ID of the field from the Record Browser instead of selecting a field.
- Leave Apply to empty if you want the value to appear on all transactions. Select a transaction to only make it appear on one transaction. Should the value appear on more then one, but not all records, then add new lines for each transaction.
- Questions, then please reach out to our support team by filling out the form on our support page
Click Save. Congratulations, you are ready to import bank statements!
Please note that the most left column of a CSV file is column 0
|Description column 1, 2 & 3||Description Column 1, 2 and 3 are both used to collect possible invoice numbers, to match with open transactions. They are also displayed as memo. You may choose to only enter 1. If you also provide a value in Description Column 2, the values in these two columns are joined. The same applies for Description Column 3.|
|Remove Leading Zero's||If the description column contains leading zeros that should be removed, check this box.|
|Debit/Credit Column||Debit/Credit column is used when there is a specific column in the statement that specifies if the amount was debited or credited from the account. If not specified, Easy Bank Statements will look for negative and positive amounts.|
|Debit/Credit Identifier||Debit/Credit Identifier tells the tool what values to expect in the Debit/Credit column. When set to Separate Columns, the Debit column must be put in field 'Debit/Credit Column' and the Credit column must be put in field 'Amount'.
Contact firstname.lastname@example.org if the necessary values are not in this list.
|Amount Column||Amount column is the column number that holds the amount.|
|Date Column||Date column is the column number that holds the date.|
|Tax Country||Tax Country determines which tax codes are accepted.|
|Default Tax Code||Default Tax Code is used when you are processing payments that do not have a bill or invoice. For example, payments that were done by debit card. Then the tax is automatically calculated, unless you change the tax code on the line. If you do not wish to have tax calculated, select an Exempt tax code. (usually E-XX, for example E-NL, or -Not Taxable-)|
|Has CSV Header Row||
Check whether the first row of the CSV file is a header instead of transactional data. If this is the case make sure this checkbox is 'checked’.
|Number Of Header Rows||
If there are multiple header rows, enter the number of header rows here. If there is only 1, only checking the box will suffice.
|Number Of Trailing Rows||
If there are trailing rows in the csv file that should be excluded from the statement, enter the number here. Leave blank if there aren't any.
|Statements Folder ID||
Enter the internal ID of the folder used to store bank statement files.
|CSV Date Format||
Select the date format used in the CSV file. Raise a support case if the necessary values are not in this list.
|Counter Party Column||
Counter Party column should hold the column number for the Counter Party of the bank transaction.
Choose the amount decimal delimiter. If left blank, a dot is used.
Choose the CSV delimiter. If left blank, a comma is used.
Set of characters based on which description strings are separated and used in matching. When left blank, "\s,:;/." is used.
|Disable Automatic Matching||
'Check' this box if automatic invoice/bill matching should not take place.
|Match Transactions On||
Mostly Invoice Number would be selected here. Sometimes, usually with e-commerce payment gateways, the sales order number is specified in the file.
|Process Empty CSV||
Check this to automatically generate Bank Statements for empty files retrieved via the scheduled data retrieval tool.