Convert OFX to XLS

Banks often provide transaction downloads as OFX, while older accounting systems and spreadsheet templates may accept only XLS. Converting the data creates editable rows for sorting, calculations, reports, or import into software that cannot read OFX.

What OFX is

OFX (Open Financial Exchange) is a structured format for transferring account, balance, statement, and transaction data between financial institutions and personal-finance software. Banks commonly use .ofx; .qfx is a related variant used by some institutions and finance applications. An OFX file can contain dates, payees, memos, amounts, transaction types, account identifiers, balances, and bank-assigned transaction IDs. It is not a spreadsheet and does not define worksheet columns, formatting, formulas, or charts.

Applications such as GnuCash, Quicken, Moneydance, and other accounting programs can import OFX, although support for QFX and particular bank variants differs.

What XLS is

XLS is Excel's older binary workbook format, compatible with Microsoft Excel, LibreOffice Calc, and many legacy accounting systems. It supports formulas, filters, charts, and multiple worksheets, but each worksheet is limited to 65,536 rows and 256 columns. Use XLSX instead when the receiving program accepts it; XLS is primarily required for older software.

Convert with GnuCash and Excel or Calc

1. Install GnuCash from gnucash.org, create or open a book, and make a backup of the original .ofx file.
2. Use File → Import → Import OFX/QFX, select the file, and assign its transactions to the correct GnuCash account. Review the detected account and transaction matches before completing the import.
3. Open the account register and use its export command to create a CSV file. Select the transaction fields needed in the spreadsheet, such as date, description, memo, amount, transaction type, balance, and transaction ID. GnuCash menu names vary by version; an account or transaction report can also be exported as CSV.
4. Open the CSV in Excel or LibreOffice Calc. Set the correct delimiter and character encoding, and assign date, decimal, and thousands-separator settings for the bank's locale. Import account numbers and transaction IDs as text if leading zeroes must be retained.
5. In Excel, choose File → Save As and select Excel 97-2003 Workbook (*.xls). In Calc, choose File → Save As and select Excel 97-2003 (*.xls). Accept the compatibility warning and inspect the saved workbook.

This method parses financial fields before creating the spreadsheet. Opening an OFX file directly as delimited text can merge fields incorrectly because OFX is structured data rather than a regular table.

Automate repeated conversions

For batch processing, use an OFX parser that supports both older SGML-style files and XML-based OFX, extract the required transaction fields, and write them to CSV or XLSX. Convert the resulting XLSX with LibreOffice if legacy XLS output is required; for example, a locally installed LibreOffice command-line conversion can use soffice --headless --convert-to xls --outdir output transactions.xlsx. Parser libraries and command-line options change over time, so validate the output against the bank statement before using it for accounting. Do not assume that a generic XML parser can correctly process every OFX download.

Use an online converter

Services such as CloudConvert, Convertio, and Zamzar may offer OFX-to-XLS conversion, but supported input and output formats can change; verify that the service currently lists both formats before uploading. Online conversion sends the file, which may contain names, account numbers, balances, and complete transaction histories, to a third party. Use a local workflow for confidential data unless the provider's storage, deletion, and processing terms are acceptable.

Check the converted workbook

• Compare debit and credit signs, transaction counts, opening balances, and ending balances with the original statement. Banks do not use identical sign conventions.
• Check dates around midnight, month boundaries, and year boundaries. Time-zone fields and regional date settings can change how spreadsheet software displays a transaction.
• Confirm that payee text, memos, transaction IDs, and leading zeroes survived the CSV and XLS steps. Keep identifiers as text where necessary.
• OFX metadata, reconciliation fields, pending-transaction status, institution-specific headers, and update information may not appear in the workbook. The XLS file is an analysis copy, not a replacement for the original OFX.
• Do not exceed 65,536 rows in an XLS worksheet. Split the export by account or date, or retain an XLSX copy for larger histories.