QBO vs QFX vs OFX
What the three statement files are, and which program each one is for.
- 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
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
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
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.
- Renaming .qfx to .qbo does not add the tags the other program wants. Convert it.
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.