Note: If you want to use the Match Bank Data and Reconcile Account Statement pages for an account, check the Use Match Bank Data and Reconcile Account Statement Pages box on the Edit Account page.
Download the account statement from your financial institution or credit card company in one of the supported file formats. To ensure successful file import, do not modify the downloaded statement file. There is a limit of 50 characters for the file name length, including extension.
You can import account statements that are in the following formats:
Important: 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.
- 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 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 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 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.
-
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.
- Note The QIF file format is no longer supported. We recommend switching to one of the new supported formats. As of 2018.2, the QIF format has been deprecated.
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.