CSV to QIF Converter
Turn bank or credit card transactions in a CSV into a QIF file
Free, no signup. Runs entirely in your browser — files stay on this device.
Drop your file here or browse from your device
Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.
CSV to QIF at a glance
| Output | A .qif file with one !Type header: Bank, CCard, Cash, Oth A or Oth L |
|---|---|
| Fields written | D date, T amount, P payee, M memo, L category, N check number; each transaction ends with ^ |
| QIF dates | MM/DD/YYYY (US) or DD/MM/YYYY (UK, Europe, Australia), with four-digit years |
| Amounts | Exact, with a minus sign for money out and no currency symbols or thousands separators |
| Reading the CSV | One signed amount column or debit and credit columns; day-first or month-first dates are detected and can be set |
| Rows that cannot be read | Left out and listed with the reason, never guessed |
Convert bank or credit card transactions saved as CSV into a QIF (Quicken Interchange Format) file. Upload the CSV, check which columns hold the date, payee, amount and category, and download the .qif file.
The converter reads one signed amount column or separate money-out and money-in columns, and understands day-first or month-first dates, decimal commas, currency symbols, amounts in parentheses and CR/DR markers. You choose whether the QIF dates are written US style (MM/DD/YYYY) or UK and European style (DD/MM/YYYY), to match the app that will import them.
Amounts are copied exactly, never rounded, and a row that cannot be read exactly is left out and listed rather than guessed. Everything runs in your browser; your transactions are not uploaded.
Continue your workflow
Finished this step? Take the result into a focused tool for what comes next.
How to Convert CSV to QIF
- Download your transactions from your bank as CSV, then upload the file here
- Check the Date, Amount (or Money out and Money in), Payee and Category columns
- Pick the account type and the date style your finance app expects
- Download the .qif file and import it into your app
Features
- Detects date, payee, amount, debit, credit, memo, category and check number columns by name
- One signed amount column or separate money-out and money-in columns
- Writes US (MM/DD/YYYY) or UK and European (DD/MM/YYYY) QIF dates
- Bank, credit card, cash, other asset or other liability account types
- Flip signs for card exports that show purchases as positive numbers
- Exact amounts: no rounding and no floating point
- Runs entirely in your browser, no upload or signup
Use Cases
- Import a bank CSV into an app that reads QIF, such as Quicken for Mac, GnuCash, Moneydance or Banktivity
- Bring old statements into Quicken cash, asset or liability accounts
- Carry categories from a spreadsheet budget into a finance app
- Move transactions between finance apps when QIF is the common format
Frequently Asked Questions
How do I convert a CSV file to QIF?
Upload the CSV, confirm which columns hold the date, payee and amount (or money out and money in), choose the account type and date style, and click Download. Each transaction becomes a QIF record with D, T and P lines ending in ^.
Can Quicken import a QIF file into a checking account?
It depends on the version. Quicken for Mac imports QIF into most account types. Quicken for Windows limits QIF import into checking, savings and credit card accounts and expects QFX for those, while cash, asset and liability accounts still accept QIF. Check your version's import menu before converting.
Should I choose MM/DD/YYYY or DD/MM/YYYY?
Match the app and region that will import the file. US versions of Quicken and most US apps read MM/DD/YYYY; UK, European and Australian versions read DD/MM/YYYY. If dates import in the wrong month, convert again with the other style.
My bank shows purchases as positive numbers. What do I do?
Turn on Flip signs. QIF records money out with a minus sign, and many credit card exports use the opposite convention.
Why were some rows left out?
A row is left out when its date is not a real calendar date, its amount is not a number, or both amount cells are empty, such as a "Pending" or balance line. The notice above the output lists each one with the reason.
Are my transactions uploaded?
No. The CSV is read and the QIF file is built in your browser. Your transactions are not sent to a server.
Need to convert the other way? Try our QIF to CSV Converter