Convert OFX to TSV

Turn OFX files into TSV. 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

One row for each transaction in your statement.Bank and card statements become tab-separated text with the account, date, amount and payee.

  1. What you get

    One TSV file. Every bank and credit card statement in the OFX file adds its transactions to it, whether the file is OFX 1 with unclosed tags or OFX 2 in XML. QFX files work the same way.

    Each transaction is one row. The columns come under this header: account, date, amount, currency, payee, memo, reference, balance, type, category and id.

  2. How values are written

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

    The reference column holds the check or reference number, the type column holds the transaction type, and the id column holds the bank's transaction id. A balance the file does not give stays empty.

  3. What it leaves out

    Investment statements are not converted. If the file holds only investment statements, the conversion stops with unsupported_elements.

    To join several TSV files afterward, you can merge TSV.

OFX and TSV.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 · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

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

terminal
$ cv convert report.ofx report.tsv
$ cv convert report.ofx report.tsv

Questions.What people ask about OFX to TSV.

01OF 04

Yes. OFX 1 with its unclosed tags and OFX 2 in XML both give a row for each transaction.

Amounts are signed, with a negative number for money out. They keep the digits the file wrote.

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

The balance column stays empty for that row. It is only filled when the file gives a balance.

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