Auto Bank Statement Import SFTP Configuration in NetSuite 2026.2

TL;DR: In NetSuite 2026.2, the SFTP configuration for Auto Bank Statement Import (ABSI) has been enhanced to include a new Download Filename Pattern field, allowing for improved file management during imports.

What's New in SFTP Configuration

In the latest update of NetSuite, specifically version 2026.2, users can now utilize the Download Filename Pattern field in the SFTP connection settings. This feature enables customization of file names for bank statement imports using regular expressions and reserved words. Such flexibility is designed to streamline the management of imported files from the bank's server.

How to Configure the SFTP Connection

To integrate your SFTP connection effectively for the Auto Bank Statement Import, follow these steps:

1. Navigate to Setup > Accounting > Financial Statements > Financial Institutions > List.
2. Locate your financial institution record and click View.
3. Access the Format Profile: Configuration subtab and select the desired format profile.
4. Click Edit on the format profile page to enter connectivity configurations.
5. On the Connectivity Configuration subtab, adjust the following fields:
   • URL: Specify your bank's SFTP URL.
   • Username: Enter the SFTP username assigned by your bank.
   • Digital Certificate or Private Key: Select an ID if your bank requires these for authentication.
   • Password: Enter your SFTP password, enabling the field after entering a URL.
   • Host Key: Provide your bank's host key for secure connections.
   • Host Key Type: Select the appropriate key type, such as RSA, DSA, or ECDSA.
   • Port: Enter the port number (0-65535) for connection.
   • Download Filename Pattern: Configure your preferred filename pattern using reserved words and regular expressions. The system will automatically replace these with the correct dates as specified in your pattern.
   • Bank Server Time Zone (GMT): Specify the GMT time zone for date replacements in filenames.
   • Date Format for Reserved Word: Enter format specifications for dates; the default is YYYYMMDD.
   • Download Directory: Specify the path to where files will reside.
   • Use Absolute Path: Check this if your bank requires it for access.
   • Download Timeout: Set a timeout interval (1-300 seconds) for downloads.
6. Click Submit to save your settings.

Who This Affects

This new configuration is relevant for:

• Administrators: Setting up and maintaining banking connections.
• Developers: Integrating banking services with existing systems.
• Finance Teams: Importing bank statements efficiently without errors.

Key Takeaways

• The Download Filename Pattern field enhances file import management in NetSuite 2026.2.
• Users can now specify filename patterns using regular expressions and reserved words for automated date handling.
• Configuring SFTP connections allows for custom authentication methods, enhancing security and flexibility.
• This update streamlines the bank statement import process, making it more reliable and user-friendly.