1. Accounting
  2. Banking
  3. Auto Bank Statement Import SuiteApp
  4. Setting Up Auto Bank Statement Import

Setting Up Auto Bank Statement Import

With the Auto Bank Statement Import (ABSI) SuiteApp, you can create your own financial institution record and set up your format profile for SFTP connection.

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.

If successful, you'll be redirected to the financial institution page, and NetSuite will show a message that the import process has started. To check the status, click Track your status.

Configuring SFTP Connection for Auto Bank Statement Import

When you use the Auto Bank Statement Import (ABSI) SuiteApp, you'll need an SFTP connection to link NetSuite to your bank’s server. You can set up your SFTP connection in NetSuite by providing either or both of the following:

  • Digital Certificate or Private Key

  • Password

If your bank needs two-factor authentication, make sure you provide both to connect successfully.

You can also set a file name pattern so the SFTP Connectivity plug-in knows which files to import into NetSuite.

To configure your SFTP connection on the format profile record:

  1. Go to Setup > Accounting > Financial Statements > Financial Institutions > List.

  2. On the Financial Institutions page, click View next to your financial institution record.

  3. On the Format Profile: Configuration subtab, click the format profile you want to use for SFTP.

  4. On the format profile page, click Edit to set up your connectivity configuration.

  5. On the Connectivity Configuration subtab, set the following fields:

    • URL – Enter your bank's URL.

      Note:

      If you edit the URL in an existing format profile, the Password field will be cleared. Make sure you reenter your SFTP password before submitting.

    • Username – Enter your SFTP username.

    • Digital Certificate or Private Key – If your bank needs authentication with a certificate or key, select the right ID here.

      You can use a digital certificate or private key instead of a password to connect to your bank’s server. Find digital certificates in Setup > Company > Preferences > Certificates, and private keys in Setup > Company > Preferences > Keys.

      For more information about storing and managing them, see Uploading Digital Certificates and Uploading Private SSH Keys.

    • Password – If your bank needs a password for authentication, enter your SFTP password.

      Note:

      When you create a new SFTP configuration, the Password field is disabled by default. To enable it, enter a value in the URL field first.

    • Host Key – Enter your bank's SFTP host key. You'll need this even if you use a digital certificate or private key instead of a password.

      Read the following topics for more information about SFTP Host Keys:

    • Host Key Type – Select the host key type: RSA, DSA, or ECDSA.

    • Port – Enter the port number that will connect to the remote account. Port number value must range from 0 to 65535.

    • Download Filename Pattern – Set up a file name pattern using regular expressions and reserved words. Use reserved words in curly brackets as date variables, and they'll be replaced with the right dates in the final file name.

      Note:

      When you use reserved words, you'll need to set the Bank Server Time Zone (GMT) and Date Format for Reserved Word fields.

      If you leave this field blank, the system will match and grab whatever file is available on the bank’s server.

      Sample Filename Pattern: MyBank_[0-9]{5}_{DateToday}.txt

      Filename: MyBank_00198_08042019.txt

      The reserved words are available in the following table. The sample values below assumes that the current date is August 4, 2019, and the date format is MMDDYYYY.

      Reserved Word

      Description

      Sample Value

      DateToday

      This reserved word will be replaced with the date today.

      08042019

      DateLastBusinessDay

      This reserved word will be replaced with the date of the previous business day.

      Only the days between, and including, Monday through Friday are considered business days.

      08022019

      DateYesterday

      This reserved word will be replaced with the date yesterday.

      08032019

      DateLastMonthEnd

      This reserved word will be replaced with the date of the previous month’s last day.

      07312019

      DateStartOfTheMonth

      This reserved word will be replaced with the date of the current month’s first day.

      08012019

    • Bank Sever Time Zone (GMT) – Select the time zone to use for the date that will replace the reserved word in the file name pattern. If left blank, NetSuite will use the time zone from your User Preferences.

      Valid time zones are between -12:00 to +13:00, in 15-minute intervals, with leading zeros if needed, and a plus or minus sign. For example, +08:00 and -08:15 are valid.

    • Date Format for Reserved Word – Enter a date format for the reserved words in your filename pattern. This is required if your filename pattern uses reserved words.

      This field defaults to YYYYMMDD by default.

      A valid date format can use:

      • 2 – 3 M (month) characters

      • 2 D (day) characters

      • 2 or 4 Y (year) characters

      • may include a hyphen (-) separator

    • Download Directory – Enter the path to the folder with the bank statement file. By default, this a relative path.

    • Use Absolute Path – Check this box if your bank uses an absolute path. The system will treat the URL format entered in the Download Directory field as an absolute path.

    • Download Timeout – Enter how many seconds to allow for the file to download. The value must be between 1 and 300.

      This field defaults to 300.

  6. Click Submit.

After you set up your SFTP connection on the Connectivity Configuration subtab, go to the Account Linking subtab. See step 4 of setting up the Auto Bank Statement Import feature for more information.

Related Topics

General Notices