Convert OFX to PARQUET

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

Bank statements as a table of rows.Each transaction becomes one row in a Parquet file.

  1. What you get

    One Parquet file with a row for each transaction in every bank and credit card statement in the OFX or QFX file. This works for OFX 1 with its unclosed tags and for OFX 2 in XML.

    Each row holds 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.

  2. How columns are typed

    The table has a column for each key of the json conversion, typed from the values. Dates become dates, and amounts and balances become numbers. The other columns are text.

  3. What it leaves out

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

    To combine several statements into one table, you can merge PARQUET files afterward.

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

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

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

terminal
$ cv convert report.ofx report.parquet
$ cv convert report.ofx report.parquet

Questions.What people ask about OFX to PARQUET.

01OF 04

Yes. QFX is Quicken's flavor of OFX, and both extensions are read.

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

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

Yes. Amounts and balances become numbers, and posting dates become dates. The other columns are text.

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