Convert CSV to QIF

Turn CSV files into QIF. 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

Bank statement rows as a QIF file.Dates, amounts, payees and categories go into a list Quicken can read.

  1. What you get

    One QIF file with an !Account block and a !Type section for each account in the table. Each transaction carries its date, amount, payee, memo and category. The reference is written as the check number.

    Dates are written month first as MM/DD/YYYY, so 2026-03-05 becomes 03/05/2026.

  2. What it leaves behind

    QIF has no place for currency, balance, transaction type or id. Those columns are dropped. If you need them later, keep the CSV.

  3. What the table must look like

    The first row must be a header that names only these columns, in any order: account, date, amount, currency, payee, memo, reference, balance, type, category and id. Every row needs dates as YYYY-MM-DD and amounts as plain numbers such as -12.50.

    Any other table stops with unsupported_elements. That includes a header with other column names. To join several statements into one table first, use merge CSV.

CSV and QIF.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 · QIF

Quicken QIF

Quicken Interchange Format, the plain-text list of transactions with dates, amounts, payees and categories that Quicken, Microsoft Money and many banks export.

Extensions
.qif
MIME type
application/x-qif
Kind
Text and data

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

terminal
$ cv convert sheet.csv sheet.qif
$ cv convert sheet.csv sheet.qif

Questions.What people ask about CSV to QIF.

01OF 04

The header may name account, date, amount, currency, payee, memo, reference, balance, type, category and id. No other column names are allowed.

Month first, as MM/DD/YYYY. The CSV dates must be YYYY-MM-DD.

No. QIF holds no currency, so that column is dropped. The balance, transaction type and id are dropped as well.

The table does not match the expected shape. Its header names other columns, or a date or amount is not in the required form.

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