Skip to the converter
StatementZap

Guides

QBO vs QFX vs OFX

What the three statement files are, and which program each one is for.

  1. 1

    OFX is the statement format

    OFX is the spec. Version 1 is SGML. Version 2 is XML. Both can carry the same bank transactions: date, amount, payee, check number, and a fit id.

  2. 2

    QBO is QuickBooks Web Connect

    A .qbo file is OFX 1 SGML plus the INTU tags QuickBooks Desktop looks for, including the institution id. Import it with Web Connect. QuickBooks Online does not import this file. It wants a CSV.

  3. 3

    QFX is Quicken's file

    A .qfx file is the same kind of OFX statement with Quicken's INTU tags. Quicken imports QFX. Giving a QFX file to QuickBooks Desktop, or a QBO file to Quicken, often fails even when the transactions are identical.

  4. 4

    Pick the download for the program

    Desktop Web Connect: QBO. Quicken: QFX or QIF. QuickBooks Online: the 3-column or 4-column CSV. A plain OFX 1 or OFX 2 file is the spec form when a tool asks for OFX rather than a branded extension.

Questions

Are the amounts different in each file?

No. The same read writes each format. The difference is the wrapper and which program will open it.