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 file name can be up to 50 characters, including the extension.
You can import account statements that are in the following formats:
If you try to import a CAMT.053.001.06-formatted XML or BAI2-formatted TXT file, and the bank mapping fields in the relevant account aren’t 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 lock box deposits. NetSuite supports BAI2 Prior-day Reporting for Bank. The statement can contain multiple bank or credit card accounts.
Note:If you're 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're 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. Make sure the statement file also adheres 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're 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're not sure which encoding the file has, check with your financial institution.
The QIF file format isn't supported. Use one of the new supported formats instead.
If your financial institution provides banking data in another format, use a third-party conversion tool to change the file to a supported format, and then import it.