How to convert CSV to QIF
- 1
Drop the CSV and check the columns
Date, description, amount or debit/credit and balance are detected for you. Change any column, the date order or reversed signs.
- 2
Review the transactions
Edit a date, a payee or an amount, flip a sign or delete a line before converting.
- 3
Download QIF
Pick the date format you need in Export settings. Any other format is one click away too.
Bank or credit card QIF
Choose Credit card as the account type and the file is written as !Type:CCard, so apps put it in a card account; otherwise it’s written as !Type:Bank.
The formats
- CSV
- Comma-separated values: a plain-text table that every bank, spreadsheet and accounting app can read. Banks’ CSVs differ in column names, date order and whether money out is negative or in its own column.
- QIF
- Quicken Interchange Format, an older plain-text format with one field per line (D date, T amount, P payee, M memo). GnuCash, Moneydance and many smaller apps still import it; current Quicken for Windows only takes QIF into some account types.