When using the Auto Bank Statement Import (ABSI) SuiteApp, an SFTP connection is required to connect NetSuite to your financial institution’s server. You can configure your SFTP connection in NetSuite by providing one or both information :
- Digital Certificate or Private Key
- Password
If your financial institution requires two-factor authentication, be sure to provide both information to successfully connect to your financial institution’s server.
You can also set a file name pattern that enables the SFTP Connectivity plug-in to identify which files to import into NetSuite.
To configure your SFTP connection on the format profile record:
- Go to Setup > Accounting > Financial Statements > Financial Institutions > List.
- On the Financial Institutions page, click View next to your financial institution record.
- On the Format Profile: Configuration subtab, click the format profile you want to use for SFTP connectivity.
- On the format profile page, click Edit to view and set up your connectivity configuration.
- On the Connectivity Configuration subtab, set the following fields:
- URL – Enter the URL for the connecting financial institution.
- Username – Enter your SFTP account username.
- Digital Certificate or Private Key – If your bank requires account authentication through a certificate or key, select a Digital Certificate or Private Key ID. A digital certificate or private key may be used in place of a password to establish a connection to the financial institution’s server. The digital certificate is available in Setup > Company > Preferences > Certificates. The private keys are available in Setup > Company > Preferences > Keys. For more information about how they are stored and managed, see Uploading Digital Certificates and Uploading Private SSH Keys.
- Password – If your bank requires account authentication through a password, enter your SFTP account password.
- Host Key – Enter the host key of the financial institution’s SFTP server. The host key is required even if Digital Certificate or Private key ID is supplied instead of a password. Read the following topics for more information about SFTP Host Key:
- Obtaining the Host Key
- Host Key Verification
- Retrieving the Host Key of an External SFTP Server
- Host Key Type – Select the host key type for this configuration. The host key type can be any of the following: 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 – You can set up a file name pattern using regular expressions and reserved words. You can use the reserved words, enclosed in curly brackets, as date variables in your file name pattern. The final output of the file name will be replaced with the appropriate dates.
- Bank Sever Time Zone (GMT) – Select the time zone that will be used to determine the date that will replace the reserved word in the file name pattern. If left blank, the time zone defined in the User Preferences page will be used instead. A valid time zone must be between -12:00 to +13:00. The time zone values must be in 15-minute intervals, include leading zeros (if applicable), and may include +or -sign. For example, +08:00 and -08:15 are valid time zones.
- Date Format for Reserved Word – Enter a date format that will apply to the reserved words in your filename pattern. A date format is required if the filename pattern contains reserved words. The value of this field is set to YYYYMMDD by default. A valid date format may have a combination of the following:
- 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 directory that contains the bank statement file to download. By default, the value entered in this field is treated as a relative path.
- Use Absolute Path – Check this box if your financial institution uses an absolute path directory. By checking this box, the system treats the URL format entered in the Download Directory field as an absolute path.
- Download Timeout – Enter the number of seconds to allow for the file to download. Download timeout value must be between 1 and 300. The value of this field is set to 300 by default.
- Click Submit.
After configuring your SFTP connection on the Connectivity Configuration subtab, continue to the Account Linking subtab.