Convert OFX files to CSV or Excel
OFX is plain text, but nobody wants to read it. Open it as a spreadsheet and check the closing balance.
No statement to hand? Try a sample: ·
What is inside an OFX file
Open Financial Exchange has a header, a sign-on block, then a statement response. Each STMTTRN element holds a type (CREDIT, DEBIT, CHECK and others), a posted date (DTPOSTED), an amount (TRNAMT, negative for money out), an ID (FITID), and a NAME and MEMO. The ledger balance (LEDGERBAL) closes the statement.
OFX 1.x and 2.x
Version 1 is SGML-like: tags are not closed and the file starts with a plain-text header. Version 2 is well-formed XML. Banks still send both, and RowBalance reads either, including files with several accounts.
How rows are mapped
Payee and memo are joined into one Description, the signed amount is split into Money in and Money out, and the FITID is kept as the reference. The ledger balance is used to check the statement.
How to do it
- Drop the .ofx file above.
- Review the transactions and the balance check.
- Download CSV or Excel (free, up to 5 pages a day).
Excel and CSV are free for up to 5 pages a day. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.
Questions
Why does my OFX file show no running balance?
OFX only carries one balance, the ledger balance at the end of the statement. RowBalance computes the running balance from it.
Can I convert it back to OFX or QBO?
Yes. After loading the file, choose OFX or QuickBooks (.qbo) on a paid plan.