Quicken Bank Statement Converter: Convert PDF Bank Statements to CSV and Excel for Import

Upload a PDF bank statement and download every transaction as clean CSV or Excel rows with the date, payee, and amount already in columns, ready to bring into Quicken. No bank login, no manual entry, no fighting a connection that will not link.

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

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

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. BankXLSX does not write QFX or QIF files. Convert the statement here, then pass the CSV through a dedicated QFX or QIF utility to produce the file Quicken for Windows will accept.

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 Quicken for Mac, import the CSV into the account. On Quicken for Windows, convert the CSV to QFX or QIF with a dedicated utility first, then import that file.

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. 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 CSV, Excel, or OFX. On Mac that CSV imports as it is. On Windows, run the CSV through a QFX or QIF utility to produce the file Quicken accepts.

  • CSV with date, payee, and amount, importable on Quicken for Mac
  • Excel (.xlsx) so you can verify the rows before importing
  • OFX for GnuCash, Moneydance, and other finance software
  • 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, or OFX to load the transactions into finance software that reads it. 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.

CSV Excel .xlsx OFX 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 clean CSV, Excel, and OFX, which is the data-preparation step every one of those routes starts from.

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 Quicken for Mac, export the CSV and import it into the account. On Quicken for Windows, export the CSV and pass it through a dedicated QFX or QIF utility, then import that file under File, Import. BankXLSX itself does not write QFX or QIF.

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 it needs a QFX or QIF conversion step first.

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.

From the same family of tools