OFX, the Open Financial Exchange, is a financial-data exchange format that includes bank and card transactions. Version 2 is XML; version 1 used an SGML layout. The specification is now maintained by the Financial Data Exchange. Klarbon writes OFX 2.2 from supported structured bank statements. Reading PDF statements is not available yet.
What is in an OFX file?
| Element | Holds |
|---|---|
BANKACCTFROM |
the account: bank, account number, type |
STMTTRN |
one transaction: type, date, amount, ID, name, memo |
LEDGERBAL |
the ledger balance and its date |
CURDEF |
the currency |
The OFX work group is part of the Financial Data Exchange (FDX). QFX is Quicken's OFX-based Web Connect format.
When is OFX used?
To import a bank statement into software that does not connect to your bank, or to load an older period the bank feed does not cover.
What can Klarbon do with OFX?
Klarbon reads OFX files and writes OFX from supported structured bank statements. It checks that the balances reconcile before download; the same unlock includes CSV, Excel, CAMT.053 and MT940. Reading PDF statements is not available yet.
Related
Frequently asked questions
What is the difference between OFX and QFX?
QFX is the Web Connect format used by Quicken, based on OFX. The structure is close to OFX, with extra product-specific fields.
Is OFX XML?
Version 2 is XML. Version 1 used a looser SGML layout. Klarbon writes OFX 2.2 in XML.
Which software imports OFX?
Use software whose import documentation explicitly supports OFX, and check the version it expects. Quicken Web Connect uses QFX, not a generic OFX import.
Sources
- Financial Data Exchange, OFX Work Group financialdataexchange.org