Convert OFX to ODS
Turn OFX files into ODS. 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 in a spreadsheet.Each bank and credit card transaction in an OFX or QFX file gets a row in an ODS sheet.
What you get
One ODS file with one sheet, named after the file. It reads both OFX 1, with its unclosed tags, and OFX 2, which is XML. Each bank or credit card transaction in the file becomes a row.
A 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. A bold header names these columns, and they are the same columns as the csv conversion.
How cells are typed
Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote, so you can sort and add them.
Every other column is text. Account numbers and transaction ids keep their leading zeros and all their digits.
What it leaves out
Investment statements are not converted. If a file holds only investment statements, the conversion stops with
unsupported_elements. If a file holds both kinds, the bank and credit card transactions are converted and the investment ones are left out.
OFX and ODS.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
OpenDocument Spreadsheet
OpenDocument spreadsheet, the native format of LibreOffice Calc.
- Extensions
- .ods
- MIME type
- application
/vnd .oasis .opendocument .spreadsheet - Kind
- Documents
In your code.The same OFX to ODS conversion through the API, for your app or your agent.
$ cv convert report.ofx report.ods$ cv convert report.ofx report.odsQuestions.What people ask about OFX to ODS.
Yes. QFX is Quicken's flavor of OFX, and it is read the same way as an OFX file.
No. Account numbers and ids are stored as text, so the leading zeros and all the digits stay.
The file holds only investment statements. Those are left out, so no rows remain to write.
Yes. See every ODS conversion for the full list.