OFX/QFX File Import Error Messages

The following table lists some common file import errors and how you can fix them.

Error Message	Cause or Scenario	Solution
The file cannot be imported because the currency code [code] in the file does not match the currency code for the same account in NetSuite. Check your format profile record or contact your bank to correct the error and re-upload the file again.	The account currency in your bank statement file doesn't match the mapped account's currency in NetSuite.	Check which currency should be used. For details on checking account information in NetSuite, see Viewing the Chart of Accounts. To fix the bank statement file, contact your financial institution.
The file upload failed because the file contains an incorrect date format. OFX Statement files use <YYYY-MM-DD> date format. Contact your bank to correct the error, and re-upload the file again.	Invalid date format.	To fix the date format in your bank statement file, contact your financial institution.
The file cannot be imported because the account [ID] in the file does not match an account in NetSuite. Check the Account Mapping in the format profile record or contact your bank to correct the error and re-upload the file again.	There's no matching account in NetSuite.	Check the account mapping in your format profile. Under the Account Linking subtab, make sure each account ID is linked to a GL account.
The file upload failed because it contains transactions that were not successfully posted in the bank's system. Contact your bank to correct the error and re-upload the file again.	The Status code in your bank statement file isn't 0 (zero) or Success.	Contact your financial institution to check the correct status of your transactions.

Error Message

Cause or Scenario

Solution

The file cannot be imported because the currency code [code] in the file does not match the currency code for the same account in NetSuite. Check your format profile record or contact your bank to correct the error and re-upload the file again.

The account currency in your bank statement file doesn't match the mapped account's currency in NetSuite.

Check which currency should be used. For details on checking account information in NetSuite, see Viewing the Chart of Accounts.

To fix the bank statement file, contact your financial institution.

The file upload failed because the file contains an incorrect date format. OFX Statement files use <YYYY-MM-DD> date format. Contact your bank to correct the error, and re-upload the file again.

Invalid date format.

To fix the date format in your bank statement file, contact your financial institution.

The file cannot be imported because the account [ID] in the file does not match an account in NetSuite. Check the Account Mapping in the format profile record or contact your bank to correct the error and re-upload the file again.

There's no matching account in NetSuite.

Check the account mapping in your format profile. Under the Account Linking subtab, make sure each account ID is linked to a GL account.

The file upload failed because it contains transactions that were not successfully posted in the bank's system. Contact your bank to correct the error and re-upload the file again.

The Status code in your bank statement file isn't 0 (zero) or Success.

Contact your financial institution to check the correct status of your transactions.

Related Topics