Bank account configuration

Bank accounts must be setup before importing bank statements. Also if bank statements are entered manually these bank accounts must be setup.

1. Setup a folder to store bank statements

1. Go to Documents (click on the tab)

2. Click on New Folder

3. Give the folder a name

4. Enter all other information and restrict access as necessary

5. Click Save

6. Take note of the Internal ID of the folder, which is displayed in the file cabinet under the Internal ID column.

2. Setup a Bank Account Configuration record

   1. This records tells ERP fast forward Bank Reconciliation how to interpret the csv file that you will import. Also some bank account-specific preferences can be set here.

   2. Go to Setup > Bank Statement Setup > Bank Account Configuration > New

   3. Select the bank account (G/L Account) that you want to setup

   4. In the Bank field, see if your bank is in the list. If yes, select it. If no, proceed to step 3 below.

   5. Once the bank is selected, most necessary field defaults will be populated. Some need to be done manually.

   6. If Payment Method is a mandatory field on the Customer Payments, select which payment method you wish to use for customer payments that are created through Easy Bankstatements

   7. Select a Default Tax Code. This 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). For non-VAT nexuses, choose -Not Taxable-

   8. In Statements Folder ID, enter the folder internal ID that was noted in step 1-6

   9. Click Save. Congratulations, you are ready to import bank statements!

      If there was no default bank configuration for your bank, you may enter the values manually. See below table for a description of all fields.

3. Setup preferences for the bank account (subtab Preferences).

   1. Set Payment Method will set the payment method on the resulting bank transaction

   2. Disable reconciliation warnings will disable the yellow WARNING boxes after saving a bank statement.

   3. Create Customer Deposit As Journal will create a journal entry instead of a Customer Deposit transaction. For advice please contact support@fastfour.com.

   4. Create Vendor Preprayment as Journal will create a journal entry instead of a Check and Vendor Credit. For advice please contact support@fastfour.com.

   5. Based on those 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.

   6. Create Journal instead of Check will not create any checks, the tool will create journals instead

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

4. Setup Custom Matching Parameters. 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.
   
   1. 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.
   2. In Transaction Field, select the field in which the value should appear
   3. 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.
   4. 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.
5. Setup Additional Fields. To use this feature, first enable it under Setup > Company > General Preferences > Custom Preferences > ERP FF Bank Reconciliation > 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.
   1. 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
   2. In NetSuite Field, select the field in which the value should appear
   3. 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.
   4. 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.
   5. Feel free to contact support@fastfour.com for questions about this functionality.