CSV to QBO Converter
Menu

CSV to QFX Converter

Convert a bank CSV or Excel file to QFX, the Web Connect file Quicken imports, right in your browser.

Drop your bank file here or choose a file

CSV, Excel, QBO, QFX, OFX or QIF · stays on your device

No signup. Your file never leaves your computer. Works in your browser.

How to convert CSV to QFX

  1. Download a CSV from your bank On your bank's website, open the account's transactions and choose CSV (or Excel) as the download format. Pick the dates you need.
  2. Drop the file into the converter Choose the file or drag it onto the box above. It is read by your browser; nothing is uploaded.
  3. Check the columns The converter matches the date, description and amount columns for you. If your credit card file shows purchases as positive numbers, turn on Flip signs.
  4. Review the transactions Every row is shown in a table. Fix a date, an amount or a description, or delete a row you don't want.
  5. Choose QFX and download Pick the account type and the bank shown in Quicken, then click Download QFX file.

How to import the QFX file into Quicken

Back up your Quicken data file before you import. These steps come from Quicken's own help pages.

Quicken for Windows

  1. Open the import screen Choose File › File Import › Web Connect (.QFX) File.
  2. Pick the file Select the QFX file you downloaded and click OK.
  3. Link the account Choose Link to add the transactions to an account you already have, or create a new account.
  4. Accept the transactions Open the account and review or accept the downloaded transactions.

Quicken's help pages name this menu item in slightly different ways (for example "Web Connect File"). Look for the Web Connect or .QFX item under File Import.

Quicken for Mac

  1. Open the import screen Choose File › Import › Bank or Brokerage File (OFX, QFX).
  2. Pick the file Select the QFX file and click Open.
  3. Choose the account On the Choose Your Accounts screen, pick the account to import into.
  4. Check the register Make sure the transactions were added.

Quicken for Windows, with a CSV file instead

  1. Make a Quicken CSV In the converter, choose Quicken CSV and type the account name exactly as it appears in Quicken.
  2. Open the CSV import Choose File › File Import › Banking Transactions › From (.CSV) File.
  3. Pick the file Click Choose .CSV File to Import…, select the file and click OK.

This is Quicken's own CSV import. Quicken describes it as useful for banks that don't support downloads. It does not check for duplicates, so import each file only once.

Why convert CSV to QFX

Quicken downloads transactions straight from banks that support it. If your bank only gives you a CSV or Excel file, or it stopped offering Quicken downloads, a CSV to QFX converter turns that file into the QFX format that Quicken’s Web Connect import reads. You keep your own account in Quicken and add the transactions to it.

What Quicken says about converted QFX files

Quicken’s support pages state that Quicken does not support QFX files created by third-party conversion software, and that Web Connect is meant for banks that partner with Quicken. When you import a QFX file, Quicken checks the bank information inside it. That is why the converter lets you choose the bank ID that goes into the file, and why it also offers the Quicken CSV option, which uses Quicken’s own, supported CSV import for Windows.

Works on Windows, Mac and phones

The converter is a web page that runs in a modern browser on Windows, Mac, iPhone, iPad or Android. There is nothing to install and no account to create. To import the file you need Quicken for Windows or Quicken for Mac on your computer.

Supported banks and file layouts

Any bank's CSV or Excel file

The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.

Known layouts, picked automatically

  • American Express card · Date, Description, Card Member, Account #, Amount, … 8 more
  • Apple Card · Transaction Date, Clearing Date, Description, Merchant, Category, … 3 more
  • Bank of America checking or savings · Date, Description, Amount, Running Bal.
  • Bank of America credit card · Posted Date, Reference Number, Payee, Address, Amount
  • Barclays credit card · Transaction Date, Description, Category, Amount
  • Capital One 360 checking or savings · Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance
  • Capital One credit card · Transaction Date, Posted Date, Card No., Description, Category, … 2 more
  • Charles Schwab Bank checking · Date, Status, Type, CheckNumber, Description, … 3 more
  • Charles Schwab Bank checking (older layout) · Date, Type, Check #, Description, Withdrawal (-), … 2 more
  • Chase checking · Details, Posting Date, Description, Amount, Type, … 2 more
  • Chase credit card · Transaction Date, Post Date, Description, Category, Type, … 2 more
  • Citi credit card · Status, Date, Description, Debit, Credit
  • Discover card · Trans. Date, Post Date, Description, Amount, Category
  • Mercury transactions · Date (UTC), Description, Amount, Status, Source Account, … 9 more
  • PayPal activity · Date, Time, TimeZone, Name, Type, … 11 more
  • PNC checking or savings · Transaction Date, Transaction Description, Amount, Balance
  • SoFi checking or savings · Date, Description, Type, Amount, Current balance, Status
  • Square transactions · Date, Time, Time Zone, Gross Sales, Discounts, … 44 more
  • Stripe balance report · balance_transaction_id, created_utc, available_on_utc, currency, gross, … 4 more
  • USAA checking or savings · Date, Description, Original Description, Category, Amount, Status
  • Venmo statement · ID, Datetime, Type, Status, Note, … 16 more
  • Wells Fargo · 5 columns, no header row

Each layout was checked against the bank's own help pages or real sample files. If your bank changes its layout, the converter still reads the file by its column names.

Common problems and fixes

Quicken says it is "unable to verify the financial institution information for this download"
Quicken shows this when it can't match the bank in the file. Quicken lists these causes: a wrong date on your computer, a bank that doesn't support your Quicken release, missing or wrong bank information, or an account type the bank doesn't support. Check your computer's date and update Quicken. Then try the bank list in the converter. If Quicken still refuses the file, use the Quicken CSV option instead.
Error CC-885
Quicken uses this code when a bank has stopped offering Web Connect in Quicken. A QFX file for that bank won't import. Use the Quicken CSV option.
Errors OL-220 to OL-226
Quicken says these codes on a Web Connect import mean there is a problem in the file itself. Open the file in the QBO file checker (it reads QFX files too) to find it, and rebuild a clean copy.
Purchases show up as deposits
Your card company lists purchases as positive numbers. Turn on Flip signs in step 2 and download again. A $50 purchase should show as −50.00.
Dates are wrong by months
Your file may write dates day first (05/01/2026 for January 5). Choose Day first under the date format in step 2.
Transactions appear twice
Quicken skips QFX transactions whose IDs it has already seen. The converter gives each transaction the same ID every time you convert the same file, so importing a file twice doesn't double it. A file made from a different download (for example, an overlapping date range) can repeat transactions, so pick dates that start after your last import. CSV imports into Quicken never check for duplicates.

CSV vs QFX

Both files can hold the same transactions. The difference is what Quicken does with them.

CSVQFX
What it isA plain table: one row per transactionA Web Connect statement file in the OFX format, made for Quicken
Opens inAny spreadsheet app, and Quicken for Windows (CSV import)Quicken for Windows and Quicken for Mac
Bank detailsNone, or an account name columnAccount type, account number and a bank ID that Quicken checks
Duplicate check in QuickenNoYes, by transaction ID
Official Quicken supportYes, for files in Quicken's CSV layoutQuicken says it does not support QFX files made by conversion software

Frequently asked questions

How do I convert a CSV file to QFX?

Drop your bank's CSV file into the converter above, check the columns and the transactions, choose QFX, pick your bank and download. It takes about a minute.

Can I convert Excel to QFX?

Yes. Excel files (.xlsx and .xls) work the same way as CSV. The converter reads the first sheet that has transactions; you can switch sheets if needed.

Will Quicken accept the QFX file?

It depends on whether Quicken accepts the bank ID in the file. Quicken says it does not support QFX files made by conversion software, so no converter can promise it. If Quicken rejects the file, the Quicken CSV option uses Quicken's own CSV import for Windows.

Do I need to sign up or install anything?

No. There is no account and nothing to install. The converter runs in your web browser on Windows, Mac or a phone.

Is my bank data safe?

Your file is read and converted by your own browser. It is never uploaded to us or anyone else. See how it works.

Does Quicken need anything else for QFX imports?

Quicken says Web Connect files are checked online and need an active Quicken subscription.

How far back can I go?

As far back as your bank's CSV goes. Quicken notes that banks typically offer 90 to 200 days of history for downloads, but many banks let you export older transactions as CSV from their website.

Last updated · EmproIT