How to Import Bank Statements into Quicken (QFX, QIF, CSV)

Quicken will not open a PDF bank statement, and that trips up a lot of people the first time they try. Quicken takes transactions in one of two ways: a live feed from a connected bank, or a file it recognizes. The file it recognizes is a QFX (Web Connect), a QIF, or a CSV laid out in its required column order. So to import a statement you have as a PDF, you convert the PDF to one of those formats and then bring it in under File, Import. This guide walks through each format, when to use it, and the exact menu clicks on both Windows and Mac.

Why Quicken will not import a PDF bank statement

A PDF is a picture of a statement, not structured data. Quicken needs to read a date, a payee, and an amount for every line, and a PDF does not hand those over in a form it can parse. Direct Connect and Express Web Connect solve this for accounts that connect cleanly, but those feeds do not cover every bank. Smaller banks and credit unions, business accounts, accounts you have already closed, and statements older than the feed reaches all tend to fall back to the PDF. In those cases you get the data in by converting the PDF to a file Quicken imports.

The three file formats Quicken imports

Before the steps, it helps to know what each format does, because the right choice depends on the account and your Quicken version.

• QFX (Web Connect): the format built for banks. Quicken matches a QFX against transactions already in the register, so a re-import does not create duplicates. QFX does not carry categories, and a QFX stops importing once your Quicken version is about three years old, so keep your copy reasonably current.
• QIF: the older format that carries categories and tags. In modern Quicken for Windows, QIF import is limited to cash, asset, and liability accounts rather than bank accounts, so it suits those accounts and older Quicken builds. It is still useful when you want categories to come across.
• CSV: a plain spreadsheet. Quicken for Windows reads a CSV with Date, Payee, Amount, Category, Tags, Notes, and Check Number columns, with dates written as MM/DD/YYYY. Quicken for Mac also accepts a CSV import. CSV is handy when you want to review and clean the numbers in a spreadsheet first.

For a normal checking, savings, or card account, QFX is usually the smoothest path because of the duplicate matching. Reach for QIF when categories matter and the account allows it, and CSV when you want a look at the data before it touches your ledger.

Step 1: Convert the PDF statement to a Quicken file

Start by turning the statement into structured rows. Upload the PDF to a Quicken bank statement converter, check that the date, payee, and amount rows look right in the preview, and export the format you want: a QFX for a matched import, a QIF for categories, or a CSV or Excel file to review first. A good converter reads scanned and image-based statements through OCR, not just digital PDFs, so an older statement you saved as an image still comes through. Make sure the dates land as MM/DD/YYYY so days and months do not flip when Quicken reads them.

Step 2: Import a QFX (Web Connect) file

This is the one-click route for a bank or card account.

1. In Quicken, choose File, then File Import, then Web Connect (.QFX) File.
2. Browse to the QFX you exported, or drag and drop it onto the window, and click Continue.
3. When Quicken asks, link the file to the correct account, or let it create a new account if this is the first import.
4. Confirm. Quicken adds the transactions and matches against anything already in the register so you do not get duplicates.

One detail worth knowing: a QFX carries an account ID, so if you convert files for more than one account, use a different account ID for each so Quicken keeps them separate.

Step 3: Import a QIF file

Use this when you want categories and tags to come across, and the account supports it.

1. Open the account you want the transactions to land in.
2. Choose File, then Import, then Import QIF File (on Mac the path is File, then Import, then QIF File).
3. Select the .qif file and pick the matching account.
4. Quicken maps the date, payee, amount, and category fields and brings the transactions in.

Remember the Windows limitation: recent Quicken for Windows restricts QIF import to cash, asset, and liability accounts. If your account is a standard bank account and the QIF option is greyed out, use the QFX route instead.

Step 4: Import a CSV file

CSV is the route when you want to clean or check the data in a spreadsheet first. Lay the file out in the column order Quicken expects, Date, Payee, Amount, Category, Tags, Notes, Check Number, with MM/DD/YYYY dates and no currency symbols or thousands separators in the amount column. Then use Quicken's CSV import for the account and map the columns when prompted. Because the converter can export the same statement as both a QFX and a CSV, a common workflow is to export the CSV, eyeball it in Excel, fix any odd payee names, and then import.

How to avoid duplicate transactions

Duplicates are the most common complaint after an import. Three habits prevent almost all of them. First, prefer QFX for bank accounts, because its matching is built to skip transactions already in the register. Second, do not import an overlapping date range twice. If you imported January 1 to 31, start the next file on February 1. Third, after a QIF or CSV import, where matching is weaker, scan the register for the first and last few days of the range, since overlap shows up at the edges. If duplicates do slip in, sort the register by date and delete the repeats before you reconcile.

Windows versus Mac, and Quicken Classic versus Simplifi

Quicken Classic on Windows and Mac both import QFX and CSV, and both import QIF with the account-type caveat above. Quicken Simplifi is a separate, web-based product that leans on connected feeds and does not offer the same file-import menu, so the QFX and QIF route here applies to Quicken Classic. If you are on Simplifi and a bank will not connect, the practical fix is to keep the account in Quicken Classic for file imports, or convert to CSV and track those transactions in a spreadsheet alongside.

Frequently asked questions

Can you import bank statements into Quicken? Yes, but not as a PDF. Quicken imports transactions from a connected bank feed or from a file it understands: a QFX (Web Connect), a QIF, or a CSV in its required column order. Convert the PDF statement to one of those formats first, then import it under File, Import.

How do I import a QFX file into Quicken? Choose File, then File Import, then Web Connect (.QFX) File. Browse to the QFX or drag it onto the window, click Continue, link it to the right account, and confirm. Quicken adds the transactions and matches against the register so duplicates are skipped.

Does Quicken import CSV files? Yes. Quicken for Windows and Mac both accept a CSV import. Lay the file out with Date, Payee, Amount, Category, Tags, Notes, and Check Number columns, dates as MM/DD/YYYY, and no symbols in the amount column, then map the columns when Quicken prompts you.

Why won't Quicken import my bank statement? Almost always because the file is a PDF, which Quicken cannot read. It needs a QFX, QIF, or formatted CSV instead. Other causes are a QFX older than your Quicken version allows, a wrong date format, or trying to import QIF into a bank account on Windows, which is not supported.

What is the difference between QFX and QIF? QFX (Web Connect) is the bank format: it matches against your register to avoid duplicates but does not carry categories, and it expires after your Quicken is about three years old. QIF carries categories and tags but, on Windows, only imports into cash, asset, and liability accounts.

Can I import several months at once? Yes. Convert each statement and import them in date order, oldest first, without overlapping ranges. For a clean multi-account history, give each account its own files and link each import to the matching account so Quicken does not mix them.

Put it together

Importing a bank statement into Quicken comes down to one rule: hand Quicken a file it can read. Convert the PDF to a Quicken-ready QFX, QIF, or CSV, then import it under File, Import, choosing Web Connect for a QFX, QIF File for a QIF, or the CSV import for a spreadsheet. If you would rather work in a generic format first, you can export a QIF file from the statement or an OFX file and review it before importing. If your books actually live in QuickBooks rather than Quicken, the two are different products: convert the statement straight to a bank statement to QuickBooks (QBO) file instead. And once the transactions are in, attach proof to them by digitizing paper and email receipts with receipt OCR software, or pull the whole statement into a worksheet with a PDF to Excel converter if you would rather reconcile by hand. For a wider comparison of tools, see our guide to the best bank statement converter software.