QIF

Bank statement PDF to QIF for Quicken

Convert a PDF bank or credit card statement to a Quicken .QIF file, checked against the opening and closing balance first. For Quicken Classic for Windows and GnuCash. Free preview.

Files deleted after 1 hourNever stored or used for trainingBalance check on every file
Processed in memory, never stored
No statement handy? See the result on a fictional one first:

1. Download your statement

Grab the PDF statement from online banking. Statements downloaded from your bank are text-based and convert cleanly; scans and photos aren't supported yet.

2. Upload and verify

Utilly reads every transaction, then checks that opening balance + transactions = closing balance. You'll see Balanced ✓ or exactly how far off it is, before you pay anything.

3. Import the QIF into Quicken

  1. Download the Quicken .QIF from your results page. One credit unlocks every format, so the CSV, OFX and QuickBooks files come with it.
  2. Quicken Classic for Windows: back up your data file, make sure the account exists, then File → File Import → QIF File and pick it under Quicken account to import into.
  3. Tick Transactions under Include in import, finish the import and check the register against the statement. Quicken for Mac only reads a QIF when you start a new data file (File → New), not into an existing one.

Why QIF?

Quicken doesn't import PDF statements, and its Web Connect help says it doesn't support QFX files made by third-party conversion software. QIF is the plain-text format Quicken Classic for Windows still imports, and GnuCash reads it too. If your bank only gives you PDF statements, or older months are no longer downloadable, Utilly reads the PDF, checks it against the opening and closing balance, and writes the QIF.

How to convert a bank statement PDF to QIF

  1. Download the PDF statement from online banking. Statements downloaded from your bank are text-based and convert cleanly; scans and phone photos aren't supported yet.
  2. Upload it above. We read every transaction and check that the opening balance plus the transactions equals the closing balance. You see Balanced ✓, or exactly how far off it is, before you pay anything.
  3. Unlock and download the Quicken .QIF. One credit covers every format of that statement.
  4. Import it into the matching account in Quicken (steps below), then reconcile the account against the same statement.

What's in the QIF file

The first transaction on our sample bank statement (business checking ending 0427) comes out as:

!Type:Bank
D09/01/2026
T-6420.18
PACH DEBIT GUSTO PAYROLL 0912
MACH DEBIT GUSTO PAYROLL 0912
^
  • Every transaction on the statement: the date (D, month first, 4-digit year), one signed amount (T, money out negative), the payee (P, first 64 characters of the description) and the full description as the memo (M).
  • The account type in the first line: !Type:Bank for a bank statement, !Type:CCard for a credit card statement, where charges, fees and interest are negative and payments and credits positive.
  • No account name, opening balance or categories. The transactions go into the account you pick when you import, so set the account's opening balance in Quicken, and categorize the transactions after the import.
  • No transaction IDs. QIF has no field for them, so Quicken can't skip a transaction it already has. Import each statement once.

Want to see it before uploading anything? Download the sample statement's QIF file (fictional bank, 31 transactions, 12,418.36 → 13,440.52), or the credit card one. More test files are in free sample bank statement files.

Importing the QIF into Quicken

ProgramWhat to do
Quicken Classic for WindowsBack up your data file and create the account first if it doesn't exist. Then File → File Import → QIF File, browse to the file, pick the account under Quicken account to import into, tick Transactions under Include in import and click Next. That list only shows accounts that can take a QIF import (Quicken help).
Quicken Classic for MacOnly when starting a new data file: File → New → Start from a .QIF file exported from another application. Quicken for Mac doesn't import a QIF into an existing file (Quicken).
GnuCashFile → Import → Import QIF…, choose the m-d-y date format when asked, and match the file to your GnuCash account (GnuCash manual).

Checking, savings and card accounts in Quicken for Windows: Quicken's own pages disagree. Its Windows help says a QIF can go into any account type, checking, savings and credit card included, as long as the account already exists. Its support article on importing data says QIF import is only for cash, asset and liability accounts (Quicken support). Your copy of Quicken decides: if the account you want isn't in the Quicken account to import into list, it can't take the QIF, so check before you buy credits by importing the sample QIF into a test data file.

Why not QFX? Quicken checks a Web Connect (QFX) file against its online services, and says it doesn't support QFX files made by third-party conversion software (Quicken). So we don't make QFX files.

Common problems

ProblemFix
The account isn't in Quicken's import listCreate the account first. If it still isn't listed, your Quicken version doesn't take a QIF into that account type (see above).
Transactions imported twiceQIF has no transaction IDs, so a month already downloaded from the bank comes in again. Delete the extra copies and import only months that aren't in the register yet.
Card payments show as chargesImport a card QIF into a credit card account, not a checking account. The file is already signed for a card: charges negative, payments positive.
The statement doesn't balanceYou see the difference before paying. Don't import a file that's off; email us the statement layout and we'll fix it or refund you.
"This PDF is password protected"Save a copy without the password, or download the statement again from online banking, and upload that.

Other formats from the same statement

  • Moving from Quicken to QuickBooks? The same results page has a .QBO and an .IIF (PDF to QuickBooks), and the QIF to QBO converter turns an existing Quicken QIF export into a .QBO.
  • Xero, Sage, FreeAgent or GnuCash: the OFX file (PDF to OFX). Excel or Google Sheets: the CSV (PDF to Excel).
  • Already have a CSV or Excel export from the bank? The free CSV to QIF converter makes the QIF without a credit for files up to 100 transactions.

Pricing

Preview any statement free. A $9 pack unlocks 5 full statements in every format, with no expiry and no subscription. Bookkeepers with many clients can go unlimited for $19/month. See pricing.

FAQ

Questions

Can I convert a bank statement PDF to QIF for Quicken for free?

You can preview every statement free: we show the balance check and the first 5 transactions with no sign-up. Unlocking the full file costs one credit ($9 for 5 statements).

Is my statement stored?

No. The PDF is read in memory and never written to disk, and extracted results are deleted after 1 hour. We never use your data for AI training.

Do scanned statements work?

Not yet. PDFs downloaded from online banking are text-based and work well. Scans and phone photos need OCR, which is on the roadmap.

What if it doesn't balance?

You'll see exactly how far off it is before paying. If a paid conversion is wrong and we can't fix it, email support@version1.io for a refund.

Can Quicken import a PDF bank statement?

No. Quicken reads QFX (Web Connect) files from your bank, QIF files and some CSV layouts, not PDFs. Convert the PDF to a QIF here, then use File → File Import → QIF File in Quicken Classic for Windows.

Why a QIF and not a QFX file?

Quicken checks a QFX (Web Connect) file against your bank's Quicken connection, and its Web Connect help says it doesn't support QFX files made by third-party conversion software, naming PDF to QFX. A QIF has no bank ID to check: Quicken for Windows imports it into an existing account you choose, as long as that account appears in its QIF import list.

Does it work for credit card statements?

Yes. A card statement is written as a credit card QIF (!Type:CCard): charges, fees and interest negative, payments and credits positive, checked against the previous and new balance first. Import it into a credit card account in Quicken.

Will Quicken skip transactions I've already downloaded?

No. A QIF has no transaction IDs, so Quicken can't tell a repeat from a new transaction. Import only statement months that aren't in the account yet, and delete any copies that slip in.

Does it work with Quicken for Mac?

Only for a brand-new data file: Quicken for Mac reads a QIF when you choose File → New → Start from a .QIF file, not into an existing file. For an existing Mac file, Quicken takes your bank's own Web Connect (QFX) download, or a CSV in Quicken's Mint column layout, which always lands in a new account that you then move the transactions out of. We don't write that CSV layout yet, so this converter isn't the right fit for Quicken for Mac.

Related guides

More bookkeeping tools