Bank GL accounts must be setup before importing bank statements. (Also if bank statements are entered manually these bank accounts must be setup)
For each of the Bank Statements you wish to use with this SuiteApp, one Bank Statement Configuration record must be created.
...
A Bank Statement Configuration must be created for each of the Bank accounts (NetSuite GL Accounts).
| Info |
|---|
For the following step you must have the Show Internal IDs preference enabled. If this preference is not enabled, go to Home > Set Preferences. Under General tab, Default section, mark Show Internal IDs. Click Save. |
CSV Configuration: This records tells Fast Four Bank Reconciliation how to interpret the csv file that you will import. Also some bank account-specific preferences can be set here.
...
Payment Method: will set the payment method on the resulting bank transaction
Create Journal instead of Customer Deposit: Check if a customer deposit should be created as journal instead of a customer deposit.
- Create Customer Payment instead of Customer Deposit: Determine your preferred transaction type to be created.
Create Vendor Pre-Payment as Journal: When applying a vendor without a GL account on the line.
- Create Journal instead of check: When applying a vendor and GL account on the line.
Based on above checkboxes, the fields Vendor Prepayment Holding Account, Default Payables Account, Default Receivables Account and Exempt Tax Code may become mandatory. Be sure to select values for the mandatory fields.
Defaults:
You may choose to select a default Department, Class and Location for this bank account.
The value selected here will appear on all payment transactions created by the tool.
- Overrule Journal Approval: Please check this option if you have any journal approval workflows in NetSuite
...
Click Save. Congratulations, you are ready to import bank statements!
| Info |
|---|
Please note that the most left column of a CSV file is column 0 |
| Field | Description |
|---|---|
| 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 support@fastfour.com 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.Bank CountryOnly has effect if you choose Finland or Switzerland as country. |
| 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. |
| Decimal Separator | Choose the amount decimal delimiter. If left blank, a dot is used. |
| CSV Delimiter | Choose the CSV delimiter. If left blank, a comma 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. |
...