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.

  1. 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.

  2. 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.

  3. 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

From · CSV

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
To · 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

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

terminal
$ cv convert sheet.csv sheet.ofx
$ cv convert sheet.csv sheet.ofx

Questions.What people ask about CSV to OFX.

01OF 04

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.

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