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.
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.
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.
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
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
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.
$ cv convert report.ofx report.json$ cv convert report.ofx report.jsonQuestions.What people ask about OFX to JSON.
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.