Quicken Bank Statement Converter: Convert PDF Bank Statements to QFX, QIF, and Excel for Import

Upload a PDF bank statement and download it as a QFX (Web Connect) file, a QIF file, or a clean CSV or Excel sheet that drops straight into Quicken Classic. No bank login, no manual entry, no fighting a connection that will not link.

QFX, QIF, CSV and Excel output
Date, payee, amount columns
For Quicken on Windows and Mac
Free to start, no credit card

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|

Why convert a bank statement for Quicken

Quicken downloads transactions automatically when your bank connects through Direct Connect or Express Web Connect, but those feeds do not cover every account. Smaller banks and credit unions never link, business accounts get dropped, closed accounts stop downloading, and older periods you need to backload are simply gone from the feed. A statement that arrives as a PDF cannot be imported either, because Quicken reads accounting files, not PDFs. The dependable path in every one of those cases is to hand Quicken a file it knows: a QFX (Web Connect) file, a QIF file, or a CSV in the exact column order it expects. This converter reads the statement PDF and writes that file for you, so the import lines up the first time.

QFX for a one-step Web Connect import

A QFX (Quicken Web Connect) file imports under File, Import, Web Connect, and Quicken matches it against transactions already in the register so you do not get duplicates.

QIF when you want categories

QIF carries categories and tags, so it suits cash, asset, and liability accounts and older Quicken workflows where you want the import to bring category data along with each line.

CSV in Quicken's column order

Quicken for Windows reads a CSV with Date, Payee, Amount, Category, Tags, Notes, and Check Number columns, dates as MM/DD/YYYY. Export to CSV or Excel to review the data before you import.

How to convert a bank statement for Quicken

Four steps, nothing to install.

1

Get the PDF

Download the statement PDF from your bank, or use the file a client emailed you. It works for checking, savings, and credit card statements from any US bank.

2

Upload it here

Drop the PDF into the converter at the top of this page. Password-protected files are detected the moment you upload them.

3

Pick your format

Review the date, payee, and amount rows in the preview, then export a QFX, a QIF, or a CSV or Excel file depending on how you want to import.

4

Import into Quicken

In Quicken, open File, then Import, and choose Web Connect for a QFX, QIF File for a QIF, or the CSV import for a formatted CSV. Pick the account and confirm.

Prefer to land transactions through a finance format rather than a spreadsheet? You can also build a bank statement to OFX file, which Quicken, GnuCash, and most finance apps accept, or a QIF file from your bank statement when you want categories to come across.

Who uses the Quicken bank statement converter

Rental property owners

Quicken Business and Personal is popular with landlords. When a property account will not connect, convert the statement and import it so rent, mortgage, and repairs all post to the right property.

Sole proprietors

Keep business and personal spending separate in Quicken. Convert each month's bank and card PDF into a QFX or CSV so your categories and tax lines stay current without retyping.

Long-time Quicken users

If your bank dropped Direct Connect or your connection keeps failing, a QFX or QIF built from the statement gets the data in cleanly, so years of history stay in one file.

Bookkeepers and advisors

Clients on Quicken often send only the statement PDF. Convert it to the format their setup imports, reconcile the account, and skip the data entry entirely.

Built for the formats Quicken imports

A bank statement PDF carries opening and closing balances, deposits, withdrawals, checks, card activity, fees, and interest, often across several pages. Quicken will not read that PDF, but it will read a QFX, a QIF, or a CSV in its required column order. The converter pulls every transaction into clean date, payee, and amount rows and writes the file in the shape Quicken expects, so the import maps without errors.

  • QFX (Web Connect) for a matched, duplicate-aware import
  • QIF when you want categories and tags to come across
  • CSV with Date, Payee, Amount and the rest of Quicken's columns
  • Dates written as MM/DD/YYYY so days and months do not flip
  • Scanned and image-only PDFs read with built-in OCR

Output you can use anywhere

Export QFX or QIF for a direct Quicken import, or CSV and Excel (.xlsx) to check the numbers first. The same files work in other tools too. If you also bring vendor bills into your books, pull the line items off them with an invoice data extractor, and turn any other report PDF into a spreadsheet with a PDF to Excel converter.

QFX (Web Connect) QIF CSV Excel .xlsx MM/DD/YYYY OCR for scans

Quicken bank statement converter FAQ

Can I import bank statements into Quicken?

Not as a PDF. Quicken imports transactions through a connected bank feed or from a file it understands: a QFX (Web Connect) file, a QIF file, or a CSV in its required column order. A statement that you have as a PDF has to be converted to one of those first. This converter reads the PDF and writes a QFX, QIF, or formatted CSV so Quicken can import the transactions directly.

How do I convert a PDF to a Quicken file?

Upload the statement PDF to the converter at the top of this page, review the date, payee, and amount rows, then export a QFX or QIF file. In Quicken open File, then Import, and choose Web Connect for a QFX or QIF File for a QIF. Pick the account, and Quicken adds the transactions. If you would rather check the data in a spreadsheet first, export a CSV or Excel file instead.

What is the difference between QFX and QIF in Quicken?

QFX is the Web Connect format Quicken uses to download from banks, and it matches against existing transactions so it avoids duplicates, but it does not carry categories. QIF is the older Quicken Interchange Format, which does bring categories and tags but is limited to certain account types in current versions. Use QFX for clean banking imports and QIF when you specifically need category data to come across.

Does Quicken import CSV files?

Yes, with strict formatting. Quicken for Windows reads a CSV whose first columns are Date, Payee, Amount, Category, Tags, Notes, and Check Number in that order, with dates as MM/DD/YYYY. Each row needs at least a date, payee, and amount, and unlike a QFX it does not check for duplicates. The converter writes the CSV in that exact column order so the banking import works without you reshaping the file by hand.

Why will not Quicken connect to my bank?

Bank feeds cover many institutions but not all of them. Smaller banks and credit unions may not offer Direct Connect, some banks charge for it, business accounts are often excluded, and connections drop for closed accounts or after a security change. Older statements you need to backload are also outside the feed. When the connection is unavailable, converting the statement PDF to a QFX, QIF, or CSV is the supported way to get the activity into Quicken.

Can I convert a scanned or image-only statement for Quicken?

Yes. The converter includes optical character recognition, so it reads scanned statements and image-only PDFs, not just digital ones. That matters for older periods and for files a client photographed or saved from a teller. The text is pulled into the same date, payee, and amount rows, so the QFX, QIF, or CSV imports into Quicken the same way a digital statement would.

Is it safe to convert my bank statement online?

Files are encrypted in transit and at rest while they are processed, and the conversion runs without sharing your data with third parties. You never enter your bank login or your Quicken credentials, because the converter works straight from the PDF you already downloaded. You stay in control of the file and the export from upload to download.