CSV to QFX Converter for Quicken with QIF and IIF Files from Bank CSV and PDF

Quicken reads Web Connect files, and a bank CSV is not one. Upload the CSV your bank or card issuer gave you, or the PDF statement when there is no CSV, and download a QFX file with dated transactions, signed amounts and a unique ID on every line. For people who keep their books in Quicken and the bookkeepers who work for them.

QFX, QIF, IIF and QBO on Plus
Reads bank CSV and PDF statements
One-time 15 page demo, no credit card

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV

Upload your bank statement

Extract:

How to convert a CSV file to QFX for Quicken

To convert CSV to QFX, upload the bank CSV to BankXLSX, check the parsed date, description and amount rows, and download the QFX file on the Plus plan. In Quicken for Windows choose File, File Import, Web Connect (.QFX) File. The same upload also downloads as QIF, IIF for QuickBooks Desktop, QBO, Excel or CSV, and a PDF statement works as the source when the bank offers no CSV.

Why a Bank CSV Will Not Go Into Quicken

The download works, the file opens in Excel, and Quicken still refuses it.

Quicken Wants Web Connect

Quicken for Windows imports transactions from a Web Connect QFX file. Its own help says it cannot import Excel, PDF or OFX files.

The Bank Dropped Its Quicken Download

Some banks and card issuers retired the Quicken option and now offer only CSV or a PDF statement.

Debit and Credit in Two Columns

Many card exports split money out and money in. A Quicken file needs one signed amount on each line.

No Header Row

Some bank downloads have no column names at all, so a converter that expects named fields reads nothing.

Duplicates After a Second Import

Without a stable ID on each transaction, importing an overlapping date range doubles the register.

Older Months Only Exist as PDF

Bank CSV downloads often stop at 90 days to 18 months. Earlier periods are in the statement archive.

From a Bank CSV to a File Quicken Accepts

One upload, then pick the format your software reads.

QFX for Quicken

A Web Connect file with the Intuit institution tag Quicken looks for, a posting date, a signed amount and an ID on every transaction.

QIF for Older Software

A QIF file with a Bank or CCard header and date, amount, payee and memo records for programs that still read QIF.

IIF and QBO for QuickBooks

The same transactions as an IIF file for QuickBooks Desktop or a QBO Web Connect file.

Reads Real Bank Layouts

Finds the header row, the date column and either one amount column or a debit and credit pair. Headerless downloads are handled too.

PDF When There Is No CSV

Upload the statement PDF, a scan or a phone photo instead, and get the same QFX, QIF or IIF download.

Nothing to Install

It runs in the browser on Windows and Mac, with unlimited users on every paid plan.

Convert CSV to QFX in 3 Steps

The routine for one account and one date range.

1

Upload the CSV

Drop the bank or card CSV into the converter above. Files up to 15 MB and 20,000 transactions are accepted.

Tip: Export one account per file so the QFX lands in one Quicken register.

2

Check the Rows

Review dates, descriptions and signs. Withdrawals and card charges should be negative, deposits and payments positive.

Tip: Compare the first and last transaction with the bank screen before you download.

3

Download QFX and Import

On Plus, download QFX. In Quicken for Windows use File, File Import, Web Connect (.QFX) File and pick the account.

Tip: Back up the Quicken data file first, then import one month as a test.

Who Converts CSV to QFX

Quicken households, landlords and sole proprietors whose bank stopped offering a Quicken download, and the bookkeepers who clean up after it.

Landlords on Quicken

Rental accounts at small banks and credit unions that only export CSV or PDF.

Sole Proprietors

Business checking and card activity kept in Quicken Business and Personal for Schedule C.

Bookkeepers

Clients on Quicken or QuickBooks Desktop who send a mix of CSV exports and statement PDFs.

Anyone Backfilling History

Years of older months that the bank feed and the CSV download no longer reach.

Transaction Types We Handle

Checking and savings activity
Credit card charges and payments
ACH deposits
Checks with numbers
Transfers
Bank fees
Interest
Refunds
Home office desk with a laptop showing a personal finance register next to printed bank statements

Can you convert CSV to QFX?

Yes. A QFX file is a text file in the Open Financial Exchange layout with a few Intuit tags added, so any tool that can read the CSV columns correctly can write one. The work is in the reading. A converter has to decide which column is the posting date, whether the amount is one signed number or a debit and credit pair, which text is the payee, and how to give every line an ID that stays the same the next time you export. BankXLSX does that on upload and shows you the rows before you download anything, which is where most bad imports are caught.

If you are curious what is inside the result, the QFX file format page walks through the header, the INTU.BID tag and each transaction field.

Which file should you download for your software

The upload is the same every time. What changes is the download you pick. This table follows what each vendor documents, with the one caveat that matters for Quicken users spelled out.

SoftwareFile to downloadWhere it goes inWorth knowing
Quicken Classic for WindowsQFXFile, File Import, Web Connect (.QFX) FileQuicken matches on transaction IDs, so a repeat import skips lines it already has.
Quicken for MacQFXFile, Import, Bank or Brokerage File (OFX, QFX)You can also drag the file into the Quicken window.
Older Quicken and other QIF readersQIFFile, File Import, QIF fileQIF has no transaction IDs, so importing the same range twice creates duplicates.
QuickBooks DesktopQBO or IIFBank Feeds for QBO, File, Utilities, Import for IIFQBO goes through bank feeds review. IIF posts straight to the register.
QuickBooks OnlineQBO or CSVTransactions, Bank transactions, Upload from fileIntuit caps an upload at 1,000 transactions and 350 KB per file.

QFX or QIF for Quicken

Use QFX unless you have a reason not to. Quicken treats a QFX file like a download from the bank: it shows the transactions for review, matches them against what is already in the register, and ignores the ones it has seen. That is the behavior you want when you import every month.

QIF is older and looser. It carries a date, an amount, a payee and a memo, and nothing that identifies a transaction, so Quicken cannot tell a second import from a first one. There is also a documentation conflict you should know about. Quicken support still has an article stating that QIF import is not available for checking, savings or credit card accounts, while newer Quicken documentation says those limits no longer apply. In practice current Quicken Classic versions accept it, but if your copy refuses a QIF into a bank account, that article is the reason, and the QFX download is the way around it. The bank statement to QIF converter page covers the QIF route in more detail.

What the converter does with a messy CSV

Bank exports are not tidy. These are the cases that break simple converters, and what happens to each one here.

What the CSV looks likeWhat ends up in the QFX
Notes or account details above the column namesThe header row is located within the first 40 lines and everything above it is skipped.
Separate Debit and Credit columnsOne signed amount per transaction, negative for money out.
Transaction date and posted date side by sideThe transaction date is used.
No header row at allColumns are recognized from their contents for the common US bank layouts.
Pending rows mixed in with posted onesRows marked pending in a status column are left out.
Amounts written with a decimal commaThe number format is worked out for the whole file, so 1.234,50 does not become 1.23.

If a file cannot be read, you get an error that says so instead of a QFX with half the lines missing. When that happens, the statement PDF for the same period is usually the cleaner source.

When the bank gives you a PDF and no CSV

This is the more common situation for older months. Online banking keeps downloadable activity for a limited window, while statements stay in the archive for years. Upload the PDF to the same converter and you get the same downloads. Scanned statements and phone photos are read with OCR. For the full Quicken walk through from a statement, see the Quicken bank statement converter. If the destination is QuickBooks Desktop, the bank statement to IIF converter page explains when IIF beats QBO.

CSV to QFX converter pricing compared

There are two established desktop tools for this job and they are cheaper than BankXLSX for one person converting CSV files on one computer. That is worth saying plainly. BankXLSX costs more because it also reads PDF statements and scans, and because a plan covers the whole team.

BankXLSXProperConvert (ProperSoft)CSV2QFX Convert (MoneyThumb)
Where it runsBrowserWindows and Mac appWindows and Mac app
Price for QFX outputPlus, $149 a month or $74 a month billed yearly$19.99 a month or $179.99 a yearLifetime Pro license or a 50 day Express license, priced in the MoneyThumb store
Who a license coversUnlimited usersOne user on one device, or 3 on the Team plan at $49.98 a monthOne user, with volume discounts from 2 licenses
PDF statements and scansYes, with OCRPDF supportedPDF on the Windows only Pro+ and Express licenses
Volume1,920 pages a month on PlusUnlimitedUnlimited
Best forTeams, and anyone with PDF statements as well as CSVOne person converting many CSV files locallyQuicken users who want a one time purchase

ProperConvert prices were read from the ProperSoft purchase page in October 2026, which also lists a 14 day money back guarantee on the first order. MoneyThumb describes its license types on the CSV2QFX help page without dollar amounts, so check its store for the current figure. For a closer look at each vendor see the ProperSoft alternative and MoneyThumb alternative comparisons, and bank statement converter pricing for our own plans. If QIF is the file you need, the CSV to QIF converter software comparison covers that choice.

Why does Quicken reject a converted QFX file?

Almost always because of the institution ID. Quicken reads the Intuit tag in the file and checks it online, and when the ID is missing or not one it recognizes you see a message that Quicken is unable to verify the financial institution information for this download. Files from BankXLSX carry a recognized Web Connect institution ID for that reason. Two other causes are worth ruling out. The account may still have online services switched on for a direct connection, which can block a Web Connect import into the same account. And the account type in the file has to agree with the register you import into: a credit card file will not go into a checking account.

We have not tested the output against every Quicken release, so import one month into a backed up data file before you run a full year. If Quicken refuses the file, contact us and send the message it shows.

Why Quicken Users Convert With BankXLSX

6
download formats from one upload
20,000
transactions per CSV file
CSV + PDF
both accepted as the source

Security & Privacy

  • No bank login and no connection to Quicken
  • 256-bit encryption on every upload
  • Delete uploaded files at any time
  • Unlimited users on every paid plan

Common Questions About Converting CSV to QFX

Yes. Upload the bank CSV to BankXLSX, review the parsed rows and download a QFX file on the Plus plan. The file is written in the Web Connect layout with the Intuit institution tag, a posting date, a signed amount and a unique ID on every transaction, which is what Quicken expects from a bank download.

Not as a general transaction import on Windows. Quicken for Windows imports transactions from Web Connect QFX files and, with limits, QIF files, and its help states that it cannot import Excel, PDF or OFX files. Its CSV options cover narrow cases such as security prices. Converting the CSV to QFX is the dependable route.

In Quicken Classic for Windows choose File, File Import, Web Connect (.QFX) File, select the file and pick an existing account or create a new one. In Quicken for Mac choose File, Import, Bank or Brokerage File (OFX, QFX), or drag the file into the Quicken window. Back up your data file first.

QFX is the Web Connect format banks use for Quicken downloads. Each transaction has a unique ID, so Quicken can skip ones it already has. QIF is an older text format with date, amount, payee and memo and no IDs, so a repeat import creates duplicates. Choose QFX for Quicken unless your software only reads QIF.

Yes. The same upload downloads as QIF on the Plus plan, with a Bank header for checking and savings accounts or a CCard header for credit cards. QIF suits older Quicken versions and other programs that still read the format.

Yes. Download IIF on the Plus plan and import it in QuickBooks Desktop under File, Utilities, Import, IIF Files. IIF posts transactions directly to the register without the bank feeds review step, so check the rows before you import.

Nearly. A QFX file is an OFX file with Intuit tags added so Quicken treats it as a Web Connect download. BankXLSX offers QFX and QBO downloads rather than a separate plain OFX button.

QFX, QIF, IIF and QBO downloads are on BankXLSX Plus at $149 a month or $74 a month billed yearly, with 1,920 pages a month and unlimited users. Starter at $49 a month covers Excel and CSV. A one-time 15 page demo lets you see how your file is read before you pay.

Related Resources

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citibank Wells Fargo Goldman Sachs Morgan Stanley U.S. Bank PNC Bank Truist Capital One TD Bank Charles Schwab Fidelity Vanguard E*TRADE TD Ameritrade Bank of New York Mellon State Street BMO USA Ally Financial Regions Fifth Third Bank Huntington KeyBank Citizens Bank First Citizens Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bank East West Bank First National of Nebraska Frost Bank BOK Financial Fulton Financial Associated Banc-Corp Valley National Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Bank Webster Bank Cadence Bank Old National First Interstate BancSystem Umpqua Bank First Hawaiian Bank Prosperity Bank SouthState First Merchants First Bank Holding Glacier Bank First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Pacific Premier Bancorp Bank OZK United Community Banks Customers Bank Texas Capital SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial Flagstar Bank Synovus Bank Santander Bank Commonwealth Bank (CommBank) ANZ Bank Westpac NAB ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA