Quicken Bank Statement Converter from PDF to QFX, QIF, CSV and Excel

Upload a PDF bank statement and download every transaction as a Web Connect QFX or QIF file for Quicken, or as clean CSV and Excel rows with the date, payee, and amount in columns. No bank login, no manual entry, no fighting a connection that will not link.

QFX and QIF files on Plus
Date, payee, amount columns
For Quicken on Windows and Mac
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:

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 first step in every one of those cases is the same: get the transactions out of the PDF and into clean, reviewable rows. This converter reads the statement and writes the date, payee, and amount for every line into a CSV or Excel sheet, which is the format Quicken for Mac imports directly and the starting point for every other route in.

CSV imports directly on Quicken for Mac

Quicken for Mac (2015 and later) imports a CSV in the Mint column layout, and it carries categories across. Convert the statement, check the rows, and import the file straight into the account.

Quicken for Windows wants QFX or QIF

Quicken for Windows imports QFX (Web Connect) and QIF, not a plain CSV of transactions. On the Plus plan BankXLSX writes both: download the QFX and import it under File, File Import, Web Connect (.QFX) File. No second utility is needed.

Excel to check before you import

Export XLSX to eyeball the dates, payees, and signs against the statement, and to confirm the running balance ties out, before anything reaches your register. Fixing a number here is easy.

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

Export the rows

Review the date, payee, and amount rows in the preview, then export CSV to import, or XLSX if you want to check the numbers against the statement first.

4

Bring it into Quicken

On Plus, download the QFX file and import it under File, File Import, Web Connect (.QFX) File on Windows, or File, Import, Bank or Brokerage File on Mac. Quicken for Mac also takes the CSV.

Prefer to land transactions through a finance format rather than a spreadsheet? BankXLSX also writes a bank statement to OFX file, which GnuCash, Moneydance, and most finance software read directly. Quicken is the exception: it wants the Intuit flavors of that format, QFX or QIF, rather than plain OFX, and both are downloads on the Plus plan. Starting from a bank CSV instead of a PDF? The CSV to QFX converter takes that file through the same upload. For the menu-by-menu import clicks on Windows and Mac, follow the guide on how to import bank statements into Quicken.

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 clean rows 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, converting 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.

What Quicken imports, and what this converter writes

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. It reads QFX and QIF on Windows, and a Mint-layout CSV on Mac. This converter pulls every transaction into clean date, payee, and amount rows and exports them as QFX, QIF, CSV, or Excel. On Windows, import the QFX as a Web Connect file. On Mac, import the QFX or the CSV, whichever you prefer.

  • CSV with date, payee, and amount, importable on Quicken for Mac
  • Excel (.xlsx) so you can verify the rows before importing
  • QFX (Web Connect) and QIF for Quicken on the Plus plan
  • 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 CSV or Excel (.xlsx) to check the numbers first, then QFX or QIF to load the transactions into Quicken. 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 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 or a QIF file on Windows, and a Mint-layout CSV on Quicken for Mac. A statement that you have as a PDF has to become one of those first. This converter reads the PDF and writes a QFX or QIF file on the Plus plan, and CSV and Excel on every plan, so the statement goes into Quicken as one of the files it accepts.

How do I convert a PDF to a Quicken file?

Upload the statement PDF to the converter at the top of this page and review the date, payee, and amount rows. On the Plus plan, download the QFX file and import it in Quicken for Windows under File, File Import, Web Connect (.QFX) File, or in Quicken for Mac under File, Import, Bank or Brokerage File. A QIF download is there for older versions, and Quicken for Mac also imports the CSV.

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 cash, asset, and liability accounts in current Quicken for Windows. Use QFX for clean banking imports and QIF when you specifically need category data to come across.

Does Quicken import CSV files?

Quicken for Mac, version 2015 and later, imports a transaction CSV in the Mint column layout, and it carries categories. Quicken for Windows does not import a transaction CSV; there it accepts QFX or QIF, and CSV is only used for updating security prices. So on Mac the exported CSV goes straight in, while on Windows you import the QFX or QIF download instead.

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 is how you get the activity into a file Quicken will accept.

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 a digital statement produces, so the import path afterward is identical.

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.

Reconciling this against a bank account? Send the bank PDFs through the bank statement converter for the same structured export, or use the bank statement to CSV converter for any accounting tool that imports CSV.