Convert OFX to CSV

Turn OFX files into CSV. Every bank and credit card statement in the file, OFX 1 with its unclosed tags or OFX 2 in XML, gives a row for each transaction with the account number, the posting date, the amount, the currency, the payee, the memo, the check or reference number, the transaction type and the bank's transaction id.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop OFX files on the dialor turn it to pick what to do

A spreadsheet of every transaction.One row per transaction, with signed amounts and dates as YYYY-MM-DD.

  1. What you get

    A CSV file with a row for each transaction in the bank and credit card statements in the file. It reads OFX 1 with its unclosed tags and OFX 2 in XML. QFX files are read the same way.

    Each row has the account, date, amount, currency, payee, memo, reference, balance, type, category and id. The account number, the posting date, the check or reference number, the transaction type and the bank's transaction id come from the file.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amounts are signed, so money out is negative, and they keep the digits the file wrote.

    A balance the file does not give stays empty.

  3. What it leaves behind

    Investment statements are left out. If the file holds only investment statements, the conversion stops with unsupported_elements.

    If you want to combine the results of several statements, merge CSV joins CSV files into one. For other table conversions, see every CSV conversion.

OFX and CSV.What each format is.

The formats

From · OFX

OFX Bank Statement

Open Financial Exchange, the statement download of North American banks and card issuers that Quicken, GnuCash and most money apps import; QFX is Quicken's flavor of it.

Extensions
.ofx .qfx
MIME type
application/x-ofx
Kind
Text and data
To · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

In your code.The same OFX to CSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.ofx report.csv
$ cv convert report.ofx report.csv

Questions.What people ask about OFX to CSV.

01OF 04

Yes. QFX is Quicken's flavor of OFX, and it is read like an OFX file.

Yes. Amounts are signed, with negative for money out.

No. Investment statements are left out. A file that holds only those stops with unsupported_elements.

The balance column stays empty for that row. Nothing is filled in for it.

More conversions.Other ways in and out of OFX and CSV.