Convert QIF to CSV

Turn QIF files into CSV. Every transaction of the bank, cash, credit card and other asset or liability accounts gives a row with the account's name, the date, the amount, the payee, the memo, the check number and the category, and the categories of split lines are joined when the transaction names none.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop QIF files on the dialor turn it to pick what to do

Your Quicken transactions as a table.One row for each transaction, with the account, date, amount and payee.

  1. What you get

    A single CSV file. Every transaction from your bank, cash, credit card and other asset or liability accounts becomes one row. Each row holds the account name, the date, the amount, the payee, the memo, the check number and the category.

    The columns come in this order: account, date, amount, currency, payee, memo, reference, balance, type, category and id. Dates are written as YYYY-MM-DD. Amounts are signed, negative for money out, with the digits the file wrote.

  2. Categories and balances

    When a transaction names no category, the categories of its split lines are joined to fill the category column. A balance the file does not give stays empty.

  3. What it leaves behind

    QIF holds no currency, so there is nothing to put in the currency column. Investment transactions are left out and do not appear as rows.

    To work with the result alongside other tables, you can merge CSV files into one. You can also see every CSV conversion.

QIF and CSV.What each format is.

The formats

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

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

terminal
$ cv convert report.qif report.csv
$ cv convert report.qif report.csv

Questions.What people ask about QIF to CSV.

01OF 04

The header reads account, date, amount, currency, payee, memo, reference, balance, type, category and id. Each transaction fills one row under it.

No. Investment transactions are left out. Transactions from bank, cash, credit card and other asset or liability accounts are kept.

Dates use the YYYY-MM-DD form. Amounts are signed, with negative numbers for money out, and keep the digits the file wrote.

QIF holds no currency, so the file has no value to give. The balance column is empty in the same way when the file does not state a balance.

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