Bank Statement Parsers SuiteApp
The Bank Statement Parsers SuiteApp delivers standard parser plug-ins that can read bank and credit card statement files and import the data in NetSuite to aid with bank reconciliation. If the Financial Institution and Format Profiles are set up correctly, the SuiteApp can identify multiple bank accounts within a single file. For more information, see Creating Financial Institution Records and Format Profile Creation.
The SuiteApp also comes with sample scripts that you can download and use as a reference when you create custom parsers. For more information, see Downloading Sample Bank Statement Parsers Scripts.
The SuiteApp will not create NetSuite transactions from the imported bank statement files.
The Bank Statement Parsers SuiteApp includes parser plug-ins for the following file formats in (Unicode) UTF-8 and UTF-8 BOM encoding:
-
BAI2 — The BAI2 parser plug-in can recognize default and standard BAI2 bank transaction codes and supports account total and number of records import validation. The SuiteApp also lets you configure the decimal precision of the BAI2 parser plug-in.
-
OFX/QFX — The OFX/QFX parser plug-in can parse bank and credit card statement files that uses OFX/QFX versions 102, 103, 211, and 220. The parser can recognize default and standard OFX/QFX bank transaction codes and supports the use of a period (.) and comma (,) as a decimal separator.
-
MT940 — The MT940 parser plug-in can recognize standard SWIFT transaction bank codes and supports the use of a period (.) and comma (,) as a decimal separator. The plug-in can also decode remittance information from the bank and display it in a more readable format.
-
CAMT.053 — The CAMT.053 parser plug-in can parse bank statement files that use the CAMT.053.001.02 version and can recognize standard ISO bank transaction codes. The plug-in includes default mappings for XML elements to NetSuite fields. Users can also create new mappings or override the default mappings.
Note:The CAMT.053 parser plug-in only supports (Unicode) UTF-8 encoding. Some editors append the BOM (Byte Order Marker) to the beginning of the file. You may have to use a third party editor to convert your file to UTF-8 prior to import into NetSuite.
-
CSV – The CSV parser plug-in can parse bank statement files in CSV file format. The plug-in includes a CSV Bank Statement Template file you can use to format your bank statement files. Default mappings to NetSuite fields and formatting preferences are also preconfigured based on the provided template file. Alternatively, you can also use your own CSV file and configure your format profile by mapping the file to NetSuite fields and updating the formatting preferences.
Note:The CSV parser plug-in only supports (Unicode) UTF-8 encoding. Some editors append the BOM (Byte Order Marker) to the beginning of the file. You may have to use a third party editor to convert your file to UTF-8 prior to import into NetSuite.
Read the following topics to learn more about the Bank Statement Parsers SuiteApp: