CSV to QIF Converter

Quicken is the most popular personal finance software in the United States, with millions of active users managing bank accounts, investments, and budgets. The problem many Quicken users face is that their bank provides transaction downloads in CSV format, but Quicken requires QIF (or the newer QFX) format for import.

This is especially common with smaller banks, credit unions, fintech platforms, and international banks that export only CSV files. Users of prepaid cards, crypto exchanges, and payroll systems also frequently receive CSV transaction exports that need to be imported into Quicken for tracking.

Without a converter, Quicken users are stuck manually entering transactions one by one — a tedious process that is impractical for accounts with dozens or hundreds of monthly transactions. FinanceConvert bridges this gap by converting any standard bank CSV into a properly formatted QIF file that Quicken can import.

QIF (Quicken Interchange Format) is a plain-text format developed by Intuit for Quicken. It uses single-character line prefixes to denote different data fields within each transaction.

A QIF file starts with a type declaration: !Type:Bank for checking and savings accounts. Each transaction is then a block of lines ending with a caret (^) separator.

The key fields are: D for the transaction date in MM/DD/YYYY format, T for the signed amount (negative for debits, positive for credits), P for the payee or description, and M for an optional memo.

When Quicken imports a QIF file, it reads each block, creates a transaction record, and adds it to the specified account register. The signed T amount determines whether the transaction appears as a payment (negative) or deposit (positive) in the register.

FinanceConvert generates QIF files that follow this exact structure. Dates are formatted as MM/DD/YYYY, amounts are signed correctly based on the Debit/Credit columns in your CSV, and descriptions are mapped from the CSV Description or Payee column.

Step 1: Export transactions from your bank. Log into your online banking and download your transaction history as a CSV file. Most banks offer this under Statements, Activity, or Export.

Step 2: Verify your CSV has the right columns. FinanceConvert needs at minimum a Date column and an Amount column (or separate Debit/Credit columns). A Description column is strongly recommended. The converter auto-detects common column names.

Step 3: Upload your CSV to the converter on this page. Drop the file into the upload zone.

Step 4: FinanceConvert parses the CSV, maps each row to a QIF transaction record, converts dates to MM/DD/YYYY format, and signs the amount correctly (negative for debits, positive for credits).

Step 5: Download the .qif file.

Step 6: Import into Quicken. Open Quicken, go to File > Import > QIF File. Select the downloaded file, choose the target account, and click Import. Quicken will add the transactions to your register.

Tip: If you are using a newer version of Quicken that prefers QFX format, you can use our OFX to QFX converter as an additional step, or contact your bank to see if they offer OFX downloads directly.

Banks export CSV files in many different formats. FinanceConvert handles the most common variations:

Single Amount column with signed values — some banks use one Amount column where debits are negative (e.g., -450.00) and credits are positive (e.g., 3200.00). The converter reads the sign and maps to the correct QIF T value.

Separate Debit and Credit columns — many banks use two columns: Debit (or Withdrawal) for money out, and Credit (or Deposit) for money in. The converter detects these and computes the signed amount for QIF.

Various date formats — banks use MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD, and other formats. The converter handles ISO dates (YYYY-MM-DD) and US-style dates (M/D/YY or M/D/YYYY) and reformats them to the MM/DD/YYYY that QIF requires.

Different column names — the converter recognizes aliases: Transaction Date, Posting Date, Value Date for dates; Narrative, Particulars, Details for descriptions; Withdrawal, DR for debits; Deposit, CR for credits. This means CSV files from Chase, Bank of America, Citi, HSBC, and most other banks work without any manual column mapping.