Scenario:
When attempting to import bank data, the user may encounters the following error message:
Error: "Bank data import failed. The bank import for one or more accounts failed due to the following error: The file could not be imported, because the account xxxxx in the file does not match an account in NetSuite. Please contact your administrator for assistance and refer to the failed imported statement: Internal ID ——."
This error typically occurs when the Account listed in the bank file does not correctly correspond to any linked account in NetSuite. The issue may be related to incorrect or outdated mappings in the Financial Institution Format Profile under Account Linking.
This error indicates a mismatch between the bank account information provided in the import file and the accounts configured in NetSuite under the relevant financial institution's format profile. Possible causes include:
- The bank account is not correctly linked in NetSuite.
- The account was previously removed or renamed.
- The configuration for the financial institution’s format profile is outdated or incorrect.
Solution:
Review the Financial Institution Setup
- Navigate to Setup > Accounting > Financial Institution > List
- Locate and click View next to the financial institution associated with the error
Edit Format Profile Configuration
- On the Format Profile: Configuration tab, click Edit on the relevant Financial Profile
- Go to the Account Linking tab
- Identify and Remove the bank account listed in the error message
- Click Save to confirm the changes
Re-link the Bank and GL Accounts
Return to the Account Linking tab
- Click Add and re-link the correct Bank Account and corresponding GL Account
- Ensure that the information matches the bank file accurately
- Click Save to apply the changes
Re-import the Bank File
Navigate to Transactions > Bank > Banking Import History > Upload File
- Click Choose File and upload the corrected bank statement file
- Select the correct Financial Institution
- Choose the appropriate Format Profile
- Click Import. Wait for the import to complete. NetSuite will validate and process the file
- After the import completes, navigate to Transactions > Bank > Match Bank Data
- Select the relevant bank Account
- Confirm that the imported transactions are visible and correctly matched
Note:
• Ensure that the account number in the bank file exactly matches the linked account in NetSuite.
• If the issue persists, verify that the format profile settings and file format comply with the financial institution's requirements.
• Consult with your NetSuite administrator or support team if the problem cannot be resolved with the above steps.