■ 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
Reconciliation. The statement can contain multiple bank accounts.
Note: If you are using default parsers, NetSuite supports the BAI2 format with UTF-8
encoding for the following banks: TD, Wells Fargo, US Bank, JP Morgan Chase, and Bank of
America Merrill Lynch. If you are using 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 bank transactions for multiple bank 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.