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

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) downloaded from your bank, a QIF, or a CSV laid out in its required column order. A real QFX can only come from the bank, because it carries an Intuit institution ID the bank is issued, so to import a statement you have as a PDF you convert the PDF to CSV and bring it in under File, 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, and the route for a PDF statement. Quicken for Windows imports it under File, File Import, Banking Transactions, From (.CSV) File, with columns such as Date, Payee, FI Payee, Amount, Debit/Credit, Category and Account and dates written as MM/DD/YYYY. Quicken for Mac also accepts a CSV, through File, Import, Mint.com File (CSV) with the Mint column names, and the Quicken for Mac CSV import guide covers that layout. CSV is handy when you want to review and clean the numbers in a spreadsheet first.

For a normal checking, savings, or card account, a QFX your bank offers is the smoothest path because of the duplicate matching. When the bank has no QFX for the period you need, which is the usual reason you are holding a PDF, CSV is the route. Reach for QIF when categories matter and the account allows it.

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 CSV laid out for Quicken's import, an OFX for other finance software, or an 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 from your bank

This is the one-click route when your bank offers a Quicken download for the dates you need. It does not apply to a converted PDF: no converter can issue the institution ID a genuine QFX carries.

1. In Quicken, choose File, then File Import, then Web Connect (.QFX) File.
2. Browse to the QFX you downloaded from the bank, 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: link each download to the existing account in your register rather than letting Quicken create a new one, or you end up with two copies of the same account.

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 CSV route instead.

Step 4: Import a CSV file

This is the route for a converted PDF statement. Lay the file out with the columns Quicken expects, Date, Payee, Amount and optionally FI Payee, Debit/Credit, Category and Account, with MM/DD/YYYY dates and no currency symbols or thousands separators in the amount column. In Quicken for Windows choose File, File Import, Banking Transactions, From (.CSV) File, pick the account and map the columns when prompted. Our converter exports CSV and Excel, so a common workflow is to export Excel, eyeball it, fix any odd payee names, save it as CSV 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, when your bank offers QFX for the dates you need, use it, because its matching is built to skip transactions already in the register. Second, a CSV import does not match against existing transactions at all, so import only the dates that are missing: if the register already runs from March onward, the CSV should stop on the last day of February. Third, after a QIF or CSV import, 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 cannot read Quicken Classic data or QFX files, but it does import CSV from its web app, one account at a time, with its own columns (Date, Payee, Amount) and a minus sign on every expense. The steps for that are on our Quicken Simplifi import transactions page.

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) from your bank, a QIF, or a CSV in its required column order. Convert the PDF statement to CSV, then import it under File, File Import, Banking Transactions.

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 and Amount columns (Quicken for Windows also reads FI Payee, Debit/Credit, Category and Account), dates as MM/DD/YYYY and no symbols in the amount column, then map the columns when Quicken prompts you. A CSV import does not match existing transactions, so import only the missing dates.

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 the statements to CSV and import them in date order, oldest first, without overlapping ranges, because the CSV import will not catch duplicates for you. 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 CSV on the convert bank statement to Quicken page, then import it under File, Import, choosing the CSV import for a spreadsheet. If you would rather work in a generic format first, you can export an OFX file and review it before importing, though Quicken itself will not read it. For background on the older format, see the QIF file guide. 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.