Convert CSV File to QFX for Quicken, or Import the CSV?

Quick Answer: Quicken for Windows imports CSV directly through File > File Import > Banking Transactions, as long as the columns follow its fixed order, so conversion is optional there. Convert to QFX when you need what CSV import lacks: duplicate matching, adding to an existing account on a Mac, or a Web Connect file. A CSV to QFX converter wraps your rows in Quicken's format with a bank ID Quicken accepts.

QFX is Quicken's Web Connect format, an Open Financial Exchange file carrying an Intuit bank identifier. Quicken reads it the way it reads a bank download: it matches incoming transactions to ones already in the register and skips duplicates. CSV import is simpler and has no such checks. That difference, not the file extension, is why people convert CSV to QFX.

Can Quicken import a CSV without converting it?

Yes, on both platforms, with different rules.

Quicken for Windows. Quicken's CSV import article gives the path File > File Import > Banking Transactions > From (.CSV) File, then Choose .CSV File to Import… and OK. The file must contain these columns in this order, even when some are empty:

Quicken is explicit about the limits: CSV import "does not detect or create transfer transactions," does not check for or match existing transactions the way Web Connect (.QFX) imports do, and reimporting the same file creates duplicates.

Quicken for Mac. Quicken's Mac CSV article uses File > Import > Mint.com File (CSV) with its own column set. The catch is significant: importing a CSV always creates a new account named after the file. You cannot add the rows to an account you already have.

When is converting CSV to QFX worth it?

• You are on a Mac and want the transactions in an existing account. CSV import cannot do it; a QFX import can.
• The period overlaps what Quicken already has. Web Connect matching avoids the duplicates a CSV reimport would create.
• Your CSV does not match Quicken's column order and you would rather let a converter map columns than rebuild the sheet.
• You want transfers and downloaded-transaction handling to behave as they do for a bank download.

If none of those apply, for example a one-time load of old history into a new Windows account, rearranging the CSV into Quicken's ten columns is free and quick.

What does a CSV to QFX converter do?

It turns each row into an OFX transaction (date, amount, payee, a unique transaction ID) and wraps them with account information and a bank identifier in the INTU.BID field. That last part is where conversions fail. Quicken checks the bank ID during Web Connect import, and Quicken's support page on verification errors lists the usual reasons a file is refused: the financial institution information is incorrect or missing, the institution does not support that account type, the institution does not support your Quicken release, or the computer's date is wrong.

Converters handle this by inserting the ID of an institution that supports Web Connect. When you set one up, check:

1. Account type. Bank and credit card files differ; choose the type that matches the Quicken account.
2. Date format. Tell the converter whether your CSV uses month-first or day-first dates.
3. Signs. Withdrawals must end up negative in the QFX.
4. Unique IDs. Each transaction needs its own ID, stable across reruns, or Quicken may skip rows or duplicate them.
5. A test import. Import a short file into a test data file first, and back up your real Quicken file before the full import.

On a Mac, the same converted QFX file works; there is nothing Windows-specific in the format. Free converters exist, often as trials or with row limits; paid ones add saved mappings and batch work. Our QIF vs QFX comparison explains why Quicken favours QFX over the older QIF format for bank accounts.

How do you reshape a bank CSV into Quicken's column order?

Most bank exports have the right information in the wrong places. Say yours has Posting Date, Details, Withdrawal, Deposit, Balance. Build Quicken's layout on a new sheet:

1. Date (A). If the bank's dates are real Excel dates, =TEXT(Sheet1!A2,"mm/dd/yyyy") produces the month-first text Quicken wants. If they are day-first text, split and rebuild them before anything else.
2. Payee (B). Point at the bank's description column. Trim long references with LEFT if you like shorter payee names.
3. FI Payee (C). Leave empty or copy the raw description for reference.
4. Amount (D). Combine the two money columns into one signed figure: =N(Sheet1!D2)-N(Sheet1!C2), which turns withdrawals negative and deposits positive.
5. Debit/Credit (E) and Category (F). Leave blank unless you want to pre-categorise.
6. Account (G). Type the exact Quicken account name and fill it down. A misspelt name is the most common reason rows land somewhere unexpected.
7. Tag, Memo, Chknum (H to J). Optional; leave the columns present even when empty.

Drop the balance column entirely, delete the bank's header row if Quicken's template does not expect one, save as CSV, and import a ten-row sample before the full file. Once this sheet works, keep it as a template: paste next month's export into Sheet1 and the Quicken layout fills itself.

Can you convert Excel to QFX?

Only by way of CSV. Save the sheet as a CSV, then either rearrange it into Quicken's CSV columns and import it directly on Windows, or run it through a converter. No mainstream tool reads .xlsx and writes QFX in one step without that intermediate save, so if a tool claims to, it is doing the CSV save behind the scenes.

How do you convert QFX back to CSV?

A QFX is text. Open it in a text editor and each transaction sits between <STMTTRN> tags, with the date in DTPOSTED, the amount in TRNAMT and the payee in NAME. To get a spreadsheet:

• use a converter that reads OFX-family files and writes CSV, or
• import the QFX into Quicken and export a report, or
• parse the tags with a short script.

Our guide to opening a QFX file in Excel walks through those routes.

Is converting the original statement a better idea?

If the CSV came from your bank, check what else the bank offers. Many institutions that support Quicken provide a QFX download directly, which beats any conversion because the bank ID and transaction IDs are genuine. If the bank offers only PDF statements for the period, convert the PDF rather than a hand-made CSV: fewer steps, fewer chances to flip a sign.

QuickBankConvert works from that starting point. It reads PDF statements and OFX files, not CSV, so it is not a CSV to QFX converter. From a statement PDF it produces a QFX for Quicken, on the Plus plan; the PDF to QFX page explains the process, and our Quicken integration page covers importing the result. For the CSV route on Windows, see our Quicken CSV import guide.

Related guides

• Making a QFX file from a PDF statement
• QIF and QFX compared for Quicken users
• Quicken's own CSV import, step by step
• Importing into Quicken