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.
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.
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.
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
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
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.
$ cv convert sheet.csv sheet.qif$ cv convert sheet.csv sheet.qifQuestions.What people ask about CSV to QIF.
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.