Page Comparison

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

...

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.

Setup a Bank Account Configuration record

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.

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

Select the bank account (G/L Account)

2. Bank account: Select the GL Account that you want to setup

In

3. Bank: Select the

"

4. Bank file format

" field

5. , see if your bank is in the list. If yes, select it. If no,

proceed to step 3

6. refer to the detailed table below.

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

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

BankstatementsSelect a Default Tax Code.

7. 1. Bank statements

8. Statements Folder ID: enter the folder internal ID that was noted in step "create a folder"

Import and Statement Preferences:

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

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

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

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

   Multimedia
   name Bank Account Config - General.mp4

Setup preferences for the bank account (subtab Preferences).

Set Payment Method
5. Disable reconciliation warnings: will disable the yellow WARNING boxes after saving a bank statement.

Matching Preferences:

Payment Difference Reasons:

Processing Preferences:

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

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

3. Create Journal instead of Customer Deposit

As Journal will create a journal entry

4. : Check if a customer deposit should be created as journal instead of a customer deposit.

5. Create Customer Payment instead of Customer Deposit
transaction. For advice please contact support@fastfour.com.
6. : Determine your preferred transaction type to be created.

7. Create Vendor

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

8. Pre-Payment as Journal: 

9. Create Journal instead of check:

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

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

11. Defaults:

1. You may choose to select a default Department, Class and Location for this bank account.

2. The value selected here will appear on all payment transactions created by the tool.

Setup

...

Additional Parameters & Fields:

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.

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

Bank Statement Additional Fields

...

:

To use this feature, first enable it under Setup > Company > General Preferences > Custom Preferences > Fast Four 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.

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

...