Convert Capital One CSV to QBO / QFX / OFX

Capital One's own pages and a Quicken Community thread describe different downloads. Read both before assuming a QFX file will import.

Convert your file now: open the converter. It runs in your browser, your statement is never uploaded, and it's free up to 30 transactions per file.

What is documented

On the Quicken Community thread Capitol One Download, a customer said Quicken reported it was unable to verify the financial institution when importing downloads for a Capital One savings account and CDs. Credit card downloads were still working for them. A community reply says Capital One no longer supports QFX transaction downloads. The original poster replied that the website still showed a QFX option, that the financial-institution number no longer worked, and that they were downloading the CSV instead. They wrote that Capital One allowed up to two years of transactions in a single file. That two-year figure is the poster's report, not a limit printed on a Capital One help page we could find.

Capital One's business charge cards page says purchase records can be downloaded in formats including Quicken, QuickBooks, and Excel. That is a product description, not a menu path, and it is about those charge cards rather than the savings and CD problem in the Quicken thread.

We did not find a Capital One help article that lists the consumer click-path or the CSV column names. In online banking, use the download or export control on the account and choose the spreadsheet if QFX will not import. Then convert the spreadsheet.

CSV columns

The source linked below does not publish the column headings in the file. After you download it, use the header row you actually see. In the converter, map a date, a description, and either one signed amount or separate money-in and money-out columns. The preview rewrites dates as YYYY-MM-DD so you can confirm the day and the month before you download.

Convert it

  1. Open the converter and drop in the CSV or Excel file. Excel (.xlsx or .xls) is fine.
  2. If the bank put your name or account number above the table, set the header row to the row that names the columns.
  3. Map the date, the description, and either one signed amount or separate paid-in and paid-out columns. Confirm the dates in the preview, which shows them as YYYY-MM-DD.
  4. Choose QBO for QuickBooks Desktop, QFX for Quicken, or OFX, and download.

Import the converted file

FAQ

The QFX file is on the website but Quicken rejects it.

That matches the Quicken Community report: the option can still be listed while Quicken says it cannot verify the institution. Download the CSV and convert it to QFX.

Does every Capital One account lack a QuickBooks file?

No. Capital One's business charge-card page says those purchase records can be downloaded for Quicken, QuickBooks, and Excel. Savings and CD QFX imports are what the community thread is about.

How far back can one CSV go?

The only figure we can cite is the original poster's note of up to two years in one file. Confirm the date range on the download screen.

Sources

Last checked: 2026-10-28. Menus move. If a label on this page does not match what you see, use the bank's own help page linked below.