Convert CSV to QIF for Quicken
QIF is the only format that preserves categories and split transactions on import. Convert your bank CSV to a clean QIF file — Quicken reads it without column mapping.
For Quicken, Banktivity, MYOB, and YNAB users. Free online — no software to install.
How It Works
Upload Your CSV
Bank export, credit card download, Fidelity statement, or any CSV with transaction data. Any column layout works.
Columns & Categories Mapped
Date, payee, amount, memo, and category fields auto-detected. Split transactions preserved if present in your CSV.
Download QIF
Quicken Interchange Format file with proper date encoding and category tags. Import via File > Import in Quicken, Banktivity, or YNAB.
QIF vs QFX vs OFX — What Quicken Actually Imports
| Feature | QIF | QFX / OFX |
|---|---|---|
| Categories | Yes (L-records) | No |
| Subcategories | Yes (Category:Sub) | No |
| Split transactions | Yes (S-records) | No |
| Check numbers | Yes | Yes |
| Memo field | Yes | Yes |
| Duplicate detection | No (by date only) | Yes (FITIDs) |
| Quicken Mac support | Empty files only | Full support |
Use QIF when you need categories or splits. Use QFX/OFX when you need duplicate detection or Mac incremental imports.
What is CSV?
Comma-Separated Values
Flat text file with no standard structure. Every bank exports different columns, date styles, and amount formats. Quicken can import CSV only in Mint-compatible format — anything else gets rejected or needs manual mapping.
What is QIF?
Quicken Interchange Format
Quicken's original file format, still the only one that carries categories, subcategories (Category:Subcategory), and split transactions. Uses tagged lines (D for date, T for amount, P for payee, L for category, S for splits).
Why This Tool
Categories Preserved
QIF is the only Quicken import format that carries category data. We map your CSV's category column to QIF L-records so Quicken imports them directly.
Split Transaction Support
Multiple categories per transaction? We output QIF S-records (split lines) so Quicken reads proper splits — not flattened single-line entries.
Correct QIF Date Encoding
QIF uses M/D'Y format with apostrophe for 2000s dates. Wrong encoding causes century bugs (2017→1917). We handle this automatically.
Auto-Detect Any CSV Layout
Date, Payee, Amount, Memo, Category — detected regardless of column names, order, or language. 3-column and 4-column (debit/credit) layouts both work.
Penny-Accurate Amounts
Rounds to 2 decimal places and validates debit/credit signs before output. No 0.01 cent rounding errors that plague other CSV-to-QIF tools.
Works on Mac, Windows, Linux
QIF files import into Quicken Windows, Quicken Mac (into empty accounts), Banktivity, MYOB, YNAB, and GnuCash across all platforms.
When to Use This
Categorized Bank Imports
Your CSV has category data from expense tracking. QFX/OFX would lose it — QIF is the only format that brings categories into Quicken intact.
Fidelity & Brokerage Exports
Fidelity changed its download process, leaving CSV as the main export option. Convert to QIF and import into Quicken with payees and categories preserved.
Banktivity & YNAB Users
Both accept QIF natively. Convert your bank CSV once, import into Banktivity or YNAB without column mapping or format errors.
How to Import QIF Into Quicken
Quicken Windows
- Go to File > Import > QIF File
- Browse and select your .qif file
- Choose the Quicken account to import into
- Select account type (Bank, Credit Card, etc.)
- Review — categories appear in the Category column
Quicken Mac
- Create a new temporary account (Mac requires empty file)
- Go to File > Import > QIF
- Select your .qif file
- Move transactions to your real account
- Delete the temporary account
Common QIF Import Issues in Quicken
Dates imported in wrong century (1917 instead of 2017)
QIF uses apostrophe notation for 2000s dates (1/15'7 = 2007). Two-digit years without the apostrophe default to 1900s. Our converter outputs the correct format.
Categories show as "Other" or are missing after import
Quicken Subscription dropped QIF category processing. The categories must be in the QIF file itself (L-records) — we include them. Also ensure the category names exist in your Quicken category list first.
Split transactions imported as single-line entries
Many converters flatten splits into one amount. We output proper QIF S-records (split lines with separate category and amount per split).
Amounts off by $0.01 after import
Caused by CSV amounts with extra decimal places (e.g., 12.345) or debit/credit sign confusion. We round to 2 decimals and validate signs before output.
Quicken Mac says "can only import into an empty file"
This is a Mac limitation. Create a new temporary account, import QIF there, move transactions to your real account, then delete the temporary one.
Frequently Asked Questions
Why use QIF instead of QFX or OFX for Quicken?
QIF is the only format that imports categories, subcategories (Category:Subcategory), and split transactions. QFX and OFX don't carry category data — Quicken has to re-categorize every transaction.
Quicken Subscription ignores my QIF categories — why?
Starting with Quicken Subscription, QIF imports go straight to the register without processing renaming rules or category matching. Categories in the QIF file itself still import — but Quicken won't auto-apply its own rules on top.
My dates imported as 1917 instead of 2017 — what happened?
QIF uses a special date format with apostrophe for 2000s (1/15'7 = Jan 15, 2007). Two-digit years without the apostrophe get read as 1900s. Our converter handles this correctly.
Can I import QIF into Quicken for Mac?
Yes, but Mac only imports QIF into empty files. Workaround: create a temporary account, import there, then move transactions to your real account.
My amounts are off by $0.01 after import — why?
Rounding errors happen when CSV amounts have more than 2 decimal places or when debit/credit columns get swapped. We round to 2 decimals and verify sign conventions before output.
Does it preserve split transactions?
Yes. If your CSV has split data (multiple category/amount pairs per transaction), we output QIF S-records so Quicken reads them as proper splits.
What software reads QIF files?
Quicken (all versions), Banktivity, MYOB, YNAB, NetSuite, GnuCash, Moneydance, and most personal finance tools that accept Quicken Interchange Format.
Other CSV-to-QIF tools cost $25-50. Is this free?
Yes. MoneyThumb CSV2QIF and ProperConvert require paid licenses. We convert free online, no signup, no desktop install needed.
Is my data secure?
Encrypted in transit, processed in memory, never stored. Your CSV is deleted after conversion.
Related Tools
CSV to QBO
Convert CSV financial files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →CSV to OFX
Convert CSV financial files to OFX format for Quicken, GnuCash, Moneydance, and other accounting tools. Auto-detects columns. Free, instant, no signup required.
Convert now →PDF to QIF
Convert bank statement PDFs to QIF for all Quicken versions. AI preserves dates, payees, and amounts from any bank layout. Free online, no signup.
Convert now →CSV to QFX
Convert CSV financial files to QFX for Quicken Web Connect import. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →