Convert CSV to OFX
Turn CSV files into OFX. The table must have the header row a bank statement converted to csv here has, naming only the columns account, date, amount, currency, payee, memo, reference, balance, type, category and id, in any order, with dates as YYYY-MM-DD and amounts as plain numbers such as -12.50 in every row; any other table fails with unsupported_elements.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop CSV files on the dialor turn it to pick what to do
A statement file your money app can import.Each account and currency in the table becomes its own statement in an OFX file.
What you get
One OFX 2.1.1 file with a statement for each account and currency. Credit card accounts become credit card statements.
Each transaction keeps its posting date and amount. Its type is kept when it is an OFX type, and otherwise it is set to CREDIT or DEBIT by the sign of the amount.
What the table must look like
The table needs a header row that names only these columns, in any order: account, date, amount, currency, payee, memo, reference, balance, type, category and id. Dates are written as YYYY-MM-DD, and amounts are plain numbers such as -12.50 in every row.
Any other table stops with
unsupported_elements. For other table jobs, see every CSV conversion.How fields are written
The id becomes FITID, or one is made from the row when there is none. The payee becomes NAME, cut to 32 characters, with up to 100 characters in EXTDNAME. The memo keeps up to 255 characters. A numeric reference becomes CHECKNUM.
The ledger balance is the closing balance the source gives, or 0.00 when it gives none. A statement without a currency gets XXX, and one without a bank number gets 000000000.
CSV and OFX.What each format is.
The formats
CSV
Rows of comma-separated values. The plainest way to move a table between programs.
- Extensions
- .csv
- MIME type
- text
/csv - Kind
- Text and data
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
In your code.The same CSV to OFX conversion through the API, for your app or your agent.
$ cv convert sheet.csv sheet.ofx$ cv convert sheet.csv sheet.ofxQuestions.What people ask about CSV to OFX.
Only account, date, amount, currency, payee, memo, reference, balance, type, category and id, in any order. A header row naming other columns stops with unsupported_elements.
Write dates as YYYY-MM-DD and amounts as plain numbers such as -12.50, in every row.
The file holds a statement for each account and currency. Credit card accounts become credit card statements.
NAME is cut to 32 characters, and up to 100 characters go in EXTDNAME.