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.
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.
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.
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
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
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.
$ cv convert report.ofx report.csv$ cv convert report.ofx report.csvQuestions.What people ask about OFX to CSV.
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.