Skip to content
BookkeepKit

Convert a Bank CSV to QFX for Quicken

Turn a CSV from online banking or a card portal into a Quicken Web Connect (.qfx) file. Columns are recognized automatically, every transaction gets a stable ID, and you review everything before downloading.

Drop a bank CSV file here

From online banking or a card portal. Excel, PDF and OFX files work too.

Processed in your browser. Your files never leave your computer.

Pro and Business: drop several statements at once to convert them in one go.

How it works

  1. 1

    Drop the CSV

    Any delimiter, with or without a header row. Excel files and PDF statements work as well.

  2. 2

    Check columns and amounts

    Confirm the date, description and amount columns. Card exports with purchases as positive numbers are spotted and flipped for you.

  3. 3

    Download the QFX

    Import it into Quicken for Windows or Mac and link it to the account the transactions belong to.

When you need a QFX file

Quicken expects bank data as a Web Connect download. Many banks stopped offering QFX downloads, cap them at the last 90 days, or only offer them for some account types. A CSV export is almost always available. Converting it gives Quicken the format it handles best, without retyping or hand-editing a file.

It's also a way to backfill history. Download a year of transactions as CSV (most banks allow longer ranges for CSV than for Quicken downloads), convert, and import once.

What the converter does with your CSV

  • Reads any layout: comma, semicolon or tab separated, UTF-8 or Windows-1252, with account details above the header or totals at the bottom.
  • Finds the columns: headers like Posted Date, Payee, Withdrawals or Running Balance are recognized, and you can change the matching by hand.
  • Normalizes amounts: dollar signs, thousands separators, parentheses and trailing minus signs are handled; debit and credit columns are merged.
  • Checks balances: when the CSV has a running balance, opening and closing balances are calculated and each row is checked against the previous one.
  • Writes OFX 1.02 SGML: the version Quicken's Web Connect import expects, with descriptions longer than 32 characters kept in the memo.

Importing the QFX into Quicken

Quicken for Windows

  1. Back up your data file.
  2. Choose File > File Import > Web Connect (.QFX) File and select the file.
  3. When Quicken asks, link it to the existing account rather than creating a new one, so the transactions land in the right register.
  4. Accept the downloaded transactions from the review pane under the register.

Quicken for Mac

  1. Choose File > Import > Bank or Brokerage File (OFX, QFX, QIF).
  2. Select the file and the account to import into.
  3. Review the new transactions before accepting them.

Tips for a clean import

  • Convert one account per file. If your CSV mixes checking and savings, split it first with the CSV splitter.
  • Set the account type to Credit card in the review step for card exports, so payments and purchases keep the right direction.
  • If two CSVs cover overlapping dates, merge them and remove repeats with the duplicate finder before converting.
  • Keep the original CSV. If something looks wrong in Quicken, you can convert again with corrections.

Frequently asked questions

Why not import the CSV straight into Quicken?

Quicken for Windows doesn't import bank CSV files, and the Mac version's CSV import doesn't recognize transactions it has already downloaded. A QFX file carries an ID for each transaction, so Quicken can match it with what's already in the register instead of adding it twice.

What's the difference between QFX and OFX?

QFX is OFX 1.02 with an extra Intuit tag that identifies the bank. Quicken reads QFX as a Web Connect download. Other personal finance and accounting programs read plain OFX; use the CSV to OFX converter for those.

Quicken says it can't verify the financial institution. What now?

Quicken checks the bank identifier inside Web Connect files, and some versions only accept identifiers of banks that offer Quicken downloads. Try importing into an existing account rather than creating a new one. On Quicken for Mac, File > Import > Bank or Brokerage File also accepts plain OFX, which avoids the check.

Will re-importing an overlapping date range create duplicates?

Usually not. Each transaction ID is built from its date, amount and description, so converting the same CSV again gives the same IDs, and Quicken skips transactions it has already accepted. If you edit a description before converting, that transaction gets a new ID.

My CSV has Debit and Credit columns. Does that work?

Yes. Separate withdrawal and deposit columns are combined into one signed amount: money out negative, money in positive.

Is the CSV uploaded?

No. The file is read and converted by your browser. Nothing about its contents is sent to a server.

Guides

Statements from a specific bank: Chase statement converter · Bank of America statement converter

Related tools