Supported File Formats for Default Parsers
Download the account statement from your bank or credit card company in one of the supported file formats. To ensure successful file import, do not modify the downloaded statement file. The limit for the file name length is 50 characters, which includes the extension.
You can import account statements that are in the following formats:
If you attempt to import a CAMT.053.001.06–formatted XML or BAI2-formatted TXT file, and the bank mapping fields in the relevant account are not set, the import will fail. For instructions, see Editing an Account. BAI2, CAMT, and CSV files must have UTF-8 encoding.
-
BAI2 (Bank Administrative Institute Version 2) TXT with UTF-8 encoding – common format developed by Bank Administrative Institute for exchanging data. This data describes account activities, including securities transactions and lockbox deposits. NetSuite supports BAI2 Prior-Day Reporting for Bank. The statement can contain multiple bank or credit card accounts.
Note:If you are using default parsers, NetSuite supports the BAI2 format with UTF-8 encoding for the following financial institutions: TD, Wells Fargo, US Bank, JP Morgan Chase, and Bank of America Merrill Lynch. If you are using Financial Institution Parser Plug-ins or Bank Statement Parser Plug-ins, NetSuite supports any format.
-
CAMT.053.001.06 XML with UTF-8 encoding – file format in compliance with ISO 20022 and used by SWIFT. This statement file can contain end-of-day transactions for multiple bank or credit card accounts.
-
CSV with UTF-8 encoding – files with the .csv extension. This statement file must also adhere to the provided CSV template and constraints. See Preparing CSV Files for Import.
-
OFX (Open Financial Exchange) – file format sponsored by Intuit, Microsoft, and Fiserv (CheckFree). It is commonly used with Microsoft Money. When importing, select the method of character encoding associated with the file. If you are not sure which encoding the file has, check with your financial institution.
-
QFX (Quicken Financial Exchange) – file format developed by Intuit and is used with their Quicken software. It is a variant of the OFX file format. When importing, select the method of character encoding associated with the file. If you are not sure which encoding the file has, check with your financial institution.
The QIF file format is no longer supported. You should switch to one of the new supported formats.
If your financial institution provides banking data in another format, use a third-party conversion tool to convert the data file to a supported format and then import.