OFX to CSV Converter

OFX is a file format, not a document — there is no way to read one without software that imports it. This turns one into a CSV you can open anywhere, with a column per field and the dates normalised so a spreadsheet sorts them correctly.

An OFX opened as a spreadsheet, with the payee text put back together.

The full payee, not the first 32 characters

OFX limits <NAME> to 32 characters and the rest goes in <MEMO>. Reading only NAME truncates every long payee; both are read and rejoined.

Debits and credits in separate columns

Easier to total, easier to filter, and it removes any question about what a bare number means.

No balance invented

An OFX states one closing balance and no running one. Calculating a balance column backwards from it would produce numbers your bank never printed, so the column stays empty and the closing figure is reported separately.

Related guides

• OFX, QFX, QBO and QIF: Which Format Does Your Software Want?
• Why QuickBooks Rejects Your QBO File
• Why Your QIF Import Lands a Month Out
• How to Convert a CSV to QBO for QuickBooks
• Bank Feeds vs Statement Conversion: When You Need Each
• Bank Statement Converter vs Manual Data Entry: A Real Comparison
• Why Your Converted Bank Statement Doesn't Balance
• The Bank Statement Date Format Problem (DD/MM vs MM/DD)