How to get a PDF bank statement into Quicken (QIF or QFX)

By Kayabyte · Last updated 28 October 2026

Quicken can import transactions from files, but a PDF statement is not one of them. If your bank no longer connects to Quicken, or you need older months than it will download, you have to turn the PDF into a file Quicken understands. The two common choices are QFX (Quicken’s flavor of OFX) and QIF (the older Quicken Interchange Format). This guide covers both, with the manual route first.

1. Try the bank’s download first

Many banks offer a download in a Quicken or QFX format from online banking. The exact labels vary by bank. A QFX from the bank is the cleanest option: it contains the bank’s identity and unique transaction IDs, so Quicken can match the account and skip duplicates. Limits: usually only a recent window of months, and some banks have dropped Quicken support.

2. Know QIF and QFX apart

QFX carries bank and account details and a unique ID per transaction. Quicken can use it to recognize duplicates and may ask you to match it to an account.
QIF is a plain text list. No unique IDs, so importing the same range twice can duplicate transactions. Some newer Quicken versions have reduced or changed QIF import, especially for bank accounts, so check what yours supports; the exact behavior varies by version and by Mac or Windows edition.

A QIF transaction is only a few lines: a D line for date, a T line for amount, a P line for payee, an optional M for memo, and a caret to close it. The date format Quicken expects depends on your regional settings, so a mismatch can swap days and months.

3. Writing a QIF by hand

If you are comfortable with a spreadsheet and a text editor:

Get the PDF rows into a sheet (see How to convert a PDF bank statement to Excel).
Put dates in the form your Quicken uses, and amounts as plain numbers with a minus for money out.
Build each record with a formula that joins the lines, and paste the result into a text file starting with a header line for the account type, for example Bank.
Save as plain text with the .qif extension.

Pitfalls: line endings, stray quotes or commas in payee names, and transfers or categories you didn’t mean to include. This is workable for a few dozen rows and tedious beyond that.

4. Importing into Quicken

In Quicken, use the File menu’s import option and pick the file type (the exact labels vary by version). Choose the account the transactions belong to, or create a new one. Do a first run into a new test account: look at the dates, signs and payees, and compare the account’s ending balance with the statement.

A habit worth keeping: after any import, check that the balance in Quicken for the statement date matches the statement’s closing balance. If it doesn’t, something is missing, duplicated or has the wrong sign.

5. Where Balanced helps

Balanced is a Mac app we make that reads PDF statements and exports QIF or QFX. You open the file, review the table, then choose the format in the export step.

Reads text PDFs, scanned PDFs and images (using Apple’s on-device text recognition) and CSV or TSV files, from any bank, with headers and months in ten languages: English, Norwegian, Swedish, Danish, German, Dutch, French, Spanish, Italian and Portuguese.
The preview lets you fix column roles, date order (day/month or month/day) and sign handling, so the file’s dates and signs are right before you import. It remembers each bank’s layout.
It checks that opening balance plus transactions equals the closing balance, and the running balance per row where the statement has one. If not, it says which rows and the difference, and exporting needs an explicit “Export anyway”.
Choose QFX when you want Quicken to treat the file as bank data, or QIF when you need the simple older format.
No AI guessing: every number is copied from your statement and checked.
Your statements are processed on your Mac and never leave it.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file, which is enough to try an import into Quicken with a test account. Pro is USD 59 per year or USD 7.99 per month, cancel anytime. See pricing.

Limits

We can’t promise that every Quicken version accepts every file, or that every bank layout is read perfectly, so check the preview first. Heavily skewed or low-quality scans can fail. If the PDF is password-protected, unlock the PDF first with the password from your bank. Needs macOS 14 or later.