Setting Up Auto Bank Statement Import

To set up the Auto Bank Statement Import feature:

1. Create a financial institution record. See Creating Financial Institution Records.

2. Add a format profile to the financial institution record. For more information, see Creating Format Profiles for Bank Reconciliation.

   When you create a format profile that uses SFTP, set these fields:

   1. Connectivity Method – Select SFTP Connectivity.

   2. Transaction Parser – Select any standard or custom Bank Statement Parser Plug-in.

      For more information about the available standard parser plug-ins you can use for the ABSI SuiteApp, see Bank Statement Parsers SuiteApp.

3. Set up your SFTP credentials on the Connectivity Configuration subtab of the format profile. For details, see steps 5 – 6 of Configuring SFTP Connection for Auto Bank Statement Import.

4. Go to the Account Linking subtab to map your financial institution data to the right GL accounts in NetSuite. For more information, see Linking Accounts for Financial Institution Connectivity.

   If you're using a standard bank statement parser and need more information about mapping keys, see Identifying Unique Account IDs for Standard Bank Statement Parsers.

5. (Optional) Map custom bank codes to the correct bank data types. For details, see Mapping Custom Bank Codes.

   If you're using a standard bank statement parser, standard transaction codes are already mapped. For MT940, for example, standard SWIFT codes are included. Only do this step if your bank uses custom transaction codes or you want to override the standard mapping.

   To see which transaction codes are supported for each format, read Supported Transaction Codes for Bank Statement Parsers SuiteApp.

6. If you're using a standard BAI2 or MT940 transaction parser, set it up on the Parser Configuration subtab of your format profile. For details, see Configuring Standard Bank Transaction Parsers.

7. Click Save.

Related Topics