Convert OFX and QFX files to CSV

What OFX and QFX are

Open Financial Exchange (OFX) is a long-standing text format for bank and credit card data, used by many banks as a download option labelled OFX, QFX or sometimes "Money" or "Quicken". QFX is Intuit's variant. A file is made of tagged blocks; the transactions are STMTTRN entries with a type, posted date, amount, an identifier and a name or memo, and the file usually includes a ledger balance with an "as of" date.

Many older OFX files are SGML-like, without closing tags, and newer ones are proper XML. Both are common in the wild.

What Tallyscope does

Add one or more OFX or QFX files. Every STMTTRN becomes a row with its date, signed amount, description (name plus memo) and currency, and the account and ledger balance are read into the statement. The result sits in the same table as every other source, so a CSV of three bank downloads and a PDF from a fourth is a single export. You can filter by date, text or amount, edit a row's category or direction, and leave rows out of totals.

An OFX statement usually carries a closing ledger balance but not a balance on every line, so the arithmetic check has less to work with than a PDF that prints a running balance. Where the file gives enough information to prove the totals, the statement shows as verified; where it does not, the status says so rather than assuming. For how this is decided, see how verification works.

CSV columns

The CSV contains Date (ISO), Statement, Account, Description, Category, Currency, Debit, Credit, Amount, Balance, the amount in your reporting currency, Counted in totals and Flags. Free exports include the first 25 rows; paid plans export all rows and also offer Excel, PDF and JSON. Cells that could be interpreted as formulas are neutralised.

Why not import OFX straight into a spreadsheet?

You can, with some tools, but OFX files have no tabular layout, and most spreadsheets do not read them natively. Accounting packages import OFX but rarely show you the arithmetic, merge several banks into one currency view, or let you reconcile in a spreadsheet. If you only need the data in a CSV, a converter that runs locally is the quickest route, and it keeps the file off a third-party server.

Several accounts, several currencies

Load one OFX file per account. Duplicate rows from overlapping downloads are detected, and transfers between your own accounts can be excluded from totals. Pick one reporting currency and Tallyscope converts every row at live exchange rates for a combined view. See multi-currency statements.

Privacy

OFX files contain account identifiers and transaction details. They are read in your browser tab and not uploaded. See converting without uploading.

If your bank also offers QIF, QIF to CSV covers that format, and the app is one click away.