Bank Statement File Name Import Matching

The Auto Bank Statement Import (ABSI) SuiteApp uses the file name pattern you set in your SFTP connection to find an import the right bank statement files into NetSuite. The table below shows how the system handles your bank data imports in different situations.

Scenario	Result
No file match or no available file on your bank's server.	The bank statement import won't work.
File matches, but the system sees that the same file name was already imported from this bank.	The bank statement import won't work. If files aren't uploaded because of parsing errors, you'll need to delete the failed import records before you can upload them again. For more information, see Deleting SFTP Connectivity Failed Import Record.
File has a parsing error and the same name as a file you already imported from another bank.	The bank statement import won't work. First, check why your import failed so you can fix the error. Then, delete the failed import record so the system can import a file with a similar name from another bank. Note: To find which import record to delete, look for the Internal ID or Configuration ID in the execution log of the failed import. For more information, see Deleting SFTP Connectivity Failed Import Record. After you delete the failed import record, you can ask the system to try importing again. To do this, see Updating Imported Bank Statement Files.
A file matched and was imported into NetSuite, but there are still matching files on your bank’s server that haven't been imported.	This can happen if the system finds more than one file that matches your file name pattern. If there are several matching files, the system only imports the first one. The rest are imported during the next scheduled import, or you can get them right away by asking the system import again. To upload the rest manually, see Updating Imported Bank Statement Files. If you're an Administrator, you can check the execution log of your import details record to see if there are files still waiting to be imported into NetSuite. To do this: As an Administrator, go to Customization > Plug-ins > Plug-In Implementations. Click the SFTP Connectivity plug-in implementation. On the Execution Log subtab, look for the log related to your import detail record. In the Details column, you'll see a message if there are files still waiting on your bank’s server.
The Download Filename Pattern field on your SFTP connectivity configuration is blank	If there's more than one file on your bank's server, the system only imports the first file that's not already in NetSuite. The rest of the files are imported during the next scheduled import, or you can get them right away by asking the system to import again. To upload the rest manually, see Updating Imported Bank Statement Files. If you’re an Administrator, you can check the execution log of your import details to see if there are files still waiting to be imported into NetSuite. To do this: As an Administrator, role, go to Customization > Plug-ins > Plug-In Implementations. Click the SFTP Connectivity plug-in implementation. On the Execution Log subtab, look for the log related to your import detail record. In the Details column, you'll see a message if there are files still waiting on your bank’s server.

Scenario

Result

No file match or no available file on your bank's server.

The bank statement import won't work.

File matches, but the system sees that the same file name was already imported from this bank.

The bank statement import won't work.

If files aren't uploaded because of parsing errors, you'll need to delete the failed import records before you can upload them again. For more information, see Deleting SFTP Connectivity Failed Import Record.

File has a parsing error and the same name as a file you already imported from another bank.

The bank statement import won't work.

First, check why your import failed so you can fix the error. Then, delete the failed import record so the system can import a file with a similar name from another bank.

Note:

To find which import record to delete, look for the Internal ID or Configuration ID in the execution log of the failed import.

For more information, see Deleting SFTP Connectivity Failed Import Record.

After you delete the failed import record, you can ask the system to try importing again. To do this, see Updating Imported Bank Statement Files.

A file matched and was imported into NetSuite, but there are still matching files on your bank’s server that haven't been imported.

This can happen if the system finds more than one file that matches your file name pattern.

If there are several matching files, the system only imports the first one. The rest are imported during the next scheduled import, or you can get them right away by asking the system import again. To upload the rest manually, see Updating Imported Bank Statement Files.

If you're an Administrator, you can check the execution log of your import details record to see if there are files still waiting to be imported into NetSuite. To do this:

As an Administrator, go to Customization > Plug-ins > Plug-In Implementations.
Click the SFTP Connectivity plug-in implementation.
On the Execution Log subtab, look for the log related to your import detail record.
In the Details column, you'll see a message if there are files still waiting on your bank’s server.

The Download Filename Pattern field on your SFTP connectivity configuration is blank

If there's more than one file on your bank's server, the system only imports the first file that's not already in NetSuite.

The rest of the files are imported during the next scheduled import, or you can get them right away by asking the system to import again. To upload the rest manually, see Updating Imported Bank Statement Files.

If you’re an Administrator, you can check the execution log of your import details to see if there are files still waiting to be imported into NetSuite. To do this:

As an Administrator, role, go to Customization > Plug-ins > Plug-In Implementations.
Click the SFTP Connectivity plug-in implementation.
On the Execution Log subtab, look for the log related to your import detail record.
In the Details column, you'll see a message if there are files still waiting on your bank’s server.

Related Topics