MT940 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 upload failed because the calculated Closing Balance does not match the Closing Amount in the file. Contact your bank to correct the error, and re-upload the file again.	The opening balance (tag :60:) plus the statement amount (tag :61:) doesn't equal the closing balance (tag :62:).	Contact your financial institution for help.
The file could not be imported because the currency code [code] for an account does not match the currency code for the same account in NetSuite.	The account currency on 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, 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 data at line [number] for [tag :X:]. Amounts must include only one comma or period as a decimal separator. Contact your bank to correct the error, and re-upload the file again.	Multiple commas were found.	To remove extra decimal separators, contact your financial institution.
The file could not be imported, because the account [name] in the file does not match an account in NetSuite.	The Transaction Account (tag :25:) value in your MT940 file is missing from your format profile.	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 the file contains an incorrect Amount Indicator. Expected Amount Indicator values are C, D, RC, or RD. Contact your bank to correct the error, and re-upload the file again.	The Amount Indicator has an unknown value.	The Amount Indicator must be C, D, RC, or RD. To fix the file, contact your financial institution.
The file upload failed because the file contains an incorrect date format. MT940 statement files use the <YYMMDD> date format. Contact your bank to correct the error, and re-upload the file again.	Wrong date format for tag :61:.	Check your bank statement file and make sure the date in tag :61: is in YYMMDD format. Contact your financial institution for help.
The file upload failed because the file contains an incorrect booking date format. MT940 statement files use the <MMDD> date format in the Booking Date field. Contact your bank to correct the error, and re-upload the file again.	Wrong booking date format.	Check your bank statement file and make sure the booking date in tag :61: is in MMDD format. Contact your financial institution for help.
The file upload failed because it contains an unknown transaction code [XYZ]. Update you format profile to add non-Swift transactions codes and re-upload the file again.	There's an unknown transaction code.	Contact your financial institution for help.

Error Message

Cause or Scenario

Solution

The file upload failed because the calculated Closing Balance does not match the Closing Amount in the file. Contact your bank to correct the error, and re-upload the file again.

The opening balance (tag :60:) plus the statement amount (tag :61:) doesn't equal the closing balance (tag :62:).

Contact your financial institution for help.

The file could not be imported because the currency code [code] for an account does not match the currency code for the same account in NetSuite.

The account currency on 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, 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 data at line [number] for [tag :X:]. Amounts must include only one comma or period as a decimal separator. Contact your bank to correct the error, and re-upload the file again.

Multiple commas were found.

To remove extra decimal separators, contact your financial institution.

The file could not be imported, because the account [name] in the file does not match an account in NetSuite.

The Transaction Account (tag :25:) value in your MT940 file is missing from your format profile.

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 the file contains an incorrect Amount Indicator. Expected Amount Indicator values are C, D, RC, or RD. Contact your bank to correct the error, and re-upload the file again.

The Amount Indicator has an unknown value.

The Amount Indicator must be C, D, RC, or RD. To fix the file, contact your financial institution.

The file upload failed because the file contains an incorrect date format. MT940 statement files use the <YYMMDD> date format. Contact your bank to correct the error, and re-upload the file again.

Wrong date format for tag :61:.

Check your bank statement file and make sure the date in tag :61: is in YYMMDD format. Contact your financial institution for help.

The file upload failed because the file contains an incorrect booking date format. MT940 statement files use the <MMDD> date format in the Booking Date field. Contact your bank to correct the error, and re-upload the file again.

Wrong booking date format.

Check your bank statement file and make sure the booking date in tag :61: is in MMDD format. Contact your financial institution for help.

The file upload failed because it contains an unknown transaction code [XYZ]. Update you format profile to add non-Swift transactions codes and re-upload the file again.

There's an unknown transaction code.

Contact your financial institution for help.

Related Topics