Convert QIF to TSV

Turn QIF files into TSV. 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 tab-separated rows.One row per transaction, with the account, date, amount, payee and category.

  1. What you get

    One TSV file. Every transaction of the bank, cash, credit card and other asset or liability accounts becomes a row. Each row holds the account's name, the date, the amount, the payee, the memo, the check number and the category.

    The rows sit under one header: account, date, amount, currency, payee, memo, reference, balance, type, category and id. The columns are separated by tabs.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amounts are signed, negative for money out, and keep the digits the file wrote.

    If a transaction names no category but has split lines, the categories of the split lines are joined to make its category. A balance the file does not give stays empty.

  3. What is left out

    QIF holds no currency, so the currency column has nothing from the file to fill it. Investment transactions are left out and do not appear as rows.

    To combine the result with other tables, you can merge TSV files. You can also browse every TSV conversion.

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

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

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

terminal
$ cv convert report.qif report.tsv
$ cv convert report.qif report.tsv

Questions.What people ask about QIF to TSV.

01OF 04

Yes, in part. When a transaction names no category, the categories of its split lines are joined and used as its category.

No. Investment transactions are left out. Bank, cash, credit card and other asset or liability accounts are converted.

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

No. QIF holds no currency, so the file gives nothing to put there.

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