ANS-0336 · ACCOUNTING & FINANCIAL CONFIGURATION
How to Import Bank Statements in BAI2 or OFX Format into NetSuite?
NetSuite supports direct import of BAI2 files, and OFX files can also be imported effectively, often requiring third-party conversion for other formats.
Short answer
NetSuite natively supports importing bank statements in BAI2 format. For other formats like BAI that need conversion to OFX, various third-party tools are available. Once converted to OFX, these files can be smoothly imported into NetSuite for bank reconciliation.
Scenario
Organizations often need to import bank statements into NetSuite for reconciliation purposes. When bank statements are provided in formats such as BAI, there can be uncertainty regarding the best method for import, especially concerning format compatibility with NetSuite's native capabilities.
Solution
Native BAI2 Support
NetSuite natively supports the import of bank statements in BAI2 format, eliminating the need for external conversion for files provided in this standard.
OFX File Import
NetSuite effectively processes OFX (Open Financial Exchange) files for bank statement import.
Conversion for Other Formats
If bank statements are in a format other than BAI2 or OFX (e.g., older BAI versions), conversion to OFX may be necessary. While Gurus Solutions does not officially endorse specific software, various third-party file converter options (both freeware and commercial) are available to facilitate this conversion. Clients are advised to research and evaluate these tools independently.Example Conversion Tool Reference:http://www.bancbridge.com/fileconversion.html
Expert NetSuite Support
Need help with this NetSuite issue?
Accounting & Financial Configuration consulting and configuration support