Users working with NetSuite’s Match Bank Data feature may encounter an issue where French accented characters appear as unreadable or corrupted text when importing OFX files. This typically occurs during navigation to: Transactions → Match Bank Data → Banking Import History → Upload File.
The issue stems from a character encoding mismatch:
- Some OFX files are commonly encoded in ISO-8859-1 (Latin-1)
- NetSuite’s default parser expects files encoded in UTF-8
Because NetSuite does not automatically detect or convert character encoding, any non-UTF-8 file results in misinterpreted characters—especially accented letters (e.g., é, è, à), which appear as ASCII “garbage.” This is expected system behavior, not a product defect.
To resolve the issue, the OFX file must be converted to UTF-8 encoding prior to upload.
Step 1: Convert the OFX File to UTF-8
- Open the OFX file using a text editor that supports encoding conversion:
- Notepad++
- Sublime Text
- Visual Studio Code
- Navigate to the encoding settings:
- In most editors: Encoding → Convert to UTF-8
- Save the file.
Important: Ensure the file retains the .OFX extension after saving. It should not be saved as a .TXT file.
Step 2: Re-upload the Converted File in NetSuite
- Navigate to:Transactions → Bank → Banking Import History → Upload File
- Click “Choose a file” and select the converted OFX file
- Click:“Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053)”
- Select the appropriate account.
- Click Import