Quicken Bank Statement Converter for PDF Bank Statements to CSV Quicken Imports

Quicken will not open a PDF, and it turns away OFX files written by any converter. The file it does take from you is a CSV in its own column layout. Upload the statement here, check every row against the printed balances, and export a CSV that maps onto Date, Payee and Amount in a couple of minutes.

CSV mapped to Quicken columns
Quicken Classic for Windows and Mac
Scans and phone photos read
15-page demo before you buy

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|

Three doors into Quicken and the one a PDF can use

Quicken accepts transactions three ways. A live connection (Direct Connect or Express Web Connect) pulls them from the bank. A Web Connect download hands over a QFX file that the bank signs with its own institution ID, and Quicken checks that ID against its list of participating banks. The third door is the banking CSV import, which takes a plain spreadsheet from anyone.

A converter can only ever use the third door. We write OFX for a living, and we still tell Quicken users not to bother with it: an OFX or QFX built from a PDF has no bank-issued ID, so Web Connect refuses it, and renaming the extension does not change that. CSV goes in every time. The longer walkthrough, menu by menu, is in the guide to getting a PDF statement into Quicken.

Rows checked against the statement

Switch on the Balances option and the export also carries the opening balance and the total rows the bank printed, so you can confirm the extracted lines add up before one of them reaches your Quicken register.

Amount columns your way

The CSV keeps the amount layout the bank printed. Quicken wants one signed Amount, so for Quicken leave the split option off; turn it on when a client's file expects a single amount broken into Debit and Credit.

Paper statements from years back

Besides PDF, the converter reads JPG, PNG, HEIC, TIFF and BMP, so a 2014 statement scanned at the library or photographed on a phone lands in Quicken next to this month's download.

Quicken CSV column map for a converted statement

Quicken Classic for Windows reads its columns in this order, and every row needs at least a date, a payee and an amount. Rename one header, add the Account column, and the file imports without the mapping screen asking questions.

Column in our CSVQuicken columnWhat goes in it
DateDateStatement posting date, written as mm/dd/yyyy
DescriptionPayeeThe merchant or memo line exactly as the bank printed it
Description (copy)FI PayeeOptional. Keeps the raw bank wording if you later rename the payee
AmountAmountSigned. Withdrawals and card charges negative, deposits positive
Debit and Credit (split option)Debit/CreditOptional. Leave it out when Amount is already signed
None on the statementCategoryOptional. Fill it in Excel or let Quicken apply your renaming rules
Account name you typeAccountThe Quicken account the rows belong to
Check number, when printedChknumOptional. Lets check payments reconcile against the register

Quicken for Mac is different. Its CSV door is File, Import, Mint.com File (CSV), which expects Mint's layout and always opens a new account named after the file, so you then move the rows into the real account. The Quicken for Mac CSV import steps cover that column set.

How to convert a bank statement for Quicken

From PDF to Quicken register in about five minutes per statement.

1

Find the gap

Open the account register in Quicken and note the last date the bank feed filled in. Everything after that, or before the feed started, is what you convert.

2

Drop the statement in

Upload the PDF or image above. If the bank locked it with a password, you type it once in the browser and it is used for that file only, never saved.

3

Trim and export

Check the rows against the printed balances, export CSV, and delete any rows dated inside the period the feed already covers.

4

Import the CSV

Quicken Classic for Windows uses File, File Import, Banking Transactions, From (.CSV) File. Pick the account, accept the column match, and reconcile against the closing balance.

Step 3 matters more than it looks. The Quicken CSV import does not compare incoming rows with transactions the feed already downloaded, so an overlap of even one week means duplicate entries you then delete by hand. Cutting the CSV at the feed's start date avoids that entirely. If the feed itself has stopped, the Quicken not downloading transactions checklist is worth running first.

Who pays to convert statements for Quicken

Landlords with several properties

Each rental often has its own small-bank account that never linked. A year of statements per property goes in as one CSV per account, ready for Schedule E categories.

Customers of banks that left Quicken

Chase ended Direct Connect in October 2022 and Bank of America no longer offers a QFX download. Months the new connection never backfilled come back from the PDFs.

Bookkeepers with Quicken clients

Clients mail a stack of PDFs in March. Batch them, export one CSV per account, and bill for review time rather than typing time.

Executors and family administrators

Rebuilding a parent's finances from paper statements for an estate accounting is slow by hand. Photos of old statements convert the same way PDFs do.

What converting a year of statements costs

Pricing is per page, not per statement or per account. A typical checking statement runs four to six pages, so twelve months for five accounts is roughly 300 pages. The Starter plan includes 3,000 pages a month for $49, or $24.50 a month billed yearly, which works out to under two cents a page. Plus, at $149 a month, adds bulk upload of 50 files at once and removes the 25-page limit per statement for long business statements.

Before paying, run up to 15 pages of your own statements through the demo (five pages per file) and check the extraction against the paper. If your bank's layout reads cleanly there, it reads cleanly at volume.

Files you can export

CSV for Quicken, Excel when a client wants to see the numbers first, and OFX for the programs that do accept it from a converter, such as MS Money, GnuCash, Moneydance and Xero (see the bank statement to OFX converter). Simplifi users have their own route in the Simplifi import guide. Statements are only half of a small business file, of course. Vendor bills can be keyed out with an invoice data extractor, and other PDF reports turned into sheets with a PDF to Excel converter.

CSV Excel .xlsx OFX for non-Quicken apps JSON

Quicken bank statement converter FAQ

Can I import bank statements into Quicken?

Yes, once the PDF is turned into a CSV. Quicken has no PDF import at all. Its options are a live bank connection, a QFX file downloaded from a participating bank, and the banking CSV import. A statement converter feeds the third one, and for most people that is the fastest way to fill months the connection missed.

How do I convert a PDF to a Quicken file?

Upload the PDF above, export CSV, and change the Description header to Payee. Add an Account column if you import several accounts at once, keep dates as mm/dd/yyyy, then use File, File Import, Banking Transactions, From (.CSV) File in Quicken Classic for Windows. Mac users go through File, Import, Mint.com File (CSV) instead.

Can a converter make a QFX file Quicken will accept?

No, and be wary of any tool that says it can for every bank. Quicken only accepts a Web Connect QFX that carries the institution ID of a participating bank, and a file built from a PDF has no genuine one. Some desktop tools borrow another bank's ID, which works until it does not. We export CSV for Quicken instead, which needs no ID.

Will the CSV import create duplicate transactions?

It can. Quicken's CSV import does not match rows against transactions already downloaded from the bank, so any date the feed covered will appear twice. Delete those rows from the CSV before importing, or import only statements from before the connection started or after it broke.

Why will not Quicken connect to my bank?

Usually because the bank changed how it supports Quicken. Several large banks moved everyone to Express Web Connect, retired Direct Connect or dropped QFX downloads, and many small banks and credit unions were never on the list. A reauthorization often fixes a live feed, but history from before the change has to come from the statements.

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

Yes. Scanned PDFs and photos in JPG, PNG, HEIC, TIFF or BMP go through optical character recognition and come out in the same Date, Payee and Amount rows as a digital statement. Check the totals in the preview, since faded print is where reading errors happen, then import as usual.

Do I have to give the converter my bank or Quicken login?

No. The converter only sees the statement file you upload. It never connects to your bank and never touches your Quicken data file, and a statement password, if the PDF has one, is used to open that file and not stored.