CSV to OFX Converter
A CSV converted to plain OFX, which is the open standard the whole family is built on. Use this when your software asks for OFX rather than for one of Intuit's variants — an OFX carrying Intuit's tags is rejected by some importers just as surely as a QFX without them is rejected by Quicken.
The open format — Xero, GnuCash, MoneyWiz and most things that are not Intuit.
Plain OFX, deliberately
No <INTU.BID>. It belongs in a QFX or a QBO and nowhere else, and its presence is enough to make a strict reader refuse the file.
The currency your statement is in
CURDEF is read off your file rather than assumed to be dollars. A euro statement imported as dollars reconciles wrongly and nothing warns you.
A period that runs forwards
DTSTART and DTEND are the earliest and latest dates in the file, not the first and last rows. A statement printed newest-first would otherwise declare a period running backwards, which importers treat as covering nothing at all.
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)