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.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
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.
The download works, the file opens in Excel, and Quicken still refuses it.
Quicken for Windows imports transactions from a Web Connect QFX file. Its own help says it cannot import Excel, PDF or OFX files.
Some banks and card issuers retired the Quicken option and now offer only CSV or a PDF statement.
Many card exports split money out and money in. A Quicken file needs one signed amount on each line.
Some bank downloads have no column names at all, so a converter that expects named fields reads nothing.
Without a stable ID on each transaction, importing an overlapping date range doubles the register.
Bank CSV downloads often stop at 90 days to 18 months. Earlier periods are in the statement archive.
One upload, then pick the format your software reads.
A Web Connect file with the Intuit institution tag Quicken looks for, a posting date, a signed amount and an ID on every transaction.
A QIF file with a Bank or CCard header and date, amount, payee and memo records for programs that still read QIF.
The same transactions as an IIF file for QuickBooks Desktop or a QBO Web Connect file.
Finds the header row, the date column and either one amount column or a debit and credit pair. Headerless downloads are handled too.
Upload the statement PDF, a scan or a phone photo instead, and get the same QFX, QIF or IIF download.
It runs in the browser on Windows and Mac, with unlimited users on every paid plan.
The routine for one account and one date range.
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.
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.
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.
Quicken households, landlords and sole proprietors whose bank stopped offering a Quicken download, and the bookkeepers who clean up after it.
Rental accounts at small banks and credit unions that only export CSV or PDF.
Business checking and card activity kept in Quicken Business and Personal for Schedule C.
Clients on Quicken or QuickBooks Desktop who send a mix of CSV exports and statement PDFs.
Years of older months that the bank feed and the CSV download no longer reach.

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.
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.
| Software | File to download | Where it goes in | Worth knowing |
|---|---|---|---|
| Quicken Classic for Windows | QFX | File, File Import, Web Connect (.QFX) File | Quicken matches on transaction IDs, so a repeat import skips lines it already has. |
| Quicken for Mac | QFX | File, Import, Bank or Brokerage File (OFX, QFX) | You can also drag the file into the Quicken window. |
| Older Quicken and other QIF readers | QIF | File, File Import, QIF file | QIF has no transaction IDs, so importing the same range twice creates duplicates. |
| QuickBooks Desktop | QBO or IIF | Bank Feeds for QBO, File, Utilities, Import for IIF | QBO goes through bank feeds review. IIF posts straight to the register. |
| QuickBooks Online | QBO or CSV | Transactions, Bank transactions, Upload from file | Intuit caps an upload at 1,000 transactions and 350 KB per file. |
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.
Bank exports are not tidy. These are the cases that break simple converters, and what happens to each one here.
| What the CSV looks like | What ends up in the QFX |
|---|---|
| Notes or account details above the column names | The header row is located within the first 40 lines and everything above it is skipped. |
| Separate Debit and Credit columns | One signed amount per transaction, negative for money out. |
| Transaction date and posted date side by side | The transaction date is used. |
| No header row at all | Columns are recognized from their contents for the common US bank layouts. |
| Pending rows mixed in with posted ones | Rows marked pending in a status column are left out. |
| Amounts written with a decimal comma | The 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.
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.
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.
| BankXLSX | ProperConvert (ProperSoft) | CSV2QFX Convert (MoneyThumb) | |
|---|---|---|---|
| Where it runs | Browser | Windows and Mac app | Windows and Mac app |
| Price for QFX output | Plus, $149 a month or $74 a month billed yearly | $19.99 a month or $179.99 a year | Lifetime Pro license or a 50 day Express license, priced in the MoneyThumb store |
| Who a license covers | Unlimited users | One user on one device, or 3 on the Team plan at $49.98 a month | One user, with volume discounts from 2 licenses |
| PDF statements and scans | Yes, with OCR | PDF supported | PDF on the Windows only Pro+ and Express licenses |
| Volume | 1,920 pages a month on Plus | Unlimited | Unlimited |
| Best for | Teams, and anyone with PDF statements as well as CSV | One person converting many CSV files locally | Quicken 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.
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.
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.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.