Convert QIF to JSON

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

Quicken transactions as a JSON array.One object per transaction, with the date, amount, payee and category.

  1. What you get

    A single JSON file that holds an array. Each transaction from your bank, cash, credit card and other asset or liability accounts becomes one object in it.

    Every object has the keys account, date, amount, currency, payee, memo, reference, balance, type, category and id. The account key holds the name of the account the transaction belongs to. The reference key holds the check number.

  2. How values are written

    Dates are written as YYYY-MM-DD. Amount and balance are numbers with the digits the file wrote, and money going out is negative. When the file gives no balance, the balance is null.

    When a transaction has no category of its own but has split lines, the categories of the split lines are joined to make its category.

  3. What it leaves behind

    Investment transactions are left out, so they do not appear in the array.

    QIF holds no currency. The file has nothing to fill the currency key from.

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

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

terminal
$ cv convert report.qif report.json
$ cv convert report.qif report.json

Questions.What people ask about QIF to JSON.

01OF 04

It is an object with the keys account, date, amount, currency, payee, memo, reference, balance, type, category and id. Together the objects form one array.

Yes. Money out is negative, and the number keeps the digits the QIF file wrote.

No. Only bank, cash, credit card and other asset or liability accounts give rows. Investment transactions are left out.

When the transaction names no category, the categories of its split lines are joined into its category.

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