Convert OFX to JSON

Turn OFX files into JSON. 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 transactions as rows of JSON.Each transaction becomes an object with the account, date, amount and payee.

  1. What you get

    One JSON file with an array that holds an object for every transaction in the statement. It reads both OFX 1, with its unclosed tags, and OFX 2, which is XML. QFX files work the same way.

    Each object has the keys account, date, amount, currency, payee, memo, reference, balance, type, category and id. The account is the account number, the reference is the check or reference number, and the id is the bank's transaction id. Bank and credit card statements in the same file all end up in the one array.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amount and balance are numbers with the digits the file wrote. Money out is negative.

    When the file does not give a balance, the balance is null.

  3. What it leaves out

    Investment statements are not converted. If a file holds only investment statements, the conversion stops with unsupported_elements. If the file also has bank or credit card statements, those are converted and the investment ones are skipped.

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

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

terminal
$ cv convert report.ofx report.json
$ cv convert report.ofx report.json

Questions.What people ask about OFX to JSON.

01OF 04

Yes. QFX is Quicken's flavor of OFX, and it converts the same way as an OFX file.

Yes. Money out is a negative amount. The number keeps the digits the file wrote.

The statement does not give a balance for that transaction. The balance key is still there, and its value is null.

The file holds only investment statements. Only bank and credit card statements are converted, so there is nothing to put in the array.

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